From 5a54c45733f6570db9476eb53fe840c312beb17f Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期五, 14 七月 2023 11:06:12 +0800 Subject: [PATCH] 项目管理:列表列名改为中文 --- WebAPI/Controllers/项目管理/工作任务/PM_WorkTaskBillController.cs | 16 ++++++++-------- 1 files changed, 8 insertions(+), 8 deletions(-) diff --git "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskBillController.cs" "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskBillController.cs" index e2715f7..113e711 100644 --- "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskBillController.cs" +++ "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/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"); } //娣诲姞鍒楀悕 -- Gitblit v1.9.1