/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.OrderBuyCarInfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@TaskID", SqlDbType.BigInt, 8),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@Age", SqlDbType.Int, 4),
new SqlParameter("@IDCard", SqlDbType.VarChar, 50),
new SqlParameter("@Vocation", SqlDbType.Int, 4),
new SqlParameter("@Marriage", SqlDbType.Int, 4),
new SqlParameter("@Income", SqlDbType.Int, 4),
new SqlParameter("@CarBrandId", SqlDbType.Int, 4),
new SqlParameter("@CarSerialId", SqlDbType.Int, 4),
new SqlParameter("@CarName", SqlDbType.NVarChar, 200),
new SqlParameter("@IsAttestation", SqlDbType.Int, 4),
new SqlParameter("@DriveAge", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.NVarChar, 200),
new SqlParameter("@CarNo", SqlDbType.NVarChar, 200),
new SqlParameter("@Remark", SqlDbType.NVarChar, 2000),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@LastModifyTime", SqlDbType.DateTime),
new SqlParameter("@LastModifyUserID", SqlDbType.Int, 4),
new SqlParameter("@CarTypeID", SqlDbType.Int, 4)
};
parameters[0].Value = model.TaskID;
parameters[1].Value = model.Type;
parameters[2].Value = model.Age;
parameters[3].Value = model.IDCard;
parameters[4].Value = model.Vocation;
parameters[5].Value = model.Marriage;
parameters[6].Value = model.Income;
parameters[7].Value = model.CarBrandId;
parameters[8].Value = model.CarSerialId;
parameters[9].Value = model.CarName;
parameters[10].Value = model.IsAttestation;
parameters[11].Value = model.DriveAge;
parameters[12].Value = model.UserName;
parameters[13].Value = model.CarNo;
parameters[14].Value = model.Remark;
parameters[15].Value = model.Status;
parameters[16].Value = model.CreateTime;
parameters[17].Value = model.CreateUserID;
parameters[18].Value = model.LastModifyTime;
parameters[19].Value = model.LastModifyUserID;
parameters[20].Value = model.CarTypeID;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_ORDERBUYCARINFO_UPDATE, parameters));
}
private void subbugcarinfo(out string msg)
{
msg = string.Empty;
Entities.OrderBuyCarInfo Model = new Entities.OrderBuyCarInfo();
Model.Age = Age;
Model.CarBrandId = CarBrandID;
Model.CarSerialId = CarSerialID;
Model.CarTypeID = CarTypeID;
Model.CarName = CarName;
Model.CarNo = CarNo;
Model.DriveAge = DriveAge;
Model.Income = InCome;
Model.IsAttestation = IsAttestation;
Model.Marriage = Marriage;
Model.IDCard = IDCard;
Model.Remark = Remark;
Model.Status = 0;
Model.Vocation = Vocation;
Model.UserName = UserName;
Model.Type = Type;
Model.TaskID = Convert.ToInt32(TaskID);
Model.CreateTime = System.DateTime.Now;
Model.CreateUserID = (int?)BLL.Util.GetLoginUserID();
Model.LastModifyTime = System.DateTime.Now;
Model.LastModifyUserID = (int?)BLL.Util.GetLoginUserID();
try
{
if (BLL.OrderBuyCarInfo.Instance.IsExistsByTaskID(Model.TaskID))
{
BLL.OrderBuyCarInfo.Instance.Update(Model);
BLL.Util.InsertUserLog("更新任务id为【" + Model.TaskID + "】的客户分类为已购车未购车信息。");
}
else
{
BLL.OrderBuyCarInfo.Instance.Insert(Model);
BLL.Util.InsertUserLog("插入任务id为【" + Model.TaskID + "】的客户分类为已购车未购车信息。");
}
msg = "success";
}
catch (Exception ex)
{
msg = "已购车未购车信息保存失败，失败原因：" + ex.Message.ToString();
}
}
private Entities.OrderBuyCarInfo LoadSingleOrderBuyCarInfo(DataRow row)
{
Entities.OrderBuyCarInfo model = new Entities.OrderBuyCarInfo();
if (row["TaskID"].ToString() != "")
{
model.TaskID = long.Parse(row["TaskID"].ToString());
}
if (row["Type"].ToString() != "")
{
model.Type = int.Parse(row["Type"].ToString());
}
if (row["Age"].ToString() != "")
{
model.Age = int.Parse(row["Age"].ToString());
}
model.IDCard = row["IDCard"].ToString();
if (row["Vocation"].ToString() != "")
{
model.Vocation = int.Parse(row["Vocation"].ToString());
}
if (row["Marriage"].ToString() != "")
{
model.Marriage = int.Parse(row["Marriage"].ToString());
}
if (row["Income"].ToString() != "")
{
model.Income = int.Parse(row["Income"].ToString());
}
if (row["CarBrandId"].ToString() != "")
{
model.CarBrandId = int.Parse(row["CarBrandId"].ToString());
}
if (row["CarSerialId"].ToString() != "")
{
model.CarSerialId = int.Parse(row["CarSerialId"].ToString());
}
if (row["CarTypeID"].ToString() != "")
{
model.CarTypeID = int.Parse(row["CarTypeID"].ToString());
}
model.CarName = row["CarName"].ToString();
if (row["IsAttestation"].ToString() != "")
{
model.IsAttestation = int.Parse(row["IsAttestation"].ToString());
}
if (row["DriveAge"].ToString() != "")
{
model.DriveAge = int.Parse(row["DriveAge"].ToString());
}
model.UserName = row["UserName"].ToString();
model.CarNo = row["CarNo"].ToString();
model.Remark = row["Remark"].ToString();
if (row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreateUserID"].ToString() != "")
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
if (row["LastModifyTime"].ToString() != "")
{
model.LastModifyTime = DateTime.Parse(row["LastModifyTime"].ToString());
}
if (row["LastModifyUserID"].ToString() != "")
{
model.LastModifyUserID = int.Parse(row["LastModifyUserID"].ToString());
}
return(model);
}
private void CustBaseInfoBind()
{
if (!string.IsNullOrEmpty(RequstTaskID))
{
//判断数据来源
Entities.OrderTask model = BLL.OrderTask.Instance.GetOrderTask(Convert.ToInt32(RequstTaskID));
if (model != null)
{
//未购车，试驾
if (model.Source == 1 || model.Source == 3)
{
Entities.OrderNewCar custBasicInfo = BLL.OrderNewCar.Instance.GetOrderNewCar(Convert.ToInt32(RequstTaskID));
if (custBasicInfo != null)
{
CustName = custBasicInfo.UserName;
if (custBasicInfo.UserGender == 1)
{
Sex = "先生";
}
else if (custBasicInfo.UserGender == 2)
{
Sex = "女士";
}
Address = custBasicInfo.UserAddress;
if (custBasicInfo.ProvinceID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
PlaceStr += BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(custBasicInfo.ProvinceID.ToString());
}
if (custBasicInfo.CityID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
PlaceStr += "," + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(custBasicInfo.CityID.ToString());
}
if (custBasicInfo.CountyID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
PlaceStr += "," + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(custBasicInfo.CountyID.ToString());
}
AreaStr = BLL.Util.GetEnumOptText(typeof(Entities.EnumArea), (int)custBasicInfo.AreaID);
CustCategoryStr = "未购车";
if (!string.IsNullOrEmpty(custBasicInfo.UserMobile) && !string.IsNullOrEmpty(custBasicInfo.UserPhone))
{
Tels = custBasicInfo.UserPhone + "," + custBasicInfo.UserMobile;
}
else if (!string.IsNullOrEmpty(custBasicInfo.UserMobile))
{
Tels = custBasicInfo.UserMobile;
}
else
{
Tels = custBasicInfo.UserPhone;
}
Email = custBasicInfo.UserMail;
}
}
//已购车
else
{
Entities.OrderRelpaceCar custBasicInfo = BLL.OrderRelpaceCar.Instance.GetOrderRelpaceCar(Convert.ToInt32(RequstTaskID));
if (custBasicInfo != null)
{
CustName = custBasicInfo.UserName;
if (custBasicInfo.UserGender == 1)
{
Sex = "先生";
}
else if (custBasicInfo.UserGender == 2)
{
Sex = "女士";
}
Address = custBasicInfo.UserAddress;
if (custBasicInfo.ProvinceID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
PlaceStr += BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(custBasicInfo.ProvinceID.ToString());
}
if (custBasicInfo.CityID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
PlaceStr += "," + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(custBasicInfo.CityID.ToString());
}
if (custBasicInfo.CountyID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
PlaceStr += "," + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(custBasicInfo.CountyID.ToString());
}
AreaStr = BLL.Util.GetEnumOptText(typeof(Entities.EnumArea), (int)custBasicInfo.AreaID);
CustCategoryStr = "已购车";
if (!string.IsNullOrEmpty(custBasicInfo.UserMobile) && !string.IsNullOrEmpty(custBasicInfo.UserPhone))
{
Tels = custBasicInfo.UserPhone + "," + custBasicInfo.UserMobile;
}
else if (!string.IsNullOrEmpty(custBasicInfo.UserMobile))
{
Tels = custBasicInfo.UserMobile;
}
else
{
Tels = custBasicInfo.UserPhone;
}
Email = custBasicInfo.UserMail;
}
}
///更具已购车未购车表确定Type
Entities.OrderBuyCarInfo modelOrderbuyCar = null;
modelOrderbuyCar = BLL.OrderBuyCarInfo.Instance.GetOrderBuyCarInfo(Convert.ToInt32(RequstTaskID));
if (modelOrderbuyCar != null)
{
if (modelOrderbuyCar.Type == 2)
{
CustCategoryStr = "未购车";
}
else
{
CustCategoryStr = "已购车";
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlAreaBind();
//ddlDataSourceBind();
if (!string.IsNullOrEmpty(RequstTaskID))
{
//判断数据来源
Entities.OrderTask model = BLL.OrderTask.Instance.GetOrderTask(Convert.ToInt32(RequstTaskID));
if (model != null)
{
//未购车,试驾
if (model.Source == 1 || model.Source == 3)
{
this.rdoNoCar.Checked = true;
Entities.OrderNewCar custBasicInfo = BLL.OrderNewCar.Instance.GetOrderNewCar(Convert.ToInt32(RequstTaskID));
if (custBasicInfo != null)
{
this.txtCustName.Value = custBasicInfo.UserName;
this.txtAddress.Value = custBasicInfo.UserAddress;
ProvinceID = custBasicInfo.ProvinceID.ToString();
CityID = custBasicInfo.CityID.ToString();
CountyID = custBasicInfo.CountyID.ToString();
//ddlDataSource.Value = "易湃";
if (custBasicInfo.UserGender == 1)
{
rdoMan.Checked = true;
}
else
{
rdoWomen.Checked = true;
}
ddlArea.Value = custBasicInfo.AreaID.ToString();
txtTel1.Value = custBasicInfo.UserPhone;
txtTel2.Value = custBasicInfo.UserMobile;
txtEmail.Value = custBasicInfo.UserMail;
}
}
//已购车
else
{
this.rdoHavCar.Checked = true;
Entities.OrderRelpaceCar custBasicInfo = BLL.OrderRelpaceCar.Instance.GetOrderRelpaceCar(Convert.ToInt32(RequstTaskID));
if (custBasicInfo != null)
{
this.txtCustName.Value = custBasicInfo.UserName;
this.txtAddress.Value = custBasicInfo.UserAddress;
ProvinceID = custBasicInfo.ProvinceID.ToString();
CityID = custBasicInfo.CityID.ToString();
CountyID = custBasicInfo.CountyID.ToString();
//ddlDataSource.Value = "易湃";
if (custBasicInfo.UserGender == 1)
{
rdoMan.Checked = true;
}
else
{
rdoWomen.Checked = true;
}
ddlArea.Value = custBasicInfo.AreaID.ToString();
txtTel1.Value = custBasicInfo.UserPhone;
txtTel2.Value = custBasicInfo.UserMobile;
txtEmail.Value = custBasicInfo.UserMail;
}
}
///更具已购车未购车表确定Type
Entities.OrderBuyCarInfo modelOrderbuyCar = null;
modelOrderbuyCar = BLL.OrderBuyCarInfo.Instance.GetOrderBuyCarInfo(Convert.ToInt32(RequstTaskID));
if (modelOrderbuyCar != null)
{
if (modelOrderbuyCar.Type == 2)
{
this.rdoNoCar.Checked = true;
this.rdoHavCar.Checked = false;
}
else
{
this.rdoHavCar.Checked = true;
this.rdoNoCar.Checked = false;
}
}
}
}
}
}
private void GetBuyCarModel(string TaskID)
{
if (!string.IsNullOrEmpty(TaskID))
{
long _taskID = Convert.ToInt32(TaskID);
//数据来源
Entities.OrderTask model = BLL.OrderTask.Instance.GetOrderTask(_taskID);
if (model != null)
{
Type = model.Source.ToString();
}
BuyCarInfoModel = BLL.OrderBuyCarInfo.Instance.GetOrderBuyCarInfo(_taskID);
if (BuyCarInfoModel != null)
{
//汽车品牌
CarBrandID = Convert.ToInt32(BuyCarInfoModel.CarBrandId);
//汽车系列
CarSerialID = Convert.ToInt32(BuyCarInfoModel.CarSerialId);
CarTypeID = Convert.ToInt32(BuyCarInfoModel.CarTypeID);
}
if (BuyCarInfoModel == null)
{
BuyCarInfoModel = new Entities.OrderBuyCarInfo();
}
//1,3都从新车里取数据，modify by qizq 2013-7-19
switch (model.Source)
{
case 1:
Entities.OrderNewCar model_newCar = new Entities.OrderNewCar();
model_newCar = BLL.OrderNewCar.Instance.GetOrderNewCar(_taskID);
if (model_newCar != null)
{
//易湃订单ID
YPOrderID = model_newCar.YPOrderID.ToString();
}
break;
case 3:
Entities.OrderNewCar model_newCar1 = new Entities.OrderNewCar();
model_newCar1 = BLL.OrderNewCar.Instance.GetOrderNewCar(_taskID);
if (model_newCar1 != null)
{
//易湃订单ID
YPOrderID = model_newCar1.YPOrderID.ToString();
}
break;
case 2:
Entities.OrderRelpaceCar model_relpaceCar = new Entities.OrderRelpaceCar();
model_relpaceCar = BLL.OrderRelpaceCar.Instance.GetOrderRelpaceCar(_taskID);
if (model_relpaceCar != null)
{
//易湃订单ID
YPOrderID = model_relpaceCar.YPOrderID.ToString();
}
break;
}
}
}
private void GetBuyCarModel(string TaskID)
{
if (!string.IsNullOrEmpty(TaskID))
{
OrderTask OrderTask = BLL.OrderTask.Instance.GetOrderTask(Convert.ToInt32(TaskID));
if (OrderTask != null)
{
CreateTime = Convert.ToDateTime(OrderTask.CreateTime.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
}
Entities.OrderBuyCarInfo BuyCarModel = BLL.OrderBuyCarInfo.Instance.GetOrderBuyCarInfo(Convert.ToInt32(TaskID));
if (BuyCarModel != null)
{
//年龄
if (BuyCarModel.Age > 0)
{
this.lblAge.Text = BuyCarModel.Age.ToString();
}
//身份证号码
this.lblIDCard.Text = BuyCarModel.IDCard;
//婚姻状态
if (BuyCarModel.Marriage != -2)
{
if (BuyCarModel.Marriage.ToString() == "1")
{
this.lblMarriage.Text = "已婚";
}
else
{
this.lblMarriage.Text = "未婚";
}
}
//车型名称
//this.lblCarName.Text = BuyCarModel.CarName;
//认证车主
if (BuyCarModel.IsAttestation >= 0)
{
if (BuyCarModel.IsAttestation == 1)
{
this.lbllegalize.Text = "是";
}
else if (BuyCarModel.IsAttestation == 0)
{
this.lbllegalize.Text = "否";
}
}
//驾龄
if (BuyCarModel.DriveAge > 0)
{
this.lblDriveAge.Text = BuyCarModel.DriveAge.ToString();
}
//用户名
this.lblUserName.Text = BuyCarModel.UserName.ToString();
//车牌号
this.lblCarNumber.Text = BuyCarModel.CarNo.ToString();
//备注
this.lblNote.Text = BuyCarModel.Remark;
//职业
if (BuyCarModel.Vocation >= 0)
{
this.lblVocation.Text = BLL.Util.GetEnumOptText(typeof(CustVocation), Convert.ToInt32(BuyCarModel.Vocation));
}
//收入
if (BuyCarModel.Income >= 0)
{
this.lblInCome.Text = BLL.Util.GetEnumOptText(typeof(CustInCome), Convert.ToInt32(BuyCarModel.Income));
}
UpdateTime = Convert.ToDateTime(BuyCarModel.LastModifyTime.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
UpdateUser = BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(Convert.ToInt32(BuyCarModel.CreateUserID));
string carType = BLL.CarTypeAPI.Instance.GetCarTypeNameByCarTypeID(int.Parse(BuyCarModel.CarTypeID.ToString()));
string carMaster = BLL.CarTypeAPI.Instance.GetMasterBrandNameByMasterBrandID(int.Parse(BuyCarModel.CarBrandId.ToString()));
string carSerial = BLL.CarTypeAPI.Instance.GetSerialNameBySerialID(int.Parse(BuyCarModel.CarSerialId.ToString()));
if (!string.IsNullOrEmpty(carMaster))
{
lblCarName.Text += carMaster;
}
if (!string.IsNullOrEmpty(carSerial))
{
lblCarName.Text += "-" + carSerial;
}
if (!string.IsNullOrEmpty(carType))
{
lblCarName.Text += "-" + carType;
}
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.OrderBuyCarInfo model)
{
return(Dal.OrderBuyCarInfo.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.OrderBuyCarInfo model)
{
return(Dal.OrderBuyCarInfo.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(SqlTransaction sqltran, Entities.OrderBuyCarInfo model)
{
Dal.OrderBuyCarInfo.Instance.Insert(sqltran, model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Entities.OrderBuyCarInfo model)
{
Dal.OrderBuyCarInfo.Instance.Insert(model);
}