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