| | |
| | | case "TB_MESTOERP_WWRK"://MESWWRK金蝶条码入库(委外入库)(同步推送) |
| | | case "TB_MESTOERP_QTRK"://MESQTRK金蝶条码入库(其他入库)(同步推送) |
| | | case "TB_MESTOERP_CPRK"://MESCPRK金蝶条码入库(产品入库)(同步推送) |
| | | case "TB_MESTOERP_SLTZ"://MESCPRK金蝶(收料通知单)(同步推送) |
| | | case "TB_MESTOERP_CGRK"://MESCPRK金蝶条码入库(采购入库)(同步推送) |
| | | case "TB_MESTOERP_XSCK"://MESCPRK金蝶条码出库(销售出库)(同步推送) |
| | | case "TB_MESTOERP_WLQDBB"://MESGCBOM金蝶高冲用料变更(同步推送) |
| | |
| | | if (dr.Table.Columns.Contains("CGAORG")) |
| | | { |
| | | org = "丽德"; |
| | | |
| | | string UP = string.Format(@"EXEC [WMS_CGLD_TOJX] '{0}' ", rtaskid); |
| | | _sqlHelper.ExecuteNonQuery(UP); |
| | | dr["NEWERPID"] = "LD"+dr["ERPID"].ToString(); |
| | | IDList.Add("LD"+dr["ERPID"].ToString()); |
| | | dr["NEWERPID"] = "LD" + dr["ERPID"].ToString(); |
| | | IDList.Add("LD" + dr["ERPID"].ToString()); |
| | | |
| | | if (dr["CGA0018"].ToString() == "103") |
| | | { |
| | | string UP = string.Format(@"EXEC [WMS_CGLD_TOJX] '{0}' ", rtaskid); |
| | | _sqlHelper.ExecuteNonQuery(UP); |
| | | |
| | | string SYSDEC = string.Format(@"UPDATE SYSDEC SET STATES='IGNORE' WHERE task_name='TB_ERPTOMES_CG' AND STATES='NEW' AND TASK_ID ='{0}'", rtaskid); |
| | | _sqlHelper.ExecuteNonQuery(SYSDEC); |
| | | |
| | | return true; |
| | | } |
| | | |
| | | |
| | | } |
| | | else |
| | | { |
| | |
| | | { |
| | | if (dF["TLA020"].ToString().Contains("装配")) |
| | | { |
| | | if (dF["TLA023"].ToString().Contains("-")) |
| | | if (dF["TLA023"].ToString().Contains("*")) |
| | | { |
| | | string[] tr = dF["TLA023"].ToString().Split('*'); |
| | | |
| | | //int i = dF["TLA023"].ToString().LastIndexOf('-'); |
| | | string StrNew = tr[1].ToString();//dF["TLA023"].ToString().Substring(i + 1, 10); |
| | | string SQLT = string.Format(@"SELECT TOP 1 * FROM WOMCAA(NOLOCK) WHERE CAA018='{0}' ", StrNew); |
| | | DataTable CAA = _sqlHelper.ExecuteDataTable(SQLT); |
| | | if (CAA.Rows.Count > 0) |
| | | { |
| | | string UP = string.Format(@"UPDATE WOMCAA SET CAA016='{0}',CAA017='{1}',CAA018='{2}' WHERE CAA002='{3}' ", CAA.Rows[0]["CAA016"].ToString(), CAA.Rows[0]["CAA017"].ToString(), CAA.Rows[0]["CAA018"].ToString(), dF["TLA002"].ToString()); |
| | | _sqlHelper.ExecuteNonQuery(UP); |
| | | } |
| | | |
| | | } |
| | | else if (dF["TLA023"].ToString().Contains("-")) |
| | | { |
| | | string[] tr = dF["TLA023"].ToString().Split('-'); |
| | | |