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