public int Add(CustomerInfo entity) { int id = CommonDataProvider.Instance().AddCustomer(entity); if (id > 0) { RefreshCustomerCache(entity); CustomerMoveRecordInfo minfo = new CustomerMoveRecordInfo() { CustomerID = id, CustomerStatus = entity.CustomerStatus, OwnerID = entity.OwnerID, Owner = entity.Owner, LastUpdateUserID = entity.LastUpdateUserID, LastUpdateUser = entity.LastUpdateUser, CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"), SystemMsg = entity.SystemRemark }; CustomerMoveRecords.Instance.Add(minfo); } return id; }
public abstract int UpdateCustomerLastConnect(CustomerInfo entity);
public abstract int UpdateCustomer(CustomerInfo entity);
public abstract int AddCustomer(CustomerInfo entity);
public static CustomerInfo PopulateCustomerInfo(IDataReader reader) { CustomerInfo entity = new CustomerInfo() { ID = (int)reader["ID"], Name = reader["Name"] as string, Phone = reader["Phone"] as string, PhoneVest = reader["PhoneVest"] as string, BackupPhone = reader["BackupPhone"] as string, ProvinceID = (int)reader["ProvinceID"], CityID = (int)reader["CityID"], DistrictID = (int)reader["DistrictID"], Address = reader["Address"] as string, WeixinAccount = reader["WeixinAccount"] as string, InfoTypeID = (int)reader["InfoTypeID"], InfoSourceID = (int)reader["InfoSourceID"], PaymentWayID = (int)reader["PaymentWayID"], IbuyCarBrandID = (int)reader["IbuyCarBrandID"], IbuyCarSeriesID = (int)reader["IbuyCarSeriesID"], IbuyCarModelID = (int)reader["IbuyCarModelID"], IbuyTimeID = (int)reader["IbuyTimeID"], QuotedpriceInfo = reader["QuotedpriceInfo"] as string, PromotionInfo = reader["PromotionInfo"] as string, RemarkInfo = reader["RemarkInfo"] as string, CreateUserID = (int)reader["CreateUserID"], CreateUser = reader["CreateUser"] as string, CreateTime = reader["CreateTime"] as string, OwnerID = (int)reader["OwnerID"], Owner = reader["Owner"] as string, OwnerPowerGroupID = (int)reader["OwnerPowerGroupID"], CustomerSex = (int)reader["CustomerSex"], TracktagID = reader["TracktagID"] as string, Tracktag = reader["Tracktag"] as string, CustomerStatusSource = (int)reader["CustomerStatusSource"], CustomerStatus = (int)reader["CustomerStatus"], LastCustomerLevelID = (int)reader["LastCustomerLevelID"], LastConnectwayID = (int)reader["LastConnectwayID"], LastConnectTime = reader["LastConnectTime"] as string, LastConnectUserID = (int)reader["LastConnectUserID"], LastConnectUser = reader["LastConnectUser"] as string, LastConnectDetail = reader["LastConnectDetail"] as string, ReservationTime = reader["ReservationTime"] as string, VisitTime = reader["VisitTime"] as string, LeaveTime = reader["LeaveTime"] as string, VisitDuration = (int)reader["VisitDuration"], VisitNumber = (int)reader["VisitNumber"], IsVisit = (int)reader["IsVisit"], ConnectTimes = (int)reader["ConnectTimes"], LastUpdateUserID = (int)reader["LastUpdateUserID"], LastUpdateUser = reader["LastUpdateUser"] as string, LastUpdateTime = reader["LastUpdateTime"] as string, SbuyCarBrandID = (int)reader["SbuyCarBrandID"], SbuyCarSeriesID = (int)reader["SbuyCarSeriesID"], SbuyCarModelID = (int)reader["SbuyCarModelID"], OrderNumber = reader["OrderNumber"] as string, KnockdownPrice = reader["KnockdownPrice"] as string, PlaceOrderTime = reader["PlaceOrderTime"] as string, PicupcarTime = reader["PicupcarTime"] as string, GiveupCauseID = (int)reader["GiveupCauseID"], FailureCauseAnalyze = reader["FailureCauseAnalyze"] as string, MarketDirectorID = (int)reader["MarketDirectorID"], MarketDirector = reader["MarketDirector"] as string, DCCDirectorID = (int)reader["DCCDirectorID"], DCCDirector = reader["DCCDirector"] as string, ExhibitionDirectorID = (int)reader["ExhibitionDirectorID"], ExhibitionDirector = reader["ExhibitionDirector"] as string, DirectorID = (int)reader["DirectorID"], Director = reader["Director"] as string, SystemRemark = reader["SystemRemark"] as string, LurkStatus = (int)reader["LurkStatus"], CheckStatus = (int)reader["CheckStatus"], DelState = (bool)reader["DelState"] ? 1 : 0, PostTime = reader["PostTime"] as string, CorporationID = (int)reader["CorporationID"] }; return entity; }
/// <summary> /// 更新客户线索缓存 /// </summary> /// <param name="entity"></param> public void RefreshCustomerCache(CustomerInfo entity) { string key = GlobalKey.CUSTOMER_LIST + "_corp" + entity.CorporationID; List<CustomerInfo> list = MangaCache.Get(key) as List<CustomerInfo>; entity = GetCustomerByID(entity.ID); if (list != null && list.Exists(c => c.ID == entity.ID)) { list[list.FindIndex(c => c.ID == entity.ID)] = entity; } else if (list == null) { GetCustomerListByCorporation(entity.CorporationID, true); } else list.Add(entity); }
public int UpdateCustomerLastConnect(CustomerInfo entity) { int result = 0; result = CommonDataProvider.Instance().UpdateCustomerLastConnect(entity); if (result > 0) { RefreshCustomerCache(entity); } return result; }
public override int UpdateCustomerLastConnect(CustomerInfo entity) { string sql = @" UPDATE ComOpp_Customer SET [LastConnectTime] = @LastConnectTime ,[LastConnectDetail] = @LastConnectDetail ,[LastConnectUserID] = @LastConnectUserID ,[LastConnectUser] = @LastConnectUser ,[LastConnectwayID] = @LastConnectwayID ,[LastCustomerLevelID] = @LastCustomerLevelID ,[LastUpdateTime] = @LastUpdateTime ,[LastUpdateUserID] = @LastUpdateUserID ,[LastUpdateUser] = @LastUpdateUser ,[ConnectTimes] = @ConnectTimes WHERE [ID] = @ID "; SqlParameter[] p = { new SqlParameter("@ID",entity.ID), new SqlParameter("@LastConnectTime",entity.LastConnectTime), new SqlParameter("@LastConnectDetail",entity.LastConnectDetail), new SqlParameter("@LastConnectUserID",entity.LastConnectUserID), new SqlParameter("@LastConnectUser",entity.LastConnectUser), new SqlParameter("@LastConnectwayID",entity.LastConnectwayID), new SqlParameter("@LastCustomerLevelID",entity.LastCustomerLevelID), new SqlParameter("@LastUpdateTime",entity.LastUpdateTime), new SqlParameter("@LastUpdateUserID",entity.LastUpdateUserID), new SqlParameter("@LastUpdateUser",entity.LastUpdateUser), new SqlParameter("@ConnectTimes",entity.ConnectTimes) }; return DataConvert.SafeInt(SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, p)); }
public override int AddCustomer(CustomerInfo entity) { string sql = @" INSERT INTO ComOpp_Customer( [Name],[Phone],[BackupPhone],[ProvinceID],[CityID],[DistrictID],[Address],[WeixinAccount],[InfoTypeID],[InfoSourceID],[PaymentWayID],[IbuyCarBrandID] ,[IbuyCarSeriesID],[IbuyCarModelID],[IbuyTimeID],[QuotedpriceInfo],[PromotionInfo],[RemarkInfo],[OwnerID],[Owner],[OwnerPowerGroupID],[CustomerSex],[TracktagID] ,[Tracktag],[CustomerStatus],[CreateTime],[CreateUserID],[CreateUser],[LastUpdateUserID],[LastUpdateUser],[LastUpdateTime],[VisitTime],[VisitNumber],[IsVisit],[CorporationID],[PostTime],[SystemRemark] )VALUES( @Name,@Phone,@BackupPhone,@ProvinceID,@CityID,@DistrictID,@Address,@WeixinAccount,@InfoTypeID,@InfoSourceID,@PaymentWayID,@IbuyCarBrandID ,@IbuyCarSeriesID,@IbuyCarModelID,@IbuyTimeID,@QuotedpriceInfo,@PromotionInfo,@RemarkInfo,@OwnerID,@Owner,@OwnerPowerGroupID,@CustomerSex,@TracktagID ,@Tracktag,@CustomerStatus,@CreateTime,@CreateUserID,@CreateUser,@LastUpdateUserID,@LastUpdateUser,@LastUpdateTime,@VisitTime,@VisitNumber,@IsVisit,@CorporationID,@PostTime,@SystemRemark ); SELECT @@IDENTITY; "; SqlParameter[] p = { new SqlParameter("@Name",entity.Name), new SqlParameter("@Phone",entity.Phone), new SqlParameter("@BackupPhone",entity.BackupPhone), new SqlParameter("@ProvinceID",entity.ProvinceID), new SqlParameter("@CityID",entity.CityID), new SqlParameter("@DistrictID",entity.DistrictID), new SqlParameter("@Address",entity.Address), new SqlParameter("@WeixinAccount",entity.WeixinAccount), new SqlParameter("@InfoTypeID",entity.InfoTypeID), new SqlParameter("@InfoSourceID",entity.InfoSourceID), new SqlParameter("@PaymentWayID",entity.PaymentWayID), new SqlParameter("@IbuyCarBrandID",entity.IbuyCarBrandID), new SqlParameter("@IbuyCarSeriesID",entity.IbuyCarSeriesID), new SqlParameter("@IbuyCarModelID",entity.IbuyCarModelID), new SqlParameter("@IbuyTimeID",entity.IbuyTimeID), new SqlParameter("@QuotedpriceInfo",entity.QuotedpriceInfo), new SqlParameter("@PromotionInfo",entity.PromotionInfo), new SqlParameter("@RemarkInfo",entity.RemarkInfo), new SqlParameter("@OwnerID",entity.OwnerID), new SqlParameter("@Owner",entity.Owner), new SqlParameter("@OwnerPowerGroupID",entity.OwnerPowerGroupID), new SqlParameter("@CustomerSex",entity.CustomerSex), new SqlParameter("@TracktagID",entity.TracktagID), new SqlParameter("@Tracktag",entity.Tracktag), new SqlParameter("@CustomerStatus",entity.CustomerStatus), new SqlParameter("@CreateTime",entity.CreateTime), new SqlParameter("@CreateUserID",entity.CreateUserID), new SqlParameter("@CreateUser",entity.CreateUser), new SqlParameter("@LastUpdateUserID",entity.LastUpdateUserID), new SqlParameter("@LastUpdateUser",entity.LastUpdateUser), new SqlParameter("@LastUpdateTime",entity.LastUpdateTime), new SqlParameter("@VisitTime",entity.VisitTime), new SqlParameter("@VisitNumber",entity.VisitNumber), new SqlParameter("@IsVisit",entity.IsVisit), new SqlParameter("@CorporationID",entity.CorporationID), new SqlParameter("@PostTime",entity.PostTime), new SqlParameter("@SystemRemark",entity.SystemRemark) }; entity.ID = DataConvert.SafeInt(SqlHelper.ExecuteScalar(_con, CommandType.Text, sql, p)); return entity.ID; }
public abstract void UpdateCustomerPhoneVest(CustomerInfo entity);
public override int UpdateCustomer(CustomerInfo entity) { string sql = @" UPDATE ComOpp_Customer SET [Name] = @Name ,[Phone] = @Phone ,[BackupPhone] = @BackupPhone ,[ProvinceID] = @ProvinceID ,[CityID] = @CityID ,[DistrictID] = @DistrictID ,[Address] = @Address ,[WeixinAccount] = @WeixinAccount ,[InfoTypeID] = @InfoTypeID ,[InfoSourceID] = @InfoSourceID ,[PaymentWayID] = @PaymentWayID ,[IbuyCarBrandID] = @IbuyCarBrandID ,[IbuyCarSeriesID] = @IbuyCarSeriesID ,[IbuyCarModelID] = @IbuyCarModelID ,[IbuyTimeID] = @IbuyTimeID ,[QuotedpriceInfo] = @QuotedpriceInfo ,[PromotionInfo] = @PromotionInfo ,[RemarkInfo] = @RemarkInfo ,[OwnerID] = @OwnerID ,[Owner] = @Owner ,[OwnerPowerGroupID] = @OwnerPowerGroupID ,[CustomerSex] = @CustomerSex ,[TracktagID] = @TracktagID ,[Tracktag] = @Tracktag ,[CustomerStatusSource] = @CustomerStatusSource ,[CustomerStatus] = @CustomerStatus ,[ReservationTime] = @ReservationTime ,[VisitTime] = @VisitTime ,[LeaveTime] = @LeaveTime ,[VisitDuration] = @VisitDuration ,[VisitNumber] = @VisitNumber ,[IsVisit] = @IsVisit ,[LastUpdateUserID] = @LastUpdateUserID ,[LastUpdateUser] = @LastUpdateUser ,[LastUpdateTime] = @LastUpdateTime ,[SbuyCarBrandID] = @SbuyCarBrandID ,[SbuyCarSeriesID] = @SbuyCarSeriesID ,[SbuyCarModelID] = @SbuyCarModelID ,[OrderNumber] = @OrderNumber ,[KnockdownPrice] = @KnockdownPrice ,[PlaceOrderTime] = @PlaceOrderTime ,[PicupcarTime] = @PicupcarTime ,[GiveupCauseID] = @GiveupCauseID ,[FailureCauseAnalyze] = @FailureCauseAnalyze ,[SystemRemark] = @SystemRemark ,[CheckStatus] = @CheckStatus ,[LurkStatus] = @LurkStatus ,[DelState] = @DelState ,[PostTime] = @PostTime WHERE [ID] = @ID "; SqlParameter[] p = { new SqlParameter("@ID",entity.ID), new SqlParameter("@Name",entity.Name), new SqlParameter("@Phone",entity.Phone), new SqlParameter("@BackupPhone",entity.BackupPhone), new SqlParameter("@ProvinceID",entity.ProvinceID), new SqlParameter("@CityID",entity.CityID), new SqlParameter("@DistrictID",entity.DistrictID), new SqlParameter("@Address",entity.Address), new SqlParameter("@WeixinAccount",entity.WeixinAccount), new SqlParameter("@InfoTypeID",entity.InfoTypeID), new SqlParameter("@InfoSourceID",entity.InfoSourceID), new SqlParameter("@PaymentWayID",entity.PaymentWayID), new SqlParameter("@IbuyCarBrandID",entity.IbuyCarBrandID), new SqlParameter("@IbuyCarSeriesID",entity.IbuyCarSeriesID), new SqlParameter("@IbuyCarModelID",entity.IbuyCarModelID), new SqlParameter("@IbuyTimeID",entity.IbuyTimeID), new SqlParameter("@QuotedpriceInfo",entity.QuotedpriceInfo), new SqlParameter("@PromotionInfo",entity.PromotionInfo), new SqlParameter("@RemarkInfo",entity.RemarkInfo), new SqlParameter("@OwnerID",entity.OwnerID), new SqlParameter("@Owner",entity.Owner), new SqlParameter("@OwnerPowerGroupID",entity.OwnerPowerGroupID), new SqlParameter("@CustomerSex",entity.CustomerSex), new SqlParameter("@TracktagID",entity.TracktagID), new SqlParameter("@Tracktag",entity.Tracktag), new SqlParameter("@CustomerStatusSource",entity.CustomerStatusSource), new SqlParameter("@CustomerStatus",entity.CustomerStatus), new SqlParameter("@ReservationTime",entity.ReservationTime), new SqlParameter("@VisitTime",entity.VisitTime), new SqlParameter("@LeaveTime",entity.LeaveTime), new SqlParameter("@VisitDuration",entity.VisitDuration), new SqlParameter("@VisitNumber",entity.VisitNumber), new SqlParameter("@IsVisit",entity.IsVisit), new SqlParameter("@LastUpdateUserID",entity.LastUpdateUserID), new SqlParameter("@LastUpdateUser",entity.LastUpdateUser), new SqlParameter("@LastUpdateTime",entity.LastUpdateTime), new SqlParameter("@SbuyCarBrandID",entity.SbuyCarBrandID), new SqlParameter("@SbuyCarSeriesID",entity.SbuyCarSeriesID), new SqlParameter("@SbuyCarModelID",entity.SbuyCarModelID), new SqlParameter("@OrderNumber",entity.OrderNumber), new SqlParameter("@KnockdownPrice",entity.KnockdownPrice), new SqlParameter("@PlaceOrderTime",entity.PlaceOrderTime), new SqlParameter("@PicupcarTime",entity.PicupcarTime), new SqlParameter("@GiveupCauseID",entity.GiveupCauseID), new SqlParameter("@FailureCauseAnalyze",entity.FailureCauseAnalyze), new SqlParameter("@SystemRemark",entity.SystemRemark), new SqlParameter("@CheckStatus",entity.CheckStatus), new SqlParameter("@LurkStatus",entity.LurkStatus), new SqlParameter("@DelState",entity.DelState), new SqlParameter("@PostTime",entity.PostTime) }; return DataConvert.SafeInt(SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, p)); }
public abstract int UpdateCustomerLastConnect(CustomerInfo entity);
public abstract int UpdateCustomer(CustomerInfo entity);
public abstract int AddCustomer(CustomerInfo entity);
public static CustomerInfo PopulateCustomerInfo(IDataReader reader) { CustomerInfo entity = new CustomerInfo() { ID = (int)reader["ID"], Name = reader["Name"] as string, Phone = reader["Phone"] as string, PhoneVest = reader["PhoneVest"] as string, BackupPhone = reader["BackupPhone"] as string, ProvinceID = (int)reader["ProvinceID"], CityID = (int)reader["CityID"], DistrictID = (int)reader["DistrictID"], Address = reader["Address"] as string, WeixinAccount = reader["WeixinAccount"] as string, InfoTypeID = (int)reader["InfoTypeID"], InfoSourceID = (int)reader["InfoSourceID"], PaymentWayID = (int)reader["PaymentWayID"], IbuyCarBrandID = (int)reader["IbuyCarBrandID"], IbuyCarSeriesID = (int)reader["IbuyCarSeriesID"], IbuyCarModelID = (int)reader["IbuyCarModelID"], IbuyTimeID = (int)reader["IbuyTimeID"], QuotedpriceInfo = reader["QuotedpriceInfo"] as string, PromotionInfo = reader["PromotionInfo"] as string, RemarkInfo = reader["RemarkInfo"] as string, CreateUserID = (int)reader["CreateUserID"], CreateUser = reader["CreateUser"] as string, CreateTime = reader["CreateTime"] as string, OwnerID = (int)reader["OwnerID"], Owner = reader["Owner"] as string, OwnerPowerGroupID = (int)reader["OwnerPowerGroupID"], CustomerSex = (int)reader["CustomerSex"], TracktagID = reader["TracktagID"] as string, Tracktag = reader["Tracktag"] as string, CustomerStatusSource = (int)reader["CustomerStatusSource"], CustomerStatus = (int)reader["CustomerStatus"], LastCustomerLevelID = (int)reader["LastCustomerLevelID"], LastConnectwayID = (int)reader["LastConnectwayID"], LastConnectTime = reader["LastConnectTime"] as string, LastConnectUserID = (int)reader["LastConnectUserID"], LastConnectUser = reader["LastConnectUser"] as string, LastConnectDetail = reader["LastConnectDetail"] as string, ReservationTime = reader["ReservationTime"] as string, VisitTime = reader["VisitTime"] as string, LeaveTime = reader["LeaveTime"] as string, VisitDuration = (int)reader["VisitDuration"], VisitNumber = (int)reader["VisitNumber"], IsVisit = (int)reader["IsVisit"], ConnectTimes = (int)reader["ConnectTimes"], LastUpdateUserID = (int)reader["LastUpdateUserID"], LastUpdateUser = reader["LastUpdateUser"] as string, LastUpdateTime = reader["LastUpdateTime"] as string, SbuyCarBrandID = (int)reader["SbuyCarBrandID"], SbuyCarSeriesID = (int)reader["SbuyCarSeriesID"], SbuyCarModelID = (int)reader["SbuyCarModelID"], OrderNumber = reader["OrderNumber"] as string, KnockdownPrice = reader["KnockdownPrice"] as string, PlaceOrderTime = reader["PlaceOrderTime"] as string, PicupcarTime = reader["PicupcarTime"] as string, GiveupCauseID = (int)reader["GiveupCauseID"], FailureCauseAnalyze = reader["FailureCauseAnalyze"] as string, MarketDirectorID = (int)reader["MarketDirectorID"], MarketDirector = reader["MarketDirector"] as string, DCCDirectorID = (int)reader["DCCDirectorID"], DCCDirector = reader["DCCDirector"] as string, ExhibitionDirectorID = (int)reader["ExhibitionDirectorID"], ExhibitionDirector = reader["ExhibitionDirector"] as string, DirectorID = (int)reader["DirectorID"], Director = reader["Director"] as string, SystemRemark = reader["SystemRemark"] as string, LurkStatus = (int)reader["LurkStatus"], CheckStatus = (int)reader["CheckStatus"], DelState = (bool)reader["DelState"] ? 1 : 0, PostTime = reader["PostTime"] as string, CorporationID = (int)reader["CorporationID"] }; return(entity); }
public override void UpdateCustomerPhoneVest(CustomerInfo entity) { string sql = "UPDATE ComOpp_Customer SET [PhoneVest] = @PhoneVest WHERE [ID] = @ID"; SqlParameter[] p = { new SqlParameter("@PhoneVest",entity.PhoneVest), new SqlParameter("@ID",entity.ID) }; SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, p); }
public int Move(CustomerInfo entity) { int result = 0; CustomerMoveRecordInfo minfo = new CustomerMoveRecordInfo() { CustomerID = entity.ID, CustomerStatus = entity.CustomerStatus, CustomerStatusSource = entity.CustomerStatus, OwnerID = entity.OwnerID, Owner = entity.Owner, LastUpdateUserID = entity.LastUpdateUserID, LastUpdateUser = entity.LastUpdateUser, CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"), SystemMsg = DateTime.Today.ToString("yyyy年MM月dd日") + "线索批量移交" }; CustomerMoveRecords.Instance.Add(minfo); entity.SystemRemark = minfo.SystemMsg; result = CommonDataProvider.Instance().UpdateCustomer(entity); if (result > 0) { RefreshCustomerCache(entity); } return result; }
private void CommitData() { int result = 0; CustomerInfo entity = new CustomerInfo(); int id = GetInt("id"); if (id > 0 && CurrentCustomerInfo != null) { entity = Customers.Instance.GetCustomerByID(id); entity.LastUpdateUserID = AdminID; entity.LastUpdateUser = Admin.Realname; entity.LastUpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); FillData(entity); if (Action == "提交到导入|集客") { entity.CustomerStatusSource = entity.CustomerStatus; entity.CustomerStatus = (int)CustomerStatus.导入_集客; entity.PostTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); entity.CheckStatus = 0; entity.LurkStatus = 0; } if (Action == "提交到清洗|邀约") { entity.CustomerStatusSource = entity.CustomerStatus; entity.CustomerStatus = (int)CustomerStatus.清洗_邀约; entity.PostTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); entity.CheckStatus = 0; entity.LurkStatus = 0; } else if (Action == "提交到到店|洽谈") { entity.CustomerStatusSource = entity.CustomerStatus; entity.CustomerStatus = (int)CustomerStatus.到店_洽谈; entity.ReservationTime = Request["form[invitetime]"]; entity.PostTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); } else if (Action == "编辑到店|洽谈") { entity.VisitTime = Request["form[arrivetime]"]; entity.LeaveTime = Request["form[leavetime]"]; entity.VisitDuration = DataConvert.SafeInt(Request["form[reception]"]); entity.VisitNumber = DataConvert.SafeInt(Request["form[arrivepeoplenum]"]); if(entity.IsVisit == 0) entity.ReservationTime = Request["form[invitetime]"]; entity.IsVisit = 1; } else if (Action == "提交到追踪|促成") { entity.CustomerStatusSource = entity.CustomerStatus; entity.CustomerStatus = (int)CustomerStatus.追踪_促成; entity.VisitTime = Request["form[arrivetime]"]; entity.LeaveTime = Request["form[leavetime]"]; entity.VisitDuration = DataConvert.SafeInt(Request["form[reception]"]); entity.VisitNumber = DataConvert.SafeInt(Request["form[arrivepeoplenum]"]); entity.IsVisit = 1; entity.PostTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); } else if (Action == "提交到预订|成交") { entity.CustomerStatusSource = entity.CustomerStatus; entity.CustomerStatus = (int)CustomerStatus.预订_成交; entity.PlaceOrderTime = Request["form[endtime]"]; entity.KnockdownPrice = Request["form[strikeprice]"]; entity.OrderNumber = Request["form[ordernum]"]; entity.PostTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); } else if (Action == "编辑预订|成交") { entity.PlaceOrderTime = Request["form[endtime]"]; entity.KnockdownPrice = Request["form[strikeprice]"]; entity.OrderNumber = Request["form[ordernum]"]; } else if (Action == "提交到提车|回访") { entity.CustomerStatusSource = entity.CustomerStatus; entity.CustomerStatus = (int)CustomerStatus.提车_回访; entity.PlaceOrderTime = Request["form[endtime]"]; entity.KnockdownPrice = Request["form[strikeprice]"]; entity.OrderNumber = Request["form[ordernum]"]; entity.PicupcarTime = Request["form[delivertime]"]; entity.PostTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); } else if (Action == "编辑提车|回访") { entity.PlaceOrderTime = Request["form[endtime]"]; entity.KnockdownPrice = Request["form[strikeprice]"]; entity.OrderNumber = Request["form[ordernum]"]; entity.PicupcarTime = Request["form[delivertime]"]; } else if (Action == "提交到战败") { entity.CustomerStatusSource = entity.CustomerStatus; entity.CustomerStatus = (int)CustomerStatus.潜客_战败; entity.GiveupCauseID = DataConvert.SafeInt(Request["form[giveupcause]"]); entity.FailureCauseAnalyze = Request["form[failurereason]"]; entity.PostTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); entity.LurkStatus = 1; } else if (Action == "提交到转出|待审") { entity.CustomerStatusSource = entity.CustomerStatus; entity.CustomerStatus = (int)CustomerStatus.转出待审; entity.CheckStatus = 1; } else if (Action == "提交到潜客|转出") { if (entity.CustomerStatus != (int)CustomerStatus.转出待审) entity.CustomerStatusSource = entity.CustomerStatus; entity.CustomerStatus = (int)CustomerStatus.潜客_转出; entity.LurkStatus = 1; entity.CheckStatus = 0; } result = Customers.Instance.Update(entity); } else if(id == 0) { entity.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); entity.CreateUserID = AdminID; entity.CreateUser = Admin.Realname; entity.LastUpdateUserID = AdminID; entity.LastUpdateUser = Admin.Realname; entity.LastUpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); entity.PostTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); entity.CorporationID = GetInt("corpid"); entity.SystemRemark = DateTime.Today.ToString("yyyy年MM月dd日") + "线索录入"; FillData(entity); if (Action == "新增到店|洽谈") { entity.VisitTime = Request["form[arrivetime]"]; entity.VisitNumber = DataConvert.SafeInt(Request["form[arrivepeoplenum]"]); entity.IsVisit = 1; } result = Customers.Instance.Add(entity); } Response.Clear(); Response.Write(result == 0 ? "n" : "y"); Response.End(); }
public int Update(CustomerInfo entity) { int result = 0; CustomerInfo entityold = GetCustomerByID(entity.ID); if (entity.CustomerStatus != entityold.CustomerStatus || entity.OwnerID != entityold.OwnerID) { CustomerMoveRecordInfo minfo = new CustomerMoveRecordInfo() { CustomerID = entity.ID, CustomerStatus = entity.CustomerStatus, CustomerStatusSource = entityold.CustomerStatus, OwnerID = entity.OwnerID, Owner = entity.Owner, LastUpdateUserID = entity.LastUpdateUserID, LastUpdateUser = entity.LastUpdateUser, CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm") }; if (entity.CustomerStatus == (int)CustomerStatus.潜客_战败) minfo.SystemMsg = DateTime.Today.ToString("yyyy年MM月dd日") + "战败"; else if (entity.CustomerStatus == (int)CustomerStatus.潜客_转出) minfo.SystemMsg = DateTime.Today.ToString("yyyy年MM月dd日") + "由" + entityold.CustomerStatusName + "转出"; else if (entity.CustomerStatus != entityold.CustomerStatus) minfo.SystemMsg = DateTime.Today.ToString("yyyy年MM月dd日") + "由" + entityold.CustomerStatusName + "转入"; else if (entity.OwnerID != entityold.OwnerID) minfo.SystemMsg = DateTime.Today.ToString("yyyy年MM月dd日") + "变更线索所有人"; CustomerMoveRecords.Instance.Add(minfo); if (entity.CustomerStatus != (int)CustomerStatus.潜客_战败 && entity.CustomerStatus != (int)CustomerStatus.潜客_转出) entity.SystemRemark = minfo.SystemMsg; if (entity.OwnerID != entityold.OwnerID) { AdminInfo owner = Admins.Instance.GetAdmin(entity.OwnerID); entity.OwnerPowerGroupID = owner.PowerGroupID; } } result = CommonDataProvider.Instance().UpdateCustomer(entity); if (result > 0) { RefreshCustomerCache(entity); } return result; }
private void FillData(CustomerInfo entity) { entity.Name = Request["form[uname]"]; entity.Phone = Request["form[phone]"]; entity.BackupPhone = Request["form[sparephone]"]; entity.ProvinceID = DataConvert.SafeInt(Request["form[province]"]); entity.CityID = DataConvert.SafeInt(Request["form[city]"]); entity.DistrictID = DataConvert.SafeInt(Request["form[district]"]); entity.Address = Request["form[address]"]; entity.WeixinAccount = Request["form[weixin]"]; entity.InfoTypeID = DataConvert.SafeInt(Request["form[infotype]"]); entity.InfoSourceID = DataConvert.SafeInt(Request["form[infosource]"]); entity.PaymentWayID = DataConvert.SafeInt(Request["form[paymentway]"]); if (Action == "提交到预订|成交" || Action == "编辑预订|成交" || Action == "提交到提车|回访" || Action == "编辑提车|回访") { entity.SbuyCarBrandID = DataConvert.SafeInt(Request["form[brand]"]); entity.SbuyCarSeriesID = DataConvert.SafeInt(Request["form[series]"]); entity.SbuyCarModelID = DataConvert.SafeInt(Request["form[spec]"]); } else { entity.IbuyCarBrandID = DataConvert.SafeInt(Request["form[brand]"]); entity.IbuyCarSeriesID = DataConvert.SafeInt(Request["form[series]"]); entity.IbuyCarModelID = DataConvert.SafeInt(Request["form[spec]"]); } entity.IbuyTimeID = DataConvert.SafeInt(Request["form[ibuytime]"]); entity.QuotedpriceInfo = Request["form[price]"]; entity.PromotionInfo = Request["form[slogan]"]; entity.RemarkInfo = Request["form[content]"]; entity.OwnerID = DataConvert.SafeInt(Request["form[owneruid]"]); entity.Owner = new Regex("\\([\\s\\S]+\\)").Replace(Request["form[owner]"],string.Empty); entity.CustomerSex = DataConvert.SafeInt(Request["form[sex]"]); entity.TracktagID = Request["form[tracktag]"]; entity.Tracktag = Request["form[tracktagname]"]; entity.CustomerStatus = DataConvert.SafeInt(Request["form[customerstatus]"]); if (GetString("action") == "recover") { entity.DelState = 0; entity.CustomerStatusSource = entity.CustomerStatus; entity.CustomerStatus = (int)CustomerStatus.清洗_邀约; entity.PostTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); entity.CheckStatus = 0; entity.LurkStatus = 0; } AdminInfo ownerinfo = Admins.Instance.GetAdmin(entity.OwnerID); if(ownerinfo != null) entity.OwnerPowerGroupID = ownerinfo.PowerGroupID; }
/// <summary> /// 更新客户号码归属地 /// </summary> /// <param name="entity"></param> public void UpdateCustomerPhoneVest(CustomerInfo entity) { CommonDataProvider.Instance().UpdateCustomerPhoneVest(entity); }
public abstract void UpdateCustomerPhoneVest(CustomerInfo entity);
/// <summary> /// 更新客户号码归属地 /// </summary> /// <param name="entity"></param> public void UpdateCustomerPhoneVest(CustomerInfo entity) { CommonDataProvider.Instance().UpdateCustomerPhoneVest(entity); }
protected void Page_Load(object sender, EventArgs e) { if (IsPost()) { int corpid = GetInt("corpid"); int state = GetInt("state"); HttpPostedFile file = Request.Files[0]; DataTable t = ImportDataTableFromExcel(file.InputStream, 0, 0); List<InfoTypeInfo> infotypelist = InfoTypes.Instance.GetListByCorpid(corpid, true); List<InfoSourceInfo> infosourcelist = InfoSources.Instance.GetListByCorpid(corpid, true); List<CarBrandInfo> brandlist = Cars.Instance.GetCarBrandList(true); List<AdminInfo> adminlist = Admins.Instance.GetAllAdmins(); foreach (DataRow row in t.Rows) { string customername = row["客户姓名"].ToString(); string sex = row["性别"].ToString(); string phone = row["客户电话"].ToString(); string backupphone = row["备用电话"].ToString(); string weixin = row["微信号"].ToString(); string infotype = row["信息类型"].ToString(); string infosource = row["信息来源"].ToString(); string ibuybrand = row["拟购品牌"].ToString(); string ibuyseries = row["拟购车系"].ToString(); string ibuymodel = row["拟购车型"].ToString(); string remark = row["备注"].ToString(); string owner = row["线索所有人"].ToString(); if (string.IsNullOrEmpty(customername) || string.IsNullOrEmpty(phone)) continue; Regex rphone = new Regex(@"^1[\d]{10}$"); if (!rphone.IsMatch(phone)) continue; if (Customers.Instance.GetCustomerByPhone(phone, corpid) == null) { CustomerInfo entity = new CustomerInfo() { Name = customername, Phone = phone, BackupPhone = backupphone, WeixinAccount = weixin, RemarkInfo = remark, SystemRemark = DateTime.Today.ToString("yyyy年MM月dd日") + "导入线索" }; switch (sex) { case "男": entity.CustomerSex = 1; break; case "女": entity.CustomerSex = 2; break; default: entity.CustomerSex = 0; break; } entity.InfoTypeID = infotypelist.Exists(l => l.Name.ToLower() == infotype.ToLower().Trim()) ? infotypelist.Find(l => l.Name.ToLower() == infotype.ToLower().Trim()).ID : 0; entity.InfoSourceID = infosourcelist.Exists(l => l.Name.ToLower() == infosource.ToLower().Trim()) ? infosourcelist.Find(l => l.Name.ToLower() == infosource.ToLower().Trim()).ID : 0; entity.IbuyCarBrandID = brandlist.Exists(l => l.Name.ToLower() == ibuybrand.ToLower().Trim()) ? brandlist.Find(l => l.Name.ToLower() == ibuybrand.ToLower().Trim()).ID : 0; if (entity.IbuyCarBrandID > 0) { List<CarSeriesInfo> serieslist = Cars.Instance.GetCarSeriesListByBrandID(entity.IbuyCarBrandID, true); entity.IbuyCarSeriesID = serieslist.Exists(l => l.Name.ToLower() == ibuyseries.ToLower().Trim()) ? serieslist.Find(l => l.Name.ToLower() == ibuyseries.ToLower().Trim()).ID : 0; } else entity.IbuyCarSeriesID = 0; if (entity.IbuyCarSeriesID > 0) { List<CarModelInfo> modellist = Cars.Instance.GetCarModelListBySeriesID(entity.IbuyCarSeriesID, true); entity.IbuyCarModelID = modellist.Exists(l => l.Name.ToLower() == ibuymodel.ToLower().Trim()) ? modellist.Find(l => l.Name.ToLower() == ibuymodel.ToLower().Trim()).ID : 0; } else entity.IbuyCarModelID = 0; entity.OwnerID = AdminID; entity.Owner = Admin.Realname; entity.OwnerPowerGroupID = Admin.PowerGroupID; if (!string.IsNullOrEmpty(owner)) { AdminInfo ownerinfo = adminlist.Find(l => l.CorporationID == corpid && l.Realname == owner); if (ownerinfo != null) { entity.OwnerID = ownerinfo.ID; entity.Owner = ownerinfo.Realname; entity.OwnerPowerGroupID = ownerinfo.PowerGroupID; } } entity.CustomerStatus = state; entity.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); entity.CreateUserID = AdminID; entity.CreateUser = Admin.Realname; entity.LastUpdateUserID = AdminID; entity.LastUpdateUser = Admin.Realname; entity.LastUpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); entity.PostTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); entity.CorporationID = corpid; Customers.Instance.Add(entity); } } WriteSuccessMessage("操作完成", "导入数据成功!", "~/chance/chancemg.aspx"); } }