public RoleModule() : base("Role") { this.RequiresAuthentication(); Get["RoleManage"] = _ => ValidPermission("RoleManage") ? View["RoleManage", RoleBll.GetData()] : View["NoPermissions"]; Post["QueryRole"] = p => { string name = Request.Form["RoleName"]; var roleList = RoleBll.RoleLikeQuery(name); return(View["RoleManage", roleList]); }; Post["CheckRoleName/{Name}"] = p => RoleBll.GetDataByName(p.Name) != null; Get["RoleAdd"] = _ => ValidPermission("RoleAdd") ? View["RoleAdd"] : View["NoPermissions"]; Post["RoleAdd"] = p => { var roleModel = new RoleModel { Name = Request.Form["RoleName"].ToString(), CreateTime = DateTime.Now.ToString(), CreateUer = Context.CurrentUser.UserName, Permission = $"{Request.Form["Node"]},{Request.Form["group"]}", Status = Request.Form["Status"].ToString(), ManageHospital = string.IsNullOrEmpty(Request.Form["HospitalText"]) ? ConstFile.ALL : Request.Form["HospitalText"].ToString() }; RoleBll.Insert(roleModel); return(Response.AsRedirect("RoleManage")); }; Get["RoleEdit/{Name}"] = p => { var model = RoleBll.GetDataByName(p.Name); return(this.ValidPermission("RoleEdit") ? View["RoleEdit", model] : View["NoPermissions"]); }; Post["RoleEdit"] = _ => { var roleModel = new RoleModel { Name = Request.Form["Name"].ToString(), CreateTime = DateTime.Now.ToString(), CreateUer = Context.CurrentUser.UserName, Permission = $"{Request.Form["Node"]},{Request.Form["group"]}", Status = Request.Form["Status"].ToString(), ManageHospital = string.IsNullOrEmpty(Request.Form["HospitalText"]) ? ConstFile.ALL : Request.Form["HospitalText"].ToString() }; RoleBll.Update(roleModel); return(Response.AsRedirect("RoleManage")); }; Post["RoleDelete/{Name}"] = p => { return(RoleBll.Delete(p.Name)); }; Get["GetRolesToJson"] = _ => { return(Response.AsJson(RoleBll.GetBuiCheckBoxJson())); }; }
protected override CommandResult AddItem(object item) { RoleInfo info = item as RoleInfo; CommandResult reuslt = bll.Insert(info); if (reuslt.Result == ResultCode.Successful && DataBaseConnectionsManager.Current.StandbyConnected) { RoleBll srbll = new RoleBll(AppSettings.CurrentSetting.CurrentStandbyConnect); srbll.UpdateOrInsert(info); } return(reuslt); }
/// <summary> /// 添加 /// </summary> protected void insert() { string value = "", values = "", sqlText = ""; string roleName = Request["roleName"]; int row = roleBll.selectByroleName(roleName); if (row == 0) { role.RoleName = roleName; Result insert = roleBll.Insert(role); if (insert == Result.添加成功) { int roleIds = roleBll.selectByroleName(roleName); string funIds = Request["functionId"]; string func = funIds.Substring(0, funIds.Length - 1); string[] functions = func.Split('?'); role.RoleName = roleName; for (int i = 0; i < functions.Length; i++) { int functionId = Convert.ToInt32(functions[i]); value = "(" + roleIds + "," + functionId + "),"; values = values + value; } sqlText = values.Substring(0, values.Length - 1); Result inserts = roleBll.InsertPer(sqlText, roleIds, "添加"); if (inserts == Result.添加失败) { Response.Write("添加失败"); Response.End(); } else { Response.Write("添加成功"); Response.End(); } } else { Response.Write("添加失败"); Response.End(); } } else { Response.Write("该职位名已存在,请您输入新的职位名"); Response.End(); } }
/// <summary> /// 角色菜单首页 /// </summary> /// <returns></returns> public ActionResult RoleMenu() { #region 角色列表 var roleList = new RoleBll().GetList(); roleList.Insert(0, new SysRole() { Name = "请选择", RoleId = "0" }); var dropList = new SelectList(roleList, "RoleId", "Name"); ViewBag.dropList = dropList; #endregion #region 菜单列表 var list = menuBll.GetMenuByPid("0"); #endregion return(View(list)); }
public ActionResult AddRole(SysRole role) { //TODO role.CreateAt = DateTime.Now; role.CreateBy = "Dong"; role.RoleId = Guid.NewGuid().ToString(); var i = roleBll.Insert(role); return(Json(1 == i ? new RetJson() { Code = 200, Flag = true, Msg = "操作成功" } : new RetJson() { Code = 200, Flag = false, Msg = "操作失败" })); }
private bool SyncRoles() { NotifyMsg(string.Format("{0}{1}......", Resources.Resource1.FrmSyncDataToStandby_Synchronizing, Resources.Resource1.FrmSyncDataToStandby_Role)); NotifyProgress(100, 0); bool success = true; CommandResult result = null; RoleBll masterbll = new RoleBll(AppSettings.CurrentSetting.CurrentMasterConnect); RoleBll standbybll = new RoleBll(AppSettings.CurrentSetting.CurrentStandbyConnect); QueryResultList <RoleInfo> infos = masterbll.GetAllRoles(); success = infos.Result == ResultCode.Successful; if (success) { success = standbybll.DeleteAllRoles().Result == ResultCode.Successful; if (success) { NotifyProgress(infos.QueryObjects.Count, 0); foreach (RoleInfo info in infos.QueryObjects) { result = standbybll.Insert(info); success = result.Result == ResultCode.Successful; NotifyProgress(null, null); if (!success) { break; } } } } if (!success) { NotifyMsg(string.Format("{0}{1}", Resources.Resource1.FrmSyncDataToStandby_Role, Resources.Resource1.Form_Fail), Color.Red); } else { NotifyMsg(string.Format("{0}{1}", Resources.Resource1.FrmSyncDataToStandby_Role, Resources.Resource1.Form_Success)); } return(success); }
protected void Button1_Click(object sender, EventArgs e) { RegionBll regionBll = new RegionBll(); UserBll userBll = new UserBll(); RoleBll roleBll = new RoleBll(); RSACryptoService rsa = new RSACryptoService(); string roleName = "微信零售"; int row = roleBll.selectByroleName(roleName); int roleId = 0; if (row <= 0) { Role role = new Role(); role.RoleName = roleName; Result insert = roleBll.Insert(role); if (insert == Result.添加成功) { roleId = roleBll.selectByroleName(roleName); string sqlText = "(" + roleId + "," + 14 + ")"; Result inserts = roleBll.InsertPer(sqlText, roleId, "添加"); if (inserts == Result.添加失败) { Response.Write("添加失败"); Response.End(); } } } else { roleId = row; } DataSet ds = regionBll.select(); int count = ds.Tables[0].Rows.Count; if (count > 0 && ds != null) { for (int i = 0; i < count; i++) { string regionId = ds.Tables[0].Rows[i]["regionId"].ToString(); string regionName = ds.Tables[0].Rows[i]["regionName"].ToString(); Region region = new Region(); region.RegionId = Convert.ToInt32(regionId); Role role = new Role(); role.RoleId = roleId; User user = new User(); user.UserId = regionId + "01"; user.UserName = regionName + "微信零售"; user.ReginId = region; user.Pwd = rsa.Encrypt("000000"); user.RoleId = role; Result rows = userBll.Insert(user); if (rows == Result.添加失败) { Response.Write("添加失败:" + regionId); } } Response.Write("添加成功"); } else { Response.Write("未查到任何组织信息"); } }
public void Insert() { int roleId = 0; string roleName = "微信零售"; int row = roleBll.selectByroleName(roleName); if (row == 0) { Role role = new Role(); role.RoleName = roleName; Result insert = roleBll.Insert(role); if (insert == Result.添加成功) { roleId = roleBll.selectByroleName(roleName); string sqlText = "(" + roleId + "," + 14 + ")"; Result inserts = roleBll.InsertPer(sqlText, roleId, "添加"); if (inserts == Result.添加失败) { Response.Write("添加失败"); Response.End(); } } } else { roleId = row; } string reName = Request["name"]; Result result = regionBll.isExit(reName); if (result == Result.记录不存在) { Result rsInsert = regionBll.insert(reName); if (rsInsert == Result.添加成功) { int regionId = regionBll.getRegionIdByName(reName); Region region = new Region(); region.RegionId = Convert.ToInt32(regionId); Role userRole = new Role(); userRole.RoleId = roleId; User user = new User(); user.UserId = regionId + "01"; user.UserName = reName + "微信零售"; user.Pwd = rsa.Encrypt("000000"); user.ReginId = region; user.RoleId = userRole; Result rows = userBll.Insert(user); if (rows == Result.记录存在) { Response.Write("添加失败"); Response.End(); } else if (rows == Result.添加失败) { Response.Write("添加失败"); Response.End(); } else { Response.Write("添加成功"); Response.End(); } } else { Response.Write("添加失败"); Response.End(); } } else { Response.Write("该组织已经存在"); Response.End(); } }
protected override CommandResult AddItem(object item) { return(bll.Insert((RoleInfo)item)); }