From 8aad6ba8e082d1fb63bfdd947f7e9da1bc133611 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 24 六月 2022 23:47:19 +0800
Subject: [PATCH] 工序定义接口开发、节拍工价接口开发
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 1049 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 1,028 insertions(+), 21 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index d0214c6..49a4858 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -21,7 +21,7 @@
public static SqlParameter[] parameters; //瀹氫箟鍏ㄥ眬SqlParameter鍙傛暟鏁扮粍
#region [缁勭粐鏋舵瀯鏁版嵁鏌ヨ]
- public static ToMessage OrganizationSearch(string orgCode, string orgName, string orgType, string userName,int startNum,int endNum,string prop,string order)
+ public static ToMessage OrganizationSearch(string orgCode, string orgName, string orgType, string userName, int startNum, int endNum, string prop, string order)
{
var dynamicParams = new DynamicParameters();
string search = "";
@@ -66,7 +66,7 @@
parent.lm_date
from TOrganization as parent
left join TOrganization as child on parent.parent_id=child.id where parent.is_delete<>1 " + search;
- var data = DapperHelper.GetPageList<object>(sql, dynamicParams,prop,order, startNum, endNum, out total);
+ var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
mes.count = total;
@@ -75,14 +75,77 @@
catch (Exception e)
{
mes.code = "300";
+ mes.count = 0;
mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region [缁勭粐鏋舵瀯鏌ユ壘涓婄骇鍗曚綅]
+ public static ToMessage PrentOrganization(string orgcode)
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ string search = "";
+ try
+ {
+ switch (orgcode)
+ {
+ case "F": //宸ュ巶
+ orgcode = "";
+ search += "and description=@orgcode ";
+ dynamicParams.Add("@orgcode", orgcode);
+ break;
+ case "D": //閮ㄩ棬
+ orgcode = "F";
+ search += "and description=@orgcode ";
+ dynamicParams.Add("@orgcode", orgcode);
+ break;
+ case "W": //杞﹂棿
+ orgcode = "D";
+ search += "and description=@orgcode ";
+ dynamicParams.Add("@orgcode", orgcode);
+ break;
+ case "K": //绉戝
+ orgcode = "W";
+ search += "and description=@orgcode ";
+ dynamicParams.Add("@orgcode", orgcode);
+ break;
+ case "L": //浜х嚎
+ orgcode = "K";
+ search += "and description=@orgcode ";
+ dynamicParams.Add("@orgcode", orgcode);
+ break;
+ default:
+ orgcode = "";
+ search += "and description=@orgcode ";
+ dynamicParams.Add("@orgcode", orgcode);
+ break;
+ }
+ sql = @"select id,org_code,org_name
+ from TOrganization
+ where is_delete<>'1' " + search;
+
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
}
return mes;
}
#endregion
#region[鏂板缂栬緫缁勭粐鏋舵瀯]
- public static ToMessage AddUpdateOrganization(string organType, string organCode, string organName,string Operator, int supUnit, string operType)
+ public static ToMessage AddUpdateOrganization(string organType, string organCode, string organName, string Operator, int supUnit, string operType)
{
var dynamicParams = new DynamicParameters();
try
@@ -101,15 +164,19 @@
if (cont > 0)
{
mes.code = "200";
+ mes.count = 0;
mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.data = null;
}
else
{
mes.code = "300";
+ mes.count = 0;
mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.data = null;
}
}
- if (operType == "Update")
+ if (operType == "Update")
{
var sql = @"update TOrganization set description=@organType,org_name=@organName,parent_id=@supUnit,lm_user=@Operator,lm_date=@CreateDate where org_code=@organCode";
dynamicParams.Add(@"organCode", organCode);
@@ -122,19 +189,25 @@
if (cont > 0)
{
mes.code = "200";
+ mes.count = 0;
mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.data = null;
}
else
{
mes.code = "300";
+ mes.count = 0;
mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.data = null;
}
- }
+ }
}
catch (Exception e)
{
mes.code = "300";
+ mes.count = 0;
mes.Message = e.Message;
+ mes.data = null;
}
return mes;
}
@@ -164,19 +237,25 @@
if (cont > 0)
{
mes.code = "200";
+ mes.count = 0;
mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
+ mes.data = null;
}
else
{
mes.code = "300";
+ mes.count = 0;
mes.Message = "鍒犻櫎鎿嶄綔澶辫触!";
+ mes.data = null;
}
}
}
catch (Exception e)
{
mes.code = "300";
+ mes.count = 0;
mes.Message = e.Message;
+ mes.data = null;
}
return mes;
}
@@ -185,7 +264,7 @@
#region[鐢ㄦ埛娓呭崟鏁版嵁鏌ヨ]
- public static ToMessage UserSearch(string UserCode, string UserName, string StuOrg, string Enable, int startNum, int endNum, string prop, string order)
+ public static ToMessage UserSearch(string UserCode, string UserName, string StuOrg,string wagetype, string Enable, int startNum, int endNum, string prop, string order)
{
var dynamicParams = new DynamicParameters();
string search = "";
@@ -206,6 +285,11 @@
search += "and u.stu_torgcode=@StuOrg ";
dynamicParams.Add("@StuOrg", StuOrg);
}
+ if (wagetype != "" && wagetype != null)
+ {
+ search += "and u.wagetype=@wagetype ";
+ dynamicParams.Add("@wagetype", wagetype);
+ }
if (Enable != "" && Enable != null)
{
search += "and u.enable=@Enable ";
@@ -218,7 +302,7 @@
//search = search.Substring(3);//鎴彇绱㈠紩2鍚庨潰鐨勫瓧绗�
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
- var sql = @"select u.usercode,u.username,u.stu_torgcode,t.org_name,u.enable,u.lm_user,u.lm_date,u.is_role
+ var sql = @"select u.id,u.usercode,u.username,u.stu_torgcode,t.org_name,u.password,u.mobile,u.email,u.wagetype,u.enable,u.lm_user,u.lm_date,u.is_role
from TUser u
left join TOrganization t on u.stu_torgcode=t.org_code where u.is_delete<>1 " + search;
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
@@ -230,70 +314,150 @@
catch (Exception e)
{
mes.code = "300";
+ mes.count = 0;
mes.Message = e.Message;
+ mes.data = null;
}
return mes;
}
#endregion
+ #region [鐢ㄦ埛鎵�灞炵粍缁嘳
+ public static ToMessage UserOrganization()
+ {
+ var dynamicParams = new DynamicParameters();
+ string sql = "";
+ try
+ {
+ List<TreeDG> list = new List<TreeDG>();
+ sql = @"select id,parent_id,org_code,org_name,description
+ FROM TOrganization ";
+ var dt = DapperHelper.selectdata(sql, dynamicParams);
+ for (int i = 0; i < dt.Rows.Count; i++) //杩欓噷鏄惊鐜墍鏈�
+ {
+ if (string.IsNullOrEmpty(dt.Rows[i]["PARENT_ID"].ToString()) || dt.Rows[i]["PARENT_ID"].ToString() == "0") //鍒ゆ柇鏄惁鏈�澶栧眰鏍硅妭鐐�
+ {
+ TreeDG tbj = new TreeDG();
+ tbj.id = dt.Rows[i]["ID"].ToString();
+ tbj.code = dt.Rows[i]["ORG_CODE"].ToString();
+ tbj.name = dt.Rows[i]["ORG_NAME"].ToString();
+ list.Add(tbj);
+ }
+ }
+ digui(dt, list);
+ mes.code = "200";
+ mes.Message = "鍔犺浇瀹屾垚";
+ mes.data = list;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.data = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region銆愰�掑綊鏂规硶銆�
+ public static void digui(DataTable dt, List<TreeDG> tree)
+ {
+ for (int m = 0; m < tree.Count; m++)
+ {
+ tree[m].children = new List<TreeDG>();
+ for (int i = 0; i < dt.Rows.Count; i++)//绗竴娆″惊鐜紝寰楀埌鎵�鏈夋牴鑺傜偣鐨勫瓙闆�
+ {
+ if (tree[m].id == dt.Rows[i]["PARENT_ID"].ToString() && dt.Rows[i]["ID"].ToString() != dt.Rows[i]["PARENT_ID"].ToString())
+ {
+ TreeDG tbjson = new TreeDG();
+ tbjson.id = dt.Rows[i]["ID"].ToString();
+ tbjson.code = dt.Rows[i]["ORG_CODE"].ToString();
+ tbjson.name = dt.Rows[i]["ORG_NAME"].ToString();
+ tree[m].children.Add(tbjson);
+ }
+ }
+ for (int i = 0; i < tree[m].children.Count; i++)
+ {
+ digui(dt, tree[m].children);//鍐嶆鐢ㄥ瓙闆嗗幓寰幆锛屾嬁鍑哄瓙闆嗙殑瀛愰泦
+ }
+ }
+ }
+
+ #endregion
+
#region[鐢ㄦ埛娓呭崟鏂板缂栬緫]
- public static ToMessage AddUpdateUser(string UserId, string UserCode, string UserName, string Enable, string StuOrg,string Mobile,string Email, string Operator, string OperType)
+ public static ToMessage AddUpdateUser(string UserId, string UserCode, string UserName,string Password, string Enable, string StuOrg, string wagetype, string Mobile, string Email, string Operator, string OperType)
{
var dynamicParams = new DynamicParameters();
try
{
if (OperType == "Add")
{
- var sql = @"insert into TUser(usercode,username,enable,mobile,lm_date,email,lm_user,stu_torgcode)
- values(@UserCode,@UserName,@Enable,@CreateDate,@Email,@Operator,@StuOrg)";
+ var sql = @"insert into TUser(usercode,username,password,enable,mobile,lm_date,email,lm_user,stu_torgcode,wagetype)
+ values(@UserCode,@UserName,@password,@Enable,@Mobile,@CreateDate,@Email,@Operator,@StuOrg,@wagetype)";
dynamicParams.Add("@UserCode", UserCode);
dynamicParams.Add("@UserName", UserName);
+ dynamicParams.Add("@password", Password);
dynamicParams.Add("@Enable", Enable);
dynamicParams.Add("@Mobile", Mobile);
dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
dynamicParams.Add("@Email", Email);
dynamicParams.Add("@Operator", Operator);
dynamicParams.Add("@StuOrg", StuOrg);
+ dynamicParams.Add("@wagetype", wagetype);
int cont = DapperHelper.SQL(sql, dynamicParams);
if (cont > 0)
{
mes.code = "200";
+ mes.count = 0;
mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.data = null;
}
else
{
mes.code = "300";
+ mes.count = 0;
mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.data = null;
}
}
if (OperType == "Update")
{
- var sql = @"update TUser set username=@UserName,enable=@Enable,mobile=@Mobile,lm_user=@Operator,email=@Email,stu_torgcode=@StuOrg,lm_date=@CreateDate where id=@UserId";
+ var sql = @"update TUser set username=@UserName,password=@password,enable=@Enable,mobile=@Mobile,lm_user=@Operator,email=@Email,stu_torgcode=@StuOrg,wagetype=@wagetype,lm_date=@CreateDate where id=@UserId";
dynamicParams.Add("@UserId", UserId);
dynamicParams.Add("@UserName", UserName);
+ dynamicParams.Add("@password", Password);
dynamicParams.Add("@Enable", Enable);
dynamicParams.Add("@Mobile", Mobile);
dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
dynamicParams.Add("@Email", Email);
dynamicParams.Add("@Operator", Operator);
dynamicParams.Add("@StuOrg", StuOrg);
+ dynamicParams.Add("@wagetype", wagetype);
int cont = DapperHelper.SQL(sql, dynamicParams);
if (cont > 0)
{
mes.code = "200";
+ mes.count = 0;
mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.data = null;
}
else
{
mes.code = "300";
+ mes.count = 0;
mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.data = null;
}
}
}
catch (Exception e)
{
mes.code = "300";
+ mes.count = 0;
mes.Message = e.Message;
+ mes.data = null;
}
return mes;
}
@@ -312,29 +476,33 @@
dynamicParams.Add("@userid", userid);
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 });
+ sql = @"delete TUserRoleRelation where user_code=@usercode";
+ 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)
{
mes.code = "200";
+ mes.count = 0;
mes.Message = "鍒犻櫎鐢ㄦ埛鎴愬姛!";
+ mes.data = null;
}
- else
+ else
{
mes.code = "300";
+ mes.count = 0;
mes.Message = "鍒犻櫎鐢ㄦ埛澶辫触!";
+ mes.data = null;
}
}
catch (Exception e)
{
mes.code = "300";
+ mes.count = 0;
mes.Message = e.Message;
+ mes.data = null;
}
return mes;
}
@@ -362,11 +530,11 @@
for (int i = 0; i < data.Count; i++)
{
sql = @"select B.role_code as code,B.role_name as name,(case when C.role_code is null then 'N' else 'Y' end) flag from TRole B
- left join TUserRoleRelation C on B.role_code=C.role_code
- where B.roletype_code=@roletype_code and C.user_code=@usercode and B.is_delete='0'";
+ left join(select role_code from TUserRoleRelation where user_code=@usercode) C on B.role_code=C.role_code
+ where B.roletype_code=@roletype_code and B.is_delete='0'";
dynamicParams.Add("@roletype_code", data[i].code);
dynamicParams.Add("@usercode", usercode);
- var data0 = DapperHelper.select<TreeObejctCont>(sql, dynamicParams);
+ var data0 = DapperHelper.select<TreeObejctCn>(sql, dynamicParams);
data[i].children = data0;
}
@@ -377,13 +545,291 @@
catch (Exception e)
{
mes.code = "300";
+ mes.count = 0;
mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[鐢ㄦ埛娓呭崟鍏宠仈瑙掕壊淇濆瓨]
+ public static ToMessage SaveUserAssoctRole(string usercode, List<RoleUserSubmit> json)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ try
+ {
+ list.Clear();
+ if (json == null || json.Count <= 0)
+ {
+ //娓呴櫎鐢ㄦ埛鍏宠仈瑙掕壊琛ㄦ暟鎹�
+ sql = @"delete TUserRoleRelation where user_code=@usercode";
+ list.Add(new { str = sql, parm =new {usercode = usercode } });
+ //娓呴櫎鐢ㄦ埛琛ㄥ叧鑱旇鑹叉爣璇�
+ 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";
+ 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(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 usercode=@usercode";
+ list.Add(new { str = sql, parm = new { usercode = usercode} });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鎿嶄綔鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鎿嶄綔澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[鐢ㄦ埛娓呭崟瀵煎叆]
+ public static ToMessage ImportUserExcel(string username, string filesName)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ DataTable ds = new DataTable();
+
+ try
+ {
+ ds = NPOIHelper.GetExcelDatatable(filesName); //璋冪敤鑷畾涔夋柟娉�
+ int rowsnum = ds.Rows.Count;
+ if (rowsnum == 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "Excel琛ㄦ牸涓虹┖,鏃犳暟鎹紒";
+ mes.data = null;
+ }
+ else
+ {
+ list.Clear();
+ for (int i = 0; i < ds.Rows.Count; i++)
+ {
+
+ if (ds.Rows[i][1].ToString() != "" && ds.Rows[i][1].ToString() != null)
+ {
+ 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)";
+ 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);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "瀵煎叆鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "瀵煎叆澶辫触!";
+ mes.data = null;
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
}
return mes;
}
#endregion
+
+ #region[瑙掕壊绫诲瀷鏌ヨ]
+ public static ToMessage RoleTypeSearch(int startNum, int endNum, string prop, string order)
+ {
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ // --------------鏌ヨ鎸囧畾鏁版嵁--------------
+ var total = 0; //鎬绘潯鏁�
+ var sql = @"select roletype_code,roletype_name
+ from TRoleType
+ where is_delete<>'1' ";
+ var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.count = total;
+ mes.data = data.ToList();
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[瑙掕壊绫诲瀷鏂板]
+ public static ToMessage RoleTypeAdd(List<ObjectData> json)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ list.Clear();
+ //寰幆鍐欏叆瑙掕壊绫诲瀷琛�
+ for (int i = 0; i < json.Count; i++)
+ {
+ sql = @"insert into TRoleType(roletype_code,roletype_name) values(@roletypecode,@roletypename)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ roletypecode = json[i].code,
+ roletypename = json[i].name
+ }
+ });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鎿嶄綔鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鎿嶄綔澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[瑙掕壊绫诲瀷鍒犻櫎]
+ public static ToMessage RoleTypeDelete(string roleTypeCode)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ try
+ {
+ list.Clear();
+ sql = @"delete TRoleType where roletype_code=@roletypecode";
+ list.Add(new { str = sql, parm = new { roletypecode = roleTypeCode}});
+ sql = @"delete TRole where roletype_code=@roletypecode";
+ list.Add(new { str = sql, parm = new { roletypecode = roleTypeCode }});
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鎿嶄綔鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鎿嶄綔澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[瑙掕壊绫诲瀷涓嬫媺鎺ュ彛]
+ public static ToMessage RoleTypeSelect()
+ {
+ string sql = "";
+ try
+ {
+ //鑾峰彇璁惧绫诲瀷鏁版嵁
+ sql = @"select roletype_code,roletype_name from TRoleType where is_delete<>'1' ";
+ var data = DapperHelper.selecttable(sql);
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
#region[瑙掕壊娓呭崟鏌ヨ]
public static ToMessage RoleSearch(string RoleCode, string RoleName, string RoleTypeCode, string CreateUser, int startNum, int endNum, string prop, string order)
@@ -419,7 +865,7 @@
//search = search.Substring(3);//鎴彇绱㈠紩2鍚庨潰鐨勫瓧绗�
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
- var sql = @"select A.role_code,A.role_name,b.roletype_code,B.roletype_name,A.lm_user,A.lm_date,A.is_user,A.is_right
+ var sql = @"select A.id,A.role_code,A.role_name,b.roletype_code,B.roletype_name,A.description,A.lm_user,A.lm_date,A.is_user,A.is_right
from TRole A
left join TRoleType B on A.roletype_code=B.roletype_code
where A.is_delete<>'1' " + search;
@@ -432,7 +878,568 @@
catch (Exception e)
{
mes.code = "300";
+ mes.count = 0;
mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[瑙掕壊娓呭崟鏂板缂栬緫]
+ public static ToMessage AddUpdateRole(string RoleId, string RoleCode, string RoleName, string RoleTypeCode, string description, string Usercode, string OperType)
+ {
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ if (OperType == "Add")
+ {
+ var sql = @"insert into TRole(role_code,role_name,lm_user,lm_date,roletype_code,description)
+ values(@RoleCode,@RoleName,@Usercode,@CreateDate,@RoleTypeCode,@description)";
+ dynamicParams.Add("@RoleCode", RoleCode);
+ dynamicParams.Add("@RoleName", RoleName);
+ dynamicParams.Add("@Usercode", Usercode);
+ dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
+ dynamicParams.Add("@RoleTypeCode", RoleTypeCode);
+ dynamicParams.Add("@description", description);
+ int cont = DapperHelper.SQL(sql, dynamicParams);
+ if (cont > 0)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.data = null;
+ }
+ }
+ if (OperType == "Update")
+ {
+ var sql = @"update TRole set role_name=@RoleName,lm_user=@Usercode,lm_date=@CreateDate,roletype_code=@RoleTypeCode,description=@description where id=@RoleId";
+ dynamicParams.Add("@RoleId", RoleId);
+ dynamicParams.Add("@RoleName", RoleName);
+ dynamicParams.Add("@Usercode", Usercode);
+ dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
+ dynamicParams.Add("@RoleTypeCode", RoleTypeCode);
+ dynamicParams.Add("@description", description);
+ int cont = DapperHelper.SQL(sql, dynamicParams);
+ if (cont > 0)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.data = null;
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[瑙掕壊娓呭崟鍒犻櫎]
+ public static ToMessage DeleteRole(string RoleCode)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ try
+ {
+ //鏇存柊瑙掕壊琛ㄣ�佽鑹插叧鑱旂敤鎴锋爣璇嗗強鍒犻櫎鐘舵��
+ sql = @"update TRole set is_user='N',is_right='N',is_delete='1' where role_code=@RoleCode";
+ list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
+ //鏇存柊瑙掕壊鍏宠仈鐢ㄦ埛琛ㄣ�佽鑹插叧鑱旂敤鎴锋爣璇嗗強鍒犻櫎鐘舵��
+ sql = @"delete TUserRoleRelation where role_code=@RoleCode";
+ list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
+ //鍒犻櫎(鏇存柊鐘舵��)瑙掕壊鍔熻兘琛�
+ sql = @"update TRoleRightRelation set is_delete='1' where role_code=@RoleCode";
+ list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鍒犻櫎鐢ㄦ埛鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鍒犻櫎鐢ㄦ埛澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[瑙掕壊娓呭崟鍏宠仈鐢ㄦ埛鏌ヨ]
+ public static ToMessage RoleAssociationUser(string rolecode, string usercode, string username, string orgcode, string isrole, int startNum, int endNum, string prop, string order)
+ {
+ var dynamicParams = new DynamicParameters();
+ string search = "";
+ try
+ {
+ if (usercode != "" && usercode != null)
+ {
+ search += "and A.usercode like '%'+@usercode+'%' ";
+ dynamicParams.Add("@usercode", usercode);
+ }
+ if (username != "" && username != null)
+ {
+ search += "and A.username like '%'+@username+'%' ";
+ dynamicParams.Add("@username", username);
+ }
+ if (orgcode != "" && orgcode != null)
+ {
+ search += "and B.org_code=@orgcode ";
+ dynamicParams.Add("@orgcode", orgcode);
+ }
+ if (isrole != "" && isrole != null)
+ {
+ if (isrole == "Y")
+ {
+ search += "and C.user_code is not null ";
+ }
+ else
+ {
+ search += "and C.user_code is null ";
+ }
+ }
+ if (search == "")
+ {
+ search = " and 1=1 ";
+ }
+ //search = search.Substring(3);//鎴彇绱㈠紩2鍚庨潰鐨勫瓧绗�
+ // --------------鏌ヨ鎸囧畾鏁版嵁--------------
+ var total = 0; //鎬绘潯鏁�
+ var sql = @"select A.usercode,A.username,B.org_code,B.org_name,(case when C.user_code is not null then 'Y' else 'N' end) as flag
+ from TUser A
+ left join TOrganization B on A.stu_torgcode=B.org_code
+ left join (
+ select distinct user_code from TUserRoleRelation where role_code=@rolecode
+ ) C on A.usercode=C.user_code where A.is_delete<>'1' " + search;
+ dynamicParams.Add("@rolecode", rolecode);
+ var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.count = total;
+ mes.data = data.ToList();
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[鐢ㄦ埛娓呭崟鍏宠仈瑙掕壊鏌ヨ1]
+ public static ToMessage RoleAssociationUserTwo(string rolecode)
+ {
+ string sql = "";
+ var dynamicParams = new DynamicParameters();
+ List<TreeObejct> list = new List<TreeObejct>();
+ try
+ {
+ //鑾峰彇瑙掕壊绫诲瀷闆嗗悎(鍖呭惈缁戝畾鏍囪瘑)
+ dynamicParams.Add("@role_code", rolecode);
+ var data = DapperHelper.selectProcedure("h_p_T_RoleAssociationUserDisplay", dynamicParams);
+
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[瑙掕壊娓呭崟鍏宠仈鐢ㄦ埛淇濆瓨]
+ public static ToMessage SaveRoleAssoctUser(string rolecode, List<ObjectData> json)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ try
+ {
+ list.Clear();
+ if (json == null || json.Count <= 0)
+ {
+ //娓呴櫎鐢ㄦ埛鍏宠仈瑙掕壊琛ㄦ暟鎹�
+ sql = @"delete TUserRoleRelation where role_code=@rolecode";
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
+ //鏍囪瑙掕壊琛ㄥ叧鑱旂敤鎴锋爣璇�
+ sql = @"update TRole set is_user='N' where role_code=@rolecode";
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
+ }
+ else
+ {
+ //娓呴櫎鐢ㄦ埛鍏宠仈瑙掕壊琛ㄦ暟鎹�
+ sql = @"delete TUserRoleRelation where role_code=@rolecode";
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
+ //寰幆鍐欏叆鐢ㄦ埛鍏宠仈瑙掕壊琛�
+ for (int i = 0; i < json.Count; i++)
+ {
+ sql = @"insert into TUserRoleRelation(user_code,role_code) values(@usercode,@role_code)";
+ list.Add(new { str = sql, parm = new { usercode = json[i].code, role_code = rolecode } });
+ }
+ //鏍囪瑙掕壊琛ㄥ叧鑱旂敤鎴锋爣璇�
+ sql = @"update TRole set is_user='Y' where role_code=@rolecode";
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鎿嶄綔鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鎿嶄綔澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[瑙掕壊娓呭崟鍏宠仈鍔熻兘鏌ヨ]
+ public static ToMessage RoleAssociationRight(string rolecode,string type)
+ {
+ List<object> list=new List<object>();
+ try
+ {
+ if (type == "" || type == null)
+ {
+ list.Add(SeachEncode.RightLocation(rolecode, "PC"));
+ list.Add(SeachEncode.RightLocation(rolecode, "APP"));
+ }
+ else if (type == "APP")
+ {
+ list.Add(SeachEncode.RightLocation(rolecode, type));
+ }
+ else {
+ list.Add(SeachEncode.RightLocation(rolecode, type));
+ }
+ mes.code = "200";
+ mes.count = list.Count;
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = list;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region [瑙掕壊娓呭崟鍏宠仈鍔熻兘淇濆瓨]
+ public static ToMessage SaveUserAssoctRight(string rolecode,string usercode, List<TreeDM> json)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ try
+ {
+ list.Clear();
+ if (json == null || json.Count <= 0)
+ {
+ //娓呴櫎鐢ㄦ埛鍏宠仈鍔熻兘琛ㄦ暟鎹�
+ sql = @"delete TRoleRightRelation where role_code=@rolecode";
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
+ //鏍囪瑙掕壊琛ㄥ叧鑱斿姛鑳芥爣璇�
+ sql = @"update TRole set is_right='N' where role_code=@rolecode";
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
+ }
+ else
+ {
+ //娓呴櫎瑙掕壊鍏宠仈鍔熻兘琛ㄦ暟鎹�
+ sql = @"delete TRoleRightRelation where role_code=@rolecode";
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
+ //寰幆鍐欏叆鐢ㄦ埛鍏宠仈瑙掕壊琛�
+ for (int i = 0; i < json.Count; i++) //PC銆丄PP灞�
+ {
+ for (int j = 0; j < json[i].children.Count; j++) //涓�绾ц彍鍗�
+ {
+ 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)";
+ 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";
+ list.Add(new { str = sql, parm = new { rolecode = rolecode } });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鎿嶄綔鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鎿嶄綔澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+
+ #region[寰�鏉ュ崟浣嶆煡璇
+ public static ToMessage CurrentUnitSearch(string cuntUnitCode, string cuntUnitName, string unitAttr, string createUser, int startNum, int endNum, string prop, string order)
+ {
+ var dynamicParams = new DynamicParameters();
+ string search = "";
+ try
+ {
+ if (cuntUnitCode != "" && cuntUnitCode != null)
+ {
+ search += "and code like '%'+@cuntUnitCode+'%' ";
+ dynamicParams.Add("@cuntUnitCode", cuntUnitCode);
+ }
+ if (cuntUnitName != "" && cuntUnitName != null)
+ {
+ search += "and name like '%'+@cuntUnitName+'%' ";
+ dynamicParams.Add("@cuntUnitName", cuntUnitName);
+ }
+ if (unitAttr != "" && unitAttr != null)
+ {
+ switch (unitAttr)
+ {
+ case "WG": //澶栬喘
+ search += "and mtype=@unitAttr ";
+ dynamicParams.Add("@unitAttr", unitAttr);
+ break;
+ case "WX": //澶栧崗
+ search += "and btype=@unitAttr ";
+ dynamicParams.Add("@unitAttr", unitAttr);
+ break;
+ default: //瀹㈡埛
+ search += "and htype=@unitAttr ";
+ dynamicParams.Add("@unitAttr", unitAttr);
+ break;
+ }
+ }
+ if (createUser != "" && createUser != null)
+ {
+ search += "and lm_user like '%'+@createUser+'%' ";
+ dynamicParams.Add("@createUser", createUser);
+ }
+ if (search == "")
+ {
+ search = "and 1=1 ";
+ }
+ // --------------鏌ヨ鎸囧畾鏁版嵁--------------
+ var total = 0; //鎬绘潯鏁�
+ var sql = @"select id,code,name,mtype,btype,htype,conttacts,conttphone,addr,lm_user,lm_date from TCustomer
+ where is_delete<>'1' " + search;
+ var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.count = total;
+ mes.data = data.ToList();
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[寰�鏉ュ崟浣嶆柊澧炵紪杈慮
+ public static ToMessage AddUpdateCurrentUnit(string unitid, string unitcode, string unitname, string mtypecode, string btypecode, string htypecode, string person, string contact, string description, string usercode,string OperType)
+ {
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ if (OperType == "Add")
+ {
+ var sql = @"insert into TCustomer(code,name,mtype,btype,htype,conttacts,conttphone,addr,lm_user,lm_date)
+ values(@unitcode,@unitname,@mtypecode,@btypecode,@htypecode,@person,@contact,@description,@usercode,@CreateDate)";
+ dynamicParams.Add("@unitcode", unitcode);
+ dynamicParams.Add("@unitname", unitname);
+ dynamicParams.Add("@mtypecode", mtypecode);
+ dynamicParams.Add("@btypecode", btypecode);
+ dynamicParams.Add("@htypecode", htypecode);
+ dynamicParams.Add("@person", person);
+ dynamicParams.Add("@contact", contact);
+ dynamicParams.Add("@description", description);
+ dynamicParams.Add("@usercode", usercode);
+ dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
+ int cont = DapperHelper.SQL(sql, dynamicParams);
+ if (cont > 0)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.data = null;
+ }
+ }
+ if (OperType == "Update")
+ {
+ var sql = @"update TCustomer set name=@unitname,mtype=@mtypecode,btype=@btypecode,htype=@htypecode,conttacts=@person,conttphone=@contact,addr=@description,lm_user=@usercode,lm_date=@CreateDate where id=@unitid";
+ dynamicParams.Add("@unitid", unitid);
+ dynamicParams.Add("@unitname", unitname);
+ dynamicParams.Add("@mtypecode", mtypecode);
+ dynamicParams.Add("@btypecode", btypecode);
+ dynamicParams.Add("@htypecode", htypecode);
+ dynamicParams.Add("@person", person);
+ dynamicParams.Add("@contact", contact);
+ dynamicParams.Add("@description", description);
+ dynamicParams.Add("@usercode", usercode);
+ dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
+ int cont = DapperHelper.SQL(sql, dynamicParams);
+ if (cont > 0)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.data = null;
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[寰�鏉ュ崟浣嶅垹闄
+ public static ToMessage DeleteCurrentUnit(string unitcode)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ list.Clear();
+ sql = @"select * from TFlw_Rteqp where eqp_code=@unitcode";
+ dynamicParams.Add("@unitcode", unitcode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "澶栧崗渚涙柟宸插叧鑱斿鍗忓伐搴�,涓嶅厑璁稿垹闄�!";
+ mes.data = null;
+ return mes;
+ }
+ //鍒犻櫎(鏇存柊鐘舵��)寰�鏉ュ崟浣嶈〃
+ sql = @"update TCustomer set is_delete='1' where code=@unitcode";
+ list.Add(new { str = sql, parm = new { unitcode = unitcode } });
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鍒犻櫎鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鍒犻櫎澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
}
return mes;
}
--
Gitblit v1.9.3