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));
}
