From c95807a552fb8814285488b1945a26cfde7ee3fd Mon Sep 17 00:00:00 2001 From: kyy <3283105747@qq.com> Date: 星期五, 26 九月 2025 13:36:02 +0800 Subject: [PATCH] 台账设备报表挪移 --- WebApi/Gs.Report/YS_jhdcl.cs | 49 WebApi/Gs.Report/YS_mjczjl.cs | 247 +++++++ WebApi/Gs.Report/YS_sbtzb.cs | 352 +++++++--- WebApi/Gs.Report/YS_sb_djjl.cs | 352 +++++++--- WebApi/Gs.Report/YS_rkjreport.cs | 49 WebApi/Gs.Report/YS_xjreport.cs | 49 WebApi/Gs.Report/YS_mjtz.cs | 247 +++++++ WebApi/Gs.Report/YS_iqc_report.cs | 49 WebApi/Gs.Report/YS_sjreport.cs | 49 WebApi/Gs.Report/YS_bgjlb.cs | 49 WebApi/Gs.Report/YS_py_pk_d.cs | 49 WebApi/Gs.Report/YS_sbbyjlb.cs | 355 +++++++--- 12 files changed, 1,394 insertions(+), 502 deletions(-) diff --git a/WebApi/Gs.Report/YS_bgjlb.cs b/WebApi/Gs.Report/YS_bgjlb.cs index d862278..ad106f5 100644 --- a/WebApi/Gs.Report/YS_bgjlb.cs +++ b/WebApi/Gs.Report/YS_bgjlb.cs @@ -1,18 +1,17 @@ -锘縰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 { - [ApiGroup(ApiGroupNames.Report)] public class YS_bgjlb : IRomteService { @@ -32,7 +31,8 @@ /// <param name="model"></param> /// <returns></returns> [RequestMethod(RequestMethods.POST)] - public ReturnDto<PageList<dynamic>> GetListPage([FromBody] dynamic model) + public ReturnDto<PageList<dynamic>> GetListPage( + [FromBody] dynamic model) { int currentPage = model.currentPage; int everyPageSize = model.everyPageSize; @@ -40,17 +40,17 @@ 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", "") - }; + 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> { @@ -61,12 +61,14 @@ }; try { - dset = DbHelperSQL.RunProcedure("prc_pc_ysBgjlb_cx", parameters, "0"); + dset = DbHelperSQL.RunProcedure("prc_pc_ysBgjlb_cx", 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()); + int.Parse(dset.Tables[1].Rows[0]["intTotal"] + .ToString()); var pages = intTotal % everyPageSize != 0 ? intTotal / everyPageSize + 1 : intTotal / everyPageSize; @@ -103,7 +105,8 @@ var dset = new DataSet(); try { - dset = DbHelperSQL.RunProcedure("[YS_bgjlb_MX]", parameters, "0"); + dset = DbHelperSQL.RunProcedure("[YS_bgjlb_MX]", parameters, + "0"); if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0) { @@ -119,8 +122,8 @@ if (m != null) return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "璇诲彇鎴愬姛锛�"); - return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�"); + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, + "璇诲彇澶辫触锛�"); } } -} - +} \ No newline at end of file diff --git a/WebApi/Gs.Report/YS_iqc_report.cs b/WebApi/Gs.Report/YS_iqc_report.cs index b9d84de..5e40e28 100644 --- a/WebApi/Gs.Report/YS_iqc_report.cs +++ b/WebApi/Gs.Report/YS_iqc_report.cs @@ -1,18 +1,17 @@ -锘縰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 { - [ApiGroup(ApiGroupNames.Report)] public class YS_iqc_report : IRomteService { @@ -32,7 +31,8 @@ /// <param name="model"></param> /// <returns></returns> [RequestMethod(RequestMethods.POST)] - public ReturnDto<PageList<dynamic>> GetListPage([FromBody] dynamic model) + public ReturnDto<PageList<dynamic>> GetListPage( + [FromBody] dynamic model) { int currentPage = model.currentPage; int everyPageSize = model.everyPageSize; @@ -40,17 +40,17 @@ 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", "") - }; + 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> { @@ -61,12 +61,14 @@ }; try { - dset = DbHelperSQL.RunProcedure("prc_pc_ysiqcReport_cx", parameters, "0"); + dset = DbHelperSQL.RunProcedure("prc_pc_ysiqcReport_cx", + 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()); + int.Parse(dset.Tables[1].Rows[0]["intTotal"] + .ToString()); var pages = intTotal % everyPageSize != 0 ? intTotal / everyPageSize + 1 : intTotal / everyPageSize; @@ -103,7 +105,8 @@ var dset = new DataSet(); try { - dset = DbHelperSQL.RunProcedure("[YS_iqc_report_MX]", parameters, "0"); + dset = DbHelperSQL.RunProcedure("[YS_iqc_report_MX]", + parameters, "0"); if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0) { @@ -119,8 +122,8 @@ if (m != null) return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "璇诲彇鎴愬姛锛�"); - return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�"); + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, + "璇诲彇澶辫触锛�"); } } -} - +} \ No newline at end of file diff --git a/WebApi/Gs.Report/YS_jhdcl.cs b/WebApi/Gs.Report/YS_jhdcl.cs index 9b6e004..642a5a4 100644 --- a/WebApi/Gs.Report/YS_jhdcl.cs +++ b/WebApi/Gs.Report/YS_jhdcl.cs @@ -1,18 +1,17 @@ -锘縰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 { - [ApiGroup(ApiGroupNames.Report)] public class YS_jhdcl : IRomteService { @@ -32,7 +31,8 @@ /// <param name="model"></param> /// <returns></returns> [RequestMethod(RequestMethods.POST)] - public ReturnDto<PageList<dynamic>> GetListPage([FromBody] dynamic model) + public ReturnDto<PageList<dynamic>> GetListPage( + [FromBody] dynamic model) { int currentPage = model.currentPage; int everyPageSize = model.everyPageSize; @@ -40,17 +40,17 @@ 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", "") - }; + 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> { @@ -61,12 +61,14 @@ }; try { - dset = DbHelperSQL.RunProcedure("prc_pc_ysJhdcl_cx", parameters, "0"); + dset = DbHelperSQL.RunProcedure("prc_pc_ysJhdcl_cx", 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()); + int.Parse(dset.Tables[1].Rows[0]["intTotal"] + .ToString()); var pages = intTotal % everyPageSize != 0 ? intTotal / everyPageSize + 1 : intTotal / everyPageSize; @@ -103,7 +105,8 @@ var dset = new DataSet(); try { - dset = DbHelperSQL.RunProcedure("[YS_jhdcl_MX]", parameters, "0"); + dset = DbHelperSQL.RunProcedure("[YS_jhdcl_MX]", parameters, + "0"); if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0) { @@ -119,8 +122,8 @@ if (m != null) return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "璇诲彇鎴愬姛锛�"); - return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�"); + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, + "璇诲彇澶辫触锛�"); } } -} - +} \ No newline at end of file diff --git a/WebApi/Gs.Report/YS_mjczjl.cs b/WebApi/Gs.Report/YS_mjczjl.cs new file mode 100644 index 0000000..050b036 --- /dev/null +++ b/WebApi/Gs.Report/YS_mjczjl.cs @@ -0,0 +1,247 @@ +锘縰sing System.Data; +using System.Data.SqlClient; +using System.Dynamic; +using System.Text; +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 static Gs.Toolbox.UtilityHelper; + +namespace Gs.Report; +/// <summary> +/// 妯″叿鎿嶄綔璁板綍 +/// </summary> +[ApiGroup(ApiGroupNames.Report)] +public class YS_mjczjl : IRomteService +{ + private readonly IHttpContextAccessor _http; + + private readonly string _userCode, _userGuid, _orgFids; + public YS_mjczjl(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("prc_pc_ysMjczjl_cx", 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<ExpandoObject> GetModel([FromBody] dynamic model) + { + string guid = model.guid.ToString(); + dynamic m = new ExpandoObject(); + m.list = new List<dynamic>(); + m.list2 = new List<dynamic>(); + // 鍋囪涓昏〃涓篗ES_JJGZ_JS_SALARY锛屾槑缁嗚〃涓篗ES_JJGZ_JS_SALARY_DETAIL + string mainTable = "YS_mjczjl"; + try + { + string sqlMain = $"SELECT * FROM {mainTable} WHERE guid='{guid}'"; + var dsMain = DbHelperSQL.Query(sqlMain); + if (dsMain != null && dsMain.Tables.Count > 0 && dsMain.Tables[0].Rows.Count > 0) + { + var dr = dsMain.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="mode"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<ExpandoObject> EditModelSubmit([FromBody] dynamic mode) + { + string _guid = mode.guid; + string _inFieldValue = mode.inFieldValue; + dynamic m = new ExpandoObject(); + m.outSum = -1; + m.outMsg = ""; + try + { + // 鍋囪鎻愪氦灏辨槸鏇存柊鏌愪釜瀛楁 + string sql = $"UPDATE YS_mjczjl SET check_status='{_inFieldValue}',check_date = getdate(), check_user='{_userGuid}' WHERE guid='{_guid}'"; + int rows = DbHelperSQL.ExecuteSql(sql); + m.outSum = rows; + m.outMsg = rows > 0 ? "鎿嶄綔鎴愬姛锛�" : "鏈洿鏂颁换浣曟暟鎹�"; + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "EditModelSubmit error锛�" + ex.Message); + m.outMsg = ex.Message; + m.outSum = -1; + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, ex.Message); + } + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "鎿嶄綔鎴愬姛锛�"); + } + + /// <summary> + /// 澧炲姞鎴栫紪杈戝疄浣� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<ExpandoObject> EditModel([FromBody] dynamic model) + { + Guid? guid = model.guid; //涓婚敭 + string yf = model.yf;//鏈堜唤 + string czrq = model.czrq;//鎿嶄綔鏃ユ湡 + string bz = model.bz;//澶囨敞 + string mjbm = model.mjbm;//妯″叿缂栫爜 + string mjmc = model.mjmc;//妯″叿鍚嶇О + string mjcz = model.mjcz;//妯″叿鎿嶄綔 + + dynamic mObj = new ExpandoObject(); + mObj.outMsg = ""; + mObj.outSum = -1; + mObj.outGuid = ""; + mObj.outNo = ""; + try + { + string sql; + if (CheckGuid(guid)) + { + sql = $"declare @userBy nvarchar(20); select top 1 @userBy=[ACCOUNT] from [dbo].[SYS_USER] where guid='{_userGuid}'" + + $"UPDATE YS_mjczjl SET yf='{yf}', czrq='{czrq}', bz='{bz}', mjbm='{mjbm}', mjmc='{mjmc}', mjcz='{mjcz}' WHERE guid='{guid}'"; + } + else + { + guid = Guid.NewGuid(); + sql = $" declare @userBy nvarchar(20); select top 1 @userBy=[ACCOUNT] from [dbo].[SYS_USER] where guid='{_userGuid}' " + + $"INSERT INTO YS_mjczjl (guid,yf, czrq, bz, mjbm, mjmc, mjcz ) " + + $"VALUES ('{guid}', '{yf}', '{czrq}', '{bz}', '{mjbm}', '{mjmc}', '{mjcz}')"; + } + int rows = DbHelperSQL.ExecuteSql(sql); + mObj.outSum = rows; + mObj.outGuid = guid.ToString(); + mObj.outMsg = rows > 0 ? "鎿嶄綔鎴愬姛锛�" : "鏈洿鏂颁换浣曟暟鎹�"; + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "EditModel error锛�" + ex.Message); + mObj.outMsg = ex.Message; + mObj.outSum = -1; + } + if (mObj.outSum <= 0) + return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception, mObj.outMsg); + return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success, mObj.outMsg); + } + + /// <summary> + /// 鍒犻櫎涓昏〃鎴栨槑缁� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<int?> DeleteModel([FromBody] dynamic model) + { + int? rtnInt = (int)ReturnCode.Default; + Guid? guid = model.guid; //鍒拌揣鍗曚富閿� + string mxGuid = model.mxGuid; + var _outMsg = ""; + var _outSum = -1; + try + { + if (CheckGuid(guid)) + { + string sql = $"DELETE FROM YS_mjczjl WHERE guid='{guid}'"; + _outSum = DbHelperSQL.ExecuteSql(sql); + _outMsg = _outSum > 0 ? "鍒犻櫎鎴愬姛锛�" : "鏈垹闄や换浣曟暟鎹�"; + } + else + { + _outMsg = "涓婚敭涓嶈兘涓虹┖锛�"; + _outSum = -1; + } + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "DeleteModel error锛�" + ex.Message); + _outMsg = ex.Message; + _outSum = -1; + } + if (_outSum <= 0) + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception, _outMsg); + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg); + } +} \ No newline at end of file diff --git a/WebApi/Gs.Report/YS_mjtz.cs b/WebApi/Gs.Report/YS_mjtz.cs new file mode 100644 index 0000000..0ea04e4 --- /dev/null +++ b/WebApi/Gs.Report/YS_mjtz.cs @@ -0,0 +1,247 @@ +锘縰sing System.Data; +using System.Data.SqlClient; +using System.Dynamic; +using System.Text; +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 static Gs.Toolbox.UtilityHelper; + +namespace Gs.Report; +/// <summary> +/// 妯″叿鍙拌处 +/// </summary> +[ApiGroup(ApiGroupNames.Report)] +public class YS_mjtz : IRomteService +{ + private readonly IHttpContextAccessor _http; + + private readonly string _userCode, _userGuid, _orgFids; + public YS_mjtz(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("prc_pc_ysMjtz_cx", 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<ExpandoObject> GetModel([FromBody] dynamic model) + { + string guid = model.guid.ToString(); + dynamic m = new ExpandoObject(); + m.list = new List<dynamic>(); + m.list2 = new List<dynamic>(); + // 鍋囪涓昏〃涓篗ES_JJGZ_JS_SALARY锛屾槑缁嗚〃涓篗ES_JJGZ_JS_SALARY_DETAIL + string mainTable = "YS_mjtz"; + try + { + string sqlMain = $"SELECT * FROM {mainTable} WHERE guid='{guid}'"; + var dsMain = DbHelperSQL.Query(sqlMain); + if (dsMain != null && dsMain.Tables.Count > 0 && dsMain.Tables[0].Rows.Count > 0) + { + var dr = dsMain.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="mode"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<ExpandoObject> EditModelSubmit([FromBody] dynamic mode) + { + string _guid = mode.guid; + string _inFieldValue = mode.inFieldValue; + dynamic m = new ExpandoObject(); + m.outSum = -1; + m.outMsg = ""; + try + { + // 鍋囪鎻愪氦灏辨槸鏇存柊鏌愪釜瀛楁 + string sql = $"UPDATE YS_mjtz SET check_status='{_inFieldValue}',check_date = getdate(), check_user='{_userGuid}' WHERE guid='{_guid}'"; + int rows = DbHelperSQL.ExecuteSql(sql); + m.outSum = rows; + m.outMsg = rows > 0 ? "鎿嶄綔鎴愬姛锛�" : "鏈洿鏂颁换浣曟暟鎹�"; + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "EditModelSubmit error锛�" + ex.Message); + m.outMsg = ex.Message; + m.outSum = -1; + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, ex.Message); + } + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "鎿嶄綔鎴愬姛锛�"); + } + + /// <summary> + /// 澧炲姞鎴栫紪杈戝疄浣� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<ExpandoObject> EditModel([FromBody] dynamic model) + { + Guid? guid = model.guid; //涓婚敭 + string mjbm = model.mjbm;//妯″叿缂栫爜 + string mjmc = model.mjmc;//妯″叿鍚嶇О + string bz = model.bz;//澶囨敞 + string mjgg = model.mjgg;//妯″叿瑙勬牸 + string mjzt = model.mjzt;//妯″叿鐘舵�� + string khmsl = model.khmsl;//寮�鍚堟ā鏁伴噺 + + dynamic mObj = new ExpandoObject(); + mObj.outMsg = ""; + mObj.outSum = -1; + mObj.outGuid = ""; + mObj.outNo = ""; + try + { + string sql; + if (CheckGuid(guid)) + { + sql = $"declare @userBy nvarchar(20); select top 1 @userBy=[ACCOUNT] from [dbo].[SYS_USER] where guid='{_userGuid}'" + + $"UPDATE YS_mjtz SET mjbm='{mjbm}', mjmc='{mjmc}', bz='{bz}', mjgg='{mjgg}', mjzt='{mjzt}', khmsl='{khmsl}' WHERE guid='{guid}'"; + } + else + { + guid = Guid.NewGuid(); + sql = $" declare @userBy nvarchar(20); select top 1 @userBy=[ACCOUNT] from [dbo].[SYS_USER] where guid='{_userGuid}' " + + $"INSERT INTO YS_mjtz (guid,mjbm, mjmc, bz, mjgg, mjzt,khmsl) " + + $"VALUES ('{guid}', '{mjbm}', '{mjmc}', '{bz}', '{mjgg}', '{mjzt}', '{khmsl}' )"; + } + int rows = DbHelperSQL.ExecuteSql(sql); + mObj.outSum = rows; + mObj.outGuid = guid.ToString(); + mObj.outMsg = rows > 0 ? "鎿嶄綔鎴愬姛锛�" : "鏈洿鏂颁换浣曟暟鎹�"; + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "EditModel error锛�" + ex.Message); + mObj.outMsg = ex.Message; + mObj.outSum = -1; + } + if (mObj.outSum <= 0) + return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception, mObj.outMsg); + return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success, mObj.outMsg); + } + + /// <summary> + /// 鍒犻櫎涓昏〃鎴栨槑缁� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<int?> DeleteModel([FromBody] dynamic model) + { + int? rtnInt = (int)ReturnCode.Default; + Guid? guid = model.guid; //鍒拌揣鍗曚富閿� + string mxGuid = model.mxGuid; + var _outMsg = ""; + var _outSum = -1; + try + { + if (CheckGuid(guid)) + { + string sql = $"DELETE FROM YS_mjtz WHERE guid='{guid}'"; + _outSum = DbHelperSQL.ExecuteSql(sql); + _outMsg = _outSum > 0 ? "鍒犻櫎鎴愬姛锛�" : "鏈垹闄や换浣曟暟鎹�"; + } + else + { + _outMsg = "涓婚敭涓嶈兘涓虹┖锛�"; + _outSum = -1; + } + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "DeleteModel error锛�" + ex.Message); + _outMsg = ex.Message; + _outSum = -1; + } + if (_outSum <= 0) + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception, _outMsg); + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg); + } +} \ No newline at end of file diff --git a/WebApi/Gs.Report/YS_py_pk_d.cs b/WebApi/Gs.Report/YS_py_pk_d.cs index 572c006..6b4bd92 100644 --- a/WebApi/Gs.Report/YS_py_pk_d.cs +++ b/WebApi/Gs.Report/YS_py_pk_d.cs @@ -1,18 +1,17 @@ -锘縰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 { - [ApiGroup(ApiGroupNames.Report)] public class YS_py_pk_d : IRomteService { @@ -32,7 +31,8 @@ /// <param name="model"></param> /// <returns></returns> [RequestMethod(RequestMethods.POST)] - public ReturnDto<PageList<dynamic>> GetListPage([FromBody] dynamic model) + public ReturnDto<PageList<dynamic>> GetListPage( + [FromBody] dynamic model) { int currentPage = model.currentPage; int everyPageSize = model.everyPageSize; @@ -40,17 +40,17 @@ 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", "") - }; + 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> { @@ -61,12 +61,14 @@ }; try { - dset = DbHelperSQL.RunProcedure("prc_pc_ysPyPkD_cx", parameters, "0"); + dset = DbHelperSQL.RunProcedure("prc_pc_ysPyPkD_cx", 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()); + int.Parse(dset.Tables[1].Rows[0]["intTotal"] + .ToString()); var pages = intTotal % everyPageSize != 0 ? intTotal / everyPageSize + 1 : intTotal / everyPageSize; @@ -103,7 +105,8 @@ var dset = new DataSet(); try { - dset = DbHelperSQL.RunProcedure("[YS_py_pk_d_MX]", parameters, "0"); + dset = DbHelperSQL.RunProcedure("[YS_py_pk_d_MX]", parameters, + "0"); if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0) { @@ -119,8 +122,8 @@ if (m != null) return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "璇诲彇鎴愬姛锛�"); - return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�"); + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, + "璇诲彇澶辫触锛�"); } } -} - +} \ No newline at end of file diff --git a/WebApi/Gs.Report/YS_rkjreport.cs b/WebApi/Gs.Report/YS_rkjreport.cs index 02bfa05..ad96dd1 100644 --- a/WebApi/Gs.Report/YS_rkjreport.cs +++ b/WebApi/Gs.Report/YS_rkjreport.cs @@ -1,18 +1,17 @@ -锘縰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 { - [ApiGroup(ApiGroupNames.Report)] public class YS_rkjreport : IRomteService { @@ -32,7 +31,8 @@ /// <param name="model"></param> /// <returns></returns> [RequestMethod(RequestMethods.POST)] - public ReturnDto<PageList<dynamic>> GetListPage([FromBody] dynamic model) + public ReturnDto<PageList<dynamic>> GetListPage( + [FromBody] dynamic model) { int currentPage = model.currentPage; int everyPageSize = model.everyPageSize; @@ -40,17 +40,17 @@ 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", "") - }; + 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> { @@ -61,12 +61,14 @@ }; try { - dset = DbHelperSQL.RunProcedure("prc_pc_ysRkjreport_cx", parameters, "0"); + dset = DbHelperSQL.RunProcedure("prc_pc_ysRkjreport_cx", + 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()); + int.Parse(dset.Tables[1].Rows[0]["intTotal"] + .ToString()); var pages = intTotal % everyPageSize != 0 ? intTotal / everyPageSize + 1 : intTotal / everyPageSize; @@ -103,7 +105,8 @@ var dset = new DataSet(); try { - dset = DbHelperSQL.RunProcedure("[YS_rkjreport_MX]", parameters, "0"); + dset = DbHelperSQL.RunProcedure("[YS_rkjreport_MX]", parameters, + "0"); if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0) { @@ -119,8 +122,8 @@ if (m != null) return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "璇诲彇鎴愬姛锛�"); - return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�"); + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, + "璇诲彇澶辫触锛�"); } } -} - +} \ No newline at end of file diff --git a/WebApi/Gs.Report/YS_sb_djjl.cs b/WebApi/Gs.Report/YS_sb_djjl.cs index ecbc144..f5fcef5 100644 --- a/WebApi/Gs.Report/YS_sb_djjl.cs +++ b/WebApi/Gs.Report/YS_sb_djjl.cs @@ -1,126 +1,250 @@ -锘縰sing Gs.Toolbox; +锘縰sing System.Data; +using System.Data.SqlClient; +using System.Dynamic; +using System.Text; +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; +/// <summary> +/// 璁惧鐐规璁板綍琛� +/// </summary> +[ApiGroup(ApiGroupNames.Report)] +public class YS_sb_djjl : IRomteService { + private readonly IHttpContextAccessor _http; - [ApiGroup(ApiGroupNames.Report)] - public class YS_sb_djjl : IRomteService + private readonly string _userCode, _userGuid, _orgFids; + public YS_sb_djjl(IHttpContextAccessor httpContextAccessor) { - private readonly IHttpContextAccessor _http; - private readonly string _userCode, _userGuid, _orgFids; - - public YS_sb_djjl(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("prc_pc_ysSbDjjl_cx", 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("[YS_sb_djjl_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, "璇诲彇澶辫触锛�"); - } + _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("prc_pc_ysSbDjjl_cx", 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<ExpandoObject> GetModel([FromBody] dynamic model) + { + string guid = model.guid.ToString(); + dynamic m = new ExpandoObject(); + m.list = new List<dynamic>(); + m.list2 = new List<dynamic>(); + // 鍋囪涓昏〃涓篗ES_JJGZ_JS_SALARY锛屾槑缁嗚〃涓篗ES_JJGZ_JS_SALARY_DETAIL + string mainTable = "YS_sb_djjl"; + try + { + string sqlMain = $"SELECT * FROM {mainTable} WHERE guid='{guid}'"; + var dsMain = DbHelperSQL.Query(sqlMain); + if (dsMain != null && dsMain.Tables.Count > 0 && dsMain.Tables[0].Rows.Count > 0) + { + var dr = dsMain.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="mode"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<ExpandoObject> EditModelSubmit([FromBody] dynamic mode) + { + string _guid = mode.guid; + string _inFieldValue = mode.inFieldValue; + dynamic m = new ExpandoObject(); + m.outSum = -1; + m.outMsg = ""; + try + { + // 鍋囪鎻愪氦灏辨槸鏇存柊鏌愪釜瀛楁 + string sql = $"UPDATE YS_sb_djjl SET check_status='{_inFieldValue}',check_date = getdate(), check_user='{_userGuid}' WHERE guid='{_guid}'"; + int rows = DbHelperSQL.ExecuteSql(sql); + m.outSum = rows; + m.outMsg = rows > 0 ? "鎿嶄綔鎴愬姛锛�" : "鏈洿鏂颁换浣曟暟鎹�"; + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "EditModelSubmit error锛�" + ex.Message); + m.outMsg = ex.Message; + m.outSum = -1; + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, ex.Message); + } + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "鎿嶄綔鎴愬姛锛�"); + } + + /// <summary> + /// 澧炲姞鎴栫紪杈戝疄浣� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<ExpandoObject> EditModel([FromBody] dynamic model) + { + Guid? guid = model.guid; //涓婚敭 + string sbmc = model.sbmc;//璁惧鍚嶇О + string djr = model.djr;//鐐规浜� + string djsj = model.djsj;//鐐规鏃堕棿 + string bz = model.bz;//澶囨敞 + string sbbm = model.sbbm;//璁惧缂栫爜 + string djrq = model.djrq;//鐐规鏃ユ湡(澶氫綑) + string UpDataTime = model.UpDataTime;//鏇存柊鏃堕棿 + string UpDataUser = model.UpDataUser;//鏇存柊浜� + + dynamic mObj = new ExpandoObject(); + mObj.outMsg = ""; + mObj.outSum = -1; + mObj.outGuid = ""; + mObj.outNo = ""; + try + { + string sql; + if (CheckGuid(guid)) + { + sql = $"declare @userBy nvarchar(20); select top 1 @userBy=[ACCOUNT] from [dbo].[SYS_USER] where guid='{_userGuid}'" + + $"UPDATE YS_sb_djjl SET sbmc='{sbmc}', djr='{djr}', djsj='{djsj}',sbbm='{sbbm}',bz='{bz}',djrq='{djrq}'," + + $" UpDataTime=GETDATE(), UpDataUser=@userBy WHERE guid='{guid}'"; + } + else + { + guid = Guid.NewGuid(); + sql = $" declare @userBy nvarchar(20); select top 1 @userBy=[ACCOUNT] from [dbo].[SYS_USER] where guid='{_userGuid}' " + + $"INSERT INTO YS_sb_djjl (guid, djr, djsj, sbmc, sbbm,bz,djrq) " + + $"VALUES ('{guid}','{djr}','{djsj}', '{sbmc}', '{sbbm}', '{bz}','{djrq}')"; + } + int rows = DbHelperSQL.ExecuteSql(sql); + mObj.outSum = rows; + mObj.outGuid = guid.ToString(); + mObj.outMsg = rows > 0 ? "鎿嶄綔鎴愬姛锛�" : "鏈洿鏂颁换浣曟暟鎹�"; + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "EditModel error锛�" + ex.Message); + mObj.outMsg = ex.Message; + mObj.outSum = -1; + } + if (mObj.outSum <= 0) + return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception, mObj.outMsg); + return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success, mObj.outMsg); + } + + /// <summary> + /// 鍒犻櫎涓昏〃鎴栨槑缁� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<int?> DeleteModel([FromBody] dynamic model) + { + int? rtnInt = (int)ReturnCode.Default; + Guid? guid = model.guid; //鍒拌揣鍗曚富閿� + string mxGuid = model.mxGuid; + var _outMsg = ""; + var _outSum = -1; + try + { + if (CheckGuid(guid)) + { + string sql = $"DELETE FROM YS_sb_djjl WHERE guid='{guid}'"; + _outSum = DbHelperSQL.ExecuteSql(sql); + _outMsg = _outSum > 0 ? "鍒犻櫎鎴愬姛锛�" : "鏈垹闄や换浣曟暟鎹�"; + } + else + { + _outMsg = "涓婚敭涓嶈兘涓虹┖锛�"; + _outSum = -1; + } + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "DeleteModel error锛�" + ex.Message); + _outMsg = ex.Message; + _outSum = -1; + } + if (_outSum <= 0) + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception, _outMsg); + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg); + } +} \ No newline at end of file diff --git a/WebApi/Gs.Report/YS_sbbyjlb.cs b/WebApi/Gs.Report/YS_sbbyjlb.cs index 1f66499..d6a73e0 100644 --- a/WebApi/Gs.Report/YS_sbbyjlb.cs +++ b/WebApi/Gs.Report/YS_sbbyjlb.cs @@ -1,126 +1,253 @@ -锘縰sing Gs.Toolbox; +锘縰sing System.Data; +using System.Data.SqlClient; +using System.Dynamic; +using System.Text; +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; +/// <summary> +/// 璁惧淇濆吇璁板綍琛� +/// </summary> +[ApiGroup(ApiGroupNames.Report)] +public class YS_sbbyjlb : IRomteService { + private readonly IHttpContextAccessor _http; - [ApiGroup(ApiGroupNames.Report)] - public class YS_sbbyjlb : IRomteService + private readonly string _userCode, _userGuid, _orgFids; + public YS_sbbyjlb(IHttpContextAccessor httpContextAccessor) { - private readonly IHttpContextAccessor _http; - private readonly string _userCode, _userGuid, _orgFids; - - public YS_sbbyjlb(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("prc_pc_ysSbbyjlb_cx", 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("[YS_sbbyjlb_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, "璇诲彇澶辫触锛�"); - } + _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("prc_pc_ysSbbyjlb_cx", 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<ExpandoObject> GetModel([FromBody] dynamic model) + { + string guid = model.guid.ToString(); + dynamic m = new ExpandoObject(); + m.list = new List<dynamic>(); + m.list2 = new List<dynamic>(); + // 鍋囪涓昏〃涓篗ES_JJGZ_JS_SALARY锛屾槑缁嗚〃涓篗ES_JJGZ_JS_SALARY_DETAIL + string mainTable = "YS_sbbyjlb"; + try + { + string sqlMain = $"SELECT * FROM {mainTable} WHERE guid='{guid}'"; + var dsMain = DbHelperSQL.Query(sqlMain); + if (dsMain != null && dsMain.Tables.Count > 0 && dsMain.Tables[0].Rows.Count > 0) + { + var dr = dsMain.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="mode"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<ExpandoObject> EditModelSubmit([FromBody] dynamic mode) + { + string _guid = mode.guid; + string _inFieldValue = mode.inFieldValue; + dynamic m = new ExpandoObject(); + m.outSum = -1; + m.outMsg = ""; + try + { + // 鍋囪鎻愪氦灏辨槸鏇存柊鏌愪釜瀛楁 + string sql = $"UPDATE YS_sbbyjlb SET check_status='{_inFieldValue}',check_date = getdate(), check_user='{_userGuid}' WHERE guid='{_guid}'"; + int rows = DbHelperSQL.ExecuteSql(sql); + m.outSum = rows; + m.outMsg = rows > 0 ? "鎿嶄綔鎴愬姛锛�" : "鏈洿鏂颁换浣曟暟鎹�"; + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "EditModelSubmit error锛�" + ex.Message); + m.outMsg = ex.Message; + m.outSum = -1; + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, ex.Message); + } + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "鎿嶄綔鎴愬姛锛�"); + } + + /// <summary> + /// 澧炲姞鎴栫紪杈戝疄浣� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<ExpandoObject> EditModel([FromBody] dynamic model) + { + Guid? guid = model.guid; //涓婚敭 + string submitStatus = model.submitStatus;//鎻愪氦鐘舵�� + string customerCode = model.customerCode;//瀹㈡埛缂栫爜 + string customerName = model.customerName;//瀹㈡埛鍚嶇О + string remark = model.remark;//澶囨敞 + string createUser = model.createUser;//鍒涘缓浜� + string createTime = model.createTime;//鍒涘缓鏃堕棿 + string lastModifyUser = model.lastModifyUser;//鏈�鍚庝慨鏀逛汉 + string lastModifyTime = model.lastModifyTime;//鏈�鍚庝慨鏀规椂闂� + string UpDataTime = model.UpDataTime;//鏇存柊鏃堕棿 + string UpDataUser = model.UpDataUser;//鏇存柊浜� + + dynamic mObj = new ExpandoObject(); + mObj.outMsg = ""; + mObj.outSum = -1; + mObj.outGuid = ""; + mObj.outNo = ""; + try + { + string sql; + if (CheckGuid(guid)) + { + sql = $"declare @userBy nvarchar(20); select top 1 @userBy=[ACCOUNT] from [dbo].[SYS_USER] where guid='{_userGuid}'" + + $"UPDATE YS_sbbyjlb SET submitStatus='{submitStatus}', customerCode='{customerCode}', customerName='{customerName}'," + + $" lastModifyUser='{lastModifyUser}', lastModifyTime='{lastModifyTime}',remark='{remark}'," + + $" UpDataTime=GETDATE(), UpDataUser=@userBy WHERE guid='{guid}'"; + } + else + { + guid = Guid.NewGuid(); + sql = $" declare @userBy nvarchar(20); select top 1 @userBy=[ACCOUNT] from [dbo].[SYS_USER] where guid='{_userGuid}' " + + $"INSERT INTO YS_sbbyjlb (guid, createUser, createTime, submitStatus, customerCode, customerName, lastModifyUser, lastModifyTime,remark) " + + $"VALUES ('{guid}',@userBy,GETDATE(), '{submitStatus}', '{customerCode}', '{customerName}', '{lastModifyUser}', '{lastModifyTime}', '{remark}')"; + } + int rows = DbHelperSQL.ExecuteSql(sql); + mObj.outSum = rows; + mObj.outGuid = guid.ToString(); + mObj.outMsg = rows > 0 ? "鎿嶄綔鎴愬姛锛�" : "鏈洿鏂颁换浣曟暟鎹�"; + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "EditModel error锛�" + ex.Message); + mObj.outMsg = ex.Message; + mObj.outSum = -1; + } + if (mObj.outSum <= 0) + return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception, mObj.outMsg); + return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success, mObj.outMsg); + } + + /// <summary> + /// 鍒犻櫎涓昏〃鎴栨槑缁� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<int?> DeleteModel([FromBody] dynamic model) + { + int? rtnInt = (int)ReturnCode.Default; + Guid? guid = model.guid; //鍒拌揣鍗曚富閿� + string mxGuid = model.mxGuid; + var _outMsg = ""; + var _outSum = -1; + try + { + if (CheckGuid(guid)) + { + string sql = $"DELETE FROM YS_sbbyjlb WHERE guid='{guid}'"; + _outSum = DbHelperSQL.ExecuteSql(sql); + _outMsg = _outSum > 0 ? "鍒犻櫎鎴愬姛锛�" : "鏈垹闄や换浣曟暟鎹�"; + } + else + { + _outMsg = "涓婚敭涓嶈兘涓虹┖锛�"; + _outSum = -1; + } + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "DeleteModel error锛�" + ex.Message); + _outMsg = ex.Message; + _outSum = -1; + } + if (_outSum <= 0) + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception, _outMsg); + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg); + } +} \ No newline at end of file diff --git a/WebApi/Gs.Report/YS_sbtzb.cs b/WebApi/Gs.Report/YS_sbtzb.cs index 982710e..9bfc20b 100644 --- a/WebApi/Gs.Report/YS_sbtzb.cs +++ b/WebApi/Gs.Report/YS_sbtzb.cs @@ -1,126 +1,252 @@ -锘縰sing Gs.Toolbox; +锘縰sing System.Data; +using System.Data.SqlClient; +using System.Dynamic; +using System.Text; +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 YS_sbtzb : IRomteService { + private readonly IHttpContextAccessor _http; - [ApiGroup(ApiGroupNames.Report)] - public class YS_sbtzb : IRomteService + private readonly string _userCode, _userGuid, _orgFids; + public YS_sbtzb(IHttpContextAccessor httpContextAccessor) { - private readonly IHttpContextAccessor _http; - private readonly string _userCode, _userGuid, _orgFids; - - public YS_sbtzb(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("prc_pc_ysSbtzb_cx", 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("[YS_sbtzb_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, "璇诲彇澶辫触锛�"); - } + _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("prc_pc_ysSbtzb_cx", 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<ExpandoObject> GetModel([FromBody] dynamic model) + { + string guid = model.guid.ToString(); + dynamic m = new ExpandoObject(); + m.list = new List<dynamic>(); + m.list2 = new List<dynamic>(); + // 鍋囪涓昏〃涓篗ES_JJGZ_JS_SALARY锛屾槑缁嗚〃涓篗ES_JJGZ_JS_SALARY_DETAIL + string mainTable = "YS_sbtzb"; + try + { + string sqlMain = $"SELECT * FROM {mainTable} WHERE guid='{guid}'"; + var dsMain = DbHelperSQL.Query(sqlMain); + if (dsMain != null && dsMain.Tables.Count > 0 && dsMain.Tables[0].Rows.Count > 0) + { + var dr = dsMain.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="mode"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<ExpandoObject> EditModelSubmit([FromBody] dynamic mode) + { + string _guid = mode.guid; + string _inFieldValue = mode.inFieldValue; + dynamic m = new ExpandoObject(); + m.outSum = -1; + m.outMsg = ""; + try + { + // 鍋囪鎻愪氦灏辨槸鏇存柊鏌愪釜瀛楁 + string sql = $"UPDATE YS_sbtzb SET check_status='{_inFieldValue}',check_date = getdate(), check_user='{_userGuid}' WHERE guid='{_guid}'"; + int rows = DbHelperSQL.ExecuteSql(sql); + m.outSum = rows; + m.outMsg = rows > 0 ? "鎿嶄綔鎴愬姛锛�" : "鏈洿鏂颁换浣曟暟鎹�"; + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "EditModelSubmit error锛�" + ex.Message); + m.outMsg = ex.Message; + m.outSum = -1; + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, ex.Message); + } + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "鎿嶄綔鎴愬姛锛�"); + } + + /// <summary> + /// 澧炲姞鎴栫紪杈戝疄浣� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<ExpandoObject> EditModel([FromBody] dynamic model) + { + Guid? guid = model.guid; //涓婚敭 + string sbbm = model.sbbm;//璁惧缂栫爜 + string sbmc = model.sbmc;//璁惧鍚嶇О + string bz = model.bz;//澶囨敞 + string createUser = model.createUser;//鍒涘缓浜� + string createDate = model.createDate;//鍒涘缓鏃堕棿 + string sbgg = model.sbgg;//璁惧瑙勬牸 + string dw = model.dw;//鍗曚綅锛堝彴/鏉★級 + string sl = model.sl;//鏁伴噺 + string zt = model.zt;//鐘舵�� + string sccj = model.sccj;//鐢熶骇鍘傚 + string UpDataTime = model.UpDataTime;//鏇存柊鏃堕棿 + string UpDataUser = model.UpDataUser;//鏇存柊浜� + + dynamic mObj = new ExpandoObject(); + mObj.outMsg = ""; + mObj.outSum = -1; + mObj.outGuid = ""; + mObj.outNo = ""; + try + { + string sql; + if (CheckGuid(guid)) + { + sql = $"declare @userBy nvarchar(20); select top 1 @userBy=[ACCOUNT] from [dbo].[SYS_USER] where guid='{_userGuid}'" + + $"UPDATE YS_sbtzb SET sbbm='{sbbm}', sbmc='{sbmc}', bz='{bz}', sbgg='{sbgg}', dw='{dw}', sl='{sl}'," + + $" zt='{zt}', sccj='{sccj}', UpDataTime=GETDATE(), UpDataUser=@userBy WHERE guid='{guid}'"; + } + else + { + guid = Guid.NewGuid(); + sql = $" declare @userBy nvarchar(20); select top 1 @userBy=[ACCOUNT] from [dbo].[SYS_USER] where guid='{_userGuid}' " + + $"INSERT INTO YS_sbtzb (guid, createUser, createDate, sbbm, sbmc, bz, sbgg, dw, sl ,zt,sccj) " + + $"VALUES ('{guid}',@userBy,GETDATE(), '{sbbm}', '{sbmc}', '{bz}', '{sbgg}', '{dw}', '{sl}', '{zt}', '{sccj}' )"; + } + int rows = DbHelperSQL.ExecuteSql(sql); + mObj.outSum = rows; + mObj.outGuid = guid.ToString(); + mObj.outMsg = rows > 0 ? "鎿嶄綔鎴愬姛锛�" : "鏈洿鏂颁换浣曟暟鎹�"; + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "EditModel error锛�" + ex.Message); + mObj.outMsg = ex.Message; + mObj.outSum = -1; + } + if (mObj.outSum <= 0) + return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception, mObj.outMsg); + return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success, mObj.outMsg); + } + + /// <summary> + /// 鍒犻櫎涓昏〃鎴栨槑缁� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<int?> DeleteModel([FromBody] dynamic model) + { + int? rtnInt = (int)ReturnCode.Default; + Guid? guid = model.guid; //鍒拌揣鍗曚富閿� + string mxGuid = model.mxGuid; + var _outMsg = ""; + var _outSum = -1; + try + { + if (CheckGuid(guid)) + { + string sql = $"DELETE FROM YS_sbtzb WHERE guid='{guid}'"; + _outSum = DbHelperSQL.ExecuteSql(sql); + _outMsg = _outSum > 0 ? "鍒犻櫎鎴愬姛锛�" : "鏈垹闄や换浣曟暟鎹�"; + } + else + { + _outMsg = "涓婚敭涓嶈兘涓虹┖锛�"; + _outSum = -1; + } + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), "DeleteModel error锛�" + ex.Message); + _outMsg = ex.Message; + _outSum = -1; + } + if (_outSum <= 0) + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception, _outMsg); + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg); + } +} \ No newline at end of file diff --git a/WebApi/Gs.Report/YS_sjreport.cs b/WebApi/Gs.Report/YS_sjreport.cs index a133620..0edae72 100644 --- a/WebApi/Gs.Report/YS_sjreport.cs +++ b/WebApi/Gs.Report/YS_sjreport.cs @@ -1,18 +1,17 @@ -锘縰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 { - [ApiGroup(ApiGroupNames.Report)] public class YS_sjreport : IRomteService { @@ -32,7 +31,8 @@ /// <param name="model"></param> /// <returns></returns> [RequestMethod(RequestMethods.POST)] - public ReturnDto<PageList<dynamic>> GetListPage([FromBody] dynamic model) + public ReturnDto<PageList<dynamic>> GetListPage( + [FromBody] dynamic model) { int currentPage = model.currentPage; int everyPageSize = model.everyPageSize; @@ -40,17 +40,17 @@ 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", "") - }; + 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> { @@ -61,12 +61,14 @@ }; try { - dset = DbHelperSQL.RunProcedure("prc_pc_ysSjreport_cx", parameters, "0"); + dset = DbHelperSQL.RunProcedure("prc_pc_ysSjreport_cx", + 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()); + int.Parse(dset.Tables[1].Rows[0]["intTotal"] + .ToString()); var pages = intTotal % everyPageSize != 0 ? intTotal / everyPageSize + 1 : intTotal / everyPageSize; @@ -103,7 +105,8 @@ var dset = new DataSet(); try { - dset = DbHelperSQL.RunProcedure("[YS_sjreport_MX]", parameters, "0"); + dset = DbHelperSQL.RunProcedure("[YS_sjreport_MX]", parameters, + "0"); if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0) { @@ -119,8 +122,8 @@ if (m != null) return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "璇诲彇鎴愬姛锛�"); - return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�"); + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, + "璇诲彇澶辫触锛�"); } } -} - +} \ No newline at end of file diff --git a/WebApi/Gs.Report/YS_xjreport.cs b/WebApi/Gs.Report/YS_xjreport.cs index 2d7daa4..258fc63 100644 --- a/WebApi/Gs.Report/YS_xjreport.cs +++ b/WebApi/Gs.Report/YS_xjreport.cs @@ -1,18 +1,17 @@ -锘縰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 { - [ApiGroup(ApiGroupNames.Report)] public class YS_xjreport : IRomteService { @@ -32,7 +31,8 @@ /// <param name="model"></param> /// <returns></returns> [RequestMethod(RequestMethods.POST)] - public ReturnDto<PageList<dynamic>> GetListPage([FromBody] dynamic model) + public ReturnDto<PageList<dynamic>> GetListPage( + [FromBody] dynamic model) { int currentPage = model.currentPage; int everyPageSize = model.everyPageSize; @@ -40,17 +40,17 @@ 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", "") - }; + 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> { @@ -61,12 +61,14 @@ }; try { - dset = DbHelperSQL.RunProcedure("prc_pc_ysXjreport_cx", parameters, "0"); + dset = DbHelperSQL.RunProcedure("prc_pc_ysXjreport_cx", + 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()); + int.Parse(dset.Tables[1].Rows[0]["intTotal"] + .ToString()); var pages = intTotal % everyPageSize != 0 ? intTotal / everyPageSize + 1 : intTotal / everyPageSize; @@ -103,7 +105,8 @@ var dset = new DataSet(); try { - dset = DbHelperSQL.RunProcedure("[YS_xjreport_MX]", parameters, "0"); + dset = DbHelperSQL.RunProcedure("[YS_xjreport_MX]", parameters, + "0"); if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0) { @@ -119,8 +122,8 @@ if (m != null) return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "璇诲彇鎴愬姛锛�"); - return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�"); + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, + "璇诲彇澶辫触锛�"); } } -} - +} \ No newline at end of file -- Gitblit v1.9.3