供应商接口优化

lch

2024-08-26 8dca993e320f7dff7d6175b7b69d9f14d1eb95fb

供应商接口优化

 HandleData/AE_MES_ERP.cs

@@ -1221,7 +1221,7 @@
            try
            {
                DataTable dt = ds.Tables[0];
                if (operatype == "INSERT")
                if (operatype == "INSERT" || operatype == "UPDATE")
                {
                    #region INSERT
                    //dt.Columns.Add("MAA005", typeof(string));
@@ -1268,7 +1268,7 @@
                                        GYS005='{5}',
                                        FUseOrgld='{6}'
                                    where ERPID='{0}'; ", dr["ERPID"]
                                                        , dr["GYS001"], dr["GYS002"], dr["GYS003"], dr["GYS004"], dr["GYS005"], dr["FUseOrgld"]);
                                                        , dr["GYSA001"], dr["GYSA002"], dr["GYSA003"], dr["GYSA004"], dr["GYSA005"], dr["FUseOrgld"]);
                    }
                    return _sqlHelper.ExecuteNonQuery(sql) > 0;
                    #endregion
@@ -3172,7 +3172,6 @@
                string res = a.Body(US).msg.ToString();

                sql = string.Format(@" update  sysdec set  states='NEW' WHERE TASK_ID='{0}' ", rtaskid);

                _sqlHelper.ExecuteNonQuery(sql);
                //string res = a.arg0.ws.MES_TO_ERP_DataTransport(task_name, descript, create_time, creator, operatype, source_table, target_table, data, data_inserted, data_deleted);
                if (res.Contains("OK"))

 frmMain.cs

@@ -184,7 +184,7 @@
                                                                                'TB_MESTOERP_TransferIn'
                                                                                ) then 3
                                                                else 4 end gp,* 
                                                        from SYSDEC  WITH(nolock) where states='NEW'  AND   descript IN ('高冲物料变更','物料信息表','仓库信息表','部门信息表','员工信息表','部门信息表','领料单','成品入库单','采购入库单','生产订单下达','物料客户对应表','采购订单','发货通知单','销售出库单','生产领料单','分步调入单','生产退料单','直接调拨单','生产补料单','委外订单','其他入库单','其他出库单')
                                                        from SYSDEC  WITH(nolock) where states='NEW'  AND   descript IN ('高冲物料变更','物料信息表','仓库信息表','部门信息表','员工信息表','部门信息表','领料单','成品入库单','采购入库单','生产订单下达','物料客户对应表','采购订单','发货通知单','销售出库单','生产领料单','分步调入单','生产退料单','直接调拨单','生产补料单','委外订单','其他入库单','其他出库单','供应商信息表')
                                                                --and task_name='TB_ERPTOMES_CG' 
                                                        order by create_time
                                                        union all
@@ -240,7 +240,7 @@
                                                                                'TB_MESTOERP_WLQDBB',
                                                                                'TB_MESTOERP_TransferIn') then 3
                                                                else 4 end gp,* 
                                                        from SYSDEC  WITH(nolock) where states='FAIL' and retry_times<1 and CREATE_TIME>'2024-06-14 13:13:34'  AND descript IN ('高冲物料变更','物料信息表','仓库信息表','部门信息表','员工信息表','生产投料单','部门信息表','领料单','成品入库单','采购入库单','生产订单下达','物料客户对应表','采购订单','发货通知单','销售出库单','分步调入单','生产领料单','生产退料单','生产补料单')
                                                        from SYSDEC  WITH(nolock) where states='FAIL' and retry_times<1 and CREATE_TIME>'2024-06-14 13:13:34'  AND descript IN ('高冲物料变更','物料信息表','仓库信息表','部门信息表','员工信息表','生产投料单','部门信息表','领料单','成品入库单','采购入库单','生产订单下达','物料客户对应表','采购订单','发货通知单','销售出库单','分步调入单','生产领料单','生产退料单','生产补料单','供应商信息表')
                                                                            and task_name not in ('TB_MESTOERP_WGRK',
                                                                                                    'TB_MESTOERP_WWRK',
                                                                                                    'TB_MESTOERP_QTRK',