yusijie
2024-12-17 feec6d0e153a8435ead4383a2a8f988b47003191
DAL/工位看板/ClsGy_SOPBill.cs
@@ -52,7 +52,7 @@
                ",HUpDater='" + omodel.HUpDater + "'" +
                ",HUpDateDate='" + omodel.HUpDateDate + "'" +
                ",HRemark='" + omodel.HRemark + "'" +
                ",HType='" + omodel.HType + "'" +
                " where HInterID=" + lngBillKey.ToString());
                //鍒犻櫎鍏宠仈
@@ -100,12 +100,12 @@
                oCn.RunProc("Insert Into Gy_SOPBillMain   " +
                "(HBillType,HInterID,HBillNo,HDate" +
                ",HYear,HPeriod,HRemark,HMaker,Hmakedate,HMaterID,HName,HMaterTypeID" +
                ",HUnitID,HMaterNumber,HUnitNumber,HStandard" +
                ",HUnitID,HMaterNumber,HUnitNumber,HStandard,HType" +
                ") " +
                " values('" + this.BillType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()," + omodel.HMaterID.ToString() + ",'" + omodel.HName + "'," + omodel.HMaterTypeID.ToString() +
                "," + omodel.HUnitID.ToString() + ",'" + omodel.HMaterNumber + "','" + omodel.HUnitNumber + "'," + DBUtility.ClsPub.BoolToString(omodel.HStandard) +
                ") ");
                "," + omodel.HUnitID.ToString() + ",'" + omodel.HMaterNumber + "','" + omodel.HUnitNumber + "','" + DBUtility.ClsPub.BoolToString(omodel.HStandard) + "','" + omodel.HType +
                "') ");
                //鎻掑叆瀛愯〃
                foreach (Model.ClsGy_SOPBillSub oSub in DetailColl)
                {