public bx_carinfo FindVinCarInfo(string carVin, int renewaltype = 0)
{
bx_carinfo carinfo = new bx_carinfo();
try
{
carinfo = DataContextFactory.GetDataContext().bx_carinfo.FirstOrDefault(x => x.vin_no == carVin && x.RenewalCarType == renewaltype);
}
catch (Exception ex)
{
logError.Info("发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException);
}
return(carinfo);
}
public bx_carinfo Find(string licenseno)
{
bx_carinfo carinfo = new bx_carinfo();
try
{
carinfo = DataContextFactory.GetDataContext().bx_carinfo.FirstOrDefault(x => x.license_no == licenseno);
}
catch (Exception ex)
{
logError.Info("发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException);
}
return(carinfo);
}
/// <summary>
/// 续保信息的userinfo部分
/// </summary>
/// <param name="userinfo"></param>
/// <param name="renewal"></param>
/// <param name="carinfo"></param>
/// <param name="lastinfo"></param>
/// <param name="timeFormat"></param>
/// <returns></returns>
public static UserInfoViewModel ConvertToViewModel(this bx_userinfo userinfo, bx_car_renewal renewal, bx_carinfo carinfo, bx_lastinfo lastinfo, int timeFormat = 0)
{
var model = new UserInfoViewModel();
model.Buid = userinfo.Id.ToString();
try
{
if (renewal != null)
{
model.BizNo = string.IsNullOrWhiteSpace(renewal.BizNO) ? string.Empty : renewal.BizNO;
model.ForceNo = string.IsNullOrWhiteSpace(renewal.ForceNO) ? string.Empty : renewal.ForceNO;
model.InsuredIdCard = string.IsNullOrWhiteSpace(renewal.InsuredIdCard)
? string.Empty
: renewal.InsuredIdCard;
model.InsuredIdType = renewal.InsuredIdType.HasValue ? renewal.InsuredIdType.Value : 0;
//model.InsuredMobile = string.IsNullOrWhiteSpace(renewal.InsuredMobile)
// ? string.Empty
// : renewal.InsuredMobile.IndexOf("*", System.StringComparison.Ordinal) >= 0 ? string.Empty : renewal.InsuredMobile;
//model.HolderMobile = string.IsNullOrWhiteSpace(renewal.HolderMobile)
// ? string.Empty
// : renewal.HolderMobile.IndexOf("*", System.StringComparison.Ordinal) >= 0 ? string.Empty : renewal.HolderMobile;
model.InsuredMobile = string.Empty;
model.HolderMobile = string.Empty;
model.HolderIdCard = string.IsNullOrWhiteSpace(renewal.HolderIdCard)
? string.Empty
: renewal.HolderIdCard;
model.HolderIdType = renewal.HolderIdType.HasValue ? renewal.HolderIdType.Value : 0;
model.HolderName = string.IsNullOrWhiteSpace(renewal.HolderName)
? string.Empty
: renewal.HolderName;
//model.LicenseOwner = string.IsNullOrWhiteSpace(renewal) ? string.Empty : renewal.HolderName;
model.PostedName = string.IsNullOrWhiteSpace(renewal.HolderName) ? string.Empty : renewal.HolderName;
model.InsuredName = string.IsNullOrWhiteSpace(renewal.InsuredName) ? string.Empty : renewal.InsuredName;
model.RateFactor1 = renewal.RateFactor1.HasValue ? renewal.RateFactor1.Value : 0;
model.RateFactor2 = renewal.RateFactor2.HasValue ? renewal.RateFactor2.Value : 0;
model.RateFactor3 = renewal.RateFactor3.HasValue ? renewal.RateFactor3.Value : 0;
model.RateFactor4 = renewal.RateFactor4.HasValue ? renewal.RateFactor4.Value : 0;
model.ForceExpireDate = renewal.LastForceEndDate.HasValue ? (timeFormat == 1 ? renewal.LastForceEndDate.Value.ToString("yyyy-MM-dd HH:mm:ss") : renewal.LastForceEndDate.Value.ToString("yyyy-MM-dd")) : string.Empty;
model.BusinessExpireDate = renewal.LastBizEndDate.HasValue ? (timeFormat == 1 ? renewal.LastBizEndDate.Value.ToString("yyyy-MM-dd HH:mm:ss") : renewal.LastBizEndDate.Value.ToString("yyyy-MM-dd")) : string.Empty;
model.NextForceStartDate = (renewal.NextForceStartDate.HasValue
? (timeFormat == 1 ? renewal.NextForceStartDate.Value.ToString("yyyy-MM-dd HH:mm:ss") : renewal.NextForceStartDate.Value.ToString("yyyy-MM-dd"))
: string.Empty);
model.NextBusinessStartDate = (renewal.NextBizStartDate.HasValue
? (timeFormat == 1 ? renewal.NextBizStartDate.Value.ToString("yyyy-MM-dd HH:mm:ss") : renewal.NextBizStartDate.Value.ToString("yyyy-MM-dd"))
: string.Empty);
if (!string.IsNullOrWhiteSpace(model.ForceExpireDate))
{
var fd = DateTime.Parse(model.ForceExpireDate);
if (fd.Date == DateTime.MinValue.Date)
{
model.ForceExpireDate = "";
}
else
{
model.ForceExpireDate = timeFormat == 1 ? DateTime.Parse(model.ForceExpireDate).ToString("yyyy-MM-dd HH:mm:ss") : DateTime.Parse(model.ForceExpireDate).ToString("yyyy-MM-dd");
}
}
if (!string.IsNullOrWhiteSpace(model.BusinessExpireDate))
{
var bd = DateTime.Parse(model.BusinessExpireDate);
if (bd.Date == DateTime.MinValue.Date)
{
model.BusinessExpireDate = "";
}
else
{
model.BusinessExpireDate = timeFormat == 1 ? DateTime.Parse(model.BusinessExpireDate).ToString("yyyy-MM-dd HH:mm:ss") : DateTime.Parse(model.BusinessExpireDate).ToString("yyyy-MM-dd");
}
}
if (!string.IsNullOrWhiteSpace(model.NextForceStartDate))
{
var nf = DateTime.Parse(model.NextForceStartDate);
if (nf.Date == DateTime.MinValue.Date)
{
model.NextForceStartDate = "";
}
}
if (!string.IsNullOrWhiteSpace(model.NextBusinessStartDate))
{
var nb = DateTime.Parse(model.NextBusinessStartDate);
if (nb.Date == DateTime.MinValue.Date)
{
model.NextBusinessStartDate = "";
}
}
model.Organization = renewal.Organization ?? string.Empty;
//新增的投保人生日和性别
model.HolderBirthday = renewal.HolderBirthday ?? string.Empty;
if (!string.IsNullOrEmpty(model.HolderBirthday) && Convert.ToDateTime(model.HolderBirthday).Year == DateTime.MinValue.Year)
{
model.HolderBirthday = string.Empty;
}
model.HolderSex = (renewal.HolderSex ?? 0).ToString();
//新增的被保险人生日和性别
model.InsuredBirthday = renewal.InsuredBirthday ?? string.Empty;
if (!string.IsNullOrEmpty(model.InsuredBirthday) && Convert.ToDateTime(model.InsuredBirthday).Year == DateTime.MinValue.Year)
{
model.InsuredBirthday = string.Empty;
}
model.InsuredSex = (renewal.InsuredSex ?? 0).ToString();
}
else
{
model.ForceExpireDate = string.Empty;
model.BusinessExpireDate = string.Empty;
model.NextForceStartDate = string.Empty;
model.NextBusinessStartDate = string.Empty;
model.InsuredIdCard = string.Empty;
model.InsuredIdType = 0;
model.InsuredMobile = string.Empty;
model.HolderMobile = string.Empty;
model.HolderIdCard = string.Empty;
model.HolderIdType = 0;
model.HolderName = string.Empty;
model.RateFactor1 = 0;
model.RateFactor2 = 0;
model.RateFactor3 = 0;
model.RateFactor4 = 0;
model.BizNo = string.Empty;
model.ForceNo = string.Empty;
model.PostedName = string.Empty;
model.InsuredName = string.Empty;
model.Organization = string.Empty;
model.HolderBirthday = string.Empty;
model.HolderSex = string.Empty;
model.InsuredBirthday = string.Empty;
model.InsuredSex = string.Empty;
}
if (carinfo != null)
{
model.FuelType = carinfo.fuel_type.HasValue ? carinfo.fuel_type.Value : 0;
model.ProofType = carinfo.proof_type.HasValue ? carinfo.proof_type.Value : 0;
model.LicenseColor = carinfo.license_color.HasValue ? carinfo.license_color.Value : 0;
model.ClauseType = carinfo.clause_type.HasValue ? carinfo.clause_type.Value : 0;
model.RunRegion = carinfo.run_region.HasValue ? carinfo.run_region.Value : 0;
model.CarUsedType = carinfo.car_used_type.HasValue ? carinfo.car_used_type.Value : 0;
model.CredentislasNum = string.IsNullOrWhiteSpace(carinfo.owner_idno) ? string.Empty : carinfo.owner_idno;
model.IdType = carinfo.owner_idno_type.HasValue ? carinfo.owner_idno_type.Value : 0;
model.PurchasePrice = (double)(carinfo.purchase_price.HasValue ? carinfo.purchase_price.Value : 0);
model.SeatCount = carinfo.seat_count.HasValue ? carinfo.seat_count.Value : 0;
model.ExhaustScale = carinfo.exhaust_scale.HasValue ? carinfo.exhaust_scale.ToString() : "0";
model.LicenseOwner = string.IsNullOrWhiteSpace(carinfo.license_owner) ? string.Empty : carinfo.license_owner;
model.CarType = (carinfo.car_type ?? 0).ToString();
model.CarVin = carinfo.vin_no ?? string.Empty;
model.EngineNo = carinfo.engine_no ?? string.Empty;
model.RegisterDate = carinfo.register_date.HasValue ? carinfo.register_date.Value.ToString("yyyy-MM-dd") : string.Empty;
model.ModleName = carinfo.mold_name ?? string.Empty;
//新增的车主生日和性别
model.OwnerBirthday = carinfo.OwnerBirthday ?? string.Empty;
if (!string.IsNullOrEmpty(model.OwnerBirthday) && Convert.ToDateTime(model.OwnerBirthday).Year == DateTime.MinValue.Year)
{
model.OwnerBirthday = string.Empty;
}
model.OwnerSex = (carinfo.OwnerSex ?? 0).ToString();
}
else
{
model.FuelType = 0;
model.ProofType = 0;
model.LicenseColor = 0;
model.ClauseType = 0;
model.RunRegion = 0;
model.CarUsedType = 0;
model.CredentislasNum = string.Empty;
model.IdType = 0;
model.ExhaustScale = string.Empty;
model.LicenseOwner = string.Empty;
model.CarType = string.Empty;
model.CarVin = string.IsNullOrWhiteSpace(userinfo.CarVIN) ? string.Empty : userinfo.CarVIN;
model.EngineNo = string.IsNullOrWhiteSpace(userinfo.EngineNo) ? string.Empty : userinfo.EngineNo;
model.RegisterDate = string.IsNullOrWhiteSpace(userinfo.RegisterDate) ? string.Empty : userinfo.RegisterDate;
model.ModleName = string.IsNullOrWhiteSpace(userinfo.MoldName) ? string.Empty : userinfo.MoldName;
model.OwnerSex = string.Empty;
model.OwnerBirthday = string.Empty;
}
//model.CarVin = string.IsNullOrWhiteSpace(userinfo.CarVIN) ? string.Empty : userinfo.CarVIN;
model.CityCode = !string.IsNullOrWhiteSpace(userinfo.CityCode) ? Convert.ToInt32(userinfo.CityCode) : 1;
//model.EngineNo = string.IsNullOrWhiteSpace(userinfo.EngineNo) ? string.Empty : userinfo.EngineNo;
model.LicenseNo = string.IsNullOrWhiteSpace(userinfo.LicenseNo) ? string.Empty : userinfo.LicenseNo;
//model.LicenseOwner = string.IsNullOrWhiteSpace(userinfo.LicenseOwner) ? string.Empty : userinfo.LicenseOwner;
//model.ModleName = string.IsNullOrWhiteSpace(userinfo.MoldName) ? string.Empty : userinfo.MoldName;
//model.RegisterDate = string.IsNullOrWhiteSpace(userinfo.RegisterDate) ? string.Empty : userinfo.RegisterDate;
if (!string.IsNullOrWhiteSpace(model.RegisterDate))
{
if (model.RegisterDate.Equals(DateTime.MinValue.ToString("yyyy-MM-dd")))
{
model.RegisterDate = "";
}
}
//model.PostedName = model.HolderName;
//model.InsuredName = string.IsNullOrWhiteSpace(userinfo.InsuredName) ? string.Empty : userinfo.InsuredName;
model.HolderName = null;
model.RenewalCarType = (userinfo.RenewalCarType ?? 0).ToString();
}
catch (Exception ex)
{
log.Info("模型转换报错:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException);
}
return(model);
}