From e9d5877789d03bbfcf8401d5f55c4ba76a21e327 Mon Sep 17 00:00:00 2001
From: cnf <3283105747@qq.com>
Date: 星期六, 22 十一月 2025 14:04:12 +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