/// <summary>
/// 绑定汽车品牌
/// </summary>
//private void BindCarBrand()
//{
// DataTable dt = BLL.BuyCarInfo.Instance.GetALLCarBrand();
// if (dt != null && dt.Rows.Count > 0)
// {
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// this.selCarBrandID.Items.Add(new ListItem(dt.Rows[i]["name"].ToString(), dt.Rows[i]["Brandid"].ToString()));
// }
// }
//}
private void GetBuyCarModel(string CustID)
{
System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
sw.Start();
if (!string.IsNullOrEmpty(CustID))
{
BuyCarInfoModel = BLL.BuyCarInfo.Instance.GetBuyCarInfo(CustID);
if (BuyCarInfoModel != null)
{
//汽车品牌
CarBrandID = Convert.ToInt32(BuyCarInfoModel.CarBrandId);
//汽车系列
CarSerialID = Convert.ToInt32(BuyCarInfoModel.CarSerialId);
CarTypeID = Convert.ToInt32(BuyCarInfoModel.CarTypeID);
}
}
if (BuyCarInfoModel == null)
{
BuyCarInfoModel = new Entities.BuyCarInfo();
}
logmsg = "（已" + sw.Elapsed.TotalSeconds.ToString("0.00") + "s）；";
sw.Stop();
}
private void subbugcarinfo(out string msg)
{
msg = string.Empty;
Entities.BuyCarInfo Model = new Entities.BuyCarInfo();
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.CustID = CustID;
Model.CreateTime = System.DateTime.Now;
Model.CreateUserID = (int?)BLL.Util.GetLoginUserID();
try
{
if (BLL.DealerInfo.Instance.IsExistsByCustID(Model.CustID))
{
BLL.DealerInfo.Instance.DeleteForSetStatus(Model.CustID);
//BLL.Util.InsertUserLog("删除客户id为" + Model.CustID + "，的车易通会员信息。");
BLL.DealerBrandInfo.Instance.Delete(Model.CustID);
//BLL.Util.InsertUserLog("删除客户id为" + Model.CustID + "，的经销商品牌信息。");
}
if (BLL.BuyCarInfo.Instance.IsExistsByCustID(Model.CustID))
{
BLL.BuyCarInfo.Instance.Update(Model);
BLL.Util.InsertUserLog("更新客户id为" + Model.CustID + "，客户分类为个人信息。");
}
else
{
BLL.BuyCarInfo.Instance.Insert(Model);
BLL.Util.InsertUserLog("插入客户id为" + Model.CustID + "，客户分类为个人信息。");
}
msg = "success";
}
catch (Exception ex)
{
msg = "个人信息保存失败，失败原因：" + ex.Message.ToString();
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(SqlTransaction tran, Entities.BuyCarInfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@CustID", SqlDbType.VarChar, 20),
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.NVarChar, 200),
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("@CarTypeID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.CustID;
parameters[2].Value = model.Type;
parameters[3].Value = model.Age;
parameters[4].Value = model.IDCard;
parameters[5].Value = model.Vocation;
parameters[6].Value = model.Marriage;
parameters[7].Value = model.Income;
parameters[8].Value = model.CarBrandId;
parameters[9].Value = model.CarSerialId;
parameters[10].Value = model.CarName;
parameters[11].Value = model.IsAttestation;
parameters[12].Value = model.DriveAge;
parameters[13].Value = model.UserName;
parameters[14].Value = model.CarNo;
parameters[15].Value = model.Remark;
parameters[16].Value = model.Status;
parameters[17].Value = model.CreateTime;
parameters[18].Value = model.CreateUserID;
parameters[19].Value = model.CarTypeID;
SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, P_BUYCARINFO_INSERT, parameters);
return((int)parameters[0].Value);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.BuyCarInfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@CustID", SqlDbType.VarChar, 20),
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),
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("@CarTypeID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RecID;
parameters[1].Value = model.CustID;
parameters[2].Value = model.Type;
parameters[3].Value = model.Age;
parameters[4].Value = model.IDCard;
parameters[5].Value = model.Vocation;
parameters[6].Value = model.Marriage;
parameters[7].Value = model.Income;
parameters[8].Value = model.CarBrandId;
parameters[9].Value = model.CarSerialId;
parameters[10].Value = model.CarName;
parameters[11].Value = model.IsAttestation;
parameters[12].Value = model.DriveAge;
parameters[13].Value = model.UserName;
parameters[14].Value = model.CarNo;
parameters[15].Value = model.Remark;
parameters[16].Value = model.Status;
parameters[17].Value = model.CreateTime;
parameters[18].Value = model.CreateUserID;
parameters[19].Value = model.CarTypeID;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_BUYCARINFO_UPDATE, parameters));
}
/// <summary>
/// 在个人基本信息表中添加一个个人信息
/// </summary>
/// <param name="groupordermodel"></param>
/// <returns></returns>
private string AddNewCustBaseInfo(Entities.GroupOrder groupordermodel)
{
string CustID = "";
#region 插入客户池
Entities.CustBasicInfo newcustmodel = new Entities.CustBasicInfo();
newcustmodel.Status = 0;
newcustmodel.Sex = groupordermodel.UserGender;
newcustmodel.CustName = groupordermodel.CustomerName;
newcustmodel.CustCategoryID = 4;
newcustmodel.ProvinceID = groupordermodel.ProvinceID;
newcustmodel.CityID = groupordermodel.CityID;
newcustmodel.AreaID = groupordermodel.AreaID;
newcustmodel.CreateTime = System.DateTime.Now;
newcustmodel.CreateUserID = userId;
//功能废弃 插入客户基本信息 废弃
CustID = null;// BLL.CustBasicInfo.Instance.Insert(newcustmodel);
Entities.CustTel custtelmodel = new Entities.CustTel();
custtelmodel.CreateTime = System.DateTime.Now;
custtelmodel.CreateUserID = userId;
custtelmodel.CustID = CustID;
custtelmodel.Tel = groupordermodel.CustomerTel;
//插入电话
BLL.CustTel.Instance.Insert(custtelmodel);
//插入bugcarinfo
Entities.BuyCarInfo bugcarmodel = new Entities.BuyCarInfo();
bugcarmodel.CustID = CustID;
bugcarmodel.Type = 4;
bugcarmodel.CarBrandId = 0;
bugcarmodel.CarSerialId = 0;
bugcarmodel.CarTypeID = 0;
bugcarmodel.Status = 0;
bugcarmodel.CreateTime = System.DateTime.Now;
bugcarmodel.CreateUserID = userId;
bugcarmodel.UserName = RequestQCTUserName;
BLL.BuyCarInfo.Instance.Insert(bugcarmodel);
#endregion
return(CustID);
}
private Entities.BuyCarInfo LoadSingleBuyCarInfo(DataRow row)
{
Entities.BuyCarInfo model = new Entities.BuyCarInfo();
if (row["RecID"].ToString() != "")
{
model.RecID = int.Parse(row["RecID"].ToString());
}
model.CustID = row["CustID"].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());
}
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());
}
return(model);
}
/// <summary>
/// ordertype 1是保存，2是提交
/// </summary>
/// <param name="ordertype"></param>
public void DealOrder(int ordertype, out string msg)
{
msg = "";
long taskid = 0;
if (long.TryParse(RequestTaskID, out taskid))
{
Entities.GroupOrderTask model = BLL.GroupOrderTask.Instance.GetGroupOrderTask(taskid);
if (model != null)
{
if (model.TaskStatus != (int)Entities.GroupTaskStatus.NoAllocation && model.TaskStatus != (int)Entities.GroupTaskStatus.Processing && model.TaskStatus != (int)Entities.GroupTaskStatus.NoProcess)
{
//msg = "{\"Result\":false,\"Msg\":\"任务ID"+ taskid +"不处于处理状态\"}";
string s = "";
s = BitAuto.ISDC.CC2012.BLL.Util.GetEnumOptText(typeof(BitAuto.ISDC.CC2012.Entities.GroupTaskStatus), Convert.ToInt32(model.TaskStatus));
msg = "任务状态为:" + s + ",不处于处理状态";
}
else
{
//本地保存订单信息，修改订单状态
Entities.GroupOrder groupordermodel = BLL.GroupOrder.Instance.GetGroupOrder(taskid);
if (groupordermodel != null)
{
#region 保存或提交订单信息，修改任务状态，插入任务操作状态
//保存
if (ordertype == 1)
{
model.LastUpdateTime = System.DateTime.Now;
model.LastUpdateUserID = userId;
model.TaskStatus = (int)Entities.GroupTaskStatus.Processing;
}
//提交
else if (ordertype == 2)
{
model.LastUpdateTime = System.DateTime.Now;
model.LastUpdateUserID = userId;
//如果 是否为回访值为：是，则更新任务状态，调回写接口
//否则 不更新，也不调回写接口
if (this.RequestIsReturnVisit == ((int)Entities.IsReturnVisit.Yes).ToString())
{
model.TaskStatus = (int)Entities.GroupTaskStatus.Processed;
}
model.SubmitTime = System.DateTime.Now;
}
int IsReturnVisit = 0;
if (int.TryParse(RequestIsReturnVisit, out IsReturnVisit))
{
groupordermodel.IsReturnVisit = IsReturnVisit;
}
groupordermodel.LastUpdateTime = System.DateTime.Now;
groupordermodel.LastUpdateUserID = userId;
//更新任务状态
BLL.GroupOrderTask.Instance.Update(model);
//对于保存不用匹配客户池客户所以在此处更新订单信息，提交要在匹配客户池客户后拿到custid后更新
//处理结果为：否的，不提交，所以在些更新订单
//if (ordertype == 1)
if (this.RequestIsReturnVisit == ((int)Entities.IsReturnVisit.No).ToString())
{
BLL.GroupOrder.Instance.Update(groupordermodel);
}
//插入或合并任务操作日志
//如果 是否为回访值为：是，则更新任务状态，调回写接口
//否则 不更新，也不调回写接口
if (this.RequestIsReturnVisit == ((int)Entities.IsReturnVisit.Yes).ToString())
{
DealLog(ordertype);
}
#endregion
//如果 是否为回访值为：是，则更新任务状态，调回写接口
//否则 不更新，也不调回写接口
#region 提交处理
if (ordertype == 2 && this.RequestIsReturnVisit == ((int)Entities.IsReturnVisit.Yes).ToString())
{
if (!string.IsNullOrEmpty(groupordermodel.CustomerTel))
{
#region 根据电话号码判断 客户池是否存在，存在不更新客户，不存在插入
string CustID = string.Empty;
//根据电话找客户，如果有多个去匹配那个名称一致的
DataTable dtcust = BLL.CustBasicInfo.Instance.GetCustBasicInfosByTel(groupordermodel.CustomerTel);
if (dtcust != null && dtcust.Rows.Count > 0)
{
for (int i = 0; i < dtcust.Rows.Count; i++)
{
if (dtcust.Rows[i]["CustName"].ToString() == groupordermodel.CustomerName)
{
CustID = dtcust.Rows[i]["CustID"].ToString();
break;
}
}
}
//如果CustID不为空说明找到了，否则没找到
if (!string.IsNullOrEmpty(CustID))
{
}
else
{
#region 插入客户池
Entities.CustBasicInfo newcustmodel = new Entities.CustBasicInfo();
newcustmodel.Status = 0;
newcustmodel.Sex = groupordermodel.UserGender;
newcustmodel.CustName = groupordermodel.CustomerName;
newcustmodel.CustCategoryID = 4;
newcustmodel.ProvinceID = groupordermodel.ProvinceID;
newcustmodel.CityID = groupordermodel.CityID;
newcustmodel.AreaID = groupordermodel.AreaID;
newcustmodel.CreateTime = System.DateTime.Now;
newcustmodel.CreateUserID = userId;
//功能废弃 插入客户基本信息
CustID = null;// BLL.CustBasicInfo.Instance.Insert(newcustmodel);
Entities.CustTel custtelmodel = new Entities.CustTel();
custtelmodel.CreateTime = System.DateTime.Now;
custtelmodel.CreateUserID = userId;
custtelmodel.CustID = CustID;
custtelmodel.Tel = groupordermodel.CustomerTel;
//插入电话
BLL.CustTel.Instance.Insert(custtelmodel);
//插入bugcarinfo
Entities.BuyCarInfo bugcarmodel = new Entities.BuyCarInfo();
bugcarmodel.CustID = CustID;
bugcarmodel.Type = 4;
bugcarmodel.CarBrandId = 0;
bugcarmodel.CarSerialId = 0;
bugcarmodel.CarTypeID = 0;
bugcarmodel.Status = 0;
bugcarmodel.CreateTime = System.DateTime.Now;
bugcarmodel.CreateUserID = userId;
//bugcarmodel.UserName = RequestQCTUserName;
BLL.BuyCarInfo.Instance.Insert(bugcarmodel);
#endregion
}
#endregion
#region 提交要匹配客户池客户所以在匹配客户池客户后拿到custid后更新订单
groupordermodel.CustID = CustID;
BLL.GroupOrder.Instance.Update(groupordermodel);
#endregion
#region 在客户历史记录里加入团购订单联系记录
Entities.CustHistoryInfo custhistroyinfomodel = new Entities.CustHistoryInfo();
custhistroyinfomodel.TaskID = RequestTaskID;
//业务类型，2为团购订单
custhistroyinfomodel.BusinessType = 2;
//录音
//if (!string.IsNullOrEmpty(RequestCallRecordID))
//{
// long callrecordid = 0;
// if (long.TryParse(RequestCallRecordID, out callrecordid))
// {
// custhistroyinfomodel.CallRecordID = callrecordid;
// }
//}
//呼出
custhistroyinfomodel.RecordType = 2;
custhistroyinfomodel.CustID = CustID;
custhistroyinfomodel.CreateTime = System.DateTime.Now;
custhistroyinfomodel.CreateUserID = userId;
//功能废弃
BLL.CustHistoryInfo.Instance.Insert(custhistroyinfomodel);
#endregion
#region 回写易湃
ReWriteOrderData(taskid);
#endregion
}
}
#endregion
}
else
{
//msg = "{\"Result\":false,\"Msg\":\"任务ID" + taskid + "对应订单不存在！\"}";
msg = "对应订单不存在！";
}
}
}
else
{
//msg = "{\"Result\":false,\"Msg\":\"任务ID" + taskid + "不存在！\"}";
msg = "任务ID不存在";
}
}
}
private void Submit(out string msg, int userID)
{
//此方法内的逻辑可参考文档：$/A5信息系统研发/销售业务管理平台/客户关系管理/doc/Call Center/无主订单处理页面保存和提交逻辑.docx ---- Add By Chybin At 2013-07-19
msg = "";
//System.Threading.Thread.Sleep(5000);
#region 准备数据
NewCarConsultInfo newInfo = null; //新车订单信息
ReplaceCarConsultInfo replaceInfo = null; //置换订单信息
Entities.OrderTask orderTaskModel = null; //无主订单任务信息
Entities.OrderTaskOperationLog orderLog = null; //任务操作日志
List <StringBuilder> listLogStr = new List <StringBuilder>(); //用户操作日志
StringBuilder sblogstr = new StringBuilder();
string logstr = "";
#region 取得新车/置换无主订单信息更新后Model(此时不保存到数据库)
Entities.OrderNewCar newModel = null; //新车订单实体类
Entities.OrderRelpaceCar replaceModel = null; //置换订单实体类
if (Source == "1" || Source == "3")
{
newInfo = (NewCarConsultInfo)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(NewCarConsultInfoStr, typeof(NewCarConsultInfo));
newModel = OrderNewSave.Save(newInfo, out msg, userID, int.Parse(TaskID));
if (msg != "")
{
return;
}
}
else if (Source == "2")
{
replaceInfo = (ReplaceCarConsultInfo)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(ReplaceCarConsultInfoStr, typeof(ReplaceCarConsultInfo));
replaceModel = OrderReplaceSave.Save(replaceInfo, out msg, userID, long.Parse(TaskID));
if (msg != "")
{
return;
}
}
#endregion
#region 取得任务的更新后信息
orderTaskModel = BLL.OrderTask.Instance.GetOrderTask(long.Parse(TaskID));
if (orderTaskModel == null)
{
msg += "没有找到相关的任务信息";
return;
}
if (orderTaskModel.TaskStatus != 2 && orderTaskModel.TaskStatus != 3)
{
msg += "当前任务状态不能保存和提交";
return;
}
if (orderTaskModel.AssignUserID != userID)
{
msg += "此订单没有分配给你";
return;
}
//修改状态
if (Action == "save")
{
orderTaskModel.TaskStatus = (int)TaskStatus.Processing;
}
else if (Action == "sub")
{
orderTaskModel.TaskStatus = (int)TaskStatus.Processed;
orderTaskModel.SubmitTime = DateTime.Now;
}
//是否已选择经销商 只有在提交时，才会改动该属性 -是否已选择经销商 lxw
if (Action == "sub")
{
if (((Source == "1" || Source == "3") && newModel.DMSMemberCode != "") || (Source == "2" && replaceModel.DMSMemberCode != ""))
{
orderTaskModel.IsSelectDMSMember = true;
}
else
{
orderTaskModel.IsSelectDMSMember = false;
}
}
if (Source == "1" || Source == "3")
{
orderTaskModel.UserName = newModel.UserName;
}
else if (Source == "2")
{
orderTaskModel.UserName = replaceModel.UserName;
}
if (NoDealerReasonID != "")
{
orderTaskModel.NoDealerReasonID = int.Parse(NoDealerReasonID);
}
orderTaskModel.NoDealerReason = NoDealerReason;
#endregion
#region 任务操作日志
orderLog = new OrderTaskOperationLog();
//modify by qizq 2013-1-4首先判断是否是通话中
if (IsCalling == "1")
{
if (HistoryLogID == "")
{
//通话中提交把本地录音主键付给实体
long CallRecordReCID = 0;
if (CallRecordID != "")
{
if (long.TryParse(CallRecordID, out CallRecordReCID))
{
orderLog.CallRecordID = CallRecordReCID;
}
}
}
}
//
orderLog.TaskID = int.Parse(TaskID);
if (Action == "save")
{
orderLog.OperationStatus = (int)OperationStatus.Save;
}
else if (Action == "sub")
{
orderLog.OperationStatus = (int)OperationStatus.Submit;
}
orderLog.TaskStatus = orderTaskModel.TaskStatus;
orderLog.CreateTime = DateTime.Now;
orderLog.CreateUserID = userID;
#endregion
#region 如果是提交操作，更新客户信息、插入咨询类型、添加客户联系记录
Entities.CustBasicInfo custmodel = null; //客户信息实体类
Entities.CustTel telPhoneMode = null; //电话实体类
Entities.CustTel telMobileMode = null; //电话实体类
Entities.CustEmail emailMode = null; //邮件实体类
Entities.ConsultOrderNewCar cNewCar = null; //新车咨询类型
Entities.ConsultOrderRelpaceCar cReplaceCar = null; //置换车咨询类型
Entities.CustHistoryInfo custHistInfo = null; //客户联系记录
Entities.BuyCarInfo buyCarInfo = new Entities.BuyCarInfo(); //已购车或未购车信息 lxw
if (Action == "sub")
{
#region 更新或插入客户信息
//代码失效，功能废弃，需求重新实现
#endregion
#region 插入咨询类型
if (Source == "1" || Source == "3")
{
cNewCar = new ConsultOrderNewCar();
#region 赋值
cNewCar.CarBrandId = newModel.CarMasterID;
cNewCar.CarSerialId = newModel.CarSerialID;
cNewCar.CarNameID = newModel.CarTypeID;
cNewCar.CarColor = newModel.CarColor;
cNewCar.DealerCode = newModel.DMSMemberCode;
cNewCar.DealerName = newModel.DMSMemberName;
cNewCar.OrderRemark = newModel.OrderRemark;
cNewCar.CallRecord = newModel.CallRecord;
cNewCar.CreateTime = DateTime.Now;
cNewCar.CreateUserID = userID;
#endregion
}
else if (Source == "2")
{
cReplaceCar = new ConsultOrderRelpaceCar();
#region 赋值
cReplaceCar.WantBrandId = replaceModel.RepCarMasterID;
cReplaceCar.WantSerialId = replaceModel.RepCarSerialID;
cReplaceCar.WantNameID = replaceModel.RepCarTypeId;
cReplaceCar.WantCarColor = replaceModel.ReplacementCarColor;
cReplaceCar.WantDealerName = replaceModel.DMSMemberName;
cReplaceCar.WantDealerCode = replaceModel.DMSMemberCode;
cReplaceCar.CallRecord = replaceModel.CallRecord;
cReplaceCar.OldBrandId = replaceModel.CarMasterID;
cReplaceCar.OldSerialId = replaceModel.CarSerialID;
cReplaceCar.OldNameID = replaceModel.CarTypeID;
cReplaceCar.OldCarColor = replaceModel.CarColor;
cReplaceCar.RegisterDateYear = replaceModel.ReplacementCarBuyYear.ToString();
cReplaceCar.RegisterDateMonth = replaceModel.ReplacementCarBuyMonth.ToString();
cReplaceCar.RegisterProvinceID = replaceModel.RepCarProvinceID;
cReplaceCar.RegisterCityID = replaceModel.RepCarCityID;
cReplaceCar.RegisterCountyID = replaceModel.RepCarCountyID;
cReplaceCar.Mileage = (decimal)replaceModel.ReplacementCarUsedMiles;
cReplaceCar.PresellPrice = replaceModel.SalePrice;
cReplaceCar.OrderRemark = replaceModel.OrderRemark;
cReplaceCar.CreateTime = DateTime.Now;
cReplaceCar.CreateUserID = userID;
#endregion
}
#endregion
#region 插入客户历史记录
custHistInfo = new CustHistoryInfo();
#region 赋值
custHistInfo.TaskID = TaskID;
if (Source == "1" || Source == "3")
{
custHistInfo.ConsultID = 60010;//新车咨询类型
}
else
{
custHistInfo.ConsultID = 60011;//置换咨询类型
}
custHistInfo.RecordType = 2;
custHistInfo.QuestionQuality = (int)QuestionNature.NatureCommon;
custHistInfo.ProcessStatus = (int)EnumTaskStatus.TaskStatusOver;
custHistInfo.CreateTime = DateTime.Now;
custHistInfo.CreateUserID = userID;
custHistInfo.LastTreatmentTime = DateTime.Now;
#endregion
#endregion
}
#endregion
#endregion
#region 事务提交
string connectionstrings = ConfigurationUtil.GetAppSettingValue("ConnectionStrings_CC");
SqlConnection connection = new SqlConnection(connectionstrings);
connection.Open();
SqlTransaction tran = connection.BeginTransaction(IsolationLevel.ReadUncommitted, "SampleTransaction");
try
{
#region 保存新车/置换无主订单信息
if (Source == "1" || Source == "3")
{
BLL.OrderNewCar.Instance.Update(tran, newModel);
}
else if (Source == "2")
{
BLL.OrderRelpaceCar.Instance.Update(tran, replaceModel);
}
#endregion
#region 修改任务信息
BLL.OrderTask.Instance.Update(tran, orderTaskModel);
#endregion
#region 任务操作日志
//modify by qizq 2013-1-4不是在通话中，处理记录已存在更新处理记录
if (IsCalling != "1" && HistoryLogID != "")
{
//通话中提交把本地录音主键付给实体
long CallRecordReCID = 0;
if (CallRecordID != "")
{
if (long.TryParse(CallRecordID, out CallRecordReCID))
{
orderLog.CallRecordID = CallRecordReCID;
}
}
long HistoryLogIDLog = 0;
if (long.TryParse(HistoryLogID, out HistoryLogIDLog))
{
orderLog.RecID = HistoryLogIDLog;
}
BLL.OrderTaskOperationLog.Instance.Update(tran, orderLog);
}
else
{
BLL.OrderTaskOperationLog.Instance.Insert(tran, orderLog);
}
//
#endregion
if (Action == "sub")
{
string retCustID = "";
#region 更新或插入客户信息
if (custmodel.RecID == -2)
{
//新加的客户
retCustID = BLL.CustBasicInfo.Instance.Insert(tran, custmodel);
#region 记日志
sblogstr = new StringBuilder();
logstr = "";
logstr += "新加了客户‘" + custmodel.CustName + "’的信息【ID：" + retCustID + "】";
if (logstr != "")
{
sblogstr.Append(logstr);
listLogStr.Add(sblogstr);
}
#endregion
}
else
{
//编辑客户信息
BLL.CustBasicInfo.Instance.Update(tran, custmodel);
retCustID = custmodel.CustID;
}
#endregion
#region 插入电话
if (telPhoneMode != null)
{
telPhoneMode.CustID = retCustID;
BLL.CustTel.Instance.Insert(tran, telPhoneMode);
}
if (telMobileMode != null)
{
telMobileMode.CustID = retCustID;
BLL.CustTel.Instance.Insert(tran, telMobileMode);
}
#endregion
#region 插入邮箱
if (emailMode != null)
{
emailMode.CustID = retCustID;
BLL.CustEmail.Instance.Insert(tran, emailMode);
}
#endregion
#region 插入咨询类型
int retDataID = 0;
if (cNewCar != null)
{
cNewCar.CustID = retCustID;
retDataID = BLL.ConsultOrderNewCar.Instance.Insert(tran, cNewCar);
#region 记日志
sblogstr = new StringBuilder();
logstr = "";
logstr += "新加了无主订单新车联系咨询记录【ID：" + retDataID + "】";
if (logstr != "")
{
sblogstr.Append(logstr);
listLogStr.Add(sblogstr);
}
#endregion
}
if (cReplaceCar != null)
{
cReplaceCar.CustID = retCustID;
retDataID = BLL.ConsultOrderRelpaceCar.Instance.Insert(tran, cReplaceCar);
#region 记日志
sblogstr = new StringBuilder();
logstr = "";
logstr += "新加了无主订单置换联系咨询记录【ID：" + retDataID + "】";
if (logstr != "")
{
sblogstr.Append(logstr);
listLogStr.Add(sblogstr);
}
#endregion
}
#endregion
#region 插入未购车或已购车记录 BuyCarInfo lxw
if (buyCarInfo != null && buyCarInfo.RecID == -2)
{
buyCarInfo.CustID = retCustID;
int recID = BLL.BuyCarInfo.Instance.Insert(tran, buyCarInfo);
#region 记日志
sblogstr = new StringBuilder();
logstr = "";
logstr += "新加了未购车已购车BuyCarInfo表的记录【ID：" + recID + "】";
if (logstr != "")
{
sblogstr.Append(logstr);
listLogStr.Add(sblogstr);
}
#endregion
}
if (buyCarInfo != null && buyCarInfo.RecID != -2)
{
BLL.BuyCarInfo.Instance.Update(tran, buyCarInfo);
#region 记日志
sblogstr = new StringBuilder();
logstr = "";
logstr += "修改了未购车已购车BuyCarInfo表的记录【ID：" + buyCarInfo.RecID + "】";
if (logstr != "")
{
sblogstr.Append(logstr);
listLogStr.Add(sblogstr);
}
#endregion
}
#endregion
#region 插入客户联系记录
if (custHistInfo != null)
{
custHistInfo.CustID = retCustID;
custHistInfo.ConsultDataID = retDataID;
BLL.CustHistoryInfo.Instance.Insert(tran, custHistInfo);
}
#endregion
#region 插入已购车或未购车信息
#endregion
#region 保存用户操作日志
foreach (StringBuilder sbStr in listLogStr)
{
BLL.Util.InsertUserLog(tran, sbStr.ToString());
}
#endregion
}
if (msg == "")
{
tran.Commit();
if (Action == "sub")
{
#region 调用易湃接口，传回数据
string errorMsg = "";
int retService = 0;
short isSelectDMS = 0;
#region 调用接口
BitAuto.ISDC.CC2012.WebService.NoDealerOrderHelper OrderHelper = new BitAuto.ISDC.CC2012.WebService.NoDealerOrderHelper();
if (Source == "1") //新车
{
isSelectDMS = newModel.DMSMemberCode == "" ? (short)2 : (short)1; //1 选择了经销商 2 未选择经销商
retService = OrderHelper.SetNewCarOrder(newModel, isSelectDMS, NoDealerReason, ref errorMsg);
}
else if (Source == "2") //置换
{
isSelectDMS = replaceModel.DMSMemberCode == "" ? (short)2 : (short)1; //1 选择了经销商 2 未选择经销商
retService = OrderHelper.SetReplacementOrder(replaceModel, isSelectDMS, NoDealerReason, ref errorMsg);
}
else if (Source == "3")
{
isSelectDMS = newModel.DMSMemberCode == "" ? (short)2 : (short)1; //1 选择了经销商 2 未选择经销商
retService = OrderHelper.SetTestDriveOrder(newModel, isSelectDMS, NoDealerReason, ref errorMsg);
}
#endregion
#region 插入更新无主订单数据日志表
Entities.UpdateOrderData updateDateMode = new UpdateOrderData();
updateDateMode.TaskID = TaskID;
if (Source == "1" || Source == "3")
{
updateDateMode.YPOrderID = newModel.YPOrderID;
}
else if (Source == "2")
{
updateDateMode.YPOrderID = replaceModel.YPOrderID;
}
updateDateMode.UpdateType = retService;
updateDateMode.IsUpdate = retService; // 1 成功了，不用处理，-1 需要重新处理
if (retService == 1)
{
updateDateMode.UpdateDateTime = DateTime.Now;
}
updateDateMode.UpdateErrorMsg = errorMsg;
updateDateMode.CreateTime = DateTime.Now;
updateDateMode.CreateUserID = userID;
updateDateMode.APIType = 1;
BLL.UpdateOrderData.Instance.Insert(updateDateMode);
#endregion
if (retService == -1)
{
msg = "InterfaceErr|" + errorMsg;
}
#endregion
}
}
else
{
tran.Rollback();
}
}
catch (Exception ex)
{
if (tran.Connection != null)
{
tran.Rollback();
}
msg = ex.Message.ToString();
}
finally
{
connection.Close();
}
#endregion
}
public int Update(SqlTransaction sqlTran, Entities.BuyCarInfo model)
{
return(Dal.BuyCarInfo.Instance.Update(sqlTran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.BuyCarInfo model)
{
return(Dal.BuyCarInfo.Instance.Update(model));
}
public int Insert(SqlTransaction tran, Entities.BuyCarInfo model)
{
return(Dal.BuyCarInfo.Instance.Insert(tran, model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.BuyCarInfo model)
{
return(Dal.BuyCarInfo.Instance.Insert(model));
}
private void GetBuyCarModel(string CustID)
{
if (!string.IsNullOrEmpty(CustID))
{
Entities.BuyCarInfo BuyCarModel = BLL.BuyCarInfo.Instance.GetBuyCarInfo(CustID);
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));
}
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;
}
}
}
}
