1

duhe

2025-03-24 2609bffee3a8de0d1e08b1b2c3fa3cfe13064f4e

 DAL/¹¤Î»¿´°å/ClsGy_SOPBill.cs

@@ -52,7 +52,7 @@
                ",HUpDater='" + omodel.HUpDater + "'" +
                ",HUpDateDate='" + omodel.HUpDateDate + "'" +
                ",HRemark='" + omodel.HRemark + "'" +

                ",HType='" + omodel.HType + "'" +

                " where HInterID=" + lngBillKey.ToString());
                //删除关联
@@ -88,28 +88,34 @@
            try
            {
                //得到mainid
                omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
                if (omodel.HInterID.ToString() == null || omodel.HInterID == 0 || omodel.HInterID.ToString() == "undefined")
                {
                    omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
                }

               
                //若MAINDI重复则重新获取
                oCn.BeginTran();
                //主表
                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)
                {
                    oCn.RunProc("Insert into Gy_SOPBillSub " +
                          "(HInterID,HEntryID,HProcID,HProcNO" +
                          ",HWorkStationID,HCenterID,HRemark" +
                          ",HWorkStationID,HCenterID,HRemark,HSourceID,HMouldID" +
                          ") values("
                          + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HProcID.ToString() + "," + oSub.HProcNo.ToString() +
                          "," + oSub.HWorkStationID.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HRemark.ToString() + "'" +
                          "," + oSub.HWorkStationID.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HRemark.ToString() + "'," + oSub.HSourceID +
                          "," + oSub.HMouldID +
                          ") ");
                }
                sReturn = "新增单据成功！";