报工平台、开工、停工、完工提交保存

YL

2021-07-20 76db5c8151205847c56d07ebc4806eb0f0c4990d

 WebAPI/DLL/ClsSc_ICMOReportBill.cs

@@ -8,9 +8,9 @@
{
    public  class ClsSc_ICMOReportBill:DBUtility.ClsXt_BaseBill
    {
        public Model.ClsSc_ICMOReportBillMain omodel = new Model.ClsSc_ICMOReportBillMain();
        public Model.ClsSc_ICMOReportBillSub oSub = new Model.ClsSc_ICMOReportBillSub();
        public List<Model.ClsSc_ICMOReportBillSub> DetailColl = new List<Model.ClsSc_ICMOReportBillSub>();
        public Models.ClsSc_ICMOReportBillMain omodel = new Models.ClsSc_ICMOReportBillMain();
        public Models.ClsSc_ICMOReportBillSub oSub = new Models.ClsSc_ICMOReportBillSub();
        public List<Models.ClsSc_ICMOReportBillSub> DetailColl = new List<Models.ClsSc_ICMOReportBillSub>();

        public ClsSc_ICMOReportBill()
        {
@@ -64,7 +64,7 @@
                DeleteBillSub(lngBillKey);
                //插入子表
                omodel.HInterID = lngBillKey;
                foreach (Model.ClsSc_ICMOReportBillSub oSub in DetailColl)
                foreach (Models.ClsSc_ICMOReportBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Sc_ICMOReportBillSub " +
                      " (HInterID,HEntryID,HMaterID,HMaterNumber" +
@@ -156,7 +156,7 @@
                "','" + omodel.HGroupID.ToString() + "'," + omodel.HDeptID.ToString() + ",'" + omodel.HDeptNumber + "'"+
                ") ");
                //插入子表
                foreach (Model.ClsSc_ICMOReportBillSub oSub in DetailColl)
                foreach (Models.ClsSc_ICMOReportBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Sc_ICMOReportBillSub " +
                      " (HInterID,HEntryID,HMaterID,HMaterNumber" +
@@ -254,7 +254,7 @@
                DetailColl.Clear();//清空
                for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
                {
                    Model.ClsSc_ICMOReportBillSub oSub = new Model.ClsSc_ICMOReportBillSub();
                    Models.ClsSc_ICMOReportBillSub oSub = new Models.ClsSc_ICMOReportBillSub();
                    // 固定赋值===============================================
                    oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]);
                    oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]);
@@ -329,7 +329,7 @@
                "," + omodel.HGroupID.ToString() + "," + omodel.HDeptID.ToString() +
                ") ");
                //插入子表
                foreach (Model.ClsSc_ICMOReportBillSub oSub in DetailColl)
                foreach (Models.ClsSc_ICMOReportBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Sc_ICMOReportBillSub " +
                      " (HInterID,HEntryID,HMaterID" +
@@ -405,7 +405,7 @@
                "," + omodel.HGroupID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HCheckType + "'" +
                ") ");
                //插入子表
                foreach (Model.ClsSc_ICMOReportBillSub oSub in DetailColl)
                foreach (Models.ClsSc_ICMOReportBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Sc_ICMOReportBillSub " +
                      " (HInterID,HEntryID,HMaterID" +