设备点检/保养规程增加字段,产品工艺产数表增加字段,设备工艺参数点检增加字段

zrg

2025-02-11 a975373ae78738e03034b773e64e74a8c8f1e816

 DAL/计划管理/ClsGy_MaterialTechParamBillMain.cs

@@ -70,7 +70,7 @@
                {
                    string subSql = "insert into Gy_MaterialTechParamBillSub" +
                           "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
                           ",HTechParamID,HTechParamUnitID,HStd,HMax,HMin,HDataForm,HDataUnit,HDataTimes,HTechParamClassID,HSNO,HStdNextTimes,HTechParamIDStd) " +
                           ",HTechParamID,HTechParamUnitID,HStd,HMax,HMin,HDataForm,HDataUnit,HDataTimes,HTechParamClassID,HSNO,HStdNextTimes,HTechParamIDStd,HIsRequired) " +
                           " values(" +
                           "" + omodel.HInterID.ToString() +
                           "," + oSub.HEntryID.ToString() +
@@ -90,6 +90,7 @@
                           "','" + oSub.HSNO +
                           "','" + oSub.HStdNextTimes +
                           "','" + oSub.HTechParamIDStd +
                           "','" + Convert.ToString(oSub.HIsRequired ? 1 : 0) +
                           "')";
                    oCn.RunProc(subSql);
                }
@@ -163,7 +164,7 @@
                {
                    string subSql = "insert into Gy_MaterialTechParamBillSub" +
                           "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
                           ",HTechParamID,HTechParamUnitID,HStd,HMax,HMin,HDataForm,HDataUnit,HDataTimes,HTechParamClassID,HSNO,HStdNextTimes,HTechParamIDStd) " +
                           ",HTechParamID,HTechParamUnitID,HStd,HMax,HMin,HDataForm,HDataUnit,HDataTimes,HTechParamClassID,HSNO,HStdNextTimes,HTechParamIDStd,HIsRequired) " +
                           " values(" +
                           "" + omodel.HInterID.ToString() +
                           "," + oSub.HEntryID.ToString() +
@@ -183,6 +184,7 @@
                           "','" + oSub.HSNO +
                           "','" + oSub.HStdNextTimes +
                           "','" + oSub.HTechParamIDStd +
                           "','" + Convert.ToString(oSub.HIsRequired ? 1 : 0)+
                           "')";
                    oCn.RunProc(subSql);
                }