Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API

wtt

2024-11-28 957b51cfdeb4374d817086a2ca761c75545e206d

 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 + "" +