From 465c9a76c3c54963603b80d27d97623ed182b2fc Mon Sep 17 00:00:00 2001 From: 况洋洋 <3283105747@qq.com> Date: 星期五, 04 七月 2025 14:31:56 +0800 Subject: [PATCH] 员工信息多岗位调整 --- WebApi/Gs.BaseInfo/Services/MesStaffManager.cs | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 51 insertions(+), 6 deletions(-) diff --git a/WebApi/Gs.BaseInfo/Services/MesStaffManager.cs b/WebApi/Gs.BaseInfo/Services/MesStaffManager.cs index 23936cc..e427a48 100644 --- a/WebApi/Gs.BaseInfo/Services/MesStaffManager.cs +++ b/WebApi/Gs.BaseInfo/Services/MesStaffManager.cs @@ -1,5 +1,4 @@ -锘縰sing System.Text; -using Gs.Entity.BaseInfo; +锘縰sing Gs.Entity.BaseInfo; using Gs.Entity.Sys; using Gs.Toolbox; using Gs.Toolbox.ApiCore.Abstract.Mvc; @@ -8,6 +7,10 @@ using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using SqlSugar; +using System.Data; +using System.Data.SqlClient; +using System.Dynamic; +using System.Text; namespace Gs.BaseInfo.Services; @@ -80,13 +83,55 @@ /// <param name="guid"></param> /// <returns></returns> [RequestMethod(RequestMethods.POST)] - public ReturnDto<MesStaff> GetModel([FromBody] MesStaff model) + //public ReturnDto<MesStaff> GetModel([FromBody] MesStaff model) + //{ + // var m = base.GetById(model.Guid); + // if (m != null) + // return ReturnDto<MesStaff>.QuickReturn(m, ReturnCode.Success, + // "璇诲彇鎴愬姛锛�"); + // return ReturnDto<MesStaff>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�"); + //} + + public ReturnDto<ExpandoObject> GetModel([FromBody] dynamic model) { - var m = base.GetById(model.Guid); + string guid = model.guid.ToString(); + dynamic m = new ExpandoObject(); + m.list = new List<dynamic>(); + m.list2 = new List<dynamic>(); + SqlParameter[] parameters = + { + new("@inMainGuid", guid), + new("@inP1", ""), + new("@inP2", ""), + new("@inP3", ""), + new("@inP4", "") + }; + var dset = new DataSet(); + try + { + dset = DbHelperSQL.RunProcedure("[prc_staff_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(); + var _tb = dset.Tables[1].TableToDynamicList(); + m.list = _tb; + //var _tb2 = dset.Tables[2].TableToDynamicList(); + //m.list2 = _tb2; + } + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), ex.Message); + } + if (m != null) - return ReturnDto<MesStaff>.QuickReturn(m, ReturnCode.Success, + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "璇诲彇鎴愬姛锛�"); - return ReturnDto<MesStaff>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�"); + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�"); } + + } \ No newline at end of file -- Gitblit v1.9.3