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