1

duhe

2024-01-25 8df2ba3888e02e82448c464791b5354b0a087920

 WebAPI/Controllers/ÏîÄ¿¹ÜÀí/±¨±í·ÖÎö/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;
            }