From f2b71fe1d3c2b7651d525a5b5bbe66fad602ea06 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 09 九月 2025 18:46:28 +0800
Subject: [PATCH] 代码清理

---
 WebApi/Gs.Report/CkController.cs |  713 +++++++++++++++++++++++++++++-----------------------------
 1 files changed, 359 insertions(+), 354 deletions(-)

diff --git a/WebApi/Gs.Report/CkController.cs b/WebApi/Gs.Report/CkController.cs
index 58ce2c1..5491102 100644
--- a/WebApi/Gs.Report/CkController.cs
+++ b/WebApi/Gs.Report/CkController.cs
@@ -1,366 +1,371 @@
-锘縰sing Gs.Toolbox;
+锘縰sing System.Data;
+using System.Data.SqlClient;
+using System.Dynamic;
+using Gs.Toolbox;
 using Gs.Toolbox.ApiCore.Abstract.Mvc;
 using Gs.Toolbox.ApiCore.Common.Mvc;
 using Gs.Toolbox.ApiCore.Group;
 using Microsoft.AspNetCore.Http;
 using Microsoft.AspNetCore.Mvc;
-using System.Data;
-using System.Data.SqlClient;
-using System.Dynamic;
 using static Gs.Toolbox.UtilityHelper;
 
 
-namespace Gs.Report
+namespace Gs.Report;
+
+[ApiGroup(ApiGroupNames.Report)]
+public class CkController : IRomteService
 {
+    private readonly IHttpContextAccessor _http;
+    private readonly string _userCode, _userGuid, _orgFids;
 
-    [ApiGroup(ApiGroupNames.Report)]
-    public class CkController : IRomteService
+    public CkController(IHttpContextAccessor httpContextAccessor)
     {
-        private readonly IHttpContextAccessor _http;
-        private readonly string _userCode, _userGuid, _orgFids;
-
-        public CkController(IHttpContextAccessor httpContextAccessor)
-        {
-            _http = httpContextAccessor;
-            (_userCode, _userGuid, _orgFids) =
-                GetUserGuidAndOrgGuid(_http);
-        }
-
-        /// <summary>
-        ///  鏉$爜搴撳瓨鏄庣粏
-        /// </summary>
-        /// <param name="model"></param>
-        /// <returns></returns>
-        [RequestMethod(RequestMethods.POST)]
-        public ReturnDto<PageList<dynamic>> GetListPage([FromBody] dynamic model)
-        {
-            int currentPage = model.currentPage;
-            int everyPageSize = model.everyPageSize;
-            string sortName = model.sortName;
-            string keyWhere = model.keyWhere;
-            SqlParameter[] parameters =
-            {
-            new("@inCurrentPage", currentPage),
-            new("@inEveryPageSize", everyPageSize),
-            new("@inSortName", sortName),
-            new("@inSortOrder", ""),
-            new("@inQueryWhere", keyWhere),
-            new("@inFid", ""),
-            new("@inP1", ""),
-            new("@inP2", ""),
-            new("@inP3", ""),
-            new("@inP4", "")
-        };
-            var dset = new DataSet();
-            var _pglist = new PageList<dynamic>
-            {
-                total = 0,
-                everyPageSize = 0,
-                pages = 0,
-                list = new List<dynamic>()
-            };
-            try
-            {
-                dset = DbHelperSQL.RunProcedure("report_cktm", parameters, "0");
-                if (dset != null && dset.Tables.Count > 0 &&
-                    dset.Tables[0].Rows.Count > 0) //鏈夋暟鎹�
-                {
-                    var intTotal =
-                        int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
-                    var pages = intTotal % everyPageSize != 0
-                        ? intTotal / everyPageSize + 1
-                        : intTotal / everyPageSize;
-                    _pglist.total = intTotal;
-                    _pglist.everyPageSize = everyPageSize;
-                    _pglist.pages = pages;
-                    var _dy = dset.Tables[0].TableToDynamicList();
-                    _pglist.list = _dy;
-                }
-            }
-            catch (Exception ex)
-            {
-                LogHelper.Debug(ToString(), ex.Message);
-            }
-
-            return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
-                ReturnCode.Success, "璇诲彇鎴愬姛");
-        }
-
-        /// <summary>
-        ///  閲囪喘鏄庣粏
-        /// </summary>
-        /// <param name="model"></param>
-        /// <returns></returns>
-        [RequestMethod(RequestMethods.POST)]
-        public ReturnDto<PageList<dynamic>> GetListPageCgmx([FromBody] dynamic model)
-        {
-            int currentPage = model.currentPage;
-            int everyPageSize = model.everyPageSize;
-            string sortName = model.sortName;
-            string keyWhere = model.keyWhere;
-            SqlParameter[] parameters =
-            {
-            new("@inCurrentPage", currentPage),
-            new("@inEveryPageSize", everyPageSize),
-            new("@inSortName", sortName),
-            new("@inSortOrder", ""),
-            new("@inQueryWhere", keyWhere),
-            new("@inFid", ""),
-            new("@inP1", ""),
-            new("@inP2", ""),
-            new("@inP3", ""),
-            new("@inP4", "")
-        };
-            var dset = new DataSet();
-            var _pglist = new PageList<dynamic>
-            {
-                total = 0,
-                everyPageSize = 0,
-                pages = 0,
-                list = new List<dynamic>()
-            };
-            try
-            {
-                dset = DbHelperSQL.RunProcedure("report_cgmx", parameters, "0");
-                if (dset != null && dset.Tables.Count > 0 &&
-                    dset.Tables[0].Rows.Count > 0) //鏈夋暟鎹�
-                {
-                    var intTotal =
-                        int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
-                    var pages = intTotal % everyPageSize != 0
-                        ? intTotal / everyPageSize + 1
-                        : intTotal / everyPageSize;
-                    _pglist.total = intTotal;
-                    _pglist.everyPageSize = everyPageSize;
-                    _pglist.pages = pages;
-                    var _dy = dset.Tables[0].TableToDynamicList();
-                    _pglist.list = _dy;
-                }
-            }
-            catch (Exception ex)
-            {
-                LogHelper.Debug(ToString(), ex.Message);
-            }
-            return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
-                ReturnCode.Success, "璇诲彇鎴愬姛");
-        }
-
-
-
-        /// <summary>
-        ///  楠岄��鏄庣粏
-        /// </summary>
-        /// <param name="model"></param>
-        /// <returns></returns>
-        [RequestMethod(RequestMethods.POST)]
-        public ReturnDto<PageList<dynamic>> GetListPageYtmx([FromBody] dynamic model)
-        {
-            int currentPage = model.currentPage;
-            int everyPageSize = model.everyPageSize;
-            string sortName = model.sortName;
-            string keyWhere = model.keyWhere;
-            SqlParameter[] parameters =
-            {
-            new("@inCurrentPage", currentPage),
-            new("@inEveryPageSize", everyPageSize),
-            new("@inSortName", sortName),
-            new("@inSortOrder", ""),
-            new("@inQueryWhere", keyWhere),
-            new("@inFid", ""),
-            new("@inP1", ""),
-            new("@inP2", ""),
-            new("@inP3", ""),
-            new("@inP4", "")
-        };
-            var dset = new DataSet();
-            var _pglist = new PageList<dynamic>
-            {
-                total = 0,
-                everyPageSize = 0,
-                pages = 0,
-                list = new List<dynamic>()
-            };
-            try
-            {
-                dset = DbHelperSQL.RunProcedure("report_ytmx", parameters, "0");
-                if (dset != null && dset.Tables.Count > 0 &&
-                    dset.Tables[0].Rows.Count > 0) //鏈夋暟鎹�
-                {
-                    var intTotal =
-                        int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
-                    var pages = intTotal % everyPageSize != 0
-                        ? intTotal / everyPageSize + 1
-                        : intTotal / everyPageSize;
-                    _pglist.total = intTotal;
-                    _pglist.everyPageSize = everyPageSize;
-                    _pglist.pages = pages;
-                    var _dy = dset.Tables[0].TableToDynamicList();
-                    _pglist.list = _dy;
-                }
-            }
-            catch (Exception ex)
-            {
-                LogHelper.Debug(ToString(), ex.Message);
-            }
-
-            return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
-                ReturnCode.Success, "璇诲彇鎴愬姛");
-        }
-
-
-        /// <summary>
-        ///  閫佽揣璁″垝鏄庣粏
-        /// </summary>
-        /// <param name="model"></param>
-        /// <returns></returns>
-        [RequestMethod(RequestMethods.POST)]
-        public ReturnDto<PageList<dynamic>> GetListPageShjh([FromBody] dynamic model)
-        {
-            int currentPage = model.currentPage;
-            int everyPageSize = model.everyPageSize;
-            string sortName = model.sortName;
-            string keyWhere = model.keyWhere;
-            SqlParameter[] parameters =
-            {
-            new("@inCurrentPage", currentPage),
-            new("@inEveryPageSize", everyPageSize),
-            new("@inSortName", sortName),
-            new("@inSortOrder", ""),
-            new("@inQueryWhere", keyWhere),
-            new("@inFid", ""),
-            new("@inP1", ""),
-            new("@inP2", ""),
-            new("@inP3", ""),
-            new("@inP4", "")
-        };
-            var dset = new DataSet();
-            var _pglist = new PageList<dynamic>
-            {
-                total = 0,
-                everyPageSize = 0,
-                pages = 0,
-                list = new List<dynamic>()
-            };
-            try
-            {
-                dset = DbHelperSQL.RunProcedure("report_shjh", parameters, "0");
-                if (dset != null && dset.Tables.Count > 0 &&
-                    dset.Tables[0].Rows.Count > 0) //鏈夋暟鎹�
-                {
-                    var intTotal =
-                        int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
-                    var pages = intTotal % everyPageSize != 0
-                        ? intTotal / everyPageSize + 1
-                        : intTotal / everyPageSize;
-                    _pglist.total = intTotal;
-                    _pglist.everyPageSize = everyPageSize;
-                    _pglist.pages = pages;
-                    var _dy = dset.Tables[0].TableToDynamicList();
-                    _pglist.list = _dy;
-                }
-            }
-            catch (Exception ex)
-            {
-                LogHelper.Debug(ToString(), ex.Message);
-            }
-            return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
-                ReturnCode.Success, "璇诲彇鎴愬姛");
-        }
-
-        /// <summary>
-        ///     璇诲彇
-        /// </summary>
-        /// <param name="guid"></param>
-        /// <returns></returns>
-        [RequestMethod(RequestMethods.POST)]
-        public ReturnDto<ExpandoObject> GetModel([FromBody] dynamic model)
-        {
-            string guid = model.guid.ToString();
-            dynamic m = new ExpandoObject();
-            SqlParameter[] parameters =
-            {
-                new("@inMainGuid", guid),
-            };
-            var dset = new DataSet();
-            try
-            {
-                dset = DbHelperSQL.RunProcedure("[report_cktm_MX]", parameters, "0");
-                if (dset != null && dset.Tables.Count > 0 &&
-                    dset.Tables[0].Rows.Count > 0)
-                {
-                    var dr = dset.Tables[0].Rows[0];
-                    m = dr.RowToDynamic();
-                }
-            }
-            catch (Exception ex)
-            {
-                LogHelper.Debug(ToString(), ex.Message);
-            }
-
-            if (m != null)
-                return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success,
-                    "璇诲彇鎴愬姛锛�");
-            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�");
-        }
-
-
-        /// <summary>
-        ///  鍙婃椂搴撳瓨宸紓琛�
-        /// </summary>
-        /// <param name="model"></param>
-        /// <returns></returns>
-        [RequestMethod(RequestMethods.POST)]
-        public ReturnDto<PageList<dynamic>> GetListPageJskc([FromBody] dynamic model)
-        {
-            int currentPage = model.currentPage;
-            int everyPageSize = model.everyPageSize;
-            string sortName = model.sortName;
-            string keyWhere = model.keyWhere;
-            SqlParameter[] parameters =
-            {
-            new("@inCurrentPage", currentPage),
-            new("@inEveryPageSize", everyPageSize),
-            new("@inSortName", sortName),
-            new("@inSortOrder", ""),
-            new("@inQueryWhere", keyWhere),
-            new("@inFid", ""),
-            new("@inP1", ""),
-            new("@inP2", ""),
-            new("@inP3", ""),
-            new("@inP4", "")
-        };
-            var dset = new DataSet();
-            var _pglist = new PageList<dynamic>
-            {
-                total = 0,
-                everyPageSize = 0,
-                pages = 0,
-                list = new List<dynamic>()
-            };
-            try
-            {
-                dset = DbHelperSQL.RunProcedure("report_jskc", parameters, "0");
-                if (dset != null && dset.Tables.Count > 0 &&
-                    dset.Tables[0].Rows.Count > 0) //鏈夋暟鎹�
-                {
-                    var intTotal =
-                        int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
-                    var pages = intTotal % everyPageSize != 0
-                        ? intTotal / everyPageSize + 1
-                        : intTotal / everyPageSize;
-                    _pglist.total = intTotal;
-                    _pglist.everyPageSize = everyPageSize;
-                    _pglist.pages = pages;
-                    var _dy = dset.Tables[0].TableToDynamicList();
-                    _pglist.list = _dy;
-                }
-            }
-            catch (Exception ex)
-            {
-                LogHelper.Debug(ToString(), ex.Message);
-            }
-            return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
-                ReturnCode.Success, "璇诲彇鎴愬姛");
-        }
+        _http = httpContextAccessor;
+        (_userCode, _userGuid, _orgFids) =
+            GetUserGuidAndOrgGuid(_http);
     }
-}
+
+    /// <summary>
+    ///     鏉$爜搴撳瓨鏄庣粏
+    /// </summary>
+    /// <param name="model"></param>
+    /// <returns></returns>
+    [RequestMethod(RequestMethods.POST)]
+    public ReturnDto<PageList<dynamic>> GetListPage([FromBody] dynamic model)
+    {
+        int currentPage = model.currentPage;
+        int everyPageSize = model.everyPageSize;
+        string sortName = model.sortName;
+        string keyWhere = model.keyWhere;
+        SqlParameter[] parameters =
+        {
+            new("@inCurrentPage", currentPage),
+            new("@inEveryPageSize", everyPageSize),
+            new("@inSortName", sortName),
+            new("@inSortOrder", ""),
+            new("@inQueryWhere", keyWhere),
+            new("@inFid", ""),
+            new("@inP1", ""),
+            new("@inP2", ""),
+            new("@inP3", ""),
+            new("@inP4", "")
+        };
+        var dset = new DataSet();
+        var _pglist = new PageList<dynamic>
+        {
+            total = 0,
+            everyPageSize = 0,
+            pages = 0,
+            list = new List<dynamic>()
+        };
+        try
+        {
+            dset = DbHelperSQL.RunProcedure("report_cktm", parameters, "0");
+            if (dset != null && dset.Tables.Count > 0 &&
+                dset.Tables[0].Rows.Count > 0) //鏈夋暟鎹�
+            {
+                var intTotal =
+                    int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
+                var pages = intTotal % everyPageSize != 0
+                    ? intTotal / everyPageSize + 1
+                    : intTotal / everyPageSize;
+                _pglist.total = intTotal;
+                _pglist.everyPageSize = everyPageSize;
+                _pglist.pages = pages;
+                var _dy = dset.Tables[0].TableToDynamicList();
+                _pglist.list = _dy;
+            }
+        }
+        catch (Exception ex)
+        {
+            LogHelper.Debug(ToString(), ex.Message);
+        }
+
+        return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
+            ReturnCode.Success, "璇诲彇鎴愬姛");
+    }
+
+    /// <summary>
+    ///     閲囪喘鏄庣粏
+    /// </summary>
+    /// <param name="model"></param>
+    /// <returns></returns>
+    [RequestMethod(RequestMethods.POST)]
+    public ReturnDto<PageList<dynamic>> GetListPageCgmx(
+        [FromBody] dynamic model)
+    {
+        int currentPage = model.currentPage;
+        int everyPageSize = model.everyPageSize;
+        string sortName = model.sortName;
+        string keyWhere = model.keyWhere;
+        SqlParameter[] parameters =
+        {
+            new("@inCurrentPage", currentPage),
+            new("@inEveryPageSize", everyPageSize),
+            new("@inSortName", sortName),
+            new("@inSortOrder", ""),
+            new("@inQueryWhere", keyWhere),
+            new("@inFid", ""),
+            new("@inP1", ""),
+            new("@inP2", ""),
+            new("@inP3", ""),
+            new("@inP4", "")
+        };
+        var dset = new DataSet();
+        var _pglist = new PageList<dynamic>
+        {
+            total = 0,
+            everyPageSize = 0,
+            pages = 0,
+            list = new List<dynamic>()
+        };
+        try
+        {
+            dset = DbHelperSQL.RunProcedure("report_cgmx", parameters, "0");
+            if (dset != null && dset.Tables.Count > 0 &&
+                dset.Tables[0].Rows.Count > 0) //鏈夋暟鎹�
+            {
+                var intTotal =
+                    int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
+                var pages = intTotal % everyPageSize != 0
+                    ? intTotal / everyPageSize + 1
+                    : intTotal / everyPageSize;
+                _pglist.total = intTotal;
+                _pglist.everyPageSize = everyPageSize;
+                _pglist.pages = pages;
+                var _dy = dset.Tables[0].TableToDynamicList();
+                _pglist.list = _dy;
+            }
+        }
+        catch (Exception ex)
+        {
+            LogHelper.Debug(ToString(), ex.Message);
+        }
+
+        return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
+            ReturnCode.Success, "璇诲彇鎴愬姛");
+    }
+
+
+    /// <summary>
+    ///     楠岄��鏄庣粏
+    /// </summary>
+    /// <param name="model"></param>
+    /// <returns></returns>
+    [RequestMethod(RequestMethods.POST)]
+    public ReturnDto<PageList<dynamic>> GetListPageYtmx(
+        [FromBody] dynamic model)
+    {
+        int currentPage = model.currentPage;
+        int everyPageSize = model.everyPageSize;
+        string sortName = model.sortName;
+        string keyWhere = model.keyWhere;
+        SqlParameter[] parameters =
+        {
+            new("@inCurrentPage", currentPage),
+            new("@inEveryPageSize", everyPageSize),
+            new("@inSortName", sortName),
+            new("@inSortOrder", ""),
+            new("@inQueryWhere", keyWhere),
+            new("@inFid", ""),
+            new("@inP1", ""),
+            new("@inP2", ""),
+            new("@inP3", ""),
+            new("@inP4", "")
+        };
+        var dset = new DataSet();
+        var _pglist = new PageList<dynamic>
+        {
+            total = 0,
+            everyPageSize = 0,
+            pages = 0,
+            list = new List<dynamic>()
+        };
+        try
+        {
+            dset = DbHelperSQL.RunProcedure("report_ytmx", parameters, "0");
+            if (dset != null && dset.Tables.Count > 0 &&
+                dset.Tables[0].Rows.Count > 0) //鏈夋暟鎹�
+            {
+                var intTotal =
+                    int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
+                var pages = intTotal % everyPageSize != 0
+                    ? intTotal / everyPageSize + 1
+                    : intTotal / everyPageSize;
+                _pglist.total = intTotal;
+                _pglist.everyPageSize = everyPageSize;
+                _pglist.pages = pages;
+                var _dy = dset.Tables[0].TableToDynamicList();
+                _pglist.list = _dy;
+            }
+        }
+        catch (Exception ex)
+        {
+            LogHelper.Debug(ToString(), ex.Message);
+        }
+
+        return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
+            ReturnCode.Success, "璇诲彇鎴愬姛");
+    }
+
+
+    /// <summary>
+    ///     閫佽揣璁″垝鏄庣粏
+    /// </summary>
+    /// <param name="model"></param>
+    /// <returns></returns>
+    [RequestMethod(RequestMethods.POST)]
+    public ReturnDto<PageList<dynamic>> GetListPageShjh(
+        [FromBody] dynamic model)
+    {
+        int currentPage = model.currentPage;
+        int everyPageSize = model.everyPageSize;
+        string sortName = model.sortName;
+        string keyWhere = model.keyWhere;
+        SqlParameter[] parameters =
+        {
+            new("@inCurrentPage", currentPage),
+            new("@inEveryPageSize", everyPageSize),
+            new("@inSortName", sortName),
+            new("@inSortOrder", ""),
+            new("@inQueryWhere", keyWhere),
+            new("@inFid", ""),
+            new("@inP1", ""),
+            new("@inP2", ""),
+            new("@inP3", ""),
+            new("@inP4", "")
+        };
+        var dset = new DataSet();
+        var _pglist = new PageList<dynamic>
+        {
+            total = 0,
+            everyPageSize = 0,
+            pages = 0,
+            list = new List<dynamic>()
+        };
+        try
+        {
+            dset = DbHelperSQL.RunProcedure("report_shjh", parameters, "0");
+            if (dset != null && dset.Tables.Count > 0 &&
+                dset.Tables[0].Rows.Count > 0) //鏈夋暟鎹�
+            {
+                var intTotal =
+                    int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
+                var pages = intTotal % everyPageSize != 0
+                    ? intTotal / everyPageSize + 1
+                    : intTotal / everyPageSize;
+                _pglist.total = intTotal;
+                _pglist.everyPageSize = everyPageSize;
+                _pglist.pages = pages;
+                var _dy = dset.Tables[0].TableToDynamicList();
+                _pglist.list = _dy;
+            }
+        }
+        catch (Exception ex)
+        {
+            LogHelper.Debug(ToString(), ex.Message);
+        }
+
+        return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
+            ReturnCode.Success, "璇诲彇鎴愬姛");
+    }
+
+    /// <summary>
+    ///     璇诲彇
+    /// </summary>
+    /// <param name="guid"></param>
+    /// <returns></returns>
+    [RequestMethod(RequestMethods.POST)]
+    public ReturnDto<ExpandoObject> GetModel([FromBody] dynamic model)
+    {
+        string guid = model.guid.ToString();
+        dynamic m = new ExpandoObject();
+        SqlParameter[] parameters =
+        {
+            new("@inMainGuid", guid)
+        };
+        var dset = new DataSet();
+        try
+        {
+            dset = DbHelperSQL.RunProcedure("[report_cktm_MX]", parameters,
+                "0");
+            if (dset != null && dset.Tables.Count > 0 &&
+                dset.Tables[0].Rows.Count > 0)
+            {
+                var dr = dset.Tables[0].Rows[0];
+                m = dr.RowToDynamic();
+            }
+        }
+        catch (Exception ex)
+        {
+            LogHelper.Debug(ToString(), ex.Message);
+        }
+
+        if (m != null)
+            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success,
+                "璇诲彇鎴愬姛锛�");
+        return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�");
+    }
+
+
+    /// <summary>
+    ///     鍙婃椂搴撳瓨宸紓琛�
+    /// </summary>
+    /// <param name="model"></param>
+    /// <returns></returns>
+    [RequestMethod(RequestMethods.POST)]
+    public ReturnDto<PageList<dynamic>> GetListPageJskc(
+        [FromBody] dynamic model)
+    {
+        int currentPage = model.currentPage;
+        int everyPageSize = model.everyPageSize;
+        string sortName = model.sortName;
+        string keyWhere = model.keyWhere;
+        SqlParameter[] parameters =
+        {
+            new("@inCurrentPage", currentPage),
+            new("@inEveryPageSize", everyPageSize),
+            new("@inSortName", sortName),
+            new("@inSortOrder", ""),
+            new("@inQueryWhere", keyWhere),
+            new("@inFid", ""),
+            new("@inP1", ""),
+            new("@inP2", ""),
+            new("@inP3", ""),
+            new("@inP4", "")
+        };
+        var dset = new DataSet();
+        var _pglist = new PageList<dynamic>
+        {
+            total = 0,
+            everyPageSize = 0,
+            pages = 0,
+            list = new List<dynamic>()
+        };
+        try
+        {
+            dset = DbHelperSQL.RunProcedure("report_jskc", parameters, "0");
+            if (dset != null && dset.Tables.Count > 0 &&
+                dset.Tables[0].Rows.Count > 0) //鏈夋暟鎹�
+            {
+                var intTotal =
+                    int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
+                var pages = intTotal % everyPageSize != 0
+                    ? intTotal / everyPageSize + 1
+                    : intTotal / everyPageSize;
+                _pglist.total = intTotal;
+                _pglist.everyPageSize = everyPageSize;
+                _pglist.pages = pages;
+                var _dy = dset.Tables[0].TableToDynamicList();
+                _pglist.list = _dy;
+            }
+        }
+        catch (Exception ex)
+        {
+            LogHelper.Debug(ToString(), ex.Message);
+        }
+
+        return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
+            ReturnCode.Success, "璇诲彇鎴愬姛");
+    }
+}
\ No newline at end of file

--
Gitblit v1.9.3