From bc91272547462e667f12efb62fe1f058da227c61 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 18 十月 2022 11:34:33 +0800
Subject: [PATCH] 新增登录后我的消息接口
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 48 +++++++++++++++++++-----------------------------
1 files changed, 19 insertions(+), 29 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index 81d8f54..a61be94 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -1699,9 +1699,8 @@
#region[瀹夌伅绯荤粺/鑷畾涔夊畨鐏懠鍙被鍨嬫煡璇
- public static ToMessage AnDengTypeSearch(int startNum, int endNum, string prop, string order)
+ public static ToMessage AnDengTypeSearch()
{
- var dynamicParams = new DynamicParameters();
try
{
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
@@ -1709,11 +1708,11 @@
var sql = @"select id, code,name
from TAnDonType
where is_delete<>'1' ";
- var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
+ var data = DapperHelper.selecttable(sql);
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
mes.count = total;
- mes.data = data.ToList();
+ mes.data = data;
}
catch (Exception e)
{
@@ -1844,20 +1843,10 @@
dynamicParams.Add("@wkshopcode", wkshopcode);
dynamicParams.Add("@calltypecode", calltypecode);
var data = DapperHelper.selectdata(sql, dynamicParams);
- if (data.Rows.Count > 0)
- {
- mes.code = "200";
- mes.count = 0;
- mes.Message = "鏌ヨ鎴愬姛!";
- mes.data = data;
- }
- else
- {
- mes.code = "300";
- mes.count = 0;
- mes.Message = "鏆傛棤鍝嶅簲浜哄憳!";
- mes.data = null;
- }
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
}
catch (Exception e)
{
@@ -1877,13 +1866,14 @@
var dynamicParams = new DynamicParameters();
try
{
- sql = @"select B.user_code as code,U.username as name,(case when C.usercode is null then 'N' else 'Y' end) flag from TUserRoleRelation B
- left join(
- select B.usercode from TAnDon_Roul_ConFig A
- inner join TAnDon_Roul_ConFigUser B on A.id=B.ando_cogfigid
- where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode
- ) C on B.user_code=C.usercode
- left join TUser U on B.user_code=U.usercode";
+ sql = @"select A.usercode,A.username,(case when B.usercode<>'' then 'Y' else 'N' end) as flag
+ from TUser A
+ left join (
+ select B.usercode from TAnDon_Roul_ConFig A
+ inner join TAnDon_Roul_ConFigUser B on A.id=B.ando_cogfigid
+ where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode and A.enable='Y'
+ ) B on A.usercode=B.usercode
+ where A.userclassid='0'";
dynamicParams.Add("@wkshopcode", wkshopcode);
dynamicParams.Add("@calltypecode", calltypecode);
var data = DapperHelper.selectdata(sql, dynamicParams);
@@ -2016,8 +2006,8 @@
parm = new
{
wkshp_code = wkshopcode,
- andengtypecode=calltypecode,
- lm_user=usercode,
+ andengtypecode = calltypecode,
+ lm_user = usercode,
lm_date = DateTime.Now.ToString(),
enable = enable
}
@@ -2050,7 +2040,7 @@
#endregion
#region[瀹夌伅绯荤粺/鍝嶅簲浜哄憳鍒犻櫎]
- public static ToMessage AnDengResponUserDeleteSeave(string id,string ando_cogfigid)
+ public static ToMessage AnDengResponUserDeleteSeave(string id, string ando_cogfigid)
{
var sql = "";
List<object> list = new List<object>();
@@ -2068,7 +2058,7 @@
sql = @"delete TAnDon_Roul_ConFigUser where id=@id";
list.Add(new { str = sql, parm = new { id = id } });
}
- else
+ else
{
//鏍规嵁瀛愯〃id鍒犻櫎瀵瑰簲瀛愯〃浜哄憳
sql = @"delete TAnDon_Roul_ConFigUser where id=@id";
--
Gitblit v1.9.3