From 1bc70e00b583aa129de0c7996df004535ef0b3e4 Mon Sep 17 00:00:00 2001 From: lg <999544862qq.com> Date: 星期四, 29 八月 2024 16:34:35 +0800 Subject: [PATCH] 用户管理 --- WebApi/Gs.User/Service/MenuActionController.cs | 39 +++++++++++++++++++++++++-------------- 1 files changed, 25 insertions(+), 14 deletions(-) diff --git a/WebApi/Gs.User/Service/MenuActionController.cs b/WebApi/Gs.User/Service/MenuActionController.cs index 42f57ab..ab42aa4 100644 --- a/WebApi/Gs.User/Service/MenuActionController.cs +++ b/WebApi/Gs.User/Service/MenuActionController.cs @@ -66,12 +66,13 @@ guid = Guid.Parse(dr["guid"].ToString()), upGuid = dr["upGuid"].ToString().Length > 0 ? Guid.Parse(dr["upGuid"].ToString()) : null, name = dr["name"].ToString(), - serialNumber = dr["serialNumber"].ToString(), icon = dr["icon"].ToString(), status = int.Parse(dr["status"].ToString()), - fromPath = dr["fromPath"].ToString(), + formPath = dr["formPath"].ToString(), idx = int.Parse(dr["idx"].ToString()), category = int.Parse(dr["category"].ToString()), + statusTxt = (dr["status"].ToString() == "1" ? "姝e父" : "绂佺敤"), + categoryTxt = (dr["category"].ToString() == "1" ? "绐椾綋绫诲瀷" : "鎸夐挳绫诲瀷"), } ); } @@ -89,8 +90,22 @@ public ReturnDto<int?> DeleteModel([FromBody] MenuAction model) { int rtnInt = (int)ReturnCode.Default; + int cont = 0; try { + //鏄惁鍐呯疆 + cont = int.Parse(DbHelperSQL.GetSingle("select count(1) from sys_MenuAction where guid='" + model.guid.ToString() + "' and [isSys]=1").ToString()); + if (cont > 0) + { + return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Exception, "鍒犻櫎澶辫触锛岃鏉$洰涓虹郴缁熷唴缃紝涓嶅彲鍒犻櫎锛�"); + } + cont = 0; + //鏄惁鏈夊瓙鑿滃崟 + cont = int.Parse(DbHelperSQL.GetSingle("select count(1) from sys_MenuAction where upguid='" + model.guid.ToString() + "'").ToString()); + if (cont > 0) + { + return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Exception, "鍒犻櫎澶辫触锛岃鏉$洰涓嬮潰鏈夊瓙鑿滃崟锛屼笉鍙垹闄わ紒"); + } rtnInt = DbHelperSQL.ExecuteSql("delete from dbo.sys_MenuAction where guid='" + model.guid.ToString() + "'"); } catch (Exception ex) @@ -112,14 +127,12 @@ [RequestMethod(RequestMethods.POST)] public ReturnDto<int?> EditModel([FromBody] MenuAction model) { - string dddd= model.guid.ToString(); Guid? guid = model.guid; Guid? upGuid = model.upGuid; string name = model.name; - string serialNumber = model.serialNumber; string icon = model.icon; int status = model.status; - string fromPath = model.fromPath; + string formPath = model.formPath; int category = model.category; int idx = model.idx; int? rtnInt = (int)ReturnCode.Default; @@ -127,24 +140,23 @@ if (guid != null) { strSql.Append(" update dbo.sys_MenuAction"); - strSql.Append(" set upGuid=@upGuid,name=@name,serialNumber=@serialNumber,icon=@icon,status=@status,fromPath=@fromPath,category=@category,idx=@idx"); + strSql.Append(" set upGuid=@upGuid,name=@name,icon=@icon,status=@status,formPath=@formPath,category=@category,idx=@idx"); strSql.Append(" where guid='" + guid + "'"); } else { guid = Guid.NewGuid(); strSql.Append("insert into dbo.sys_MenuAction("); - strSql.Append(" guid,upGuid,name,serialNumber,icon,status,fromPath,category,idx)"); + strSql.Append(" guid,upGuid,name,icon,status,formPath,category,idx)"); strSql.Append(" values ("); - strSql.Append("'" + guid + "',@upGuid,@name,@serialNumber,@icon,@status,@fromPath,@category,@idx)"); + strSql.Append("'" + guid + "',@upGuid,@name,@icon,@status,@formPath,@category,@idx)"); } SqlParameter[] parameters = { new SqlParameter("@upGuid", upGuid), new SqlParameter("@name", name), - new SqlParameter("@serialNumber",serialNumber), new SqlParameter("@icon",icon), new SqlParameter("@status",status), - new SqlParameter("@fromPath",fromPath), + new SqlParameter("@formPath",formPath), new SqlParameter("@category",category), new SqlParameter("@idx",idx), }; @@ -158,7 +170,7 @@ rtnInt = (int)ReturnCode.Exception; } if (rtnInt > 0) - return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, "澧炲姞鎴愬姛锛�"); + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, "鎿嶄綔鎴愬姛锛�"); else return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception, "澧炲姞澶辫触锛岃閲嶈瘯锛�"); } @@ -170,7 +182,7 @@ /// <returns></returns> [RequestMethod(RequestMethods.POST)] [AllowAnonymous] - public ReturnDto<MenuAction> GetModel([FromBody] MenuAction model ) + public ReturnDto<MenuAction> GetModel([FromBody] MenuAction model) { MenuAction m = new MenuAction(); System.Text.StringBuilder sbSql = new StringBuilder(); @@ -185,10 +197,9 @@ m.guid = Guid.Parse(dr["guid"].ToString()); m.upGuid = dr["upGuid"].ToString().Length > 0 ? Guid.Parse(dr["upGuid"].ToString()) : null; m.name = dr["name"].ToString(); - m.serialNumber = dr["serialNumber"].ToString(); m.icon = dr["icon"].ToString(); m.status = int.Parse(dr["status"].ToString()); - m.fromPath = dr["fromPath"].ToString(); + m.formPath = dr["formPath"].ToString(); m.idx = int.Parse(dr["idx"].ToString()); m.category = int.Parse(dr["category"].ToString()); return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "璇诲彇鎴愬姛锛�"); -- Gitblit v1.9.3