/// <summary> /// 增加一条数据 /// </summary> public int Insert(SqlTransaction sqltran, Entities.OrderNewCar model) { SqlParameter[] parameters = { new SqlParameter("@TaskID", SqlDbType.BigInt, 8), new SqlParameter("@YPOrderID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.NVarChar, 64), new SqlParameter("@UserPhone", SqlDbType.NVarChar, 64), new SqlParameter("@UserMobile", SqlDbType.NVarChar, 64), new SqlParameter("@UserMail", SqlDbType.NVarChar, 64), new SqlParameter("@UserGender", SqlDbType.Int, 4), new SqlParameter("@ProvinceID", SqlDbType.Int, 4), new SqlParameter("@CityID", SqlDbType.Int, 4), new SqlParameter("@CountyID", SqlDbType.Int, 4), new SqlParameter("@AreaID", SqlDbType.Int, 4), new SqlParameter("@UserAddress", SqlDbType.NVarChar, 1024), new SqlParameter("@OrderCreateTime", SqlDbType.SmallDateTime), new SqlParameter("@OrderRemark", SqlDbType.NVarChar, 1024), new SqlParameter("@CarMasterID", SqlDbType.Int, 4), new SqlParameter("@CarSerialID", SqlDbType.Int, 4), new SqlParameter("@CarTypeID", SqlDbType.Int, 4), new SqlParameter("@CarColor", SqlDbType.NVarChar, 16), new SqlParameter("@DMSMemberCode", SqlDbType.VarChar, 50), new SqlParameter("@DMSMemberName", SqlDbType.NVarChar, 256), new SqlParameter("@CallRecord", SqlDbType.NVarChar, 2000), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@DealerID", SqlDbType.Int, 4), new SqlParameter("@OrderType", SqlDbType.Int, 4) }; parameters[0].Value = model.TaskID; parameters[1].Value = model.YPOrderID; parameters[2].Value = model.UserName; parameters[3].Value = model.UserPhone; parameters[4].Value = model.UserMobile; parameters[5].Value = model.UserMail; parameters[6].Value = model.UserGender; parameters[7].Value = model.ProvinceID; parameters[8].Value = model.CityID; parameters[9].Value = model.CountyID; parameters[10].Value = model.AreaID; parameters[11].Value = model.UserAddress; parameters[12].Value = model.OrderCreateTime; parameters[13].Value = model.OrderRemark; parameters[14].Value = model.CarMasterID; parameters[15].Value = model.CarSerialID; parameters[16].Value = model.CarTypeID; parameters[17].Value = model.CarColor; parameters[18].Value = model.DMSMemberCode; parameters[19].Value = model.DMSMemberName; parameters[20].Value = model.CallRecord; parameters[21].Value = model.Status; parameters[22].Value = model.CreateTime; parameters[23].Value = model.DealerID; parameters[24].Value = model.OrderType; return(SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_ORDERNEWCAR_INSERT, parameters)); }
internal void SubmitCheckInfo(bool isUpdate, out string msg) { msg = string.Empty; CheckInfo checkInfo = (CheckInfo)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(CheckedInfoStr, typeof(CheckInfo)); string errorMsg = string.Empty; if (!checkInfo.Validate(isUpdate, out errorMsg)) { msg = "{Result:'no',CustID:'0',ErrorMsg:'" + errorMsg + "'}"; return; } if (!string.IsNullOrEmpty(checkInfo.CustBaseInfo.TaskID)) { //已购车 if (checkInfo.CustBaseInfo.CustCategoryID == "2") { Entities.OrderRelpaceCar info = BLL.OrderRelpaceCar.Instance.GetOrderRelpaceCar(Convert.ToInt32(checkInfo.CustBaseInfo.TaskID)); if (info == null) { msg = "{Result:'no',CustID:'0',ErrorMsg:'没找到客户信息'}"; return; } else { //记录更新之前的信息 StringBuilder sbUpdate = new StringBuilder(); sbUpdate.Append("修改客户【" + info.TaskID + "】:"); if (info.UserName != checkInfo.CustBaseInfo.CustName) { sbUpdate.Append("把姓名【" + info.UserName + "】修改为【" + checkInfo.CustBaseInfo.CustName + "】,"); } if (info.UserGender != Convert.ToInt32(checkInfo.CustBaseInfo.Sex)) { sbUpdate.Append("把性别" + info.UserGender == "1" ? "【男】" : "【女】" + "修改为" + checkInfo.CustBaseInfo == "1" ? "【男】" : "【女】" + ","); } if (info.AreaID != Convert.ToInt32(checkInfo.CustBaseInfo.AreaID)) { sbUpdate.Append("把区域【" + BLL.Util.GetEnumOptText(typeof(Entities.EnumArea), (int)info.AreaID) + "】修改为【" + BLL.Util.GetEnumOptText(typeof(Entities.EnumArea), Convert.ToInt32(checkInfo.CustBaseInfo.AreaID)) + "】,"); } if (info.ProvinceID != Convert.ToInt32(checkInfo.CustBaseInfo.ProvinceID)) { sbUpdate.Append("把省【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(info.ProvinceID.ToString()) + "】修改为【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(checkInfo.CustBaseInfo.ProvinceID.ToString()) + "】,"); } if (info.CityID != Convert.ToInt32(checkInfo.CustBaseInfo.CityID)) { sbUpdate.Append("把市【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(info.CityID.ToString()) + "】修改为【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(checkInfo.CustBaseInfo.CityID.ToString()) + "】,"); } if (info.CountyID != Convert.ToInt32(checkInfo.CustBaseInfo.CountyID)) { sbUpdate.Append("把县【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(info.CountyID.ToString()) + "】修改为【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(checkInfo.CustBaseInfo.CountyID.ToString()) + "】,"); } info.UserAddress = checkInfo.CustBaseInfo.Address; info.AreaID = Convert.ToInt32(checkInfo.CustBaseInfo.AreaID); info.CityID = Convert.ToInt32(checkInfo.CustBaseInfo.CityID); info.CountyID = Convert.ToInt32(checkInfo.CustBaseInfo.CountyID); info.UserName = checkInfo.CustBaseInfo.CustName; info.ProvinceID = Convert.ToInt32(checkInfo.CustBaseInfo.ProvinceID); info.UserGender = Convert.ToInt32(checkInfo.CustBaseInfo.Sex); if (info.UserPhone != checkInfo.CustBaseInfo.UserPhone) { sbUpdate.Append("把电话【" + info.UserPhone + "】修改为【" + checkInfo.CustBaseInfo.UserPhone + "】,"); } info.UserPhone = checkInfo.CustBaseInfo.UserPhone; if (info.UserMobile != checkInfo.CustBaseInfo.UserMobile) { sbUpdate.Append("把手机【" + info.UserMobile + "】修改为【" + checkInfo.CustBaseInfo.UserMobile + "】,"); } info.UserMobile = checkInfo.CustBaseInfo.UserMobile; if (info.UserMail != checkInfo.CustBaseInfo.Email) { sbUpdate.Append("把邮箱【" + info.UserMail + "】修改为【" + checkInfo.CustBaseInfo.Email + "】,"); } info.UserMail = checkInfo.CustBaseInfo.Email; BLL.OrderRelpaceCar.Instance.Update(info); //插入日志记录 BLL.Util.InsertUserLog(sbUpdate.ToString()); } } //未购车 else { Entities.OrderNewCar info = BLL.OrderNewCar.Instance.GetOrderNewCar(Convert.ToInt32(checkInfo.CustBaseInfo.TaskID)); if (info == null) { msg = "{Result:'no',CustID:'0',ErrorMsg:'没找到客户信息'}"; return; } else { //记录更新之前的信息 StringBuilder sbUpdate = new StringBuilder(); sbUpdate.Append("修改客户【" + info.TaskID + "】:"); if (info.UserName != checkInfo.CustBaseInfo.CustName) { sbUpdate.Append("把姓名【" + info.UserName + "】修改为【" + checkInfo.CustBaseInfo.CustName + "】,"); } if (info.UserGender != Convert.ToInt32(checkInfo.CustBaseInfo.Sex)) { sbUpdate.Append("把性别" + info.UserGender == "1" ? "【男】" : "【女】" + "修改为" + checkInfo.CustBaseInfo == "1" ? "【男】" : "【女】" + ","); } if (info.AreaID != Convert.ToInt32(checkInfo.CustBaseInfo.AreaID)) { sbUpdate.Append("把区域【" + BLL.Util.GetEnumOptText(typeof(Entities.EnumArea), (int)info.AreaID) + "】修改为【" + BLL.Util.GetEnumOptText(typeof(Entities.EnumArea), Convert.ToInt32(checkInfo.CustBaseInfo.AreaID)) + "】,"); } if (info.ProvinceID != Convert.ToInt32(checkInfo.CustBaseInfo.ProvinceID)) { sbUpdate.Append("把省【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(info.ProvinceID.ToString()) + "】修改为【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(checkInfo.CustBaseInfo.ProvinceID.ToString()) + "】,"); } if (info.CityID != Convert.ToInt32(checkInfo.CustBaseInfo.CityID)) { sbUpdate.Append("把市【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(info.CityID.ToString()) + "】修改为【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(checkInfo.CustBaseInfo.CityID.ToString()) + "】,"); } if (info.CountyID != Convert.ToInt32(checkInfo.CustBaseInfo.CountyID)) { sbUpdate.Append("把县【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(info.CountyID.ToString()) + "】修改为【" + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(checkInfo.CustBaseInfo.CountyID.ToString()) + "】,"); } info.UserAddress = checkInfo.CustBaseInfo.Address; info.AreaID = Convert.ToInt32(checkInfo.CustBaseInfo.AreaID); info.CityID = Convert.ToInt32(checkInfo.CustBaseInfo.CityID); info.CountyID = Convert.ToInt32(checkInfo.CustBaseInfo.CountyID); info.UserName = checkInfo.CustBaseInfo.CustName; info.ProvinceID = Convert.ToInt32(checkInfo.CustBaseInfo.ProvinceID); info.UserGender = Convert.ToInt32(checkInfo.CustBaseInfo.Sex); if (info.UserPhone != checkInfo.CustBaseInfo.UserPhone) { sbUpdate.Append("把电话【" + info.UserPhone + "】修改为【" + checkInfo.CustBaseInfo.UserPhone + "】,"); } info.UserPhone = checkInfo.CustBaseInfo.UserPhone; if (info.UserMobile != checkInfo.CustBaseInfo.UserMobile) { sbUpdate.Append("把手机【" + info.UserMobile + "】修改为【" + checkInfo.CustBaseInfo.UserMobile + "】,"); } info.UserMobile = checkInfo.CustBaseInfo.UserMobile; if (info.UserMail != checkInfo.CustBaseInfo.Email) { sbUpdate.Append("把邮箱【" + info.UserMail + "】修改为【" + checkInfo.CustBaseInfo.Email + "】,"); } info.UserMail = checkInfo.CustBaseInfo.Email; BLL.OrderNewCar.Instance.Update(info); //插入日志记录 BLL.Util.InsertUserLog(sbUpdate.ToString()); } } msg = "{Result:'yes',CustID:'',ErrorMsg:'" + errorMsg + "'}"; } }
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 Entities.OrderNewCar LoadSingleOrderNewCar(DataRow row) { Entities.OrderNewCar model = new Entities.OrderNewCar(); if (row["TaskID"].ToString() != "") { model.TaskID = long.Parse(row["TaskID"].ToString()); } if (row["YPOrderID"].ToString() != "") { model.YPOrderID = int.Parse(row["YPOrderID"].ToString()); } model.UserName = row["UserName"].ToString(); model.UserPhone = row["UserPhone"].ToString(); model.UserMobile = row["UserMobile"].ToString(); model.UserMail = row["UserMail"].ToString(); if (row["UserGender"].ToString() != "") { model.UserGender = int.Parse(row["UserGender"].ToString()); } if (row["ProvinceID"].ToString() != "") { model.ProvinceID = int.Parse(row["ProvinceID"].ToString()); } if (row["CityID"].ToString() != "") { model.CityID = int.Parse(row["CityID"].ToString()); } if (row["CountyID"].ToString() != "") { model.CountyID = int.Parse(row["CountyID"].ToString()); } if (row["AreaID"].ToString() != "") { model.AreaID = int.Parse(row["AreaID"].ToString()); } model.UserAddress = row["UserAddress"].ToString(); if (row["OrderCreateTime"].ToString() != "") { model.OrderCreateTime = DateTime.Parse(row["OrderCreateTime"].ToString()); } model.OrderRemark = row["OrderRemark"].ToString(); if (row["CarMasterID"].ToString() != "") { model.CarMasterID = int.Parse(row["CarMasterID"].ToString()); } if (row["CarSerialID"].ToString() != "") { model.CarSerialID = int.Parse(row["CarSerialID"].ToString()); } if (row["CarTypeID"].ToString() != "") { model.CarTypeID = int.Parse(row["CarTypeID"].ToString()); } model.CarColor = row["CarColor"].ToString(); model.DMSMemberCode = row["DMSMemberCode"].ToString(); model.DMSMemberName = row["DMSMemberName"].ToString(); model.CallRecord = row["CallRecord"].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.Table.Columns.Contains("DealerID") && row["DealerID"].ToString() != "") { model.DealerID = int.Parse(row["DealerID"].ToString()); } if (row.Table.Columns.Contains("OrderType") && row["OrderType"].ToString() != "") { model.OrderType = int.Parse(row["OrderType"].ToString()); } return(model); }
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 }
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 bindNewCarData() { int _taskID; if (int.TryParse(TaskID, out _taskID)) { Entities.OrderNewCar model = BLL.OrderNewCar.Instance.GetOrderNewCar(_taskID); if (model != null) { string carType = BLL.CarTypeAPI.Instance.GetCarTypeNameByCarTypeID(int.Parse(model.CarTypeID.ToString())); string carMaster = BLL.CarTypeAPI.Instance.GetMasterBrandNameByMasterBrandID(int.Parse(model.CarMasterID.ToString())); string carSerial = BLL.CarTypeAPI.Instance.GetSerialNameBySerialID(int.Parse(model.CarSerialID.ToString())); CarType = carMaster + "-" + carSerial + "-" + carType; #region 历史车型和地区 Entities.QueryOrderNewCarLog query = new Entities.QueryOrderNewCarLog(); query.YPOrderID = model.YPOrderID; int totalCount = 0; DataTable dt = BLL.OrderNewCarLog.Instance.GetOrderNewCarLog(query, "", 1, 10, out totalCount); if (dt != null && dt.Rows.Count > 0) { #region 历史车型 int CarMasterID = 0; int CarSerialID = 0; int brandID = 0; BLL.CarTypeAPI.Instance.GetSerialIDAndMasterBrandIDByCarTypeID(int.Parse(dt.Rows[0]["CarID"].ToString()), out CarSerialID, out CarMasterID, out brandID); string oldCarType = BLL.CarTypeAPI.Instance.GetCarTypeNameByCarTypeID(int.Parse(dt.Rows[0]["CarID"].ToString())); string oldCarMaster = BLL.CarTypeAPI.Instance.GetMasterBrandNameByMasterBrandID(CarMasterID); string oldCarSerial = BLL.CarTypeAPI.Instance.GetSerialNameBySerialID(CarSerialID); OldCarType = oldCarMaster + "-" + oldCarSerial + "-" + oldCarType; #endregion #region 历史地区 int ProvinceID = Entities.Constants.Constant.INT_INVALID_VALUE; int CityID = Entities.Constants.Constant.INT_INVALID_VALUE; int CountyID = Entities.Constants.Constant.INT_INVALID_VALUE; string locationName = BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaStrByAreaID(dt.Rows[0]["LocationID"].ToString()); switch (locationName.Split(',').Length) { case 1: ProvinceID = int.Parse(locationName.Split(',')[0]); break; case 2: ProvinceID = int.Parse(locationName.Split(',')[0]); CityID = int.Parse(locationName.Split(',')[1]); break; case 3: ProvinceID = int.Parse(locationName.Split(',')[0]); CityID = int.Parse(locationName.Split(',')[1]); CountyID = int.Parse(locationName.Split(',')[2]); break; default: break; } if (ProvinceID != Entities.Constants.Constant.INT_INVALID_VALUE) { PlaceStr += BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(ProvinceID.ToString()); } if (CityID != Entities.Constants.Constant.INT_INVALID_VALUE) { PlaceStr += "," + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(CityID.ToString()); } if (CountyID != Entities.Constants.Constant.INT_INVALID_VALUE) { PlaceStr += "," + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(CountyID.ToString()); } #endregion } #endregion if (model.CarColor != "-1" && model.CarColor != "null" && model.CarColor != null) { CarColor = model.CarColor; } else { CarColor = ""; } //经销商iD if (model.DealerID != Constant.INT_INVALID_VALUE) { if (int.TryParse(model.DealerID.ToString(), out DealerId)) { } } DMSMemberName = model.DMSMemberName; OrderRemark = model.OrderRemark; CreateTime = model.OrderCreateTime.ToString(); CallRecord = model.CallRecord; } } }
internal static Entities.OrderNewCar Save(NewCarConsultInfo newInfo, out string msg, int userID, int TID) { msg = string.Empty; Entities.OrderNewCar model = BLL.OrderNewCar.Instance.GetOrderNewCar(TID); #region 检查格式 if (newInfo == null) { msg += "新车联系信息为空<br/>"; } if (newInfo.CarMasterID == "0") { msg += "请选择关注车型的品牌<br/>"; } if (newInfo.CarSerialID == "0") { msg += "请选择关注车型的系列<br/>"; } if (newInfo.CarTypeID == "0") { msg += "请选择关注车型的车型<br/>"; } if (newInfo.CallRecord == "") { msg += "请填写电话记录<br/>"; } if (newInfo.UserName == "") { msg += "请填写用户姓名<br/>"; } if (msg != "") { return(null); } #endregion #region 新车订单信息实体类 int _carMasterID; if (int.TryParse(newInfo.CarMasterID, out _carMasterID)) { model.CarMasterID = _carMasterID; } int _carSerialID; if (int.TryParse(newInfo.CarSerialID, out _carSerialID)) { model.CarSerialID = _carSerialID; } int _carTypeID; if (int.TryParse(newInfo.CarTypeID, out _carTypeID)) { model.CarTypeID = _carTypeID; } if (newInfo.CarColor != "请选择颜色" && newInfo.CarColor != "-1" && newInfo.CarColor != "null") { model.CarColor = newInfo.CarColor; } else { model.CarColor = ""; } model.CallRecord = newInfo.CallRecord; model.DMSMemberCode = newInfo.DMSMemberCode; model.DMSMemberName = newInfo.DMSMemberName; model.UserName = newInfo.UserName; #endregion return(model); }
private void BindInfo() { #region 根据类型绑定联系记录控件 //1新车,3试驾modify by qizq 2013-7-19 if (Source == "1" || Source == "3") { //新车订单 Entities.OrderNewCar newCarModel = BLL.OrderNewCar.Instance.GetOrderNewCar(long.Parse(TID)); if (newCarModel != null) { #region 绑定新车订单 this.ddlNewBrand = newCarModel.CarMasterID.ToString(); this.ddlNewSerial = newCarModel.CarSerialID.ToString(); this.ddlNewName = newCarModel.CarTypeID.ToString(); ///this.ddlNewCarColor.Value = newCarModel.CarColor; this.ddlCarTypeID = newCarModel.CarTypeID.ToString(); nowColor = newCarModel.CarColor; //经销商 this.hidNewCarDMSmemberCode.Value = newCarModel.DMSMemberCode; //名称 this.txtNewDealer.Value = newCarModel.DMSMemberName; this.labNewsRemark.InnerText = newCarModel.OrderRemark; this.labNewCreatTime.InnerText = DateTime.Parse(newCarModel.OrderCreateTime.ToString()).ToString("yyyy-MM-dd HH:mm:ss"); this.txtNewCallRecord.Value = newCarModel.CallRecord; //经销商iD if (newCarModel.DealerID != Constant.INT_INVALID_VALUE) { if (int.TryParse(newCarModel.DealerID.ToString(), out DealerId)) { } } #region 隐藏域 this.hidDMSCode.Value = newCarModel.DMSMemberCode; this.hidDMSName.Value = newCarModel.DMSMemberName; //this.hidDMSLevel.Value = newCarModel.hidDMSLevel; //this.hidDMSAddress.Value = newCarModel.hidDMSAddress; //this.hidDMSTel.Value = newCarModel.hidDMSTel; //this.hidDMSCity.Value = newCarModel.hidDMSCity; #endregion #endregion } } else if (Source == "2") { //置换订单 Entities.OrderRelpaceCar replaceCarModel = BLL.OrderRelpaceCar.Instance.GetOrderRelpaceCar(long.Parse(TID)); if (replaceCarModel != null) { #region 绑定置换订单信息 this.ddlWantBrand = replaceCarModel.CarMasterID.ToString(); this.ddlWantSerial = replaceCarModel.CarSerialID.ToString(); this.ddlWantName = replaceCarModel.CarTypeID.ToString(); this.ddlCarTypeID = replaceCarModel.RepCarTypeId.ToString(); this.ddlRecCarTypeID = replaceCarModel.CarTypeID.ToString(); nowColor = replaceCarModel.ReplacementCarColor; relColor = replaceCarModel.CarColor; //经销商 this.hidWantDMSMemberCode.Value = replaceCarModel.DMSMemberCode; // //名称 this.txtWantDealer.Value = replaceCarModel.DMSMemberName; this.dllOldBrand = replaceCarModel.RepCarMasterID.ToString(); this.dllOldSerial = replaceCarModel.RepCarSerialID.ToString(); this.dllOldName = replaceCarModel.RepCarTypeId.ToString(); this.dllOldColor.Value = replaceCarModel.ReplacementCarColor; this.dllRegDateYear.Value = replaceCarModel.ReplacementCarBuyYear.ToString(); this.dllRegDateMonth.Value = replaceCarModel.ReplacementCarBuyMonth.ToString(); //省份 Province = replaceCarModel.RepCarProvinceID.ToString(); City = replaceCarModel.RepCarCityID.ToString(); County = replaceCarModel.RepCarCountyID.ToString(); this.txtMileage.Value = replaceCarModel.ReplacementCarUsedMiles.ToString(); this.txtProSellPrice.Value = replaceCarModel.SalePrice.ToString(); this.labWantRemark.InnerText = replaceCarModel.OrderRemark; this.labWantCreateTime.InnerText = DateTime.Parse(replaceCarModel.OrderCreateTime.ToString()).ToString("yyyy-MM-dd HH:mm:ss"); this.txtReplaceCallRecord.Value = replaceCarModel.CallRecord; this.hidDMSCode.Value = replaceCarModel.DMSMemberCode; this.hidDMSName.Value = replaceCarModel.DMSMemberName; //经销商iD if (replaceCarModel.DealerID != Constant.INT_INVALID_VALUE) { if (int.TryParse(replaceCarModel.DealerID.ToString(), out DealerId)) { } } #endregion } } //根据经销商id,取名称 if (DealerId != 0) { BitAuto.YanFa.Crm2009.Entities.DMSMember DMSModel = BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetDMSMemberByMemberCode(DealerId.ToString()); if (DMSModel != null) { DealerName = DMSModel.Name; MemberID = DMSModel.ID.ToString(); CustID = DMSModel.CustID; } } #endregion }
/// <summary> /// 根据易湃新车订单实体信息,插入表OrderNewCar信息 /// </summary> /// <param name="tran"></param> /// <param name="taskID">任务ID</param> /// <param name="model">易湃新车订单实体信息</param> /// <returns></returns> public bool InsertByTaskID(SqlTransaction tran, long taskID, Entities.OrderNewCarLog model) { Entities.OrderNewCar onModel = new Entities.OrderNewCar(); onModel.TaskID = taskID; onModel.YPOrderID = model.YPOrderID; onModel.UserName = model.UserName; onModel.UserPhone = model.UserPhone; onModel.UserMobile = model.UserMobile; onModel.UserMail = model.UserMail; if (model.UserGender != null && model.UserGender.Value == 0) { onModel.UserGender = 2;//性别“女” } else { onModel.UserGender = model.UserGender; } onModel.ProvinceID = null; onModel.CityID = null; onModel.CountyID = null; if (model.LocationID != null) { string locationName = BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaStrByAreaID(model.LocationID.Value.ToString()); switch (locationName.Split(',').Length) { case 1: onModel.ProvinceID = int.Parse(locationName.Split(',')[0]); break; case 2: onModel.ProvinceID = int.Parse(locationName.Split(',')[0]); onModel.CityID = int.Parse(locationName.Split(',')[1]); break; case 3: onModel.ProvinceID = int.Parse(locationName.Split(',')[0]); onModel.CityID = int.Parse(locationName.Split(',')[1]); onModel.CountyID = int.Parse(locationName.Split(',')[2]); break; default: break; } } onModel.AreaID = null; onModel.UserAddress = model.UserAddress; onModel.OrderCreateTime = model.OrderCreateTime; onModel.OrderRemark = model.OrderRemark; onModel.CarMasterID = null; onModel.CarSerialID = null; onModel.CarTypeID = null; if (model.CarID != null) { onModel.CarTypeID = model.CarID; int CarMasterID = 0; int CarSerialID = 0; int brandID = 0; BLL.CarTypeAPI.Instance.GetSerialIDAndMasterBrandIDByCarTypeID(model.CarID.Value, out CarSerialID, out CarMasterID, out brandID); //onModel.CarMasterID = CarMasterID; //onModel.CarSerialID = CarSerialID; if (CarMasterID > 0) { onModel.CarMasterID = CarMasterID; } if (CarSerialID > 0) { onModel.CarSerialID = CarSerialID; } } onModel.CarColor = model.CarColor; onModel.DMSMemberCode = string.Empty; onModel.DMSMemberName = string.Empty; onModel.CallRecord = string.Empty; onModel.Status = 0; onModel.CreateTime = DateTime.Now; onModel.DealerID = model.DealerID; onModel.OrderType = model.OrderType; int recid = Insert(tran, onModel); if (recid > 0) { BLL.Loger.Log4Net.Info(string.Format("新车任务生成表OrderNewCar成功,主键ID为:{0},无主订单ID为:{1},车款ID:{2},子品牌ID:{3},主品牌ID为:{4}", recid, onModel.YPOrderID, onModel.CarTypeID == null ? 0 : onModel.CarTypeID.Value, onModel.CarSerialID == null ? 0 : onModel.CarSerialID.Value, onModel.CarMasterID == null ? 0 : onModel.CarMasterID.Value )); return(true); } return(false); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(SqlTransaction sqltran, Entities.OrderNewCar model) { return(Dal.OrderNewCar.Instance.Update(sqltran, model)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.OrderNewCar model) { return(Dal.OrderNewCar.Instance.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.OrderNewCar model) { Dal.OrderNewCar.Instance.Insert(model); }