/// <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)); }