1

duhe

2023-07-10 a76081416ebb7c0d0a0be0a2ee6f34fa5ae765ce

 WebAPI/Controllers/项目管理/工程项目/PM_ProjectBillController.cs

@@ -467,12 +467,12 @@

                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from PM_ProjectBillMain order by HProNumber ", "PM_ProjectBillMain");
                    ds = oCN.RunProcReturn("select * from PM_ProjectBillMain order by HBillNo ", "PM_ProjectBillMain");
                }
                else
                {
                    string sql1 = "select * from PM_ProjectBillMain where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by HProNumber ";
                    string sql = sql1 + sWhere + " order by HBillNo ";
                    ds = oCN.RunProcReturn(sql, "PM_ProjectBillMain");
                }

@@ -534,7 +534,7 @@
                    return objJsonResult;
                }

                ds = oCN.RunProcReturn("exec h_p_PM_ProjectReportBill_EditInit " + HInterID, "h_p_PM_ProjectReportBill_EditInit");
                ds = oCN.RunProcReturn("exec h_p_PM_ProjectBill_EditInit " + HInterID, "h_p_PM_ProjectBill_EditInit");
                tableList.Add(ds.Tables[0]);
                tableList.Add(ds.Tables[1]);
                tableList.Add(ds.Tables[2]);