增加 物料+工序获取检验方案

zrg

2024-12-13 f4673c4e3408abf638dd59e93c9ae1be68839714

 WebAPI/Controllers/XSGL/YS_ContactBalController.cs

@@ -427,9 +427,11 @@
                        ds = oCN.RunProcReturn(sql, "YSYF_ContactBal");
                        if (ds.Tables[0].Rows.Count == 0)
                        {
                            sql = "insert into YSYF_ContactBal(HRP,HCusID,HCurID,HBeginBalance) " +
                            sql = "insert into YSYF_ContactBal(HYear,HPeriod,HRP,HCusID,HCurID,HBeginBalance) " +
                                "values(" +
                                "" + HFRP + "" +
                                "YEAR(getdate())" +
                                ",Month(getdate())" +
                                "," + HFRP + "" +
                                "," + HCusID + "" +
                                "," + HCurID + "" +
                                "," + HBeginBalance + "" +
@@ -475,9 +477,11 @@
                        ds = oCN.RunProcReturn(sql, "YSYF_ContactBal");
                        if (ds.Tables[0].Rows.Count == 0)
                        {
                            sql = "insert into YSYF_ContactBal(HRP,HCusID,HCurID,HBeginBalance) " +
                            sql = "insert into YSYF_ContactBal(HYear,HPeriod,HRP,HCusID,HCurID,HBeginBalance) " +
                                "values(" +
                                "" + HFRP + "" +
                                "YEAR(getdate())" +
                                ",Month(getdate())" +
                                "," + HFRP + "" +
                                "," + HCusID + "" +
                                "," + HCurID + "" +
                                "," + HBeginBalance + "" +