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