// 新增
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 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;
}
/// <summary>
/// 根据客户编码查询短信列表
/// </summary>
/// <param name="tenantCode"></param>
/// <returns></returns>
public List<EMSMSVehicle> GetSMSVehicle(string tenantCode)
{
List<EMSMSVehicle> smsVeList = new List<EMSMSVehicle>();
if (!string.IsNullOrEmpty(tenantCode))
{
string sCmdText = string.Format(@"select LicenseNumber,smsvehicle_id,TenantCode,VehicleCode from gps_SMSVehicle where tenantCode='{0}'", tenantCode);
using (DbDataReader sdr = MySqlDB.GetDataReader(CommandType.Text, sCmdText))
{
if (sdr != null)
{
while (sdr.Read())
{
EMSMSVehicle smsve = new EMSMSVehicle();
smsve.LicenseNumber = sdr["LicenseNumber"].ToString();
smsve.smsvehicle_id = sdr["smsvehicle_id"].ToULong();
smsve.TenantCode = sdr["TenantCode"].ToString();
smsve.VehicleCode = sdr["VehicleCode"].ToGuid();
smsVeList.Add(smsve);
}
}
sdr.Close();
}
}
return smsVeList;
}
