/// <summary>
/// 设置用户车主信息
/// </summary>
/// <param name="userId"></param>
/// <param name="carModelId"></param>
/// <param name="carNumber"></param>
/// <param name="carNumberTime"></param>
/// <param name="VIN"></param>
/// <param name="drivingLicenseType"></param>
/// <param name="drivingLicenseTime"></param>
/// <returns></returns>
public bool SetUserCarOwnerInfo(
string userId,
int carModelId,
string carNumber,
DateTime?carNumberTime,
string VIN,
string drivingLicenseType,
DateTime?drivingLicenseTime
)
{
/*车主信息：
* ex1 我的车型、
* ex2 车牌号码、
* ex3 vin号、
* ex4 车辆上牌时间（yyyy-MM-dd）、
* ex5 驾照领取时间 (yyyy-MM-dd)、
* ex6 驾照类型
*/
bool result = false;
var key = CommonPlatform.Helper.EnumStringHelper.ToString(Enums.UserExpandType.CarOwnerInfo);
Model.UserExpand data = new Model.UserExpand()
{
UserId = userId,
CreateTime = DateTime.Now,
Ex1 = carModelId.ToString(),
Ex2 = carNumber,
Ex3 = VIN,
Ex4 = carNumberTime == null ? "" : carNumberTime.Value.ToShortDateString(),
Ex5 = drivingLicenseTime == null ? "" : drivingLicenseTime.Value.ToShortDateString(),
Ex6 = drivingLicenseType,
DataType = key
};
var oldData = Get <Model.UserExpand>(string.Format(" UserId = '{0}' AND DataType = '{1}' ",
userId,
key
));
//查询是否有，有则更新无则新增
if (oldData != null)
{
oldData.Ex1 = data.Ex1;
oldData.Ex2 = data.Ex2;
oldData.Ex3 = data.Ex3;
oldData.Ex4 = data.Ex4;
oldData.Ex5 = data.Ex5;
oldData.Ex6 = data.Ex6;
result = Update(oldData);
}
else
{
result = Add(data);
}
return(result);
}
/// <summary>
/// 根据用户扩展信息获取车主信息
/// </summary>
/// <param name="userExp"></param>
/// <returns></returns>
public static CarOwnerInfo GetDataByUserExpand(UserExpand userExp)
{
CarOwnerInfo data = null;
if (userExp == null)
{
return(null);
}
data = new CarOwnerInfo();
/*车主信息：
* ex1 我的车型、
* ex2 车牌号码、
* ex3 vin号、
* ex4 车辆上牌时间（yyyy-MM-dd）、
* ex5 驾照领取时间 (yyyy-MM-dd)、
* ex6 驾照类型
*/
data.UserId = userExp.UserId;
data.CarModelId = Convert.ToInt32(userExp.Ex1);
data.CarNumber = userExp.Ex2;
data.VIN = userExp.Ex3;
data.DrivingLicenseType = userExp.Ex6;
DateTime carNumberTime, drivingLicenseTime;
if (DateTime.TryParse(userExp.Ex4, out carNumberTime))
{
data.CarNumberTime = carNumberTime;
}
if (DateTime.TryParse(userExp.Ex5, out drivingLicenseTime))
{
data.DrivingLicenseTime = drivingLicenseTime;
}
if (data.CarModelId > 0)
{
data.CarModel = new BLLCarLibrary().GetCarModelInfo(data.CarModelId);
}
return(data);
}
/// <summary>
/// 设置用户车型
/// </summary>
/// <param name="userId"></param>
/// <param name="carModelId"></param>
/// <returns></returns>
public bool SetUserCarModel(string userId, int carModelId)
{
/*车主信息：
* ex1 我的车型、
* ex2 车牌号码、
* ex3 vin号、
* ex4 车辆上牌时间（yyyy-MM-dd）、
* ex5 驾照领取时间 (yyyy-MM-dd)、
* ex6 驾照类型
*/
bool result = false;
var key = CommonPlatform.Helper.EnumStringHelper.ToString(Enums.UserExpandType.CarOwnerInfo);
Model.UserExpand data = new Model.UserExpand()
{
UserId = userId,
CreateTime = DateTime.Now,
Ex1 = carModelId.ToString(),
DataType = key
};
var oldData = Get <Model.UserExpand>(string.Format(" UserId = '{0}' AND DataType = '{1}' ",
userId,
key
));
//查询是否有，有则更新无则新增
if (oldData != null)
{
oldData.Ex1 = data.Ex1;
result = Update(oldData);
}
else
{
result = Add(data);
}
return(result);
}
/// <summary>
/// 更新扩展
/// </summary>
/// <param name="rtype"></param>
/// <param name="userId"></param>
/// <param name="DataValue"></param>
/// <returns></returns>
public bool UpdateUserExpand(BLLJIMP.Enums.UserExpandType rtype, string userId, string dataValue, string ex1 = "", string ex2 = "", string ex3 = "",
string ex4 = "", string ex5 = "", string ex6 = "", string ex7 = "", string ex8 = "", string ex9 = "", string ex10 = "")
{
Model.UserExpand data = GetUserExpand(rtype, userId);
if (data == null)
{
return(AddUserExpand(rtype, userId, dataValue, ex1, ex2, ex3, ex4, ex5, ex6, ex7, ex8, ex9, ex10));
}
data.DataValue = dataValue;
data.Ex1 = ex1;
data.Ex2 = ex2;
data.Ex3 = ex3;
data.Ex4 = ex4;
data.Ex5 = ex5;
data.Ex6 = ex6;
data.Ex7 = ex7;
data.Ex8 = ex8;
data.Ex9 = ex9;
data.Ex10 = ex10;
data.WebsiteOwner = WebsiteOwner;
return(Update(data));
}
/// <summary>
/// 添加扩展
/// </summary>
/// <param name="rtype"></param>
/// <param name="userId"></param>
/// <param name="dataValue"></param>
/// <returns></returns>
public bool AddUserExpand(BLLJIMP.Enums.UserExpandType rtype, string userId, string dataValue, string ex1 = "", string ex2 = "",
string ex3 = "", string ex4 = "", string ex5 = "", string ex6 = "", string ex7 = "", string ex8 = "", string ex9 = "", string ex10 = "")
{
Model.UserExpand data = new Model.UserExpand()
{
UserId = userId,
DataValue = dataValue,
CreateTime = DateTime.Now,
DataType = CommonPlatform.Helper.EnumStringHelper.ToString(rtype),
Ex1 = ex1,
Ex2 = ex2,
Ex3 = ex3,
Ex4 = ex4,
Ex5 = ex5,
Ex6 = ex6,
Ex7 = ex7,
Ex8 = ex8,
Ex9 = ex9,
Ex10 = ex10,
WebsiteOwner = WebsiteOwner
};
return(Add(data));
}
