From 552e0511da582564137c172298eea33290630502 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期三, 24 一月 2024 17:33:41 +0800
Subject: [PATCH] 我的项目查询
---
WebAPI/Controllers/项目管理/报表分析/PM_ReportController.cs | 15 +++------------
1 files changed, 3 insertions(+), 12 deletions(-)
diff --git "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/PM_ReportController.cs" "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/PM_ReportController.cs"
index 4748a1d..fd06a47 100644
--- "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/PM_ReportController.cs"
+++ "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/PM_ReportController.cs"
@@ -203,17 +203,8 @@
objJsonResult.data = null;
return objJsonResult;
}
-
- if (sWhere == null || sWhere.Equals(""))
- {
- ds = oCn.RunProcReturn("select * from h_v_PM_ProjectBillMYList order by 鍗曟嵁鍙� desc", "h_v_PM_ProjectBillMYList");
- }
- else
- {
- string sql1 = "select * from h_v_PM_ProjectBillMYList where 1 = 1 ";
- string sql = sql1 + sWhere + " order by 鍗曟嵁鍙� desc";
- ds = oCn.RunProcReturn(sql, "h_v_PM_ProjectBillMYList");
- }
+ string sql = "exec h_p_My_PM_ProjectReportBill " + user+",0,''";
+ ds=oCn.RunProcReturn(sql, "h_p_My_PM_ProjectReportBill");
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
@@ -226,7 +217,7 @@
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "鎴愬姛锛�";
- objJsonResult.data = ds.Tables[0];
+ objJsonResult.data = ds;
objJsonResult.list = columnNameList;
return objJsonResult;
}
--
Gitblit v1.9.1