不良评审申请单,选着工序流转卡,查询数据增加过滤条件,设备故障登记单,生产质量汇报单,异常反馈单, 取样单,增加字段保存

zrg

2024-07-24 f0b15e2fc7bdccb18d27cba0c9dfd667e36c20a6

 DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs

@@ -110,9 +110,10 @@
            {
                //若MAINDI重复则重新获取
                oCn.BeginTran();
                string sql = "Insert into Sc_ICMOBillQualityStatus_Tmp(HBarCode,HInterID,HBillNo,HCheckManID,HBadReasonID,HWasterReasonID,HResult,HAddr," +
                string sql = "Insert into Sc_ICMOBillQualityStatus_Tmp"+ 
                                "(HBarCode,HInterID,HBillNo,HCheckManID,HBadReasonID,HWasterReasonID,HResult,HAddr," +
                                "HRemark,HSaveType,HICMOInterID,HICMOEntryID,HICMOBillNo,HSplitNo,HMaterID,HProcID,HSourceID,HDate,HGroupID,HDeptID,HStationID," +
                                "HPRDORGID,HAuxPropID,HBillType,HReportType,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationInterID," +
                                "HPRDORGID,HAuxPropID,HBillType,HBillSubType,HReportType,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationInterID," +
                                "HRelationEntryID,HRelationBillNo,HMaker,HMakeDate)" +
                                "values(" +
                                "'" + omodel.HBarCode +
@@ -139,6 +140,7 @@
                                "," + omodel.HPRDORGID +
                                "," + omodel.HAuxPropID +
                                ",'" + BillType +
                                "','" + "" +
                                "'," + omodel.HReportType +
                                "," + omodel.HSourceInterID +
                                "," + omodel.HSourceEntryID +
@@ -197,9 +199,17 @@
                omodel.HRelationInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HRelationInterID"]);
                omodel.HRelationEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HRelationEntryID"]);
                omodel.HRelationBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRelationBillNo"]);
                omodel.HUpDateDate = Ds.Tables[0].Rows[0]["HUpDateDate"].ToString().Trim();
                omodel.HUpDater = Ds.Tables[0].Rows[0]["HUpDater"].ToString().Trim();
                omodel.HCheckDate = Ds.Tables[0].Rows[0]["HCheckDate"].ToString().Trim();
                omodel.HChecker = Ds.Tables[0].Rows[0]["HChecker"].ToString().Trim();
                omodel.HCloseDate = Ds.Tables[0].Rows[0]["HCloseDate"].ToString().Trim();
                omodel.HCloseMan = Ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim();
                omodel.HDeleteDate = Ds.Tables[0].Rows[0]["HDeleteDate"].ToString().Trim();
                omodel.HDeleteMan = Ds.Tables[0].Rows[0]["HDeleteMan"].ToString().Trim();
                //
                
                 


                sReturn = "显示单据成功！";
                return true;
            }