partial void OnConvertAdditionalFields(IRole source, RoleDao dest)
{
if (source.Rights != null)
{
dest.Rights = _rightMapper.Convert(source.Rights).ToList();
}
}
public List<string> Handle(ActivityAuth auth)
{
List<string> result = new List<string>();
ISqlMapper mapper = Common.GetMapperFromSession();
UserBLL bll = new UserBLL();
string userid = bll.GetCurrentUser().User.ID;
//string userid = "16";
RoleDao roledao = new RoleDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
string[] roleids = auth.Value.Split(',');
var subroles = roledao.Query(new RoleQueryForm { ParentIDs = roleids.ToList() });
var urs = urdao.Query(new User_RoleQueryForm { UserID = userid });
var roles = subroles.FindAll(t => urs.Exists(p => p.RoleID == t.ID));
if (roles == null || roles.Count == 0)
{
result.Add(userid);
}
else
{
IWorkflowAuthorityHandler handler = new RoleWorkflowAuthorityHandler();
foreach (var role in roles)
{
if (roleids.Any(t => t == role.ParentID))
{
result.AddRange(handler.Handle(new ActivityAuth
{
Value = role.ParentID,
}));
}
}
}
return result;
}
public List <string> Handle(ActivityAuth auth)
{
ISqlMapper mapper = Common.GetMapperFromSession();
RoleDao roledao = new RoleDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
List <string> result = new List <string>();
var role = roledao.Query(new RoleQueryForm {
ID = auth.Value, IsDeleted = 0
}).FirstOrDefault();
if (role != null)
{
var userrole = urdao.Query(new User_RoleQueryForm {
RoleID = role.ID
});
if (userrole != null)
{
foreach (var ur in userrole)
{
if (!result.Contains(ur.UserID))
{
result.Add(ur.UserID);
}
}
}
}
return(result);
}
public ActionResult Create(Role role)
{
if (ModelState.IsValid)
{
var dao = new RoleDao();
var getRole = dao.getByName(role.Name);
//Check if new role exsits
if (getRole != null)
{
ModelState.AddModelError("Name", "Role " + role.Name + " exists in database.");
return(View(role));
}
var entity = new Role();
entity.Id = Guid.NewGuid();
entity.Name = role.Name;
entity.Description = role.Description;
Guid id = dao.create(entity);
if (id != null)
{
ViewBag.CreateRoleSuccessMessage = "Create " + role.Name + " successful";
}
else
{
ViewBag.CreateRoleErrorMessage = "Create " + role.Name + " failed";
}
}
return(View(role));
}
private async void Delete()
{
if (!Global.HasRight("0503"))
{
MessageAlert.Alert("权限不足！");
return;
}
if (SelectedRole == null)
{
MessageAlert.Alert("请选择要删除的记录！");
return;
}
var confirm = await MessageAlert.Confirm("确定删除此记录？");
if (!confirm)
{
return;
}
RoleDao dao = new RoleDao();
var rlt = dao.DeleteRole(SelectedRole.Id);
if (rlt.HasError)
{
MessageAlert.Alert(rlt.Msg);
}
RefreshList(null);
}
public void initAdminClient()
{
ClientDao dao = new ClientDao();
ClientEntity temp = dao.getClientByUsername("admin");
if (temp != null)
{
dao.DeleteClient("admin");
}
ClientEntity client = new ClientEntity();
RoleDao roleDao = new RoleDao();
DepartmentDao departmentDao = new DepartmentDao();
client.Username = "******";
client.Password = "******";
client.RealName = "yangtf";
client.Role = roleDao.getByName("superadmin");
client.Department = departmentDao.getByName("6");
client.encryptPassword();
IList <CatalogEntity> catalogs = new CatalogDao().getAll();
client.Catalogs = catalogs;
dao.save(client);
}
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);
}
public UnitOfWork(IDbConnection connection)
{
_connection = connection;
StoredProcedures = new StoredProcedures(connection);
Brands = new BrandDao(connection);
Carts = new CartDao(connection);
Categories = new CategoryDao(connection);
CategoryProducts = new CategoryProductDao(connection);
ContactInfo = new ContactInfoDao(connection);
Characteristics = new CharacteristicDao(connection);
CharacteristicProducts = new CharacteristicProductDao(connection);
FavouriteProducts = new FavouriteProductDao(connection);
Items = new ItemDao(connection);
OptionalParameters = new OptionalParameterDao(connection);
OptionalParameterProducts = new OptionalParameterProductDao(connection);
Orders = new OrderDao(connection);
OrderDeliveryTypes = new OrderDeliveryTypeDao(connection);
OrderPaymentTypes = new OrderPaymentTypeDao(connection);
OrderProducts = new OrderProductDao(connection);
OrderStatuses = new OrderStatusDao(connection);
Products = new ProductDao(connection);
ProductImages = new ProductImageDao(connection);
Roles = new RoleDao(connection);
SupportMessages = new SupportMessageDao(connection);
Users = new UserDao(connection);
}
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);
}
private void LoadUserLevel()
{
try
{
UserLevelDao dao = new UserLevelDao();
IList <UserLevel> lst = dao.GetList();
foreach (var v in lst)
{
cmbRoleLevel.Items.Add(string.Format("{0}_{1}", v.LevelId, v.LevelName));
}
cmbRoleLevel.SelectedIndex = 0;
RoleDao roleDao = new RoleDao();
IList <Role> roleLst = roleDao.GetList();
foreach (var v in roleLst)
{
cmbRoles.Items.Add(string.Format("{0}_{1}", v.RoleId, v.RoleName));
}
cmbRoles.SelectedIndex = 0;
}
catch (Exception ex)
{
LogHelper.AppLoger.Error(ex);
}
}
public static void downloadRole()
{
String StationID = ManageLOG.getValueFromRegistry(Configurations.AppRegName, "StationID");
int total = 0;
int success = 0;
RoleDao dao = new RoleDao();
List <ModelRole> lists = dao.Select("");
if (lists != null)
{
total = lists.Count;
logger.Debug("# Start download [ROLE] from server.");
foreach (ModelRole model in lists)
{
List <ModelRole> tmp = dao.SelectOffline(" Where role_code='" + model.role_code + "'");
if (tmp != null)
{
if (tmp.Count > 0)
{
}
else
{
if (dao.InsertOffline(model))
{
success++;
}
}
}
}
logger.Debug("# Summary=> Total Download total: " + total + " success: " + success + " fail: " + (total - success));
logger.Debug("# End Download data from server.");
}
}
public UnitOfWork(IDbConnection connection)
{
_connection = connection;
AccountDao = new AccountDao(connection);
BusCoordinateDao = new BusCoordinateDao(connection);
BusDao = new BusDao(connection);
BusDriverDao = new BusDriverDao(connection);
CityDao = new CityDao(connection);
CountryDao = new CountryDao(connection);
DistanceDao = new DistanceDao(connection);
DistrictDao = new DistrictDao(connection);
DriverDao = new DriverDao(connection);
DriverContactDao = new DriverContactDao(connection);
LocationDao = new LocationDao(connection);
LookupsDao = new LookupsDao(connection);
LookupValuesDao = new LookupValuesDao(connection);
RepairSpecialistDao = new RepairSpecialistDao(connection);
RoleDao = new RoleDao(connection);
RouteDao = new RouteDao(connection);
RouteLocationDao = new RouteLocationDao(connection);
TripDao = new TripDao(connection);
TripBusDao = new TripBusDao(connection);
TripBusDriverDao = new TripBusDriverDao(connection);
UserDao = new UserDao(connection);
VehicleDao = new VehicleDao(connection);
ScheduleDao = new ScheduleDao(connection);
ScheduleLocationDao = new ScheduleLocationDao(connection);
StoredProcedureDao = new StoredProcedureDao(connection);
}
public LogonResultForm GetUserInfo(string userid)
{
var mapper = Common.GetMapperFromSession();
UserDao userdao = new UserDao(mapper);
var user = userdao.Query(new UserQueryForm { Name = userid }).FirstOrDefault();
if (user == null) throw new Exception("用户：" + userid + "在系统中不存在！");
if (user.Enabled == 0) throw new Exception("该用户已被禁用，请联系管理员！");
LogonResultForm result = new LogonResultForm();
UserInfoDao userInfoDao = new UserInfoDao(mapper);
RoleDao roleDao = new RoleDao(mapper);
LogonHistoryDao historyDao = new LogonHistoryDao(mapper);
string token = Guid.NewGuid().ToString().Replace("-", "");
var userinfo = userInfoDao.Query(new UserInfoQueryForm { ID = user.ID }).FirstOrDefault();
UserEntireInfo u = new UserEntireInfo { User = user };
if (userinfo != null) u.UserInfo = userinfo;
u.Role = roleDao.QueryRoleByUserID(u.User.ID);
CacheItem item = new CacheItem(token, u);
LogonHistory history = new LogonHistory
{
LogonTime = DateTime.Now,
Token = token,
UserID = user.ID,
ActiveTime = DateTime.Now,
};
historyDao.Add(history);
result.token = token;
result.UserInfo = userinfo;
cache.AddItem(item, 30 * 60);
MenuBLL menubll = new MenuBLL();
result.Menu = menubll.GetCurrentUserMenu(result.token);
return result;
}
private void initRoles()
{
RoleEntity[] roles = createRoles();
RoleDao dao = new RoleDao();
dao.save(roles);
}
partial void OnConvertAdditionalFields(RoleDao source, IRole dest)
{
if (source.Rights != null)
{
dest.Rights = _rightMapper.Convert(source.Rights);
}
}
public string AddRole(AddRoleServiceForm form)
{
Role role = new Role
{
DataAccessType = form.DataAccessType,
Creator = form.Creator,
IsDeleted = 0,
Name = form.Name,
ParentID = form.ParentID,
Remark = form.Remark,
};
//新增角色
ISqlMapper mapper = MapperHelper.GetMapper();
RoleDao dao = new RoleDao(mapper);
Menu_RoleDao mrdao = new Menu_RoleDao(mapper);
#region risk role
string id = dao.Add(role);
AddRoleAuth(mapper, form, id);
#endregion
#region menu
if (form.Menus != null)
{
foreach (var mr in form.Menus)
{
mrdao.Add(new Menu_Role { RoleID = id, MenuID = mr.ID });
}
}
#endregion
return id;
}
public UserleaderWorkflowAuthority()
{
ISqlMapper mapper = Common.GetMapperFromSession();
roledao = new RoleDao(mapper);
urdao = new User_RoleDao(mapper);
}
public JsonResult Create(Role role)
{
try
{
if (ModelState.IsValid)
{
var dao = new RoleDao();
var result = dao.Insert(role);
if (result == 1)
{
SetAlert("Thêm bản ghi thành công!", "success");
return(Json("Saved Successfully!", JsonRequestBehavior.AllowGet));
}
else
{
SetAlert("Không thể thêm bản ghi này!", "error");
return(Json("Not Saved!", JsonRequestBehavior.AllowGet));
}
}
else
{
var errorList = (from item in ModelState
where item.Value.Errors.Any()
select item.Value.Errors[0].ErrorMessage).ToList();
SetAlert("Not Saved!", "error");
return(Json(errorList, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
SetAlert("Không thể thêm bản ghi này!", "error");
var errormessage = "Error occured: " + ex.Message;
return(Json(errormessage, JsonRequestBehavior.AllowGet));
}
}
public RightSetViewModel()
{
//查询角色
RoleDao roleDao = new RoleDao();
var roleRlt = roleDao.GetRoles();
if (roleRlt.HasError)
{
MessageAlert.Alert(roleRlt.Msg);
}
else
{
Roles = roleRlt.Entities;
}
//查询所有权限
RightDao rightDao = new RightDao();
var rightRlt = rightDao.GetRights();
if (rightRlt.HasError)
{
MessageAlert.Alert(rightRlt.Msg);
}
else
{
Rights = rightRlt.Entities;
}
}
public JsonResult Delete(string id)
{
var ckRole = new RoleDao().CheckRoleIsUsed(id);
if (!ckRole)
{
var res = new RoleDao().Delete(id);
if (res)
{
return(Json(new
{
status = true
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new
{
status = false
}, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new
{
status = false,
message = "Role đã được dùng. Vui lòng kiểm tra lại!"
}, JsonRequestBehavior.AllowGet));
}
}
public JsonResult LoadData(int type, string keyword, int pageIndex, int pageSize)
{
string str = NonUnicode.RemoveUnicode(keyword).ToLower();
var model = new RoleDao().ListAll();
switch (type)
{
case 0: model = model.Where(x => NonUnicode.RemoveUnicode(x.Name).ToLower().Contains(str)); break;
case 1: model = model.Where(x => NonUnicode.RemoveUnicode(x.Name).ToLower().Contains(str)); break;
}
int totalRow = model.Count();
model = model.OrderByDescending(x => x.ID)
.Skip((pageIndex - 1) * pageSize)
.Take(pageSize);
int totalRowCurent = model.Count();
return(Json(new
{
data = model,
total = totalRow,
totalCurent = totalRowCurent,
status = true
}, JsonRequestBehavior.AllowGet));
}
public string AddRole(AddRoleServiceForm form)
{
string weixinid = Common.WeiXinDepartmentID;
if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["WeiXinDepartmentID"]))
{
weixinid = ConfigurationManager.AppSettings["WeiXinDepartmentID"];
}
Role role = new Role
{
DataAccessType = form.DataAccessType,
Creator = form.Creator,
IsDeleted = 0,
Name = form.Name,
ParentID = form.ParentID,
Remark = form.Remark,
WeiXinID = weixinid,
};
//新增角色
ISqlMapper mapper = Common.GetMapperFromSession();
RoleDao dao = new RoleDao(mapper);
#region risk role
string id = dao.Add(role);
AddRoleAuth(mapper, form, id);
#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
},
}));
}
/// <summary>
/// This method is called when the model for a derived context has been initialized, but
/// before the model has been locked down and used to initialize the context. The default
/// implementation of this method does nothing, but it can be overridden in a derived class
/// such that the model can be further configured before it is locked down.
/// </summary>
/// <param name="modelBuilder">The builder that defines the model for the context being created.</param>
/// <remarks>
/// Typically, this method is called only once when the first instance of a derived context
/// is created. The model for that context is then cached and is for all further instances of
/// the context in the app domain. This caching can be disabled by setting the ModelCaching
/// property on the given ModelBuidler, but note that this can seriously degrade performance.
/// More control over caching is provided through use of the DbModelBuilder and DbContextFactory
/// classes directly.
/// </remarks>
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
UserDao.CreateTable(modelBuilder);
RoleDao.CreateTable(modelBuilder);
RightDao.CreateTable(modelBuilder);
ResourceDao.CreateTable(modelBuilder);
base.OnModelCreating(modelBuilder);
}
public void GetAllTest()
{
var target = new RoleDao();
ReadOnlyCollection <Role> actual;
actual = target.GetAll();
Assert.AreEqual(2, actual.Count);
}
public void GeByNametTest()
{
var target = new RoleDao();
string id = "role1";
Role actual;
actual = target.GetByName(id);
Assert.AreEqual(id, actual.Name);
}
public void GetRolesTest()
{
var target = new RoleDao();
var roleId = new[] { "role1", "role2" };
ReadOnlyCollection <Role> actual;
actual = target.GetRoles(roleId);
Assert.AreEqual(2, actual.Count);
}
public LoginResultForm Login(string username, string password)
{
LoginResultForm result = new LoginResultForm();
ISqlMapper mapper = MapperHelper.GetMapper();
UserDao userdao = new UserDao(mapper);
UserInfoDao userInfoDao = new UserInfoDao(mapper);
RoleDao roleDao = new RoleDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
LogonHistoryDao historyDao = new LogonHistoryDao(mapper);
MenuDao menudao = new MenuDao(mapper);
Menu_RoleDao mrdao = new Menu_RoleDao(mapper);
var user = userdao.Query(new UserQueryForm { Name = username, Password = password }).FirstOrDefault();
if (user != null)
{
if (user.Enabled == 0) throw new Exception("该用户已被禁用，请联系管理员！");
string token = Guid.NewGuid().ToString().Replace("-", "");
var userinfo = userInfoDao.Query(new UserInfoQueryForm { ID = user.ID }).FirstOrDefault();
var ur = urdao.Query(new User_RoleQueryForm { UserID = user.ID });
List<string> roleidlist = new List<string>();
ur.ForEach(t =>
{
roleidlist.Add(t.RoleID);
});
var roles = roleDao.Query(new RoleQueryForm { IDs = roleidlist });
var mrs = mrdao.Query(new Menu_RoleQueryForm { RoleIDs = roleidlist });
var menuids = (from mr in mrs select mr.MenuID).Distinct().ToList();
result.Menu = menudao.Query(new MenuQueryForm { IDs = menuids, Enabled = 1 });
UserEntireInfo u = new UserEntireInfo
{
User = user,
UserInfo = userinfo,
Role = roles,
};
CacheItem item = new CacheItem(token, u);
LogonHistory history = new LogonHistory
{
LogonTime = DateTime.Now,
Token = token,
UserID = user.ID,
ActiveTime = DateTime.Now,
};
historyDao.Add(history);
result.User = u;
result.token = token;
cache.AddItem(item, 1800);
//MonitorCache.GetInstance().PushMessage(new CacheMessage { Message = "login user:"******",token:" + token }, SOAFramework.Library.CacheEnum.FormMonitor);
return result;
}
else
{
throw new Exception("用户名或者密码错误！请输入正确的用户名和密码！");
}
}
public Role GetRoleByID(int id)
{
var data = new RoleDao().GetRoleById(id);
return(new Role
{
RoleName = data.RoleName
});
}
public FrmEditProfile(FrmMain main, ModelUser user)
{
InitializeComponent();
userDao = new UserDao();
siteDao = new StationDao();
roleDao = new RoleDao();
this.user = user;
this.main = main;
}
public FrmStaff()
{
InitializeComponent();
userDao = new UserDao();
staffDao = new StaffDao();
stationDao = new StationDao();
loungeDao = new LoungeDao();
roleDao = new RoleDao();
areaDao = new AreaDao();
}
public JsonResult GetDetail(string id)
{
var model = new RoleDao().GetDetailById(id);
return(Json(new
{
data = model,
status = true
}, JsonRequestBehavior.AllowGet));
}
public bool DeleteRole(string id)
{
if (string.IsNullOrEmpty(id)) throw new Exception("删除角色时没有ID");
ISqlMapper mapper = MapperHelper.GetMapper();
RoleDao dao = new RoleDao(mapper);
Role_Module_ActionDao rmadao = new Role_Module_ActionDao(mapper);
rmadao.Delete(new Role_Module_ActionQueryForm { RoleID = id });
Role currentrole = dao.Query(new RoleQueryForm { ID = id }).FirstOrDefault();
return dao.Delete(new RoleQueryForm { ID = id });
}
private void Employees_Load(object sender, EventArgs e)
{
var designationDao = new DesignationDao();
var roleDao = new RoleDao();
cmbRoles.DataSource = roleDao.GetAllRoles();
cmbDesignations.DataSource = designationDao.GetAllDesignations();
ShowEmployees();
}
public void TestGetRoles()
{
RoleDao dao = new RoleDao();
IList <RoleEntity> roles = dao.getAllRoles();
foreach (var role in roles)
{
Console.WriteLine(role.Id + "#" + role.RoleName + "#" + role.Description);
}
}
public List<string> GetUserIDList(List<ActivityAuth> auth)
{
var mapper = Common.GetMapperFromSession();
List<string> result = new List<string>();
RoleDao roledao = new RoleDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
UserBLL userbll = new UserBLL();
foreach (var au in auth)
{
IWorkflowAuthorityHandler handler = WorkflowAuthorityFactory.CreateHandler(au.Type.ToLower());
result.AddRange(handler.Handle(au));
}
return result;
}
public List<string> Handle(ActivityAuth auth)
{
ISqlMapper mapper = Common.GetMapperFromSession();
RoleDao roledao = new RoleDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
List<string> result = new List<string>();
var role = roledao.Query(new RoleQueryForm { ID = auth.Value, IsDeleted = 0 }).FirstOrDefault();
if (role != null)
{
var userrole = urdao.Query(new User_RoleQueryForm { RoleID = role.ID });
if (userrole != null)
{
foreach (var ur in userrole)
{
if (!result.Contains(ur.UserID))
{
result.Add(ur.UserID);
}
}
}
}
return result;
}
public string AddRole(AddRoleServiceForm form)
{
string weixinid = Common.WeiXinDepartmentID;
if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["WeiXinDepartmentID"])) weixinid = ConfigurationManager.AppSettings["WeiXinDepartmentID"];
Role role = new Role
{
DataAccessType = form.DataAccessType,
Creator = form.Creator,
IsDeleted = 0,
Name = form.Name,
ParentID = form.ParentID,
Remark = form.Remark,
WeiXinID = weixinid,
};
//新增角色
ISqlMapper mapper = Common.GetMapperFromSession();
RoleDao dao = new RoleDao(mapper);
#region risk role
string id = dao.Add(role);
AddRoleAuth(mapper, form, id);
#endregion
return id;
}
public List<Role> Query(RoleQueryForm form)
{
ISqlMapper mapper = MapperHelper.GetMapper();
RoleDao dao = new RoleDao(mapper);
return dao.Query(form);
}
/// <summary>
/// 查询角色
/// </summary>
/// <param name="form"></param>
/// <returns></returns>
public List<FullRoleInfo> QueryFullRole(RoleQueryForm form)
{
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);
MenuDao menudao = new MenuDao(mapper);
List<FullRoleInfo> result = new List<FullRoleInfo>();
form.IsDeleted = 0;
var roles = dao.Query(form);
var roleids = (from r in roles select r.ID).ToList();
var rmas = rmadao.Query(new Role_Module_ActionQueryForm { RoleIDs = roleids });
var mrs = mrdao.Query(new Menu_RoleQueryForm { RoleIDs = roleids });
var menuids = (from mr in mrs select mr.MenuID).Distinct().ToList();
var menus = menudao.Query(new MenuQueryForm { IDs = menuids, Enabled = 1 });
AuthorityMapping mapping = XMLHelper.DeserializeFromFile<AuthorityMapping>(Common.AuthorityMappingFile);
foreach (var role in roles)
{
var data = role.ConvertTo<FullRoleInfo>();
var parentrole = roles.Find(t => t.ID == role.ParentID);
if (parentrole != null) data.ParentRoleName = parentrole.Name;
#region 查询权限
var role_rmas = rmas.FindAll(t => t.RoleID.Equals(role.ID));
data.Authority = new List<AuthorityNodeForCheck>();
foreach (var auth in mapping.AuthNode)
{
auth.Checked = (from au in auth.Item
from r in role_rmas
where au.ModuleID == r.ModuleID && au.ActionID == r.ActionID
select au).Count() == auth.Item.Count;
data.Authority.Add(new AuthorityNodeForCheck { ID = auth.ID, Checked = auth.Checked, Name = auth.Name });
}
#endregion
#region 查询菜单
data.Menus = (from mr in mrs join m in menus on mr.MenuID equals m.ID where mr.RoleID.Equals(role.ID) select m).ToList();
#endregion
result.Add(data);
}
return result;
}
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 },
});
}
public bool Update(Model.User user, UserInfo ui, List<string> roleidlist)
{
#region risk update
ISqlMapper mapper = Common.GetMapperFromSession();
UserDao udao = new UserDao(mapper);
UserInfoDao uidao = new UserInfoDao(mapper);
if (user != null)
{
Model.User entity = new User
{
ID = user.ID,
Enabled = user.Enabled,
};
udao.Update(new UserUpdateForm { Entity = entity, UserQueryForm = new UserQueryForm { ID = user.ID } });
}
if (ui != null)
{
uidao.Update(new UserInfoUpdateForm { Entity = ui, UserInfoQueryForm = new UserInfoQueryForm { ID = ui.ID } });
}
if (roleidlist != null)
{
User_RoleDao urdao = new User_RoleDao(mapper);
urdao.Delete(new User_RoleQueryForm { UserID = user.ID });
foreach (var role in roleidlist)
{
User_Role ur = new User_Role { RoleID = role, UserID = user.ID };
urdao.Add(ur);
}
}
#endregion
#region weixin api
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();
var user_temp = udao.Query(new UserQueryForm { ID = user.ID }).FirstOrDefault();
var ui_temp = uidao.Query(new UserInfoQueryForm { ID = user.ID }).FirstOrDefault();
try
{
SOAFramework.Library.WeiXin.WeiXinApi.User.Update(new SOAFramework.Library.WeiXin.User
{
department = weixinids,
mobile = ui_temp.Mobile,
name = ui_temp.CnName,
weixinid = ui_temp.WX,
userid = user_temp.Name,
enable = 1,
});
}
catch (SOAFramework.Library.WeiXin.WeiXinException ex)
{
switch (ex.Code)
{
case "60111"://如果微信上不存在用户，就新建
SOAFramework.Library.WeiXin.WeiXinApi.User.Create(new SOAFramework.Library.WeiXin.User
{
enable = 1,
userid = user_temp.Name,
name = ui_temp.CnName,
mobile = ui_temp.Mobile,
weixinid = ui_temp.WX,
department = weixinids,
});
break;
default:
throw ex;
}
}
#endregion
return true;
}
public List<FullUser> Query(FullUserQueryForm form)
{
ISqlMapper mapper = MapperHelper.GetMapper();
UserDao dao = new UserDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
RoleDao roledao = new RoleDao(mapper);
var users = dao.QueryFullUser(form);
var userids = (from u in users select u.ID).ToList();
var urs = urdao.Query(new User_RoleQueryForm { UserIDs = userids });
var roleids = (from ur in urs select ur.RoleID).Distinct().ToList();
var roles = roledao.Query(new RoleQueryForm { IDs = roleids });
foreach (var u in users)
{
u.Roles = (from ur in urs join role in roles on ur.RoleID equals role.ID
where ur.UserID.Equals(u.ID) select role).ToList();
}
return users;
}
/// <summary>
/// 查询所有用户
/// </summary>
/// <returns></returns>
public List<FullUser> Query(FullUserQueryForm form)
{
ISqlMapper mapper = Common.GetMapperFromSession();
FullUserDao dao = new FullUserDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
RoleDao roledao = new RoleDao(mapper);
var userlist = dao.Query(form);
var userids = (from u in userlist select u.ID).ToList();
var urs = urdao.Query(new User_RoleQueryForm { UserIDs = userids });
var roleids = (from ur in urs select ur.RoleID).Distinct().ToList();
var roles = roledao.Query(new RoleQueryForm { IDs = roleids });
foreach (var u in userlist)
{
var ur_temp = urs.FindAll(t => t.UserID == u.ID);
var rolelist = (from ur in ur_temp join r in roles on ur.RoleID equals r.ID select r).ToList();
u.RoleList = rolelist;
}
return userlist;
}
public UserRoleService()
{
RoleDao = new RoleDao(context);
UserDao = new UserDao(context);
}
public void IsUsersInRoleTest()
{
var target = new RoleDao();
string roleName = "role1";
bool expected = true;
bool actual;
actual = target.IsUsesInRole(roleName);
Assert.AreEqual(expected, actual);
roleName = "no_exist_role";
expected = false;
actual = target.IsUsesInRole(roleName);
Assert.AreEqual(expected, actual);
}
public UserEntireInfo GetCurrentUser(string token = null)
{
ISqlMapper mapper = MapperHelper.GetMapper();
if (string.IsNullOrEmpty(token)) token = ServiceSession.Current.Context.Parameters["token"].ToString();
var u = GetUserEntireInfoFromCache(token);
if (u == null)
{
MonitorCache.GetInstance().PushMessage(new CacheMessage { Message = "user is null" }, SOAFramework.Library.CacheEnum.FormMonitor);
UserDao userdao = new UserDao(mapper);
RoleDao roledao = new RoleDao(mapper);
UserInfoDao uidao = new UserInfoDao(mapper);
LogonHistoryDao lhdao = new LogonHistoryDao(mapper);
var logonhistory = lhdao.Query(new LogonHistoryQueryForm { Token = token }).FirstOrDefault();
if (logonhistory == null) throw new Exception("获取当前用户信息时发生错误，用户不存在");
string userid = logonhistory.UserID;
var user = userdao.Query(new UserQueryForm { ID = userid }).FirstOrDefault();
var userinfo = uidao.Query(new UserInfoQueryForm { ID = userid }).FirstOrDefault();
var roles = roledao.QueryRoleByUserID(userid);
u = new UserEntireInfo
{
User = user,
Role = roles,
UserInfo = userinfo,
};
}
return u;
}
public void GetAllTest()
{
var target = new RoleDao();
ReadOnlyCollection<Role> actual;
actual = target.GetAll();
Assert.AreEqual(2, actual.Count);
}
public RoleViewProxy()
{
RoleDao = new RoleDao(context);
PermissionDao = new PermissionDao(context);
}
/// <summary>
/// Initializes a new instance of the RoleSvc class by creating a object of RoleDao class.
/// </summary>
public RoleSvc()
{
this.roleDao = new RoleDao();
}
/// <summary>
/// 获得用户角色子级下的所有用户
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public List<string> GetUserSubUserIDs(string userid)
{
UserBLL userbll = new UserBLL();
ISqlMapper mapper = MapperHelper.GetMapper();
User_RoleDao urdao = new User_RoleDao(mapper);
RoleDao roledao = new RoleDao(mapper);
var urs = urdao.Query(new User_RoleQueryForm { UserID = userid });
List<string> useridlist = new List<string>();
//检查用户的角色有没有全数据权限
var roles = roledao.QueryRoleByUserID(userid);
foreach (var role in roles)
{
if (role.DataAccessType == (int)DataAccesssEnum.All) return null;
}
useridlist.Add(userid);
List<Role> list = new List<Role>();
foreach (var ur in urs)
{
list.AddRange(GetAllSubRoles(ur.RoleID));
}
var roleids = (from r in list select r.ID).ToList();
if (roleids.Count == 0) return useridlist;
var users = urdao.Query(new User_RoleQueryForm { RoleIDs = roleids });
useridlist.AddRange((from u in users select u.UserID).ToList());
return useridlist;
}
public void FindAllTest()
{
var target = new RoleDao();
int startRow = 0;
int pageSize = 1;
IList<Role> actual;
actual = target.FindAll(startRow, pageSize);
Assert.AreEqual(1, actual.Count);
}
public void GetRolesTest()
{
var target = new RoleDao();
var roleId = new[] { "role1", "role2" };
ReadOnlyCollection<Role> actual;
actual = target.GetRoles(roleId);
Assert.AreEqual(2, actual.Count);
}
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 UserleaderWorkflowAuthority()
{
ISqlMapper mapper = Common.GetMapperFromSession();
roledao = new RoleDao(mapper);
urdao = new User_RoleDao(mapper);
}
public RoleViewService()
{
RoleDao = new RoleDao(context);
PermissionDao = new PermissionDao(context);
}
public void GeByNametTest()
{
var target = new RoleDao();
string id = "role1";
Role actual;
actual = target.GetByName(id);
Assert.AreEqual(id, actual.Name);
}
