// 修改
public ResultContent UpdateSMSQuery(SmsQueryVehicleParam para)
{
ResultContent rc = new ResultContent();
// 要校验
try
{
ISMSQueryVehicleService sqv = new SMSQueryVehicleService();
IdentityNoService identity = new IdentityNoService();
EMSMSQueryVehicle entity = sqv.GetSMSQuery(para.smsid);
//entity.CreateDate = DateTime.Now;
entity.TenantCode = para.TenantCode;
entity.CustomerName = para.CustomerName;
entity.CustomerTelephone = para.Telphone;
entity.IsProfessional = false;
entity.SMSVehicle.Clear();
if (!para.vehicleCodelist.IsNullOrEmpty())
{
for (int i = 0; i < para.vehicleCodelist.Count; i++)
{
EMSMSVehicle vehicle = new EMSMSVehicle()
{
smsvehicle_id = identity.GetSMSVehicleID(),
VehicleCode = para.vehicleCodelist[i],
TenantCode = para.TenantCode,
LicenseNumber = para.LicenceNumberlist[i]
};
entity.SMSVehicle.Add(vehicle);
}
}
sqv.Modify(entity);
rc.Result = true;
rc.Message = "修改成功!";
}
catch (Exception ex)
{
rc.Result = false;
rc.Message = ex.Message;
Logger.Error(ex.Message, ex);
}
return rc;
}
// 新增
public ResultContent AddSMSQuery(SmsQueryVehicleParam para)
{
ResultContent rc = new ResultContent();
try
{
// 要校验
IdentityNoService identity = new IdentityNoService();
EMSMSQueryVehicle entity = new EMSMSQueryVehicle();
entity.sms_vehicle_set_id = identity.GetSMSQueryVehicleSettingID();
entity.CreateDate = DateTime.Now;
entity.TenantCode = para.TenantCode;
entity.CustomerName = para.CustomerName;
entity.CustomerTelephone = para.Telphone;
entity.IsProfessional = false;
if (!para.vehicleCodelist.IsNullOrEmpty())
{
entity.SMSVehicle = new List<EMSMSVehicle>();
for (int i = 0; i < para.vehicleCodelist.Count; i++)
{
EMSMSVehicle vehicle = new EMSMSVehicle()
{
smsvehicle_id = identity.GetSMSVehicleID(),
VehicleCode = para.vehicleCodelist[i],
TenantCode = para.TenantCode,
LicenseNumber = para.LicenceNumberlist[i]
};
entity.SMSVehicle.Add(vehicle);
}
}
SMSQueryVehicleService sqv = new SMSQueryVehicleService();
sqv.Add(entity);
rc.Message = "新增成功!";
rc.Result = true;
}
catch (Exception ex)
{
rc.Result = false;
rc.Message = ex.Message;
Logger.Error(ex.Message, ex);
}
return rc;
}
public ESMSQueryInfoViewModel GetSMSQueryListViewModel(SmsQueryVehicleParam para)
{
IList<Guid> vehicleCodeList = para.vehicleCodelist;
string customerName = para.CustomerName;
string telephone = para.Telphone;
string tenantCode = para.TenantCode;
int pageIndex = para.PageIndex;
int pageSize = para.PageSize;
try
{
SMSQueryVehicleService sqv = new SMSQueryVehicleService();
int rowCount = 0;
//IList<EMSMSQueryVehicle> queryList = sqv.GetSMSQueryList(vehicleCodeList, customerName, telephone, tenantCode, pageIndex, pageSize, ref rowCount);
//代码优化后
IList<EMSMSQueryVehicle> queryList = sqv.GetNewSMSQueryList(vehicleCodeList, customerName, telephone, tenantCode, pageIndex, pageSize, ref rowCount);
ESMSQueryInfoViewModel MSmsQuery = new ESMSQueryInfoViewModel();
if (queryList != null && queryList.Count > 0 && rowCount > 0)
{
List<ESMSQueryViewModel> list = new List<ESMSQueryViewModel>();
for (int i = 0; i < queryList.Count; i++)
{
EMSMSQueryVehicle entity = queryList[i];
ESMSQueryViewModel model = new ESMSQueryViewModel();
model.Index = i + 1;
model.sms_vehicle_set_id = entity.sms_vehicle_set_id;
model.CreateDate = entity.CreateDate;
model.CustomerName = entity.CustomerName;
model.CustomerTelephone = entity.CustomerTelephone;
model.IsProfessional = entity.IsProfessional;
model.TenantCode = entity.TenantCode;
model.LicenseNumberDesc = entity.LicenseNumberDesc;
model.VehicleCodeList = entity.VehicleList;
list.Add(model);
}
MSmsQuery.userListViewModel = list;
MSmsQuery.RowCount = rowCount;
}
return MSmsQuery;
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
return null;
}
}
public ActionResult CreateSMSQuery(string customerName, string telphone, string vehicleCodes, string LicenceNumbers)
{
if (string.IsNullOrEmpty(customerName))
{
return Json(new
{
result = 0,
data = "请输入姓名!"
});
}
if (string.IsNullOrEmpty(telphone))
{
return Json(new
{
result = 0,
data = "请输入手机号码!"
});
}
List<Guid> codes = new List<Guid>();
if (!string.IsNullOrEmpty(vehicleCodes))
{
string[] codeArray = vehicleCodes.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
int length = codeArray.Count();
for (int i = 0; i < length; i++)
{
codes.Add(new Guid(codeArray[i]));
}
}
if (codes.Count <= 0)
{
return Json(new
{
result = 0,
data = "请选择查询车辆!"
});
}
List<string> licenceList = new List<string>();
if (!string.IsNullOrEmpty(LicenceNumbers))
{
string[] licenceArray = LicenceNumbers.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
int length = licenceArray.Count();
for (int i = 0; i < length; i++)
{
licenceList.Add(licenceArray[i]);
}
}
if (licenceList.Count <= 0)
{
return Json(new
{
result = 0,
data = "请选择查询车辆!"
});
}
SmsQueryVehicleParam param = new SmsQueryVehicleParam();
param.CustomerName = customerName;
param.TenantCode = SessionUserInfo.TenantCode;
param.vehicleCodelist = codes;
param.Telphone = telphone;
param.LicenceNumberlist = licenceList;
List<object> list = _ISysSettingWCFService.GetUeslessVehicle(SessionUserInfo.SelectedUser.TenantCode);
if (list != null && list.Count > 0)
{
List<string> msgList = new List<string>();
for (int i = 0; i < list.Count; i++)
{
for (int j = 0; j < codes.Count; j++)
{
if (list[i].ToString() == codes[j].ToString())
{
if (licenceList.Count > j)
{
msgList.Add(licenceList[j]);
break;
}
}
}
}
if (msgList.Count > 0)
{
return Json(new
{
result = 0,
data = string.Format("操作失败,以下车辆已被关注5次\r\n{0}\r\n请重新选择车辆", string.Join(",", msgList.ToArray()))
});
}
}
ResultContent DBresult = _ISysSettingWCFService.AddSMSQuery(param);
return Json(new
{
result = DBresult.Result ? 1 : 0,
data = DBresult.Message
});
}
public ActionResult SearchSMSQuery(string customerName, string vehicleCodes, string telphone)
{
List<Guid> codes = new List<Guid>();
if (!string.IsNullOrEmpty(vehicleCodes))
{
string[] codeArray = vehicleCodes.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
int length = codeArray.Count();
for (int i = 0; i < length; i++)
{
codes.Add(new Guid(codeArray[i]));
}
}
SmsQueryVehicleParam param = new SmsQueryVehicleParam();
param.CustomerName = customerName;
param.vehicleCodelist = codes;
param.Telphone = telphone;
param.TenantCode = SessionUserInfo.TenantCode;
param.PageIndex = PageIndex;
param.PageSize = PageSize;
ESMSQueryInfoViewModel vmList = _ISysSettingWCFService.GetSMSQueryListViewModel(param);
if (vmList == null || vmList.userListViewModel == null || vmList.userListViewModel.Count <= 0)
{
return null;
}
var query = from u in vmList.userListViewModel
select new
{
cell = new string[]{
"",//操作列
u.CustomerName,
u.CustomerTelephone,
u.LicenseNumberDesc,
u.sms_vehicle_set_id.ToString(),
u.VehicleCodeList
}
};
var result = new
{
total = vmList.RowCount / Convert.ToInt32(PageSize) + 1,
page = GridPageIndex,
records = vmList.RowCount,
rows = query
};
return Json(result, JsonRequestBehavior.AllowGet);
}
public ActionResult SaveSMSQuery(ulong smsID, string customerName, string telphone, string vehicleCodes, string LicenceNumbers)
{
if (string.IsNullOrEmpty(customerName))
{
return Json(new
{
result = 0,
data = "请输入姓名!"
});
}
if (string.IsNullOrEmpty(telphone))
{
return Json(new
{
result = 0,
data = "请输入手机号码!"
});
}
List<Guid> codes = new List<Guid>();
if (!string.IsNullOrEmpty(vehicleCodes))
{
string[] codeArray = vehicleCodes.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
int length = codeArray.Count();
for (int i = 0; i < length; i++)
{
codes.Add(new Guid(codeArray[i]));
}
}
if (codes.Count <= 0)
{
return Json(new
{
result = 0,
data = "请选择查询车辆!"
});
}
List<string> licenceList = new List<string>();
if (!string.IsNullOrEmpty(LicenceNumbers))
{
string[] licenceArray = LicenceNumbers.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
int length = licenceArray.Count();
for (int i = 0; i < length; i++)
{
licenceList.Add(licenceArray[i]);
}
}
if (licenceList.Count <= 0)
{
return Json(new
{
result = 0,
data = "请选择查询车辆!"
});
}
WebManagerWCFService webManagerService = new WebManagerWCFService();
List<string> msgList = new List<string>();
for (int i = 0; i < codes.Count; i++)
{
List<ulong> smsIDList = webManagerService.GetSmsQuerySmsIDList(SessionUserInfo.SelectedUser.TenantCode, codes[i].ToString());
if (smsIDList.Count > 5 || smsIDList.Count == 5 && !smsIDList.Contains(smsID))
{
msgList.Add(licenceList[i]);
}
}
if (msgList.Count > 0)
{
return Json(new
{
result = 0,
data = string.Format("操作失败,以下车辆已被关注5次\r\n{0}\r\n请重新选择车辆", string.Join(",", msgList.ToArray()))
});
}
SmsQueryVehicleParam param = new SmsQueryVehicleParam();
param.smsid = smsID;
param.CustomerName = customerName;
param.TenantCode = SessionUserInfo.TenantCode;
param.vehicleCodelist = codes;
param.Telphone = telphone;
param.LicenceNumberlist = licenceList;
ResultContent DBresult = _ISysSettingWCFService.UpdateSMSQuery(param);
return Json(new
{
result = DBresult.Result ? 1 : 0,
data = DBresult.Message
});
}
