public IList<EMVehicleInUserGroup> SelectByUserGroupID(ulong userGroupID) { MUserGroupService userGroupService = new MUserGroupService(); EMUserGroup userGroup = userGroupService.Get(userGroupID); IList<EMVehicleInUserGroup> list = new List<EMVehicleInUserGroup>(); if (userGroup != null && userGroup.IsAdminGroup) { //EMVehicleService vehicleService = new EMVehicleService(); //IList<EMVehicle> listVehicle = vehicleService.SelectAll(userGroup.TenantCode); IList<EMVehicle> listVehicle = _VehicleDAL.GetUserVehicleList("", userGroup.TenantCode); foreach (EMVehicle vehicle in listVehicle) { list.Add(new EMVehicleInUserGroup() { UserGroupID = userGroupID, VehicleCode = vehicle.VehicleCode, LicenceNumber = vehicle.LicenceNumber }); } } else { string sql = string.Format(@"SELECT a.*,b.LicenceNumber FROM movo_vehicle_usergroup a LEFT JOIN movo_Vehicle b ON a.VehicleCode = b.VehicleCode where a.UserGroupID={0};", userGroupID); DataSet ds = MySqlDB.GetDataSet(CommandType.Text, sql); if (ds == null || ds.Tables[0].Rows.Count == 0) return list; for (int i = 0, i_Count = ds.Tables[0].Rows.Count; i < i_Count; i++) { list.Add(ConvertInfo(ds.Tables[0].Rows[i])); } } return list; }
public List<EMUserGroupViewModel> SearchUserGroup(string userGroupName, string tenantCode) { try { IMUserGroupService userGroup = new MUserGroupService(); IList<EMUserGroup> userList = userGroup.GetList(userGroupName, tenantCode); List<EMUserGroupViewModel> modelList = null; if (userList != null || userList.Count > 0) { modelList = new List<EMUserGroupViewModel>(); foreach (EMUserGroup entity in userList) { modelList.Add(ConvertHelper.ConvertObj<EMUserGroup, EMUserGroupViewModel>(entity)); } } return modelList; } catch (Exception ex) { Logger.Error(ex.Message, ex); return null; } }
public EMUserInfoViewModel GetUserListViewModel(string userName, string userGroupID, string tenantCode, int pageIndex, int pageSize) { try { MUserGroupService iMUserGroup = new MUserGroupService(); UserService userService = new UserService(); int rowCount = 0; IList<EMUser> userList = userService.GetUserList(userName, userGroupID, tenantCode, pageIndex, pageSize, ref rowCount); EMUserInfoViewModel userInfo = new EMUserInfoViewModel(); if (userList != null && userList.Count > 0 && rowCount > 0) { userInfo = new EMUserInfoViewModel(); List<EMUserListViewModel> list = new List<EMUserListViewModel>(); for (int i = 0; i < userList.Count; i++) { EMUser entity = userList[i]; EMUserListViewModel model = new EMUserListViewModel(); model = new EMUserListViewModel(); model.Index = i + 1; model.UserCode = entity.UserCode; model.UserName = entity.UserName; model.IsRegisterUser = entity.IsRegisterUser; model.PassWord = entity.PassWord; model.RealName = entity.RealName; model.Mobile = entity.Mobile; model.TenantCode = entity.TenantCode; if (entity.UserGroupID != null) { EMUserGroup userGroup = iMUserGroup.Get(entity.UserGroupID); if (userGroup != null) { model.UserGroupID = userGroup.UserGroupID; model.UserGroupName = userGroup.UserGroupName; } } if (entity.LastLoginTime.ToString() == DateTime.MinValue.ToString()) model.LastLoginTime = null; else model.LastLoginTime = entity.LastLoginTime; if (entity.CreateTime.ToString() == DateTime.MinValue.ToString()) model.CreateTime = DateTime.MaxValue; else model.CreateTime = entity.CreateTime; list.Add(model); } userInfo.userListViewModel = list; userInfo.RowCount = rowCount; } return userInfo; } catch (Exception ex) { Logger.Error(ex.Message, ex); return null; } }
public DBProcessResult DeleteUserGroup(ulong userGroupID) { DBProcessResult result = new DBProcessResult(); try { if (AnyUserInGroup(userGroupID)) { result.IsSuccess = false; result.Message = "用户组下有用户,不能删除,请先转移或删除用户!"; return result; } IMUserGroupService userGroupSev = new MUserGroupService(); IEMVehicleInUserGroupService viuSev = new EMVehicleInUserGroupService(); //删除用户组 userGroupSev.Delete(userGroupID); //删除旧车辆与用户组的关系,并新增关系 viuSev.DeleteByUserGroupID(userGroupID); result.IsSuccess = true; } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; Logger.Error(ex.Message, ex); } return result; }
public DBProcessResult UpdateUserGruop(EMUserGroupWithVehiclesViewModel viewModel) { DBProcessResult result = new DBProcessResult(); try { IMUserGroupService userGroupSev = new MUserGroupService(); bool isExists = userGroupSev.IsExist(viewModel.UserGourpView.UserGroupName, viewModel.UserGourpView.UserGroupID, viewModel.UserGourpView.TenantCode); if (isExists) { result.IsSuccess = false; result.Message = "用户组名已经存在"; return result; } IEMVehicleInUserGroupService viuSev = new EMVehicleInUserGroupService(); //修改用户组 EMUserGroup entity = ConvertHelper.ConvertObj<EMUserGroupViewModel, EMUserGroup>(viewModel.UserGourpView); userGroupSev.Update(entity); //删除旧车辆与用户组的关系,并新增关系 viuSev.DeleteByUserGroupID(entity.UserGroupID); List<EMVehicleInUserGroup> vehicleList = new List<EMVehicleInUserGroup>(); foreach (EMVehicleInUserGroupViewModel vehicleView in viewModel.Vehicles) { EMVehicleInUserGroup vehicle = new EMVehicleInUserGroup(); vehicle.UserGroupID = entity.UserGroupID; vehicle.VehicleCode = vehicleView.VehicleCode; vehicleList.Add(vehicle); } viuSev.Insert(vehicleList); result.IsSuccess = true; } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; Logger.Error(ex.Message, ex); } return result; }
public DBProcessResult<EMUserGroupViewModel> InsertUserGruop(EMUserGroupWithVehiclesViewModel viewModel) { DBProcessResult<EMUserGroupViewModel> result = new DBProcessResult<EMUserGroupViewModel>(); try { IMUserGroupService userGroupSev = new MUserGroupService(); bool isExists = userGroupSev.IsExist(viewModel.UserGourpView.UserGroupName , viewModel.UserGourpView.TenantCode); if (isExists) { result.IsSuccess = false; result.Message = "用户组名已经存在"; return result; } IdentityNoService codeSec = new IdentityNoService(); IEMVehicleInUserGroupService viuSev = new EMVehicleInUserGroupService(); //新增用户组 viewModel.UserGourpView.UserGroupID = codeSec.GetUserGroupID(); EMUserGroup entity = ConvertHelper.ConvertObj<EMUserGroupViewModel, EMUserGroup>(viewModel.UserGourpView); userGroupSev.Add(entity); //新增车辆与用户组的关系 List<EMVehicleInUserGroup> vehicleList = new List<EMVehicleInUserGroup>(); foreach (EMVehicleInUserGroupViewModel vehicleView in viewModel.Vehicles) { EMVehicleInUserGroup vehicle = new EMVehicleInUserGroup(); vehicle.UserGroupID = entity.UserGroupID; vehicle.VehicleCode = vehicleView.VehicleCode; vehicleList.Add(vehicle); } viuSev.Insert(vehicleList); result.IsSuccess = true; result.ReturnValue = viewModel.UserGourpView; } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; Logger.Error(ex.Message, ex); } return result; }
public EMUserGroupWithVehiclesViewModel GetUserGruopWithVehicles(ulong userGroupID) { EMUserGroupWithVehiclesViewModel uvView = new EMUserGroupWithVehiclesViewModel(); try { IMUserGroupService userGroup = new MUserGroupService(); IEMVehicleInUserGroupService viugSev = new EMVehicleInUserGroupService(); EMUserGroup ugEntity = userGroup.Get(userGroupID); uvView.UserGourpView = ConvertHelper.ConvertObj<EMUserGroup, EMUserGroupViewModel>(ugEntity); List<EMVehicleInUserGroup> vehicleList = viugSev.SelectByUserGroupID(userGroupID).ToList(); uvView.Vehicles = ConvertHelper.ConvertList<EMVehicleInUserGroup, EMVehicleInUserGroupViewModel>(vehicleList); return uvView; } catch (Exception ex) { Logger.Error(ex.Message, ex); return null; } }