duhe
2023-07-14 5a54c45733f6570db9476eb53fe840c312beb17f
WebAPI/Controllers/ÏîÄ¿¹ÜÀí/¹¤×÷ÈÎÎñ/PM_WorkTaskBillController.cs
@@ -333,13 +333,13 @@
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from PM_WorkTaskBillMain order by HBillNo ", "PM_WorkTaskBillMain");
                    ds = oCN.RunProcReturn("select * from h_v_PM_WorkTaskBillList order by å•据号 ", "h_v_PM_WorkTaskBillList");
                }
                else
                {
                    string sql1 = "select * from PM_WorkTaskBillMain where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by HBillNo ";
                    ds = oCN.RunProcReturn(sql, "PM_WorkTaskBillMain");
                    string sql1 = "select * from h_v_PM_WorkTaskBillList where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by å•据号 ";
                    ds = oCN.RunProcReturn(sql, "h_v_PM_WorkTaskBillList");
                }
                //添加列名
@@ -1099,13 +1099,13 @@
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from PM_WorkTaskReportBillMain order by HBillNo desc ", "PM_ProjectStageBillMain");
                    ds = oCN.RunProcReturn("select * from h_v_PM_WorkTaskReportBillList order by å•据号", "h_v_PM_ProjectStageBillList");
                }
                else
                {
                    string sql1 = "select * from PM_WorkTaskReportBillMain where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by HBillNo desc ";
                    ds = oCN.RunProcReturn(sql, "PM_WorkTaskReportBillMain");
                    string sql1 = "select * from h_v_PM_WorkTaskReportBillList where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by å•据号";
                    ds = oCN.RunProcReturn(sql, "h_v_PM_WorkTaskReportBillList");
                }
                //添加列名