1

yangle

2024-12-18 9e20f45757ab2c69127ede14e5bd69bb60552d53

 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)
                {