增加工艺参数大类分析报表方法,新增字段 HTechParamClassID int //工艺参数大类（Gy_TechnologyParameterCl...

zrg

2024-08-12 2a363a58ad45f09afdcc0a2c54383b0a76ea1208

 WebAPI/Controllers/XSGL/Kf_SellOutEntryReportController.cs

@@ -37,15 +37,16 @@
            try
            {
                List<object> columnNameList = new List<object>();
                List<DataTable> tableList = new List<DataTable>();
                ////查看权限
                //if (!DBUtility.ClsPub.Security_Log("Kf_SellOutEntryReport_Query", 1, false, user))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "无查看权限！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                if (!DBUtility.ClsPub.Security_Log("Kf_SellOutEntryReport", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无查看权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }


                //查询
@@ -60,6 +61,9 @@
                    ds = oCN.RunProcReturn(sql, "h_p_Kf_SellOutEntryReport");
                }

                tableList.Add(ds.Tables[0]);
                tableList.Add(ds.Tables[1]);

                //添加列名
                foreach (DataColumn col in ds.Tables[0].Columns)
                {
@@ -71,7 +75,7 @@
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.data = tableList;
                objJsonResult.list = columnNameList;
                return objJsonResult;
            }