public ExcuteResultEnum AddNewBcUserInfo(BcUserInfoEntity entity, string roleIds = null) { if ( EntityExecution.Count <BcUserInfoEntity>( n => n.UserAccount == entity.UserAccount && n.DeleteFlag == false) > 0) { return(ExcuteResultEnum.IsExist); } using (TransactionScope ts = new TransactionScope()) { entity.UserId = null; entity.DeleteFlag = false; entity.Password = Encryption.Encrypt(entity.Password); var id = EntityExecution.InsertWithIdentity(entity); if (!string.IsNullOrEmpty(roleIds)) { foreach (string roleId in roleIds.Split(',')) { var userRoleEntity = new BcUserRoleEntity { UserId = (int?)id, RoleId = int.Parse(roleId) }; EntityExecution.Insert(userRoleEntity); } } ts.Complete(); } return(ExcuteResultEnum.Success); }
public async Task <long> PromoteStagedDataAsync(EntityExecution entityExecution, Entity entity, DataMart dataMart, CancellationToken cancellationToken) { // no op: Databus takes care of this await Task.CompletedTask; return(Convert.ToInt64(0)); }
private List <SysEnumNameEntity> SetSysEnumNameListCache() { var list = EntityExecution.SelectAll <SysEnumNameEntity>(); DataCache.SetCache(CacheKey, list); return(list); }
public List <SysMenuEntity> GetSysMenuListByFatherNode(int fatherNode = 0) { List <SysMenuEntity> list = EntityExecution.SelectAll <SysMenuEntity>(n => n.DeleteFlag == false && n.FatherNode == fatherNode); list = list.OrderBy(n => n.Seq).ToList(); return(list); }
public ExcuteResultEnum AddNewBcUserRole(BcUserRoleEntity entity) { if (EntityExecution.Count <BcUserRoleEntity>(n => n.RoleId == entity.RoleId && n.UserId == entity.UserId) > 0) { return(ExcuteResultEnum.IsExist); } entity.Insert(); return(ExcuteResultEnum.Success); }
public void DeleteBcUserRole(int userId, int roleId) { BcUserRoleEntity entity = new BcUserRoleEntity() { UserId = userId, RoleId = roleId }; EntityExecution.Delete(entity); }
public void DeleteBcLogError(int id) { BcLogErrorEntity entity = new BcLogErrorEntity() { Id = id }; EntityExecution.Delete(entity); }
public void DeleteBcAutoCode(int id) { BcAutoCodeEntity entity = new BcAutoCodeEntity() { Id = id }; EntityExecution.Delete(entity); }
public BcUserInfoEntity GetSingleBcUserInfo(int userId) { var entity = EntityExecution.SelectOne <BcUserInfoEntity>(n => n.UserId == userId); if (entity != null) { entity.Password = Encryption.Decrypt(entity.Password); } return(entity); }
public void DeleteSysPageFuncPoint(string pageUrl) { SysPageFuncPointEntity entity = new SysPageFuncPointEntity() { PageUrl = pageUrl }; EntityExecution.Delete(entity); SetSysPageFuncPointListCache(); }
public void DeleteSysEnumName(string type, string value) { SysEnumNameEntity entity = new SysEnumNameEntity() { Type = type, Value = value }; EntityExecution.Delete(entity); SetSysEnumNameListCache(); }
public void DeleteBcPermission(int permissionId, int permissionType, string moduleId, string funcPointId) { var entity = new BcPermissionEntity(); entity.UserRoleId = permissionId; entity.PermissionType = permissionType; entity.ModuleId = moduleId; entity.FuncPointId = funcPointId; EntityExecution.Delete(entity); }
public void DeleteSysRelation(string moduleId, string funcPointId) { SysRelationEntity entity = new SysRelationEntity() { ModuleId = moduleId, FuncPointId = funcPointId }; EntityExecution.Delete(entity); SetSysRelationListCache(); }
public EmployeeEntity GetEmployeeEntity(string id) { var entity = EntityExecution.SelectOne <EmployeeEntity>(n => n.EMPLOYEE_ID == id); var restaurantEntity = new RestaurantBiz().GetRestaurantEntity(entity.RESTAURANT_ID); if (restaurantEntity != null) { entity.RESTAURANT_NAME = restaurantEntity.RESTAURANT_NAME; } return(entity); }
public List <FoodEntity> GetFoodEntityList(FoodEntity condition_entity) { GenericWhereEntity <FoodEntity> where_entity = new GenericWhereEntity <FoodEntity>(); if (condition_entity.FOOD_ID != null) { where_entity.Where(n => (n.FOOD_ID == condition_entity.FOOD_ID)); } if (condition_entity.RESTAURANT_ID != null) { where_entity.Where(n => (n.RESTAURANT_ID == condition_entity.RESTAURANT_ID)); } return(EntityExecution.SelectAll(where_entity)); }
public List <FoodTypeEntity> GetFoodTypeEntityList(FoodTypeEntity condition_entity) { GenericWhereEntity <FoodTypeEntity> where_entity = new GenericWhereEntity <FoodTypeEntity>(); if (condition_entity.FOOD_TYPE_ID != null) { where_entity.Where(n => (n.FOOD_TYPE_ID == condition_entity.FOOD_TYPE_ID)); } if (condition_entity.FOOD_TYPE_NAME != null) { where_entity.Where(n => (n.FOOD_TYPE_NAME == condition_entity.FOOD_TYPE_NAME)); } return(EntityExecution.SelectAll(where_entity)); }
public List <EmployeeEntity> GetEmployeeEntityList(EmployeeEntity condition_entity) { GenericWhereEntity <EmployeeEntity> where_entity = new GenericWhereEntity <EmployeeEntity>(); if (condition_entity.EMPLOYEE_ID != null) { where_entity.Where(n => (n.EMPLOYEE_ID == condition_entity.EMPLOYEE_ID)); } if (!string.IsNullOrEmpty(condition_entity.PASSWORD)) { where_entity.Where(n => (n.PASSWORD == condition_entity.PASSWORD)); } return(EntityExecution.SelectAll(where_entity)); }
public List <RestaurantEntity> GetRestaurantEntityList(RestaurantEntity condition_entity) { GenericWhereEntity <RestaurantEntity> where_entity = new GenericWhereEntity <RestaurantEntity>(); if (condition_entity.RESTAURANT_ID != null) { where_entity.Where(n => (n.RESTAURANT_ID == condition_entity.RESTAURANT_ID)); } if (condition_entity.RESTAURANT_NAME != null) { where_entity.Where(n => (n.RESTAURANT_NAME == condition_entity.RESTAURANT_NAME)); } return(EntityExecution.SelectAll(where_entity)); }
public ExcuteResultEnum DeleteBcGroup(int groupId) { if (EntityExecution.Count <BcUserInfoEntity>(n => n.GroupId == groupId && n.DeleteFlag == false) > 0) { return(ExcuteResultEnum.IsOccupied); } BcGroupEntity entity = new BcGroupEntity() { GroupId = groupId }; EntityExecution.Delete(entity); return(ExcuteResultEnum.Success); }
public ExcuteResultEnum DeleteBcRole(int roleId) { if (EntityExecution.Count <BcUserRoleEntity>(n => n.RoleId == roleId) > 0) { return(ExcuteResultEnum.IsOccupied); } BcRoleEntity entity = new BcRoleEntity() { RoleId = roleId }; EntityExecution.Delete(entity); return(ExcuteResultEnum.Success); }
public ExcuteResultEnum DeleteBcUserInfo(int userId) { if (EntityExecution.Count <BcUserRoleEntity>(n => n.UserId == userId) > 0) { return(ExcuteResultEnum.IsOccupied); } var entity = GetSingleBcUserInfo(userId); if (new SysGlobalSettingBiz().IsSuperAdmin(entity.UserAccount)) { return(ExcuteResultEnum.IsSuperAdmin); } entity.DeleteFlag = true; return(UpdateBcUserInfo(entity)); }
private List <SysRelationEntity> SetSysRelationListCache() { var listSysRelationEntity = EntityExecution.SelectAll <SysRelationEntity>(); var listSysModuleEnumEntity = new SysModuleEnumBiz().GetSysModuleEnumList(); var listSysFuncPointEnumEntity = new SysFuncPointEnumBiz().GetSysFuncPointEnumList(); var query = from sysRelationEntity in listSysRelationEntity join sysModuleEnumEntity in listSysModuleEnumEntity on sysRelationEntity.ModuleId equals sysModuleEnumEntity.Name join sysFuncPointEnumEntity in listSysFuncPointEnumEntity on sysRelationEntity.FuncPointId equals sysFuncPointEnumEntity.Name select new SysRelationEntity() { ModuleId = sysRelationEntity.ModuleId, FuncPointId = sysRelationEntity.FuncPointId, Permissions = sysRelationEntity.Permissions, ModuleName = sysModuleEnumEntity.Description, FuncPointName = sysFuncPointEnumEntity.Description, }; listSysRelationEntity = query.ToList <SysRelationEntity>(); foreach (SysRelationEntity sysRelationEntity in listSysRelationEntity) { if (!string.IsNullOrEmpty(sysRelationEntity.Permissions)) { sysRelationEntity.PermissionList = new List <string>(); sysRelationEntity.PermissionListName = new List <string>(); var list = sysRelationEntity.Permissions.Split(',').ToList(); foreach (string s in list) { if (!string.IsNullOrEmpty(s)) { sysRelationEntity.PermissionList.Add(s); sysRelationEntity.PermissionListName.Add(SysEnumNameExBiz.GetDescription <SysFuncPointEnum>(s)); } } if (sysRelationEntity.PermissionListName.Count > 0) { sysRelationEntity.PermissionsName = string.Join(",", sysRelationEntity.PermissionListName.ToArray()); } } } DataCache.SetCache(CacheKey, listSysRelationEntity); return(listSysRelationEntity); }
private List <SysPageFuncPointEntity> SetSysPageFuncPointListCache() { var listSysPageFuncPointEntity = EntityExecution.SelectAll <SysPageFuncPointEntity>().OrderBy(n => n.PageUrl); var listSysFuncPointEnumEntity = new SysFuncPointEnumBiz().GetSysFuncPointEnumList(); var query = from sysPageFuncPointEntity in listSysPageFuncPointEntity join sysFuncPointEnumEntity in listSysFuncPointEnumEntity on sysPageFuncPointEntity.FuncPointId equals sysFuncPointEnumEntity.Name select new SysPageFuncPointEntity() { PageUrl = sysPageFuncPointEntity.PageUrl, FuncPointId = sysPageFuncPointEntity.FuncPointId, FuncPointName = sysFuncPointEnumEntity.Description, }; var list = query.ToList <SysPageFuncPointEntity>(); DataCache.SetCache(CacheKey, list); return(list); }
public List <OrderListEntity> GetOrderListEntityList(OrderListEntity condition_entity) { GenericWhereEntity <OrderListEntity> where_entity = new GenericWhereEntity <OrderListEntity>(); if (condition_entity.LIST_ID != null) { where_entity.Where(n => (n.LIST_ID == condition_entity.LIST_ID)); } if (condition_entity.ORDER_ID != null) { where_entity.Where(n => (n.ORDER_ID == condition_entity.ORDER_ID)); } if (condition_entity.FOOD_ID != null) { where_entity.Where(n => (n.FOOD_ID == condition_entity.FOOD_ID)); } return(EntityExecution.SelectAll(where_entity)); }
public List <OrderMainEntity> GetOrderMainEntityList(OrderMainEntity condition_entity) { GenericWhereEntity <OrderMainEntity> where_entity = new GenericWhereEntity <OrderMainEntity>(); if (condition_entity.ORDER_ID != null) { where_entity.Where(n => (n.ORDER_ID == condition_entity.ORDER_ID)); } if (condition_entity.RESTAURANT_ID != null) { where_entity.Where(n => (n.RESTAURANT_ID == condition_entity.RESTAURANT_ID)); } if (condition_entity.TABLE_ID != null) { where_entity.Where(n => (n.TABLE_ID == condition_entity.TABLE_ID)); } if (condition_entity.ORDER_FLAG != null) { where_entity.Where(n => (n.ORDER_FLAG == condition_entity.ORDER_FLAG)); } return(EntityExecution.SelectAll(where_entity)); }
public LoginStatusEnum DoLogin(string userAccount, string password) { var entity = EntityExecution.SelectOne <BcUserInfoEntity>(n => n.UserAccount == userAccount && n.DeleteFlag == false); if (entity == null) { return(LoginStatusEnum.UserNotExist); } if (entity.Password != Encryption.Encrypt(password)) { return(LoginStatusEnum.PasswordError); } if ((bool)!entity.ActivityFlag) { return(LoginStatusEnum.UserDisabled); } return(LoginStatusEnum.Success); }
public ExcuteResultEnum UpdateBcUserInfo(BcUserInfoEntity entity, string roleIds = null) { entity.Password = Encryption.Encrypt(entity.Password); using (TransactionScope ts = new TransactionScope()) { entity.Update(); EntityExecution.Delete <BcUserRoleEntity>(n => n.UserId == entity.UserId); if (!string.IsNullOrEmpty(roleIds)) { foreach (string roleId in roleIds.Split(',')) { var userRoleEntity = new BcUserRoleEntity { UserId = entity.UserId, RoleId = int.Parse(roleId) }; EntityExecution.Insert(userRoleEntity); } } ts.Complete(); } return(ExcuteResultEnum.Success); }
public List <BcGroupEntity> GetBcGroupList() { return(EntityExecution.SelectAll <BcGroupEntity>()); }
public BcGroupEntity GetSingleBcGroup(int groupId) { return(EntityExecution.SelectOne <BcGroupEntity>(n => n.GroupId == groupId)); }
public BcUserInfoEntity GetBcUserInfoWithPermission(string userAccount) { var entity = EntityExecution.SelectOne <BcUserInfoEntity>( n => n.UserAccount == userAccount && n.ActivityFlag == true && n.DeleteFlag == false); //获取用户的角色 var userRoleList = new BcUserRoleBiz().GetBcUserRoleList(entity.UserId); entity.RoleList = new List <BcRoleEntity>(); foreach (BcUserRoleEntity userRoleEntity in userRoleList) { entity.RoleList.Add(new BcRoleEntity() { RoleId = userRoleEntity.RoleId, RoleName = userRoleEntity.RoleName }); } //获取用户是否为超级管理员 entity.IsSuperAdmin = new SysGlobalSettingBiz().IsSuperAdmin(entity.UserAccount); //获取用户的权限 if (entity.IsSuperAdmin) { //如果是超级管理员,获取所有权限 entity.PermisionList = new List <PermissionEntity>(); var sysRelationList = new SysRelationBiz().GetEnabledSysRelationList(); foreach (SysRelationEntity sysRelationEntity in sysRelationList) { entity.PermisionList.Add(new PermissionEntity() { ModuleId = sysRelationEntity.ModuleId, FuncPointId = sysRelationEntity.FuncPointId, PermissionList = sysRelationEntity.PermissionList }); } } else { //如果不是超级管理员,获取用户权限和角色权限 var bcPermissionBiz = new BcPermissionBiz(); //1、获取用户权限 entity.PermisionList = new List <PermissionEntity>(); var bcUserPermissionList = bcPermissionBiz.GetEnabledBcPermissionList(2, entity.UserId); foreach (BcPermissionEntity bcPermissionEntity in bcUserPermissionList) { entity.PermisionList.Add(new PermissionEntity() { ModuleId = bcPermissionEntity.ModuleId, FuncPointId = bcPermissionEntity.FuncPointId, PermissionList = bcPermissionEntity.Permissions.Split(',').ToList() }); } //2、获取角色权限 foreach (BcRoleEntity bcRoleEntity in entity.RoleList) { var bcRolePermissionList = bcPermissionBiz.GetEnabledBcPermissionList(1, bcRoleEntity.RoleId); foreach (BcPermissionEntity bcPermissionEntity in bcRolePermissionList) { var list = entity.PermisionList.Where( n => n.ModuleId == bcPermissionEntity.ModuleId && n.FuncPointId == bcPermissionEntity.FuncPointId).ToList(); if (list.Count > 0) { var pcList = bcPermissionEntity.Permissions.Split(',').ToList(); foreach (string s in pcList) { if (!list[0].PermissionList.Contains(s)) { list[0].PermissionList.Add(s); } } } else { entity.PermisionList.Add(new PermissionEntity() { ModuleId = bcPermissionEntity.ModuleId, FuncPointId = bcPermissionEntity.FuncPointId, PermissionList = bcPermissionEntity.Permissions.Split(',').ToList() }); } } } } //根据用户权限,获取用户的菜单列表 entity.MenuList = new SysMenuBiz().GetEnabledSysMenuListByPermission(entity.PermisionList); return(entity); }