From 0ea0fc59c2dc8014fdd9d9f332d699b3be2308e6 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期六, 18 六月 2022 14:35:21 +0800
Subject: [PATCH] 往来单位查询接口、新增编辑、删除
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 162 ++++++++++++++++++++++++++++-------------------------
1 files changed, 85 insertions(+), 77 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index 26a34c9..8875edf 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -443,12 +443,10 @@
var data = DapperHelper.selectdata(sql, dynamicParams);
sql = @"update TUserRoleRelation set is_delete='1' where user_code=@usercode";
- dynamicParams.Add("@usercode", data.Rows[0]["USERCODE"].ToString());
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { usercode = data.Rows[0]["USERCODE"].ToString() } });
sql = @"update TUser set is_delete='1' where id=@userid";
- dynamicParams.Add("@userid", userid);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { userid = userid } });
bool aa = DapperHelper.DoTransaction(list);
if (aa)
{
@@ -518,7 +516,6 @@
{
var sql = "";
List<object> list = new List<object>();
- var dynamicParams = new DynamicParameters();
try
{
list.Clear();
@@ -526,35 +523,30 @@
{
//娓呴櫎鐢ㄦ埛鍏宠仈瑙掕壊琛ㄦ暟鎹�
sql = @"delete TUserRoleRelation where user_code=@usercode";
- dynamicParams.Add("@usercode", usercode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm =new {usercode = usercode } });
//娓呴櫎鐢ㄦ埛琛ㄥ叧鑱旇鑹叉爣璇�
- sql = @"update TUser set is_role='N' where user_code=@usercode";
- dynamicParams.Add("@usercode", usercode);
- list.Add(new { str = sql, parm = dynamicParams });
+ sql = @"update TUser set is_role='N' where usercode=@usercode";
+ list.Add(new { str = sql, parm = new { usercode = usercode } });
}
else
{
//娓呴櫎鐢ㄦ埛鍏宠仈瑙掕壊琛ㄦ暟鎹�
sql = @"delete TUserRoleRelation where user_code=@usercode";
- dynamicParams.Add("@usercode", usercode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { usercode = usercode } });
+
//寰幆鍐欏叆鐢ㄦ埛鍏宠仈瑙掕壊琛�
for (int i = 0; i < json.Count; i++)
{
for (int j = 0; j < json[i].Data.Count; j++)
{
- sql = @"insert into TUserRoleRelation(usercode,role_code) values(@usercode,@role_code)";
- dynamicParams.Add("@usercode", usercode);
- dynamicParams.Add("@role_code", json[i].Data[j]);
- list.Add(new { str = sql, parm = dynamicParams });
+ sql = @"insert into TUserRoleRelation(user_code,role_code) values(@usercode,@role_code)";
+ list.Add(new { str = sql, parm = new { usercode = usercode, role_code= json[i].Data[j] } });
}
}
//鏍囪鐢ㄦ埛琛ㄥ叧鑱旇鑹叉爣璇�
- sql = @"update TUser set is_role='Y' where user_code=@usercode";
- dynamicParams.Add("@usercode", usercode);
- list.Add(new { str = sql, parm = dynamicParams });
+ sql = @"update TUser set is_role='Y' where usercode=@usercode";
+ list.Add(new { str = sql, parm = new { usercode = usercode} });
}
bool aa = DapperHelper.DoTransaction(list);
if (aa)
@@ -583,7 +575,6 @@
var sql = "";
List<object> list = new List<object>();
DataTable ds = new DataTable();
- var dynamicParams = new DynamicParameters();
try
{
@@ -604,17 +595,19 @@
{
sql = @"insert into TUser(usercode,username,enable,password,mobile,email,lm_user,lm_date,wagetype,stu_torgcode)
values(@usercode,@username,@enable,@password,@mobile,@email,@lm_user,@lm_date,@wagetype,@stu_torgcode)";
- dynamicParams.Add("@usercode", ds.Rows[i][1].ToString());
- dynamicParams.Add("@username", ds.Rows[i][2].ToString());
- dynamicParams.Add("@enable", ds.Rows[i][3].ToString());
- dynamicParams.Add("@password", ds.Rows[i][4].ToString());
- dynamicParams.Add("@mobile", ds.Rows[i][5].ToString());
- dynamicParams.Add("@email", ds.Rows[i][6].ToString());
- dynamicParams.Add("@lm_user", username);
- dynamicParams.Add("@lm_date", DateTime.Now.ToString());
- dynamicParams.Add("@wagetype", ds.Rows[i][7].ToString());
- dynamicParams.Add("@stu_torgcode", ds.Rows[i][8].ToString());
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new {
+ usercode = ds.Rows[i][1].ToString(),
+ username = ds.Rows[i][2].ToString(),
+ enable = ds.Rows[i][3].ToString(),
+ password = ds.Rows[i][4].ToString(),
+ mobile = ds.Rows[i][5].ToString(),
+ email = ds.Rows[i][6].ToString(),
+ lm_user = username,
+ lm_date = DateTime.Now.ToString(),
+ wagetype = ds.Rows[i][7].ToString(),
+ stu_torgcode = ds.Rows[i][8].ToString()
+ }
+ });
}
}
bool aa = DapperHelper.DoTransaction(list);
@@ -680,9 +673,15 @@
for (int i = 0; i < json.Count; i++)
{
sql = @"insert into TRoleType(roletypecode,roletypename) values(@roletypecode,@roletypename)";
- dynamicParams.Add("@roletypecode", json[i].code);
- dynamicParams.Add("@roletypename", json[i].name);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ roletypecode = json[i].code,
+ roletypename = json[i].name
+ }
+ });
}
bool aa = DapperHelper.DoTransaction(list);
if (aa)
@@ -710,17 +709,13 @@
{
var sql = "";
List<object> list = new List<object>();
- var dynamicParams = new DynamicParameters();
try
{
list.Clear();
sql = @"delete TRoleType where roletype_code=@roletypecode";
- dynamicParams.Add("@roletypecode", roleTypeCode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { roletypecode = roleTypeCode}});
sql = @"delete TRole where roletype_code=@roletypecode";
- dynamicParams.Add("@roletypecode", roleTypeCode);
- list.Add(new { str = sql, parm = dynamicParams });
-
+ list.Add(new { str = sql, parm = new { roletypecode = roleTypeCode }});
bool aa = DapperHelper.DoTransaction(list);
if (aa)
{
@@ -859,24 +854,17 @@
{
var sql = "";
List<object> list = new List<object>();
- var dynamicParams = new DynamicParameters();
try
{
//鏇存柊瑙掕壊琛ㄣ�佽鑹插叧鑱旂敤鎴锋爣璇嗗強鍒犻櫎鐘舵��
sql = @"update TRole set is_user='N',is_right='N',is_delete='1' where role_code=@RoleCode";
- dynamicParams.Add("@RoleCode", RoleCode);
- list.Add(new { str = sql, parm = dynamicParams });
-
+ list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
//鏇存柊瑙掕壊鍏宠仈鐢ㄦ埛琛ㄣ�佽鑹插叧鑱旂敤鎴锋爣璇嗗強鍒犻櫎鐘舵��
sql = @"update TUserRoleRelation set is_delete='1' where role_code=@RoleCode";
- dynamicParams.Add("@RoleCode", RoleCode);
- list.Add(new { str = sql, parm = dynamicParams });
-
+ list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
//鍒犻櫎(鏇存柊鐘舵��)瑙掕壊鍔熻兘琛�
sql = @"update TRoleRightRelation set is_delete='1' where user_code=@RoleCode";
- dynamicParams.Add("@RoleCode", RoleCode);
- list.Add(new { str = sql, parm = dynamicParams });
-
+ list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
bool aa = DapperHelper.DoTransaction(list);
if (aa)
{
@@ -960,11 +948,10 @@
#endregion
#region[瑙掕壊娓呭崟鍏宠仈鐢ㄦ埛淇濆瓨]
- public static ToMessage SaveRoleAssociationUser(string rolecode, List<ObjectData> json)
+ public static ToMessage SaveRoleAssoctUser(string rolecode, List<ObjectData> json)
{
var sql = "";
List<object> list = new List<object>();
- var dynamicParams = new DynamicParameters();
try
{
list.Clear();
@@ -972,31 +959,25 @@
{
//娓呴櫎鐢ㄦ埛鍏宠仈瑙掕壊琛ㄦ暟鎹�
sql = @"delete TUserRoleRelation where role_code=@rolecode";
- dynamicParams.Add("@rolecode", rolecode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
//鏍囪瑙掕壊琛ㄥ叧鑱旂敤鎴锋爣璇�
sql = @"update TRole set is_user='N' where role_code=@rolecode";
- dynamicParams.Add("@rolecode", rolecode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
}
else
{
//娓呴櫎鐢ㄦ埛鍏宠仈瑙掕壊琛ㄦ暟鎹�
sql = @"delete TUserRoleRelation where role_code=@rolecode";
- dynamicParams.Add("@rolecode", rolecode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
//寰幆鍐欏叆鐢ㄦ埛鍏宠仈瑙掕壊琛�
for (int i = 0; i < json.Count; i++)
{
sql = @"insert into TUserRoleRelation(usercode,role_code) values(@usercode,@role_code)";
- dynamicParams.Add("@usercode", json[i]);
- dynamicParams.Add("@role_code", rolecode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { usercode = json[i], role_code = rolecode } });
}
//鏍囪瑙掕壊琛ㄥ叧鑱旂敤鎴锋爣璇�
sql = @"update TRole set is_user='Y' where role_code=@rolecode";
- dynamicParams.Add("@rolecode", rolecode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
}
bool aa = DapperHelper.DoTransaction(list);
if (aa)
@@ -1057,7 +1038,6 @@
{
var sql = "";
List<object> list = new List<object>();
- var dynamicParams = new DynamicParameters();
try
{
list.Clear();
@@ -1065,19 +1045,16 @@
{
//娓呴櫎鐢ㄦ埛鍏宠仈鍔熻兘琛ㄦ暟鎹�
sql = @"delete TRoleRightRelation where role_code=@rolecode";
- dynamicParams.Add("@rolecode", rolecode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
//鏍囪瑙掕壊琛ㄥ叧鑱斿姛鑳芥爣璇�
sql = @"update TRole set is_right='N' where role_code=@rolecode";
- dynamicParams.Add("@rolecode", rolecode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
}
else
{
//娓呴櫎瑙掕壊鍏宠仈鍔熻兘琛ㄦ暟鎹�
sql = @"delete TRoleRightRelation where role_code=@rolecode";
- dynamicParams.Add("@rolecode", rolecode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
//寰幆鍐欏叆鐢ㄦ埛鍏宠仈瑙掕壊琛�
for (int i = 0; i < json.Count; i++) //PC銆丄PP灞�
{
@@ -1086,18 +1063,18 @@
for (int k = 0; k < json[i].children[j].children.Count; k++) //浜岀骇鑿滃崟
{
sql = @"insert into TRoleRightRelation(role_code,right_code,lm_user,lm_date) values(@role_code,@right_code,@lm_user,@lm_date)";
- dynamicParams.Add("@role_code", rolecode);
- dynamicParams.Add("@right_code", json[i].children[j].children[k].code);
- dynamicParams.Add("@lm_user", usercode);
- dynamicParams.Add("@lm_date", DateTime.Now.ToString());
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new {
+ role_code = rolecode,
+ right_code= json[i].children[j].children[k].code,
+ lm_user= usercode, lm_date= DateTime.Now.ToString()
+ }
+ });
}
}
}
//鏍囪瑙掕壊琛ㄥ叧鑱旂敤鎴锋爣璇�
sql = @"update TRole set is_right='Y' where role_code=@rolecode";
- dynamicParams.Add("@rolecode", rolecode);
- list.Add(new { str = sql, parm = dynamicParams });
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
}
bool aa = DapperHelper.DoTransaction(list);
if (aa)
@@ -1233,5 +1210,36 @@
return mes;
}
#endregion
+
+ #region[寰�鏉ュ崟浣嶅垹闄
+ public static ToMessage DeleteCurrentUnit(string unitid)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ try
+ {
+ //鍒犻櫎(鏇存柊鐘舵��)寰�鏉ュ崟浣嶈〃
+ sql = @"update TCustomer set is_delete='1' where id=@unitid";
+ list.Add(new { str = sql, parm = new { unitid = unitid } });
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.Message = "鍒犻櫎鐢ㄦ埛鎴愬姛!";
+ }
+ else
+ {
+ mes.code = "300";
+ mes.Message = "鍒犻櫎鐢ㄦ埛澶辫触!";
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.Message = e.Message;
+ }
+ return mes;
+ }
+ #endregion
}
}
\ No newline at end of file
--
Gitblit v1.9.3