1

llj

7 天以前 efb3e796ce184fdd3bfab9c8aab238cec0b20d67

 WebAPI/Controllers/CJGL/Gy_MaterPreventErrMouldBillController.cs

@@ -1039,6 +1039,9 @@
                if (!tb2.Columns.Contains("失效验证方法"))
                    error += "没有找到【失效验证方法】的标题,";

                if (!tb2.Columns.Contains("防错结果"))
                    error += "没有找到【防错结果】的标题,";

                if (!tb2.Columns.Contains("表体备注"))
                    error += "没有找到【表体备注】的标题,";

@@ -1267,6 +1270,7 @@
                    string HPreventErrNote = item["防错功能"].ToString();
                    string HLoseMode = item["失效模式"].ToString();
                    string HLoseCheck = item["失效验证方法"].ToString();
                    string HPreventErrResult = item["防错结果"].ToString();

                    ds = oCN.RunProcReturn("select * from Gy_MaterPreventErrMouldBillMain where HBillNo='" + HBillNo + "'", "Gy_MaterPreventErrMouldBillMain");

@@ -1294,7 +1298,7 @@
                        //插入子表
                        oCN.RunProc("insert into Gy_MaterPreventErrMouldBillSub " +
                        "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRemark" +
                        ",HPreventErrMouldID,HPreventErrNote,HLoseMode,HLoseCheck) " +
                        ",HPreventErrMouldID,HPreventErrNote,HLoseMode,HLoseCheck,HPreventErrResult) " +
                        " values(" +
                        "" + HInterID.ToString() +
                        "," + 1 +
@@ -1307,6 +1311,7 @@
                        "','" + HPreventErrNote +
                        "','" + HLoseMode +
                        "','" + HLoseCheck +
                        "','" + HPreventErrResult +
                        "')");
                    }
                    else
@@ -1322,7 +1327,7 @@
                        //插入子表
                        oCN.RunProc("insert into Gy_MaterPreventErrMouldBillSub " +
                        "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRemark" +
                        ",HPreventErrMouldID,HPreventErrNote,HLoseMode,HLoseCheck) " +
                        ",HPreventErrMouldID,HPreventErrNote,HLoseMode,HLoseCheck,HPreventErrResult) " +
                        " values(" +
                        "" + HInterID.ToString() +
                        "," + HEntryID +
@@ -1335,6 +1340,7 @@
                        "','" + HPreventErrNote +
                        "','" + HLoseMode +
                        "','" + HLoseCheck +
                        "','" + HPreventErrResult +
                        "')");
                    }