1
llj
2 天以前 4c2d6fc7aeb7fe0cc44b2735514d47ff2ace18fa
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 + "" +