public DBProcessResult DeleteCar(string sVechileCode)
{
DBProcessResult result = new DBProcessResult() { IsSuccess = false, Message = "删除失败!" };
VehicleDAL vDal = new VehicleDAL();
bool isSucess = vDal.DeleteCar(sVechileCode);
if (isSucess)
{
result.IsSuccess = true;
result.Message = "删除成功！";
}
return result;
}
public DBProcessResult DeleteVehicle(Guid code)
{
DBProcessResult result = new DBProcessResult();
try
{
IEMVehicleService service = new EMVehicleService();
service.Delete(code);
result.IsSuccess = true;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
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 DBProcessResult Get_MobileSMSSendOut(string mobile, string userCode, string sendMsg)
{
DBProcessResult result = new DBProcessResult() { IsSuccess = true, Message = "短信已发送，请注意查收！" };
try
{
SMSService smsService = new SMSService();
DateTime today = DateTime.Today;
MobileSMSSendOutHelper.RemoveMobileSMSSendOutInfo(today.AddDays(-1).ToString("yyyyMMdd"));
IDictionary<string, int> dictionary = MobileSMSSendOutHelper.GetMobileDictionary(today.ToString("yyyyMMdd"));
if (dictionary != null && dictionary.Count > 0)
{
if (dictionary.ContainsKey(mobile))
{
int num = dictionary[mobile];
if (num > 10)
{
result.IsSuccess = false;
result.Message = "对不起，同一个手机号码每天最多只能发送10次！";
}
else
{
//MovoSMSProxy.SendMoveSMS(mobile, MobileSMSSendOutHelper.SMSString, -1, "20010030300002", userCode);
smsService.SendSMS(sendMsg, mobile);
//smsService.SendSMS(MobileSMSSendOutHelper.SMSString, mobile);
num++;
dictionary[mobile] = num;
}
}
else
{
//MovoSMSProxy.SendMoveSMS(mobile, MobileSMSSendOutHelper.SMSString, -1, "20010030300002", userCode);
smsService.SendSMS(sendMsg, mobile);
dictionary.Add(mobile, 1);
}
}
else
{
//MovoSMSProxy.SendMoveSMS(mobile, MobileSMSSendOutHelper.SMSString, -1, "20010030300002", userCode);
smsService.SendSMS(sendMsg, mobile);
dictionary.Add(mobile, 1);
}
MobileSMSSendOutHelper.SetMobileSMSSendOutInfo(today.ToString("yyyyMMdd"), dictionary);
}
catch (Exception exception)
{
Logger.Error("Get_MobileSMSSendOut：手机号码(" + mobile + ")" + exception.Message);
}
return result;
}
public DBProcessResult ModifyVehicleGroup(EMVehicleGroupViewModel view)
{
DBProcessResult result = new DBProcessResult();
try
{
EMVehicleGroup entity = ConvertHelper.ConvertObj<EMVehicleGroupViewModel, EMVehicleGroup>(view);
EMVehicleGroupService service = new EMVehicleGroupService();
service.Update(entity);
result.IsSuccess = true;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
public DBProcessResult DeleteVehicleGroup(ulong groupID)
{
DBProcessResult result = new DBProcessResult();
try
{
EMVehicleGroupService service = new EMVehicleGroupService();
IEMVehicleService vehicleService = new EMVehicleService();
EMVehicleGroup currentGourp = service.Select(groupID);
IList<EMVehicleGroup> groupList = service.SelectChild(groupID);
List<EMVehicle> vehicleList = vehicleService.SelectVehicleByGroupID(groupID).ToList();
foreach (EMVehicleGroup group in groupList)
{
IList<EMVehicle> tmpList = vehicleService.SelectVehicleByGroupID(group.GroupID);
vehicleList.AddRange(tmpList);
}
foreach (EMVehicle vehicleEntity in vehicleList)
{
vehicleEntity.GroupID = currentGourp.ParentGroupID.Value;
vehicleService.Update(vehicleEntity);
}
service.DeleteChild(groupID);
service.Delete(groupID);
result.IsSuccess = true;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
public DBProcessResult TransferVehicle(string vehicleCode, string newTenantCode)
{
DBProcessResult result = new DBProcessResult();
try
{
//查询新客户的默认车辆组
EMVehicleGroupService VGSev = new EMVehicleGroupService();
ulong newVehicleGroupID = VGSev.GetTopGroupID(newTenantCode);
EMVehicleService VSev = new EMVehicleService();
EMVehicle vehicle = VSev.Select(new Guid(vehicleCode));
//更新车辆的车辆组和Tenantcode
vehicle.GroupID = newVehicleGroupID;
vehicle.TenantCode = newTenantCode;
VSev.Update(vehicle);
//将车辆从旧的车辆和用户组关系中删除
EMVehicleInUserGroupService VIUSev = new EMVehicleInUserGroupService();
VIUSev.DeleteByVehicleCode(vehicleCode);
//删除车辆报警参数设置
MySqlHelper.TransCommand(getCmdTextList(vehicleCode));
result.IsSuccess = true;
result.Message = "转移车辆成功！";
}
catch
{
result.IsSuccess = false;
result.Message = "转移车辆失败！";
}
return result;
}
public DBProcessResult ChangeDeviceStopState(Guid vehicleCode, bool isStop)
{
DBProcessResult result = new DBProcessResult();
try
{
IEMVehicleService service = new EMVehicleService();
EMVehicle model = service.Select(vehicleCode);
model.IsStop = isStop;
service.Update(model);
result.IsSuccess = true;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
public DBProcessResult ModifyVehicle(VehicleViewModel view)
{
DBProcessResult result = new DBProcessResult();
try
{
IEMVehicleService service = new EMVehicleService();
EMVehicle entity = ConvertHelper.ConvertObj<VehicleViewModel, EMVehicle>(view);
//同一租户下车牌号码不能重复
EMVehicle old = service.Select(view.VehicleCode);
if (old.LicenceNumber != entity.LicenceNumber)
{
bool licenceNumberIsExist = service.IsExist(entity.TenantCode, entity.LicenceNumber);
if (licenceNumberIsExist)
{
result.IsSuccess = false;
result.Message = "已经有相同车牌号的车辆";
return result;
}
}
service.Update(entity);
result.IsSuccess = true;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
public DBProcessResult DeleteCustomer(string tenantCode)
{
DBProcessResult result = new DBProcessResult() { IsSuccess = false, Message = "删除失败!" };
try
{
EMTenantService tenantServ = new EMTenantService();
UserService userService = new UserService();
EMVehicleService vehicleServ = new EMVehicleService();
IList<EMVehicle> ltEMVehicle = vehicleServ.SelectAll(tenantCode);
if (ltEMVehicle != null && ltEMVehicle.Count > 0)
{
result.Message = "对不起，客户下还存在车辆，不能删除！";
result.IsSuccess = false;
}
else
{
EMTenant emTenant = tenantServ.Select(tenantCode);
if (emTenant != null)
{
//EMUser emUser = userService.GetUser(emTenant.RegisterUserCode);
userService.Delete(emTenant.RegisterUserCode);//删除注册账号
tenantServ.Delete(emTenant);//删除运营商信息
result.Message = "删除成功!";
result.IsSuccess = true;
}
//tenantServ.Delete(tenantCode);
//result.Message = "删除成功!";
//result.IsSuccess = true;
}
}
catch (Exception ex)
{
Logger.Error(ex.Message);
}
return result;
}
public DBProcessResult DeleteOperate(string tenantCode)
{
DBProcessResult result = new DBProcessResult() { IsSuccess = false, Message = "删除失败!" };
try
{
IEMTenantService tenantServ = new EMTenantService();
IUserService userService = new UserService();
IList<EMTenant> ltTenantAll = tenantServ.GetGrandChildren(tenantCode);
if (ltTenantAll != null && ltTenantAll.Count > 0)
{
result.Message = "对不起，运营商下还存在子运营商或客户，不能删除！";
result.IsSuccess = false;
}
else
{
EMTenant emTenant = tenantServ.Select(tenantCode);
if(emTenant != null)
{
//EMUser emUser = userService.GetUser(emTenant.RegisterUserCode);
userService.Delete(emTenant.RegisterUserCode);//删除注册账号
tenantServ.Delete(emTenant);//删除运营商信息
result.Message = "删除成功!";
result.IsSuccess = true;
}
}
}
catch (Exception ex)
{
Logger.Error(ex.Message);
}
return result;
}
/// <summary>
/// 移动车辆到指定车辆组
/// </summary>
/// <param name="entity"></param>
/// <param name="userName"></param>
/// <returns></returns>
public DBProcessResult MoveVehicle(Guid vehicleCode, ulong groupID)
{
DBProcessResult result = new DBProcessResult();
try
{
IEMVehicleService service = new EMVehicleService();
EMVehicle entity = service.Select(vehicleCode);
if (entity == null)
{
result.IsSuccess = false;
result.Message = "移动失败,车辆不存在!";
return result;
}
entity.GroupID = groupID;
service.Update(entity);
result.IsSuccess = true;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
/// <summary>
/// 保存车辆组
/// </summary>
/// <param name="entity"></param>
/// <param name="userName"></param>
/// <returns></returns>
public DBProcessResult SaveVehicleGroup(EMVehicleGroup entity)
{
EMVehicleGroupService service = new EMVehicleGroupService();
DBProcessResult result = new DBProcessResult();
try
{
service.Update(entity);
result.IsSuccess = true;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
public DBProcessResult AddVehicle(EMVehicleViewModel view)
{
DBProcessResult result = new DBProcessResult();
try
{
EMVehicleService service = new EMVehicleService();
EHistoryDataStoreConfigService configService = new EHistoryDataStoreConfigService();
EMGpsTypeService gpsTypeService = new EMGpsTypeService();
EMVehicleLogService logService = new EMVehicleLogService();
IdentityNoService noService = new IdentityNoService();
bool licenceNumberIsExist = service.IsExist(view.TenantCode, view.LicenceNumber);
if (licenceNumberIsExist)
{
result.IsSuccess = false;
result.Message = "已经有相同车牌号的车辆";
return result;
}
EMVehicle entity = ConvertHelper.ConvertObj<EMVehicleViewModel, EMVehicle>(view);
EMGpsType gpsTypeEntity = gpsTypeService.Get(entity.GPSTypeID);
Logger.Info("code line 290: gpsTypeService.Get(entity.GPSTypeID)");
entity.GPSTypeName = gpsTypeEntity.TypeName;
bool bo = service.IsExist(view.DeviceNo);
if (bo != true)
{
//新增车辆历史数据配置
string tableName = GetTableNameByCondition(gpsTypeEntity.PrefixCode);
EHisotryDataStoreTables table = configService.GetHistoryTable(tableName);
Logger.Info("code line 299: configService.GetHistoryTable(tableName)");
if (table == null)
{
result.IsSuccess = false;
result.Message = string.Format("找不到对应的历史数据表[{0}]，请联系DBA！", tableName);
return result;
}
//新增车辆
EnumGPSCodeRule codeType = (EnumGPSCodeRule)gpsTypeEntity.GPSCodeRule;
entity.GPSCode = GetGPSCodeHelper.GetGPSCode(gpsTypeEntity.PrefixCode, codeType, entity.SIMNo, entity.DeviceNo);
if (entity.DeviceNo.Length == gpsTypeEntity.MachineCodeLength)
{
entity.CreateTime = DateTime.Now;
entity.InstallTime = DateTime.Now;
GetVehicleGroupID(entity); //客户管理中新增车辆时，没有车辆组，默认增加到顶级车辆组
service.Insert(entity);
EHistoryDataStoreConfig configEntity = new EHistoryDataStoreConfig();
configEntity.CreateDate = DateTime.Now;
configEntity.Enable = true;
configEntity.StoreTable = table;
configEntity.VehicleCode = entity.VehicleCode;
configService.Insert(configEntity);
//新增车辆Log
EMVehicleLog vehicleLog = new EMVehicleLog()
{
BeginDate = DateTime.Now,
LogID = noService.GetVehicleLogID(),
DeviceNo = entity.DeviceNo,
EndDate = null,
GPSCode = entity.GPSCode,
GPSTypeID = entity.GPSTypeID,
InitMileage = entity.InitMileage,
LicenceNumber = entity.LicenceNumber,
Operator = view.UserName,
SIMNo = entity.SIMNo,
TenantCode = entity.TenantCode,
VehicleCode = entity.VehicleCode,
GroupID = entity.GroupID,
};
logService.Insert(vehicleLog);
view.VehicleCode = entity.VehicleCode;
result.IsSuccess = true;
}
else
{
result.IsSuccess = false;
result.Message = "GPS设备号长度，不在指定范围内，请重新填写！";
}
}
else
{
result.IsSuccess = false;
result.Message = "设备号已存在，请重新填写！";
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
Logger.Info(ex.StackTrace + "【" + ex.Message + "】");
}
return result;
}
public DBProcessResult ModifyVehicle(EMVehicleViewModel view)
{
DBProcessResult result = new DBProcessResult();
try
{
IEMVehicleService service = new EMVehicleService();
IEMVehicleLogService logService = new EMVehicleLogService();
IdentityNoService noService = new IdentityNoService();
IEMGpsTypeService gpsTypeService = new EMGpsTypeService();
EMVehicle entity = ConvertHelper.ConvertObj<EMVehicleViewModel, EMVehicle>(view);
EMVehicle oldEntity = service.Select(view.VehicleCode);
entity.ExpireTime = oldEntity.ExpireTime;
entity.InstallTime = oldEntity.InstallTime;
entity.CreateTime = oldEntity.CreateTime;
entity.IsStop = oldEntity.IsStop;
EMGpsType gpsTypeEntity = gpsTypeService.Get(entity.GPSTypeID);
entity.GPSTypeName = gpsTypeEntity.TypeName;
//如果设备号改变，要重新获取GPSCode，添加和修改日志
if (entity.DeviceNo != oldEntity.DeviceNo)
{
bool bo = service.IsExist(view.DeviceNo);
if (bo != true)
{
EnumGPSCodeRule codeType = (EnumGPSCodeRule)gpsTypeEntity.GPSCodeRule;
entity.GPSCode = GetGPSCodeHelper.GetGPSCode(gpsTypeEntity.PrefixCode, codeType, entity.SIMNo, entity.DeviceNo);
if (entity.DeviceNo.Length == gpsTypeEntity.MachineCodeLength)
{
//修改上一个日志
DateTime now = DateTime.Now;
EMVehicleLog lastLog = logService.GetLast(entity.VehicleCode);
if (lastLog != null)
{
lastLog.EndDate = now;
logService.Update(lastLog);
}
//新增一个日志
EMVehicleLog vehicleLog = new EMVehicleLog()
{
BeginDate = now,
LogID = noService.GetVehicleLogID(),
DeviceNo = entity.DeviceNo,
EndDate = null,
GPSCode = entity.GPSCode,
GPSTypeID = entity.GPSTypeID,
InitMileage = entity.InitMileage,
LicenceNumber = entity.LicenceNumber,
Operator = view.UserName,
SIMNo = entity.SIMNo,
TenantCode = entity.TenantCode,
GroupID = entity.GroupID,
VehicleCode = entity.VehicleCode
};
logService.Insert(vehicleLog);
entity.InstallTime = DateTime.Now;
service.Update(entity);
result.IsSuccess = true;
}
else
{
result.IsSuccess = false;
result.Message = "GPS设备号长度，不在指定范围内，请重新填写！";
}
}
else
{
result.IsSuccess = false;
result.Message = "GPS设备号已存在，请重新填写！";
}
}
else
{
service.Update(entity);
result.IsSuccess = true;
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
public DBProcessResult AddVehicleOperate(EMVehicle entity, string sUserName)
{
DBProcessResult result = new DBProcessResult();
try
{
VehicleDAL ve = new VehicleDAL();
IdentityNoService noService = new IdentityNoService();
bool isLiceNum = ve.IsLicenceNumber(entity.TenantCode, entity.LicenceNumber);
if (isLiceNum)
{
result.IsSuccess = false;
result.Message = "已经有相同车牌号的车辆";
return result;
}
//EMVehicle entity = ConvertHelper.ConvertObj<EMVehicleViewModel, EMVehicle>(view);
EMGpsType gpsTypeEntity = ve.GetGpsTypeByGpsTypeId(entity.GPSTypeID);
entity.GPSTypeName = gpsTypeEntity.TypeName;
bool isDev = ve.IsDeviceNo(entity.DeviceNo);
if (isDev != true)
{
//新增车辆历史数据配置
string tableName = GetTableNameByCondition(gpsTypeEntity.PrefixCode);
EHisotryDataStoreTables table = ve.GetHistoryTable(tableName);
if (table == null)
{
result.IsSuccess = false;
result.Message = string.Format("找不到对应的历史数据表[{0}]，请联系DBA！", tableName);
return result;
}
//新增车辆
EnumGPSCodeRule codeType = (EnumGPSCodeRule)gpsTypeEntity.GPSCodeRule;
entity.GPSCode = GetGPSCodeHelper.GetGPSCode(gpsTypeEntity.PrefixCode, codeType, entity.SIMNo, entity.DeviceNo);
if (entity.DeviceNo.Length == gpsTypeEntity.MachineCodeLength)
{
GetVehicleGroupID(entity); //客户管理中新增车辆时，没有车辆组，默认增加到顶级车辆组
Logger.Info("新增车辆: " + entity.LicenceNumber + "开始");
ve.AddVehicle(entity);
Logger.Info("新增车辆: " + entity.LicenceNumber + "结束");
EHistoryDataStoreConfig configEntity = new EHistoryDataStoreConfig();
configEntity.RecordID = Guid.NewGuid();
configEntity.CreateDate = DateTime.Now;
configEntity.Enable = true;
configEntity.StoreTable = table;
configEntity.VehicleCode = entity.VehicleCode;
Logger.Info("新增车辆 gps_historydatastoreconfig: " + configEntity.StoreTable.TableName + "开始");
ve.AddHistoryDataStoreConfig(configEntity);
Logger.Info("新增车辆 gps_historydatastoreconfig: " + configEntity.StoreTable.TableName + "结束");
//新增车辆Log
EMVehicleLog vehicleLog = new EMVehicleLog()
{
BeginDate = DateTime.Now,
LogID = noService.GetVehicleLogID(),
DeviceNo = entity.DeviceNo,
EndDate = null,
GPSCode = entity.GPSCode,
GPSTypeID = entity.GPSTypeID,
InitMileage = entity.InitMileage,
LicenceNumber = entity.LicenceNumber,
Operator = sUserName,
SIMNo = entity.SIMNo,
TenantCode = entity.TenantCode,
VehicleCode = entity.VehicleCode,
GroupID = entity.GroupID,
};
Logger.Info("新增车辆 movo_vehiclelog: " + configEntity.StoreTable.TableName + "开始");
ve.AddVehicleLog(vehicleLog);
Logger.Info("新增车辆 movo_vehiclelog: " + configEntity.StoreTable.TableName + "结束");
result.IsSuccess = true;
}
else
{
result.IsSuccess = false;
result.Message = string.Format(@"GPS设备号长度为{0}，请重新填写！", gpsTypeEntity.MachineCodeLength);
}
}
else
{
result.IsSuccess = false;
result.Message = "设备号已存在，请重新填写！";
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
Logger.Info("新增车辆:" + ex.StackTrace + "【" + ex.Message + "】");
}
return result;
}
public DBProcessResult AddVehicleGroup(EMVehicleGroupViewModel view)
{
IdentityNoService noService = new IdentityNoService();
DBProcessResult result = new DBProcessResult();
try
{
EMVehicleGroup entity = ConvertHelper.ConvertObj<EMVehicleGroupViewModel, EMVehicleGroup>(view);
entity.GroupID = noService.GetVehicleGroupID();
entity.Remark = " ";
EMVehicleGroupService service = new EMVehicleGroupService();
service.Insert(entity);
view.GroupID = entity.GroupID;
result.IsSuccess = true;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
public DBProcessResult<int> AddVehicleOperateTran(EMVehicle entity, string sUserName)
{
DBProcessResult<int> result = new DBProcessResult<int>();
try
{
VehicleDAL ve = new VehicleDAL();
IdentityNoService noService = new IdentityNoService();
bool isLiceNum = ve.IsLicenceNumber(entity.TenantCode, entity.LicenceNumber);
if (isLiceNum)
{
result.IsSuccess = false;
result.Message = "已经有相同车牌号的车辆";
result.ReturnValue = -1;
return result;
}
EMGpsType gpsTypeEntity = ve.GetGpsTypeByGpsTypeId(entity.GPSTypeID);
entity.GPSTypeName = gpsTypeEntity.TypeName;
bool isDev = ve.IsDeviceNo(entity.DeviceNo);
if (isDev != true)
{
//新增车辆历史数据配置
string tableName = GetTableNameByCondition(gpsTypeEntity.PrefixCode);
EHisotryDataStoreTables table = ve.GetHistoryTable(tableName);
if (table == null)
{
result.IsSuccess = false;
result.Message = string.Format("找不到对应的历史数据表[{0}]，请联系DBA！", tableName);
result.ReturnValue = -1;
return result;
}
//新增车辆
EnumGPSCodeRule codeType = (EnumGPSCodeRule)gpsTypeEntity.GPSCodeRule;
entity.GPSCode = GetGPSCodeHelper.GetGPSCode(gpsTypeEntity.PrefixCode, codeType, entity.SIMNo, entity.DeviceNo);
if (entity.DeviceNo.Length == gpsTypeEntity.MachineCodeLength)
{
GetVehicleGroupID(entity); //客户管理中新增车辆时，没有车辆组，默认增加到顶级车辆组
EHistoryDataStoreConfig configEntity = new EHistoryDataStoreConfig();
configEntity.RecordID = Guid.NewGuid();
configEntity.CreateDate = DateTime.Now;
configEntity.Enable = true;
configEntity.StoreTable = table;
configEntity.VehicleCode = entity.VehicleCode;
//新增车辆Log
EMVehicleLog vehicleLog = new EMVehicleLog()
{
BeginDate = DateTime.Now,
LogID = noService.GetVehicleLogID(),
DeviceNo = entity.DeviceNo,
EndDate = null,
GPSCode = entity.GPSCode,
GPSTypeID = entity.GPSTypeID,
InitMileage = entity.InitMileage,
LicenceNumber = entity.LicenceNumber,
Operator = sUserName,
SIMNo = entity.SIMNo,
TenantCode = entity.TenantCode,
VehicleCode = entity.VehicleCode,
GroupID = entity.GroupID
};
var res = ve.AddVehicleOperTrans(entity, configEntity, vehicleLog);
result.IsSuccess = res.State;
result.Message = res.Msg;
result.ReturnValue = new VehicleDAL().SelectCount(entity.TenantCode.ToString());
}
else
{
result.IsSuccess = false;
result.Message = string.Format(@"GPS设备号长度为{0}，请重新填写！", gpsTypeEntity.MachineCodeLength);
result.ReturnValue = -1;
}
}
else
{
result.IsSuccess = false;
result.Message = "设备号已存在，请重新填写！";
result.ReturnValue = -1;
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
result.ReturnValue = -1;
Logger.Error("VehicleManagerWCFService.AddVehicleOperateTran(EMVehicle entity, string sUserName)；" + ex.Message, ex);
}
return result;
}
public DBProcessResult UserAndTenantModify(UserInfoModifyViewModel userViewModel)
{
DBProcessResult result = new DBProcessResult();
try
{
IUserService userService = new UserService();
IEMTenantService tenantService = new EMTenantService();
if (!string.IsNullOrEmpty(userViewModel.Pwd))
{
EMUser user = userService.GetUser(userViewModel.UserCode);
user.PassWord = userViewModel.Pwd;
userService.Update(user);
}
EMTenant tenant = tenantService.Select(userViewModel.TenantCode);
tenant.Email = userViewModel.Email;
tenant.QQ = userViewModel.QQ;
tenantService.Update(tenant);
result.Message = "修改成功！";
result.IsSuccess = true;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
public DBProcessResult UserInfoModify(string UserCode, string Password)
{
DBProcessResult result = new DBProcessResult();
try
{
IUserService ser = new UserService();
EMUser model = ser.GetUser(UserCode);
if (Password != "")
model.PassWord = Password;
ser.Modify(model);
result.IsSuccess = true;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
