1

yxj

2025-04-24 23dbc5b616dfa1a2bcb1fa4302637b8df701f43c

 DAL/Öʼì¹ÜÀí/ClsQC_BackSampleCheckBill.cs

@@ -69,6 +69,7 @@
                ",HProcID='" + omodel.HProcID.ToString() +
                "',HSourceOrgID='" + omodel.HSourceOrgID.ToString() +
                "',HInspectOrgID='" + omodel.HInspectOrgID.ToString() +
                "',HWorkShiftID='" + omodel.HWorkShiftID.ToString() +
                "' where HInterID=" + lngBillKey.ToString());
                //删除关联
                DeleteRelation(ref sReturn, lngBillKey);
@@ -124,6 +125,8 @@
            try
            {

                oCn.BeginTran();

                //保存前控制=========================================
                string HBillNote = "";
                DataSet ds = oCn.RunProcReturn("Exec h_p_QC_BackSampleCheckBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ", "h_p_QC_BackSampleCheckBill_BeforeSaveCtrl");
@@ -139,13 +142,12 @@
                }
                //=========================================================

                oCn.BeginTran();

              
                string sql = "";

                sql = "Insert Into QC_BackSampleCheckBillMain" +
                "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HYear,HPeriod,HRemark,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType," +
                "HDeptID,HEmp,HProcID,HSourceOrgID,HInspectOrgID) " +
                "HDeptID,HEmp,HProcID,HSourceOrgID,HInspectOrgID,HWorkShiftID) " +
                " values(" +
                "'" + this.BillType + 
                "','" + this.HBillSubType + 
@@ -167,6 +169,7 @@
                "','" + omodel.HProcID.ToString() + 
                "','" + omodel.HSourceOrgID.ToString() +
                "','" + omodel.HInspectOrgID.ToString() +
                "','" + omodel.HWorkShiftID.ToString() +
                "') ";
                //主表
                oCn.RunProc(sql);