public void TestList() { UserDao userDao = new UserDao(connectionString); RoleDao roleDao = new RoleDao(connectionString); Role role = TestHelper.CreateRole(); int isSave = roleDao.Save(role); Assert.IsTrue(isSave > 0); User user1 = TestHelper.CreateUser(); User user2 = TestHelper.CreateUser(); role.Users = new List <User>(); role.Users.Add(user1); role.Users.Add(user2); isSave = roleDao.Update(role); Assert.IsTrue(isSave > 0); IList <User> list = userDao.List(role.Id); Assert.AreEqual(2, list.Count); int isDelete = roleDao.Delete(role.Id); Assert.IsTrue(isDelete > 0); list = userDao.List(role.Id); Assert.AreEqual(0, list.Count); }
public string Edit(Role role) { string msg = "Done"; try { if (ModelState.IsValid) { var dao = new RoleDao(); var result = dao.Update(role); if (result == 1) { SetAlert("Thêm bản ghi thành công!", "success"); msg = "Saved Successfully"; } else { msg = "Some Validation "; SetAlert("Không thể thêm bản ghi này!", "error"); } } } catch (Exception ex) { msg = "Error occured:" + ex.Message; SetAlert("Không thể thêm bản ghi này!", "error"); } return(msg); }
private void B_ADD_Click(object sender, EventArgs e) { if (isValidInputData()) { ModelRole model = new ModelRole(); model.id = this.id; model.role_code = role_code.Text; model.role_name = role_name.Text; Boolean result = false; switch (B_ADD.Text) { case "บันทึก": result = roleDao.Insert(model); if (result) { MessageBox.Show("บันทึกข้อมูลเรียบร้อยแล้ว"); } break; case "แก้ไข": result = roleDao.Update(model); if (result) { MessageBox.Show("แก้ไขข้อมูลเรียบร้อยแล้ว"); } break; } if (result) { refresh(); } } }
public bool UpdateRole(AddRoleServiceForm form) { if (string.IsNullOrEmpty(form.ID)) { throw new Exception("更新角色时没有ID"); } ISqlMapper mapper = Common.GetMapperFromSession(); RoleDao dao = new RoleDao(mapper); Role_Module_ActionDao rmadao = new Role_Module_ActionDao(mapper); rmadao.Delete(new Role_Module_ActionQueryForm { RoleID = form.ID }); AddRoleAuth(mapper, form, form.ID); return(dao.Update(new RoleUpdateForm { Entity = new Role { LastUpdator = form.LastUpdator, Name = form.Name, ParentID = form.ParentID, Remark = form.Remark, DataAccessType = form.DataAccessType, }, RoleQueryForm = new RoleQueryForm { ID = form.ID }, })); }
public ActionResult Edit(tb_Roles entity) { if (ModelState.IsValid) { Dao.Update(entity); } return(View(entity)); }
public void Update() { const int id = 1; const string name = "test"; var model = RoleDao.Get(id); model.Name = name; var result = RoleDao.Update(model); Assert.AreEqual(1, result); }
public bool Update([FromBody] Role model) { try { return(_roleDao.Update(model)); } catch (Exception ex) { nlog.Error(ex, "更新角色失败!", model.ToJSON()); return(false); } }
/// <summary> /// 更新角色 /// </summary> /// <param name="role"></param> /// <returns></returns> public Result Update(Role role) { int row = roleDao.Update(role); if (row > 0) { return(Result.更新成功); } else { return(Result.更新失败); } }
public void TestCURD() { Role role = TestHelper.CreateRole(); RoleDao roleDao = new RoleDao(connectionString); int isSave = roleDao.Save(role); Assert.IsTrue(isSave > 0); role.Name = "hello"; int isUpdate = roleDao.Update(role); Assert.IsTrue(isUpdate > 0); int isDelete = roleDao.Delete(role.Id); Assert.IsTrue(isDelete > 0); }
public void TestAddUser() { UserDao userDao = new UserDao(connectionString); RoleDao roleDao = new RoleDao(connectionString); User user = TestHelper.CreateUser(); Role role = TestHelper.CreateRole(); role.Users = new List <User>(); role.Users.Add(user); int isSave = roleDao.Save(role); Assert.IsTrue(isSave > 0); user = TestHelper.CreateUser(); role.Users.Add(user); isSave = roleDao.Update(role); Assert.IsTrue(isSave > 0); }
public string Add(Model.User user, UserInfo ui, List <string> roleidlist) { #region risk user ISqlMapper mapper = Common.GetMapperFromSession(); if (user == null) { throw new Exception("user不能为null!"); } UserDao dao = new UserDao(mapper); var exist = dao.Query(new UserQueryForm { Name = user.Name }); if (exist.Count > 0) { throw new Exception("已存在用户名:" + user.Name); } if (string.IsNullOrEmpty(ui.WX) && string.IsNullOrEmpty(ui.Mobile)) { throw new Exception("微信号或者手机不能为空"); } string id = dao.Add(user); if (ui == null) { ui = new UserInfo(); } UserInfoDao infodao = new UserInfoDao(mapper); ui.ID = id; infodao.Add(ui); if (roleidlist == null) { return(id); } User_RoleDao urdao = new User_RoleDao(mapper); foreach (var role in roleidlist) { User_Role ur = new User_Role { RoleID = role, UserID = user.ID }; urdao.Add(ur); } #endregion #region weixin user RoleDao roledao = new RoleDao(mapper); var roles = roledao.Query(new RoleQueryForm { IDs = roleidlist }); var weixinids = (from r in roles where !string.IsNullOrEmpty(r.WeiXinID) select Convert.ToInt32(r.WeiXinID)).ToArray(); try { SOAFramework.Library.WeiXin.WeiXinApi.User.Create(new SOAFramework.Library.WeiXin.User { department = weixinids, enable = 1, mobile = ui.Mobile, name = ui.CnName, weixinid = ui.WX, userid = user.Name, }); } catch (SOAFramework.Library.WeiXin.WeiXinException ex) { switch (ex.Code) { case "60004": case "60003": foreach (var role in roles) { //部门不存在就新建部门 Role parentrole = null; if (!string.IsNullOrEmpty(role.ParentID)) { roledao.Query(new RoleQueryForm { ID = role.ParentID }).FirstOrDefault(); } var department = new SOAFramework.Library.WeiXin.Department { name = role.Name, }; if (parentrole != null) { department.parentid = parentrole.WeiXinID; } var response = SOAFramework.Library.WeiXin.WeiXinApi.Department.Create(department); roledao.Update(new RoleUpdateForm { Entity = new Role { WeiXinID = response.id }, RoleQueryForm = new RoleQueryForm { ID = role.ID }, }); } SOAFramework.Library.WeiXin.WeiXinApi.User.Create(new SOAFramework.Library.WeiXin.User { department = weixinids, enable = 1, mobile = ui.Mobile, name = ui.CnName, weixinid = ui.WX, userid = user.Name, }); break; case "60102": //用户已存在 SOAFramework.Library.WeiXin.WeiXinApi.User.Update(new SOAFramework.Library.WeiXin.User { department = weixinids, mobile = ui.Mobile, name = ui.CnName, weixinid = ui.WX, userid = user.Name, }); break; default: throw ex; } } #endregion return(id); }
public bool UpdateRole(AddRoleServiceForm form) { if (string.IsNullOrEmpty(form.ID)) throw new Exception("更新角色时没有ID"); ISqlMapper mapper = MapperHelper.GetMapper(); RoleDao dao = new RoleDao(mapper); Role_Module_ActionDao rmadao = new Role_Module_ActionDao(mapper); Menu_RoleDao mrdao = new Menu_RoleDao(mapper); rmadao.Delete(new Role_Module_ActionQueryForm { RoleID = form.ID }); AddRoleAuth(mapper, form, form.ID); mrdao.Delete(new Menu_RoleQueryForm { RoleID = form.ID }); if (form.Menus != null) { foreach (var menu in form.Menus) { mrdao.Add(new Menu_Role { RoleID = form.ID, MenuID = menu.ID }); } } return dao.Update(new RoleUpdateForm { Entity = new Role { LastUpdator = form.LastUpdator, Name = form.Name, ParentID = form.ParentID, Remark = form.Remark, DataAccessType = form.DataAccessType, }, RoleQueryForm = new RoleQueryForm { ID = form.ID }, }); }
/// <summary> /// Update Role /// </summary> /// <param name="objRole"></param> public static void UpdateRole(Role objRole) { RoleDao.Update(objRole); }
public bool UpdateRole(Role role) { return(RoleDao.Update(role)); }
public string Add(Model.User user, UserInfo ui, List<string> roleidlist) { #region risk user ISqlMapper mapper = Common.GetMapperFromSession(); if (user == null) { throw new Exception("user不能为null!"); } UserDao dao = new UserDao(mapper); var exist = dao.Query(new UserQueryForm { Name = user.Name }); if (exist.Count > 0) throw new Exception("已存在用户名:" + user.Name); if (string.IsNullOrEmpty(ui.WX) && string.IsNullOrEmpty(ui.Mobile)) throw new Exception("微信号或者手机不能为空"); string id = dao.Add(user); if (ui == null) { ui = new UserInfo(); } UserInfoDao infodao = new UserInfoDao(mapper); ui.ID = id; infodao.Add(ui); if (roleidlist == null) return id; User_RoleDao urdao = new User_RoleDao(mapper); foreach (var role in roleidlist) { User_Role ur = new User_Role { RoleID = role, UserID = user.ID }; urdao.Add(ur); } #endregion #region weixin user RoleDao roledao = new RoleDao(mapper); var roles = roledao.Query(new RoleQueryForm { IDs = roleidlist }); var weixinids = (from r in roles where !string.IsNullOrEmpty(r.WeiXinID) select Convert.ToInt32(r.WeiXinID)).ToArray(); try { SOAFramework.Library.WeiXin.WeiXinApi.User.Create(new SOAFramework.Library.WeiXin.User { department = weixinids, enable = 1, mobile = ui.Mobile, name = ui.CnName, weixinid = ui.WX, userid = user.Name, }); } catch (SOAFramework.Library.WeiXin.WeiXinException ex) { switch (ex.Code) { case "60004": case "60003": foreach (var role in roles) { //部门不存在就新建部门 Role parentrole = null; if (!string.IsNullOrEmpty(role.ParentID)) roledao.Query(new RoleQueryForm { ID = role.ParentID }).FirstOrDefault(); var department = new SOAFramework.Library.WeiXin.Department { name = role.Name, }; if (parentrole != null) department.parentid = parentrole.WeiXinID; var response = SOAFramework.Library.WeiXin.WeiXinApi.Department.Create(department); roledao.Update(new RoleUpdateForm { Entity = new Role { WeiXinID = response.id }, RoleQueryForm = new RoleQueryForm { ID = role.ID }, }); } SOAFramework.Library.WeiXin.WeiXinApi.User.Create(new SOAFramework.Library.WeiXin.User { department = weixinids, enable = 1, mobile = ui.Mobile, name = ui.CnName, weixinid = ui.WX, userid = user.Name, }); break; case "60102"://用户已存在 SOAFramework.Library.WeiXin.WeiXinApi.User.Update(new SOAFramework.Library.WeiXin.User { department = weixinids, mobile = ui.Mobile, name = ui.CnName, weixinid = ui.WX, userid = user.Name, }); break; default: throw ex; } } #endregion return id; }
public bool UpdateRole(AddRoleServiceForm form) { if (string.IsNullOrEmpty(form.ID)) { throw new Exception("更新角色时没有ID"); } ISqlMapper mapper = Common.GetMapperFromSession(); RoleDao dao = new RoleDao(mapper); Role_Module_ActionDao rmadao = new Role_Module_ActionDao(mapper); rmadao.Delete(new Role_Module_ActionQueryForm { RoleID = form.ID }); AddRoleAuth(mapper, form, form.ID); return dao.Update(new RoleUpdateForm { Entity = new Role { LastUpdator = form.LastUpdator, Name = form.Name, ParentID = form.ParentID, Remark = form.Remark, DataAccessType = form.DataAccessType, }, RoleQueryForm = new RoleQueryForm { ID = form.ID }, }); }
public bool Update(RoleObject ob) { return(ModelRole.Update(ob)); }