private void deleteRole() { try { if (dataGridView.SelectedRows.Count < 1) { return; } string R_Code = dataGridView.SelectedRows[0].Cells["R_Code"].Value.ToString(); if (untCommon.QuestionMsg("您确定删除[" + R_Code + "]该项吗?")) { SysRoleBLL companybll = new SysRoleBLL(); if (companybll.Delete(R_Code) > 0) { untCommon.InfoMsg("删除成功!"); loadData(); } else { untCommon.InfoMsg("删除失败!"); } } } catch (Exception ex) { untCommon.ErrorMsg("角色管理删除数据异常:" + ex.Message); } }
public string delete(SysRoleModel model) { var a = roleBLL.Delete(model.Id); var jsondata = js.Serialize(new { flag = a }); return(jsondata); }
public ActionResult UpdateData() { ProductPublishVer ver = null; using (var client = new ServiceReference1.Service1Client()) { try { //TransactionOptions options=new TransactionOptions(); //options.IsolationLevel=IsolationLevel.Serializable; //options.Timeout = new TimeSpan(0, 0, 60); using (TransactionScope tran = new TransactionScope(TransactionScopeOption.Required)) { ver = client.UpdatePublish(CommonService.CompanyId, 2, Sys.CurrentUser.FullName); #region 菜单和权限 if (ver.ProductModuleVerk__BackingField != null) { var menus = new List <SysMenus>(); var limits = new List <SysLimits>(); ver.ProductModuleVerk__BackingField.ProductMenuLimitsk__BackingField.Each(o => { switch (o.Typek__BackingField) { case 1: menus.Add(new SysMenus() { MenuId = o.MenuIdk__BackingField, PMenuId = o.PMenuIdk__BackingField, SortOrder = o.SortOrderk__BackingField, Status = o.Statusk__BackingField, Title = o.Titlek__BackingField, URL = o.Urlk__BackingField, CompanyId = CommonService.CompanyId }); break; case 3: limits.Add(new SysLimits() { LimitId = o.MenuIdk__BackingField, PLimitId = o.PMenuIdk__BackingField, SortOrder = o.SortOrderk__BackingField, Status = Convert.ToInt16(o.Statusk__BackingField), Title = o.Titlek__BackingField, CompanyId = CommonService.CompanyId }); break; default: break; } }); if (menus.Any()) { var list = SysMenuBLL.FindList(o => o.CompanyId == CommonService.CompanyId); SysMenuBLL.Delete(list); SysMenuBLL.AddRange(menus); } if (limits.Any()) { var list = SysLimitsBLL.FindList(o => o.CompanyId == CommonService.CompanyId); SysLimitsBLL.Delete(list); SysLimitsBLL.AddRange(limits); } } #endregion #region 角色 if (ver.ProductRoleVerk__BackingField != null) { var roles = new List <SysRoles>(); var customMenus = new List <SysCustomMenus>(); ver.ProductRoleVerk__BackingField.ProductRolesk__BackingField.Each(o => { var role = new SysRoles(); role.CompanyId = CommonService.CompanyId; role.RoleId = o.RoleIdk__BackingField.GetValueOrDefault(); role.Title = o.Titlek__BackingField; role.LimitsIds = o.Limitidsk__BackingField ?? ""; //role.Type = 0; role.Status = true; var cm = new SysCustomMenus() { CompanyId = role.CompanyId, Type = 2, ObjId = role.RoleId, MenuIds = string.Join(",", o.ProductRoleDatask__BackingField.Where(i => i.HasSelectedk__BackingField).OrderBy(i => i.SortOrderk__BackingField).Select(i => i.MenuIdk__BackingField)) }; roles.Add(role); customMenus.Add(cm); }); if (roles.Any()) { var list = SysRoleBLL.FindList(o => o.CompanyId == CommonService.CompanyId); roles.Each(o => { var r = list.FirstOrDefault(i => i.RoleId == o.RoleId); if (r != null) { //o.DeptId = r.DeptId; if (!r.Memo.IsNullOrEmpty()) { o.Memo = r.Memo; } o.Status = r.Status; } }); SysRoleBLL.RemoveCustomMenus(SysRoleBLL.GetCustomMenus()); SysRoleBLL.Delete(list); SysRoleBLL.AddRange(roles); SysRoleBLL.AddCustomMenus(customMenus); } } #endregion #region 字典 if (ver.ProductDictionaryVerk__BackingField != null) { var dicts = new List <SysDataDictionary>(); ver.ProductDictionaryVerk__BackingField.ProductDictionaryDatask__BackingField.Each(o => { dicts.Add(new SysDataDictionary() { Depth = o.Depthk__BackingField, DicPSN = o.DicPSNk__BackingField, DicSN = o.DicSNk__BackingField, //HasChild = o.HasChildk__BackingField, SortOrder = o.SortOrderk__BackingField, Status = Convert.ToBoolean(o.Statusk__BackingField), Title = o.Titlek__BackingField }); }); if (dicts.Any()) { var list = SysDataDictService.FindList(o => o.CompanyId == CommonService.CompanyId); SysDataDictService.Delete(list); SysDataDictService.AddRange(dicts); } } #endregion #region 初始化数据 var sqls = new Dictionary <int, string>(); var db = new Pharos.DBFramework.DBHelper(); if (ver.ProductDataVerk__BackingField != null) { ver.ProductDataVerk__BackingField.ProductDataSqlsk__BackingField.OrderBy(o => o.RunSortk__BackingField).Each(o => { sqls[o.MenuIdk__BackingField] = o.RunSqlk__BackingField; }); foreach (var de in sqls) { try { var sql = de.Value; if (sql.Contains("@")) { System.Text.RegularExpressions.Regex regex = new System.Text.RegularExpressions.Regex(@"@\b[a-zA-Z0-9]*"); sql = sql.Replace(regex.Match(sql).ToString(), CommonService.CompanyId.ToString()); } db.ExecuteNonQueryText(sql, null); } catch (Exception ex) { throw new Exception("更新初始化数据失败!MenuId:" + de.Key + ";" + Pharos.Sys.LogEngine.ToInnerException(ex).Message); } } sqls.Clear(); } #endregion #region 历史数据处理 ver.ProductPublishSqlsk__BackingField.OrderBy(o => o.RunSortk__BackingField).Each(o => { sqls[o.MenuIdk__BackingField] = o.RunSqlk__BackingField; }); foreach (var de in sqls) { try { db.ExecuteNonQueryText(de.Value, null); } catch (Exception ex) { throw new Exception("历史数据处理失败!MenuId:" + de.Key + ";" + Pharos.Sys.LogEngine.ToInnerException(ex).Message); } } #endregion tran.Complete(); } } catch (Exception e) { new Pharos.Sys.LogEngine().WriteError(e); if (ver != null) { client.AddUpdateLog(ver.PublishIdk__BackingField, CommonService.CompanyId, false, Pharos.Sys.LogEngine.ToInnerException(e).Message, Sys.CurrentUser.FullName); } return(Content(OpResult.Fail().ToJson())); } client.Close(); return(Content(OpResult.Success().ToJson())); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; switch (request["action"]) { case "getListByPage": jr = new JsonResult(); try { page = Convert.ToInt32(request["page"]); rows = Convert.ToInt32(request["rows"]); sort = request["sort"]; order = request["order"]; gsr = bll.GetListByPage(page, rows, sort, order); jr.Success = true; jr.Obj = gsr; } catch (Exception ex) { jr.Msg = "系统错误!" + ex.ToString(); } context.Response.Write(Utils.SerializeObject(jr)); break; case "Insert": jr = new JsonResult(); try { sysRole = Utils.AutoWiredClass <SysRole>(request, sysRole = new SysRole()); sysRole.ID = Guid.NewGuid().ToString(); sysRole.CDate = DateTime.Now; bll.Insert(sysRole); jr.Success = true; jr.Msg = "保存成功!"; } catch (Exception ex) { jr.Msg = "保存失败!" + ex.ToString(); } context.Response.Write(Utils.SerializeObject(jr)); break; case "Update": jr = new JsonResult(); try { sysRole = Utils.AutoWiredClass <SysRole>(request, sysRole = new SysRole()); sysRole.UDate = DateTime.Now; bll.Update(sysRole); jr.Success = true; jr.Msg = "保存成功!"; } catch (Exception ex) { jr.Msg = "保存失败!" + ex.ToString(); } context.Response.Write(Utils.SerializeObject(jr)); break; case "getRoleByID": jr = new JsonResult(); try { roleID = request["RoleID"]; sysRole = bll.GetObjectByID(roleID); jr.Success = true; jr.Obj = sysRole; } catch (Exception ex) { jr.Msg = "系统错误!" + ex.ToString(); } context.Response.Write(Utils.SerializeObject(jr)); break; case "delete": jr = new JsonResult(); try { roleID = request["RoleID"]; bll.Delete(roleID); jr.Success = true; jr.Msg = "删除成功!"; } catch (Exception ex) { jr.Msg = "删除失败!" + ex; } context.Response.Write(Utils.SerializeObject(jr)); break; case "getNoRole": jr = new JsonResult(); try { userID = request["UserID"]; gsr = bll.GetNoRoleList(userID); jr.Success = true; jr.Obj = gsr; } catch (Exception ex) { jr.Msg = ex.ToString(); } context.Response.Write(Utils.SerializeObject(jr)); break; case "getHasRole": jr = new JsonResult(); try { userID = request["UserID"]; gsr = bll.GetHasRoleList(userID); jr.Success = true; jr.Obj = gsr; } catch (Exception ex) { jr.Msg = ex.ToString(); } context.Response.Write(Utils.SerializeObject(jr)); break; } }