性能报废台账 送测登记数据台账

yangle

2024-07-30 1d3e15f89fab38986b09bb9879fc5ebc49010c55

 DAL/¼Æ»®¹ÜÀí/ClsGy_MaterialTechParamBillMain.cs

@@ -54,6 +54,7 @@
                    "', HProcID  = '" + omodel.HProcID +
                    "', HEquipID  = '" + omodel.HEquipID +
                    "', HOrgID     = '" + omodel.HOrgID +
                    "', HMouldID = '" + omodel.HMouldID +
                    "' where HInterID = " + omodel.HInterID;

                oCn.RunProc(mainSql);
@@ -71,7 +72,7 @@
                            "" +
                            "" +
                            "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
                            ",HTechParamID,HTechParamUnitID,HStd,HMax,HMin) " +
                            ",HTechParamID,HTechParamUnitID,HStd,HMax,HMin,HDataForm,HDataUnit,HDataTimes) " +
                            " values(" +
                            "" + omodel.HInterID.ToString() +
                            "," + oSub.HEntryID.ToString() +
@@ -84,7 +85,10 @@
                            "'," + oSub.HStd +
                            "," + oSub.HMax +
                            ",'" + oSub.HMin +
                            "')";
                            "','" + oSub.HDataForm +
                            "','" + oSub.HDataUnit +
                           "'," + oSub.HDataTimes +
                            ")";
                    oCn.RunProc(subSql);
                }

@@ -128,7 +132,7 @@
                //插入主表
                string mainSql = "insert into Gy_MaterialTechParamBillMain" +
                    "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HRemark,HMaker,HMakeDate" +
                    ",HDeptID,HEmpID,HMaterID,HWorkCenterID,HEquipID,HOrgID,HProcID ) " +
                    ",HDeptID,HEmpID,HMaterID,HWorkCenterID,HEquipID,HOrgID,HProcID,HMouldID ) " +
                    "values(" +
                    "" + omodel.HYear.ToString() +
                    "," + omodel.HPeriod.ToString() +
@@ -146,7 +150,8 @@
                    "','" + omodel.HWorkCenterID +
                    "','" + omodel.HEquipID +
                    "','" + omodel.HOrgID +
                     "','" + omodel.HProcID +
                    "','" + omodel.HProcID +
                     "','" + omodel.HMouldID +
                    "')";

                oCn.RunProc(mainSql);
@@ -159,7 +164,7 @@
                           "" +
                           "" +
                           "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
                           ",HTechParamID,HTechParamUnitID,HStd,HMax,HMin) " +
                           ",HTechParamID,HTechParamUnitID,HStd,HMax,HMin,HDataForm,HDataUnit,HDataTimes) " +
                           " values(" +
                           "" + omodel.HInterID.ToString() +
                           "," + oSub.HEntryID.ToString() +
@@ -172,7 +177,10 @@
                           "'," + oSub.HStd +
                           "," + oSub.HMax +
                           ",'" + oSub.HMin +
                           "')";
                           "','" + oSub.HDataForm +
                            "','" + oSub.HDataUnit +
                           "'," + oSub.HDataTimes +
                           ")";
                    oCn.RunProc(subSql);
                }
                sReturn = "新增单据成功！";