/// <summary> /// 获得会员除去4个字段的对照文本信息 /// </summary> /// <param name="cc_DMSMember"></param> /// <param name="DMSMember"></param> /// <param name="contrastInfoInside"></param> /// <param name="contrastInfo"></param> private void GetDMSMemberContrastByPart2(Entities.ProjectTask_DMSMember cc_DMSMember, BitAuto.YanFa.Crm2009.Entities.DMSMember DMSMember, ref string contrastInfoInside, ref string contrastInfo) { if (cc_DMSMember.Phone != DMSMember.Phone) { contrastInfoInside += "Phone:('" + Util.EscapeString(DMSMember.Phone) + "','" + Util.EscapeString(cc_DMSMember.Phone) + "'),"; contrastInfo += "易湃会员电话由:" + DMSMember.Phone + ",改为:" + cc_DMSMember.Phone + ","; } if (cc_DMSMember.Fax != DMSMember.Fax) { contrastInfoInside += "Fax:('" + Util.EscapeString(DMSMember.Fax) + "','" + Util.EscapeString(cc_DMSMember.Fax) + "'),"; contrastInfo += "易湃会员传真由:" + DMSMember.Fax + ",改为:" + cc_DMSMember.Fax + ","; } if (cc_DMSMember.CompanyWebSite != DMSMember.CompanyWebSite) { contrastInfoInside += "CompanyWebSite:('" + Util.EscapeString(DMSMember.CompanyWebSite) + "','" + Util.EscapeString(cc_DMSMember.CompanyWebSite) + "'),"; contrastInfo += "易湃会员公司网址由:" + DMSMember.CompanyWebSite + ",改为:" + cc_DMSMember.CompanyWebSite + ","; } if (cc_DMSMember.Email != DMSMember.Email) { contrastInfoInside += "Email:('" + Util.EscapeString(DMSMember.Email) + "','" + Util.EscapeString(cc_DMSMember.Email) + "'),"; contrastInfo += "易湃会员Email由:" + DMSMember.Email + ",改为:" + cc_DMSMember.Email + ","; } if (cc_DMSMember.Postcode != DMSMember.Postcode) { contrastInfoInside += "Postcode:('" + Util.EscapeString(DMSMember.Postcode) + "','" + Util.EscapeString(cc_DMSMember.Postcode) + "'),"; contrastInfo += "易湃会员邮编由:" + DMSMember.Postcode + ",改为:" + cc_DMSMember.Postcode + ","; } if (cc_DMSMember.ContactAddress != DMSMember.ContactAddress) { contrastInfoInside += "ContactAddress:('" + Util.EscapeString(DMSMember.ContactAddress) + "','" + Util.EscapeString(cc_DMSMember.ContactAddress) + "'),"; contrastInfo += "易湃会员销售地址由:" + DMSMember.ContactAddress + ",改为:" + cc_DMSMember.ContactAddress + ","; } contrastInfoInside = contrastInfoInside.TrimEnd(','); contrastInfo = contrastInfo.TrimEnd(','); }
//public bool isDisabled = true; /// <summary> /// 已有的会员 /// </summary> public UCEditMember(Entities.ProjectTask_DMSMember member) : this() { this.Member = member; this.TaskID = member.PTID; this.MemberID = member.MemberID; if (!string.IsNullOrEmpty(member.MemberCode)) { spanMemberID.InnerText = member.MemberCode; liMemberID.Style.Remove("display"); if (member.SyncStatus != null) { spanMemberSyncStatus.InnerText = BitAuto.YanFa.Crm2009.BLL.Util.GetEnumOptText(member.SyncStatus.Value); liMemberSyncStatus.Style.Remove("display"); } liMemberCooperated.Style.Remove("display"); li400.Style.Remove("display"); } if (string.IsNullOrEmpty(member.OriginalDMSMemberID) == false && member.SyncStatus != (int)BitAuto.YanFa.Crm2009.Entities.EnumDMSSyncStatus.Rejected) //会员状态!=打回 { selMemberType.Attributes.Add("disabled", "disabled"); //不能编辑会员类型 //isDisabled = false; } SyncStatus = member.SyncStatus.ToString(); this.tfMemberID.Value = member.MemberID.ToString(); this.OriginalDMSMemberID = string.IsNullOrEmpty(member.OriginalDMSMemberID) ? "" : member.OriginalDMSMemberID; this.ControlName = "易湃会员(" + member.Name + ")"; }
private void LoadBrandInfoOfMember(Entities.ProjectTask_DMSMember m) { StringBuilder sb1 = new StringBuilder(); StringBuilder sb2 = new StringBuilder(); //品牌 DataTable dtdb = Dal.ProjectTask_DMSMember_Brand.Instance.GetProjectTask_DMSMember_MainBrand(m.MemberID); foreach (DataRow drdb in dtdb.Rows) { sb1.Append(drdb["BrandID"].ToString() + ","); sb2.Append(drdb["BrandName"].ToString() + ","); } m.BrandIDs = sb1.ToString().Trim(','); m.BrandNames = sb2.ToString().Trim(','); //附加子品牌 sb1 = new StringBuilder(); sb2 = new StringBuilder(); dtdb = Dal.ProjectTask_DMSMember_Brand.Instance.GetProjectTask_DMSMember_SerialBrand(m.MemberID); foreach (DataRow drdb in dtdb.Rows) { sb1.Append(drdb["SerialID"].ToString() + ","); sb2.Append(drdb["SerialName"].ToString() + ","); } m.SerialIds = sb1.ToString().Trim(','); m.SerialNames = sb2.ToString().Trim(','); }
public void ProjectTask_DMSMemberDelete(int memberId) { Entities.ProjectTask_DMSMember c = this.GetProjectTask_DMSMember(memberId); if (c == null) { throw new Exception("无法得到此会员"); } Dal.ProjectTask_DMSMember.Instance.Delete(memberId); }
/// <summary> /// 增加一条数据 /// </summary> public int Insert(Entities.ProjectTask_DMSMember model) { SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@PTID", SqlDbType.VarChar), new SqlParameter("@OriginalDMSMemberID", SqlDbType.VarChar, 50), new SqlParameter("@Name", SqlDbType.VarChar, 256), new SqlParameter("@Abbr", SqlDbType.VarChar, 64), new SqlParameter("@Phone", SqlDbType.VarChar, 256), new SqlParameter("@Fax", SqlDbType.VarChar, 128), new SqlParameter("@CompanyWebSite", SqlDbType.VarChar, 256), new SqlParameter("@Email", SqlDbType.VarChar, 256), new SqlParameter("@Postcode", SqlDbType.VarChar, 32), new SqlParameter("@ProvinceID", SqlDbType.VarChar, 20), new SqlParameter("@CityID", SqlDbType.VarChar, 20), new SqlParameter("@CountyID", SqlDbType.VarChar, 20), new SqlParameter("@ContactAddress", SqlDbType.VarChar, 256), new SqlParameter("@Longitude", SqlDbType.VarChar, 64), new SqlParameter("@Lantitude", SqlDbType.VarChar, 64), new SqlParameter("@TrafficInfo", SqlDbType.VarChar, 1024), new SqlParameter("@BrandGroupID", SqlDbType.Int, 4), new SqlParameter("@EnterpriseBrief", SqlDbType.VarChar, 1024), new SqlParameter("@Remarks", SqlDbType.VarChar, 256), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@MemberType", SqlDbType.VarChar, 20) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.PTID; parameters[2].Value = model.OriginalDMSMemberID; parameters[3].Value = model.Name; parameters[4].Value = model.Abbr; parameters[5].Value = model.Phone; parameters[6].Value = model.Fax; parameters[7].Value = model.CompanyWebSite; parameters[8].Value = model.Email; parameters[9].Value = model.Postcode; parameters[10].Value = model.ProvinceID; parameters[11].Value = model.CityID; parameters[12].Value = model.CountyID; parameters[13].Value = model.ContactAddress; parameters[14].Value = model.Longitude; parameters[15].Value = model.Lantitude; parameters[16].Value = model.TrafficInfo; parameters[17].Value = model.BrandGroupID; parameters[18].Value = model.EnterpriseBrief; parameters[19].Value = model.Remarks; parameters[20].Value = model.Status; parameters[21].Value = model.MemberType; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_DMSMEMBER_INSERT, parameters); return(Convert.ToInt32(parameters[0].Value.ToString())); }
/// <summary> /// 删除会员 /// </summary> public void Delete(int memberId) { Entities.ProjectTask_DMSMember c = this.GetProjectTask_DMSMember(memberId); if (c == null) { throw new Exception("无法得到此会员"); } if (c.OriginalDMSMemberID.Length > 0) { throw new Exception("不可删除CRM中已有的会员"); } Dal.ProjectTask_DMSMember.Instance.Delete(memberId); }
/// <summary> /// 插入到审核对照表,类型为:会员主营品牌变化,则生成记录 /// </summary> /// <param name="cc_DMSMember">呼叫中心会员实体</param> /// <param name="DMSMember">CRM系统会员实体</param> /// <returns>返回插入记录主键ID</returns> public int InsertByDMSMemberBrandChange(Entities.ProjectTask_DMSMember cc_DMSMember, BitAuto.YanFa.Crm2009.Entities.DMSMember DMSMember) { int recid = -1; if (cc_DMSMember != null && DMSMember != null) { Entities.ProjectTask_AuditContrastInfo model = new Entities.ProjectTask_AuditContrastInfo(); model.PTID = cc_DMSMember.PTID; model.DMSMemberID = DMSMember.ID.ToString(); model.CustID = DMSMember.CustID; model.CreateTime = DateTime.Now; model.CreateUserID = BLL.Util.GetLoginUserID(); model.ExportStatus = 0; //0-未导出,1-已导出 model.DisposeStatus = 0; //未处理 string contrastInfoInside = string.Empty; string contrastInfo = string.Empty; //判断会员类型字段是否有过更改 if (!BLL.Util.IsEqualsByStringArray(cc_DMSMember.BrandIDs, DMSMember.BrandIds)) { model.ContrastType = 6; contrastInfoInside += "BrandIDs:('" + Util.EscapeString(DMSMember.BrandIds) + "','" + Util.EscapeString(cc_DMSMember.BrandIDs) + "'),"; contrastInfo += "会员主营品牌由:" + DMSMember.BrandNames + ",改为:" + cc_DMSMember.BrandNames + ","; contrastInfoInside = contrastInfoInside.TrimEnd(','); contrastInfo = contrastInfo.TrimEnd(','); if (contrastInfoInside != string.Empty && contrastInfo != string.Empty) { model.ContrastInfoInside = contrastInfoInside; model.ContrastInfo = contrastInfo; if (string.IsNullOrEmpty(DMSMember.MemberCode)) //是否会员开通成功 { model.DisposeStatus = 1; //已处理 model.DisposeTime = DateTime.Now; } Insert(model); } } contrastInfoInside = string.Empty; contrastInfo = string.Empty; } return(recid); }
public void SaveMemberInfo() { //保存车易通信息 Entities.ProjectTask_DMSMember member = null; Validate(false, out member); if (member != null) { BLL.ProjectTask_DMSMember.Instance.InsertOrUpdate(member); } //保存车商通信息 BitAuto.YanFa.Crm2009.Entities.CstMember member1 = null; string Brands = ""; //Crm2009.Entities.CSTMember_Brand modelBrand = null; BitAuto.YanFa.Crm2009.Entities.CSTLinkMan modelLinkMan = null; ValidateCSTMember(false, out member1, out Brands, out modelLinkMan); if (member1 != null) { BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.UpdateCstMember(member1); } //主营品牌 12.6.4注释 //if (Brands != "") //{ // string[] brandID = Brands.Split(','); // Crm2009.BLL.CSTMember_Brand.Instance.DeleteByCSTRecID(member1.CSTRecID); // for (int i = 0; i < brandID.Length; i++) // { // if (brandID[i] != "") // { // Crm2009.Entities.CSTMember_Brand modelBrand = new Crm2009.Entities.CSTMember_Brand(); // modelBrand.CSTRecID = member1.CSTRecID; // modelBrand.CreateTime = DateTime.Now; // modelBrand.BrandID = int.Parse(brandID[i]); // Crm2009.BLL.CSTMember_Brand.Instance.Add(modelBrand); // } // } //} if (modelLinkMan != null) { BitAuto.YanFa.Crm2009.BLL.CSTLinkMan.Instance.Update(modelLinkMan); } }
public UCMember(Entities.ProjectTask_DMSMember member) : this() { //this.MemberID = member.ID; //this.tfMemberID.Value = member.ID.ToString(); //this.OriginalDMSMemberID = string.IsNullOrEmpty(member.OriginalDMSMemberID) ? "" : member.OriginalDMSMemberID; this.Member = member; this.ControlName = "易湃会员(" + Member.Name + ")"; if (!string.IsNullOrEmpty(member.MemberCode)) { spanMemberID.InnerText = member.MemberCode; liMemberID.Style.Remove("display"); if (member.SyncStatus != null) { spanMemberSyncStatus.InnerText = BitAuto.YanFa.Crm2009.BLL.Util.GetEnumOptText(member.SyncStatus.Value); liMemberSyncStatus.Style.Remove("display"); li400.Style.Remove("display"); } liMemberCooperated.Style.Remove("display"); } }
public void InsertOrUpdate(Entities.ProjectTask_DMSMember member) { if (string.IsNullOrEmpty(member.PTID)) { throw new Exception("TID不可无意义"); } member.Status = 0; if (member.MemberID > 0) { Dal.ProjectTask_DMSMember.Instance.Update(member); } else { member.MemberID = Dal.ProjectTask_DMSMember.Instance.Insert(member); } //更新品牌与子品牌 Dal.ProjectTask_DMSMember_Brand.Instance.UpdateMemberSerial(member.MemberID, member.BrandIDs, "", 0); Dal.ProjectTask_DMSMember_Brand.Instance.UpdateMemberSerial(member.MemberID, "", member.SerialIds, 1); }
/// <summary> /// 获得会员4个字段的对照文本信息 /// </summary> /// <param name="cc_DMSMember"></param> /// <param name="DMSMember"></param> /// <param name="contrastInfoInside"></param> /// <param name="contrastInfo"></param> private void GetDMSMemberContrastByPart1(Entities.ProjectTask_DMSMember cc_DMSMember, BitAuto.YanFa.Crm2009.Entities.DMSMember DMSMember, ref string contrastInfoInside, ref string contrastInfo) { if (cc_DMSMember.Name != DMSMember.Name) { contrastInfoInside += "Name:('" + Util.EscapeString(DMSMember.Name) + "','" + Util.EscapeString(cc_DMSMember.Name) + "'),"; contrastInfo += "易湃会员名称由:" + DMSMember.Name + ",改为:" + cc_DMSMember.Name + ","; } if (cc_DMSMember.Abbr != DMSMember.Abbr) { contrastInfoInside += "Abbr:('" + Util.EscapeString(DMSMember.Abbr) + "','" + Util.EscapeString(cc_DMSMember.Abbr) + "'),"; contrastInfo += "易湃会员简称由:" + DMSMember.Abbr + ",改为:" + cc_DMSMember.Abbr + ","; } if (cc_DMSMember.ProvinceID != DMSMember.ProvinceID) { contrastInfoInside += "ProvinceID:('" + Util.EscapeString(DMSMember.ProvinceID) + "','" + Util.EscapeString(cc_DMSMember.ProvinceID) + "'),"; contrastInfo += "易湃会员所属省份由:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(DMSMember.ProvinceID) + ",改为:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(cc_DMSMember.ProvinceID) + ","; } if (cc_DMSMember.CityID != DMSMember.CityID) { contrastInfoInside += "CityID:('" + Util.EscapeString(DMSMember.CityID) + "','" + Util.EscapeString(cc_DMSMember.CityID) + "'),"; contrastInfo += "易湃会员所属城市由:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(DMSMember.CityID) + ",改为:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(cc_DMSMember.CityID) + ","; } if (cc_DMSMember.CountyID != DMSMember.CountyID) { contrastInfoInside += "CountyID:('" + Util.EscapeString(DMSMember.CountyID) + "','" + Util.EscapeString(cc_DMSMember.CountyID) + "'),"; contrastInfo += "易湃会员所属区县由:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(DMSMember.CountyID) + ",改为:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(cc_DMSMember.CountyID) + ","; } if (cc_DMSMember.MemberType != DMSMember.MemberType) { contrastInfoInside += "MemberType:('" + Util.EscapeString(DMSMember.MemberType) + "','" + Util.EscapeString(cc_DMSMember.MemberType) + "'),"; contrastInfo += "易湃会员类型由:" + GetMemberType(DMSMember.MemberType) + ",改为:" + GetMemberType(cc_DMSMember.MemberType) + ","; } contrastInfoInside = contrastInfoInside.TrimEnd(','); contrastInfo = contrastInfo.TrimEnd(','); }
public List <Entities.ProjectTask_DMSMember> GetProjectTask_DMSMemberByTID(string taskId) { List <Entities.ProjectTask_DMSMember> list = new List <Entities.ProjectTask_DMSMember>(); int tc = -1; Entities.QueryProjectTask_DMSMember q = new QueryProjectTask_DMSMember(); q.PTID = StringHelper.SqlFilter(taskId); DataTable dt = this.GetProjectTask_DMSMember(q, " ProjectTask_DMSMember.MemberID desc", 1, 10000, out tc); if (tc > 0) { foreach (DataRow dr in dt.Rows) { Entities.ProjectTask_DMSMember m = LoadSingleProjectTask_DMSMember(dr); LoadBrandInfoOfMember(m); list.Add(m); } } return(list); }
public void Validate(bool whenSubmit, out Entities.ProjectTask_DMSMember member) { Regex reMemberPhoneAndFax = new Regex(@"(^0[0-9]{2,3}-[0-9]{7,8}$)|(^0[0-9]{2,3}-[0-9]{7,8}-[0-9]{1,5}$)|(^13[0-9]{9}$)|(^15[0-9]{9}$)|(^18[0-9]{9}$)|(^400\d{7}$)"); int id = -1; if (MemberID != "") { if (!int.TryParse(MemberID, out id)) { throw new Exception("会员ID无法转换为int类型"); } member = BLL.ProjectTask_DMSMember.Instance.GetProjectTask_DMSMember(int.Parse(MemberID)); member.MemberID = int.Parse(MemberID);; if (string.IsNullOrEmpty(Name)) { throw new Exception("会员名称不能为空"); } if (Name.Length > 256) { throw new Exception("会员名称超长"); } member.Name = Name; if (string.IsNullOrEmpty(Abbr)) { throw new Exception("会员简称不可为空"); } member.Abbr = Abbr; if (BLL.Util.GetLength(abbr) > 14) { throw new Exception("会员简称不能超过14个字符"); } //Modify=Masj,Date=2012-08-28 if (whenSubmit) { if (string.IsNullOrEmpty(member.OriginalDMSMemberID) == false) { if (BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.IsExistsByAbbrName(member.OriginalDMSMemberID, Abbr, 1)) { BitAuto.YanFa.Crm2009.Entities.QueryDMSMember query = new BitAuto.YanFa.Crm2009.Entities.QueryDMSMember(); query.Abbr = Abbr; int total = 0; DataTable dt = BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetMemberAndCust(query, "", 1, 1000000, out total); string msg = string.Empty; for (int j = 0; j < dt.Rows.Count; j++) { msg += "客户名称:" + dt.Rows[j]["CustName"].ToString() + ";会员全称:" + dt.Rows[j]["Name"].ToString() + ";会员简称" + dt.Rows[j]["Abbr"].ToString() + "<br>"; if (j < dt.Rows.Count) { msg += "--------------------------------"; } } throw new Exception("已存在此会员简称<br>" + msg); } } } if (whenSubmit && string.IsNullOrEmpty(MemberType)) { throw new Exception("会员类型不能为空"); } member.MemberType = MemberType; if (Phone.Length > 256) { throw new Exception("会员电话超长"); } if (!string.IsNullOrEmpty(Phone) && Phone.Split(',').Length > 0) { foreach (string phone in Phone.Split(',')) { if ((!string.IsNullOrEmpty(phone)) && (!reMemberPhoneAndFax.IsMatch(phone))) { throw new Exception("会员电话格式不正确,<br/>固话:010-68492345 010-68492345-8217 手机:直接输入13245687921 特殊号码:4000689960"); } } } member.Phone = Phone.TrimEnd(',').TrimStart(','); //member.BrandIDs = Brand; if (Fax.Length > 256) { throw new Exception("会员传真超长"); } if (!string.IsNullOrEmpty(Fax) && Fax.Split(',').Length > 0) { foreach (string fax in Fax.Split(',')) { if ((!string.IsNullOrEmpty(fax)) && (!reMemberPhoneAndFax.IsMatch(fax))) { throw new Exception("会员传真格式不正确,<br/>固话:010-68492345 010-68492345-8217 手机:直接输入13245687921 特殊号码:4000689960"); } } } member.Fax = Fax.TrimEnd(',').TrimStart(','); if (CompanyWebSite.Length > 256) { throw new Exception("会员公司网址超长"); } member.CompanyWebSite = CompanyWebSite; if (Email.Length > 256) { throw new Exception("会员Email超长"); } member.Email = Email; if (PostCode.Length > 32) { throw new Exception("会员邮编超长"); } member.Postcode = PostCode; if (whenSubmit && string.IsNullOrEmpty(Brand)) { throw new Exception("主营品牌必填"); } member.BrandIDs = Brand; int i = -1; if (string.IsNullOrEmpty(ProvinceId) == false && int.TryParse(ProvinceId, out i) == false) { throw new Exception("ProvinceID无法转换成int类型"); } if (whenSubmit && i <= 0) { throw new Exception("会员省份必填"); } member.ProvinceID = ProvinceId; if (string.IsNullOrEmpty(CityID) == false && int.TryParse(CityID, out i) == false) { throw new Exception("CityID无法转换成int类型"); } if (whenSubmit && i <= 0) { throw new Exception("会员城市必填"); } member.CityID = CityID; if (string.IsNullOrEmpty(CountyId) == false && int.TryParse(CountyId, out i) == false) { throw new Exception("CountyID无法转换成int类型"); } member.CountyID = CountyId; if (ContactAddress.Length > 256) { throw new Exception("会员地址超长"); } if (whenSubmit && string.IsNullOrEmpty(contactAddress)) { throw new Exception("会员地址必填"); } member.ContactAddress = contactAddress; float l = -1; if (string.IsNullOrEmpty(Longitude) == false && float.TryParse(Longitude, out l) == false) { throw new Exception("Longitude无法转换成float类型"); } if (whenSubmit && l <= 0) { throw new Exception("地图标点必填"); } member.Longitude = Longitude; if (string.IsNullOrEmpty(Lantitude) == false && float.TryParse(Lantitude, out l) == false) { throw new Exception("Lantitude无法转换成float类型"); } if (whenSubmit && l <= 0) { throw new Exception("地图标点必填"); } member.Lantitude = Lantitude; //member.SerialIds = SerialIds; if (TrafficInfo.Length > 1024) { throw new Exception("会员交通信息超长"); } member.TrafficInfo = TrafficInfo; if (EnterpriseBrief.Length > 1024) { throw new Exception("会员企业简介超长"); } member.EnterpriseBrief = EnterpriseBrief; if (Remarks.Length > 1024) { throw new Exception("会员备注超长"); } member.Remarks = Remarks; member.SerialIds = SerialIDs; } else { member = null; } }
/// <summary> /// 插入到审核对照表,类型为:会员信息变化,若会员有变化,则生成记录 /// </summary> /// <param name="recid">表ProjectTask_AuditContrastInfo主键</param> /// <param name="cC_DMSMember">呼叫中心会员实体</param> /// <param name="DMSMember">CRM系统会员实体</param> /// <returns></returns> public void UpdateMemberInfo(int recid, Entities.ProjectTask_DMSMember cc_DMSMember, BitAuto.YanFa.Crm2009.Entities.DMSMember DMSMember) { if (cc_DMSMember != null && DMSMember != null && !string.IsNullOrEmpty(DMSMember.MemberCode)) { //判断会员除去4个字段,是否有过更改 if (cc_DMSMember.Phone != DMSMember.Phone || cc_DMSMember.Fax != DMSMember.Fax || cc_DMSMember.CompanyWebSite != DMSMember.CompanyWebSite || cc_DMSMember.Email != DMSMember.Email || cc_DMSMember.Postcode != DMSMember.Postcode || cc_DMSMember.ContactAddress != DMSMember.ContactAddress //cc_DMSMember.TrafficInfo != DMSMember.TrafficInfo || //cc_DMSMember.EnterpriseBrief != DMSMember.EnterpriseBrief || //cc_DMSMember.Remarks != DMSMember.Remarks ) { int result = WebService.DealerInfoServiceHelper.Instance.UpdateDealerInfo(int.Parse(DMSMember.MemberCode), cc_DMSMember.ContactAddress, cc_DMSMember.Postcode, cc_DMSMember.Phone, cc_DMSMember.Fax, cc_DMSMember.CompanyWebSite, cc_DMSMember.Email); string resultStr = string.Empty; int disposeStatus = 1;//已处理 switch (result) { case 0: resultStr = "更新失败"; disposeStatus = 2; //未修改 break; case 1: resultStr = "更新成功"; break; case -1: resultStr = "该经销商在DMS中不存在"; disposeStatus = 2; //未修改 break; case -2: resultStr = "该经销商不是免费或者导入的"; disposeStatus = 2; //未修改 break; case -3: resultStr = "该免费经销商已经有排期"; disposeStatus = 2; //未修改 break; case -4: resultStr = "销售电话格式不正确"; disposeStatus = 2; //未修改 break; case -5: resultStr = "传真格式不正确"; disposeStatus = 2; //未修改 break; default: resultStr = "其他异常"; disposeStatus = 2; //未修改 break; } Entities.ProjectTask_AuditContrastInfo model = BLL.ProjectTask_AuditContrastInfo.Instance.GetProjectTask_AuditContrastInfo(recid); if (model != null) { model.Remark = resultStr; model.DisposeTime = DateTime.Now; model.DisposeStatus = disposeStatus; BLL.ProjectTask_AuditContrastInfo.Instance.Update(model); } } } }
public void SubmitMemberInfo() { //车易通信息提交 Entities.ProjectTask_DMSMember member = null; Validate(true, out member); if (member != null) { if (BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.IsExistsByAbbrName(member.OriginalDMSMemberID, member.Abbr, 1)) { throw new Exception("此会员简称在Crm库中已存在"); } else { Guid memberGuid = new Guid(member.OriginalDMSMemberID); BitAuto.YanFa.Crm2009.Entities.DMSMember dmsMember = BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetDMSMember(memberGuid); dmsMember.Abbr = member.Abbr; dmsMember.BrandGroupID = member.BrandGroupID; dmsMember.BrandIds = member.BrandIDs; dmsMember.BrandNames = member.BrandNames; dmsMember.CityID = member.CityID; dmsMember.CompanyWebSite = member.CompanyWebSite; dmsMember.ContactAddress = member.ContactAddress; dmsMember.CountyID = member.CountyID; dmsMember.Email = member.Email; dmsMember.EnterpriseBrief = member.EnterpriseBrief; dmsMember.Fax = member.Fax; dmsMember.TrafficInfo = member.TrafficInfo; dmsMember.Remarks = member.Remarks; dmsMember.ProvinceID = member.ProvinceID; dmsMember.Postcode = member.Postcode; dmsMember.Phone = member.Phone; dmsMember.Name = member.Name; dmsMember.MemberType = member.MemberType; dmsMember.Remarks = member.Remarks; dmsMember.SerialIds = member.SerialIds; dmsMember.SerialNames = member.SerialIds; dmsMember.MapCoordinateList.Add(new BitAuto.YanFa.Crm2009.Entities.DMSMapCoordinate( memberGuid, BitAuto.YanFa.Crm2009.Entities.Constants.Constant.MapProviderName, member.Longitude, member.Lantitude) ); if (dmsMember.SyncStatus == (int)BitAuto.YanFa.Crm2009.Entities.EnumDMSSyncStatus.Rejected) { string content = BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetUpdateContent(dmsMember, "{0}由【{1}】修改为【{2}】", ','); content = string.Format("为【{0}(ID:{1})】修改会员【{2}(ID:{3})】{4}。", dmsMember.CustName, dmsMember.CustID, member.Name, member.MemberCode, content.Length > 0 ? ":" + content : string.Empty); BitAuto.YanFa.SysRightManager.Common.LogInfo.Instance.InsertLog(ConfigurationUtil.GetAppSettingValue("MemberLogModuleID"), (int)BitAuto.YanFa.SysRightManager.Common.LogInfo.ActionType.Update, content); BLL.ProjectTask_DMSMember.Instance.InsertOrUpdate(member); //保存cc会员信息 dmsMember.SyncStatus = (int)BitAuto.YanFa.Crm2009.Entities.EnumDMSSyncStatus.ApplyFor; BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.Update(dmsMember); //保存crm会员信息 BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.InsertSyncLog(memberGuid, (int)BitAuto.YanFa.Crm2009.Entities.EnumDMSSyncStatus.ApplyFor, "申请成功(呼叫中心二次审核)", BLL.Util.GetLoginUserID(), DateTime.Now); } else { throw new Exception("此会员不可提交到crm中,因为此会员不是打回状态"); } } } //车商通信息提交 BitAuto.YanFa.Crm2009.Entities.CstMember cstMember = null; string Brands = ""; //Crm2009.Entities.CSTMember_Brand modelBrand = null; BitAuto.YanFa.Crm2009.Entities.CSTLinkMan cstLinkMan = null; ValidateCSTMember(true, out cstMember, out Brands, out cstLinkMan); if (cstMember != null) { if (cstMember.SyncStatus == (int)BitAuto.YanFa.Crm2009.Entities.EnumCSTSyncStatus.Rejected) { //当CstMemberID字段有值时,更新交通信息的接口 12.6.4注释 //if (cstMember.CstMemberID != Entities.Constants.Constant.INT_INVALID_VALUE && cstMember.CstMemberID != 0) //{ // //更新车商通信息接口 // string msg = ""; // int[] arrBrand = null; // //主营品牌 //if (Brands != "") //{ // string[] ids = Brands.Split(','); // arrBrand = new int[ids.Length]; // for (int i = 0; i < ids.Length; i++) // { // arrBrand[i] = Convert.ToInt32(ids[i].ToString()); // } //} // bool result = BitAuto.YanFa.DMSInterface.CstMemberServiceHandler.UpdateTranstarUserInfo(cstMember.CstMemberID, cstMember.FullName, cstMember.ShortName, //cstMember.VendorClass, cstMember.SuperId, cstMember.ProvinceID, cstMember.CityID, out msg); //if (result == false) //{ // throw new Exception(msg); //} //} string content = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.GetUpdateContent(cstMember, cstLinkMan, "{0}由【{1}】修改为【{2}】", ','); content = string.Format("为【{0}(ID:{1})】修改会员【{2}(ID:{3})】{4}。", cstMember.CustName, cstMember.CustID, cstMember.FullName, cstMember.VendorCode, content.Length > 0 ? ":" + content : string.Empty); BitAuto.YanFa.SysRightManager.Common.LogInfo.Instance.InsertLog(ConfigurationUtil.GetAppSettingValue("MemberLogModuleID"), (int)BitAuto.YanFa.SysRightManager.Common.LogInfo.ActionType.Update, content); cstMember.SyncStatus = (int)BitAuto.YanFa.Crm2009.Entities.EnumCSTSyncStatus.ApplyFor; BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.UpdateCstMember(cstMember);//保存crm车商通会员信息 //插入开通日志 cstMember.CreateTime = DateTime.Now; BitAuto.YanFa.Crm2009.BLL.CSTMemberSyncLog.Instance.AddSynclog(cstMember.CSTRecID, cstMember.SyncStatus, "申请成功(呼叫中心二次审核)", cstMember.CreateUserID, cstMember.CreateTime); //更新Crm车商通主营品牌信息 12.6.4注释 //if (Brands != "") //{ // string[] brandID = Brands.Split(','); // Crm2009.BLL.CSTMember_Brand.Instance.DeleteByCSTRecID(cstMember.CSTRecID); // for (int i = 0; i < brandID.Length; i++) // { // if (brandID[i] != "") // { // Crm2009.Entities.CSTMember_Brand modelBrand = new Crm2009.Entities.CSTMember_Brand(); // modelBrand.CSTRecID = cstMember.CSTRecID; // modelBrand.CreateTime = DateTime.Now; // modelBrand.BrandID = int.Parse(brandID[i]); // Crm2009.BLL.CSTMember_Brand.Instance.Add(modelBrand); // } // } //} BitAuto.YanFa.Crm2009.BLL.CSTLinkMan.Instance.Update(cstLinkMan);//保存crm车商通会员联系人信息 } else { throw new Exception("此车商通会员不可提交到crm中,因为此车商通会员不是打回状态"); } } }
public void DeleteMemberInfo() { int id = -1; if (MemberID != "") { if (int.TryParse(MemberID, out id)) { Entities.ProjectTask_DMSMember member = BLL.ProjectTask_DMSMember.Instance.GetProjectTask_DMSMember(id); if (member != null) { BitAuto.YanFa.Crm2009.Entities.DMSMember dmsMember = BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetDMSMember(new Guid(member.OriginalDMSMemberID)); if (dmsMember != null) { if (dmsMember.SyncStatus == (int)BitAuto.YanFa.Crm2009.Entities.EnumDMSSyncStatus.Rejected) { BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.Delete(dmsMember.ID.ToString()); BLL.ProjectTask_DMSMember.Instance.ProjectTask_DMSMemberDelete(id); string content = string.Format("为【{0}(ID:{1})】删除会员【{2}(ID:{3})】成功。", dmsMember.CustName, dmsMember.CustID, dmsMember.Name, dmsMember.MemberCode); BitAuto.YanFa.SysRightManager.Common.LogInfo.Instance.InsertLog(ConfigurationUtil.GetAppSettingValue("MemberLogModuleID"), (int)BitAuto.YanFa.SysRightManager.Common.LogInfo.ActionType.Delete, content); } else { throw new Exception("只有打回的会员才能删除!"); } } } } else { throw new Exception("会员ID无法转换为int类型"); } } //车商通会员删除 if (OriginalCSTRecID != string.Empty) { BitAuto.YanFa.Crm2009.Entities.CstMember cstMember = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.GetCstMemberModel(OriginalCSTRecID); int ID = BLL.ProjectTask_CSTMember.Instance.GetIDByCSTRecID(OriginalCSTRecID); if (cstMember != null) { if (cstMember.SyncStatus == (int)BitAuto.YanFa.Crm2009.Entities.EnumCSTSyncStatus.Rejected) { BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.Delete(cstMember.ID.ToString()); //删除CRM车商通会员信息 BLL.ProjectTask_CSTMember.Instance.ProjectTask_CSTMemberDelete(ID); //删除CC车商通会员信息 string content = string.Format("为【{0}(ID:{1})】删除会员【{2}(ID:{3})】成功。", cstMember.CustName, cstMember.CustID, cstMember.FullName, cstMember.VendorCode); BitAuto.YanFa.SysRightManager.Common.LogInfo.Instance.InsertLog(ConfigurationUtil.GetAppSettingValue("MemberLogModuleID"), (int)BitAuto.YanFa.SysRightManager.Common.LogInfo.ActionType.Delete, content); } else { throw new Exception("只有打回的会员才能删除!"); } } else { throw new Exception("删除失败"); } } }
//add by qizhiqiang 2012-4-25 /// <summary> /// 插入到审核对照表,类型为:已开通车易通信息变更,则生成记录 /// </summary> /// <param name="cc_DMSMember">呼叫中心会员实体</param> /// <param name="DMSMember">CRM系统会员实体</param> /// <returns>返回插入记录主键ID</returns> public int InsertByOpenedDMSMemberChange(Entities.ProjectTask_DMSMember cc_DMSMember, BitAuto.YanFa.Crm2009.Entities.DMSMember DMSMember) { int recid = -1; if (cc_DMSMember != null && DMSMember != null) { Entities.ProjectTask_AuditContrastInfo model = new Entities.ProjectTask_AuditContrastInfo(); model.PTID = cc_DMSMember.PTID; model.DMSMemberID = DMSMember.ID.ToString(); model.CustID = DMSMember.CustID; model.CreateTime = null; model.CreateUserID = BLL.Util.GetLoginUserID(); model.ExportStatus = 0; //0-未导出,1-已导出 model.DisposeStatus = 0; //未处理 string contrastInfoInside = string.Empty; string contrastInfo = string.Empty; //已开通有排期车易通信息变更 model.ContrastType = 9; //判断是否修改地图 IsEqualsByMapList(cc_DMSMember.Lantitude, cc_DMSMember.Longitude, DMSMember.MapCoordinateList, ref contrastInfoInside, ref contrastInfo); if (!BLL.Util.IsEqualsByStringArray(cc_DMSMember.BrandIDs, DMSMember.BrandIds) || cc_DMSMember.Name != DMSMember.Name || cc_DMSMember.Abbr != DMSMember.Abbr || cc_DMSMember.ProvinceID != DMSMember.ProvinceID || cc_DMSMember.CityID != DMSMember.CityID || cc_DMSMember.CountyID != DMSMember.CountyID || cc_DMSMember.MemberType != DMSMember.MemberType || cc_DMSMember.Phone != DMSMember.Phone || cc_DMSMember.Fax != DMSMember.Fax || cc_DMSMember.CompanyWebSite != DMSMember.CompanyWebSite || cc_DMSMember.Email != DMSMember.Email || cc_DMSMember.Postcode != DMSMember.Postcode || cc_DMSMember.ContactAddress != DMSMember.ContactAddress || cc_DMSMember.TrafficInfo != DMSMember.TrafficInfo || cc_DMSMember.EnterpriseBrief != DMSMember.EnterpriseBrief || cc_DMSMember.Remarks != DMSMember.Remarks || !BLL.Util.IsEqualsByStringArray(cc_DMSMember.SerialIds, DMSMember.SerialIds) ) { GetDMSMemberContrastByOpenedDMSMember(cc_DMSMember, DMSMember, ref contrastInfoInside, ref contrastInfo); } if (contrastInfoInside != string.Empty && contrastInfo != string.Empty) { contrastInfoInside = contrastInfoInside.TrimEnd(','); contrastInfo = contrastInfo.TrimEnd(','); model.ContrastInfoInside = contrastInfoInside; model.ContrastInfo = contrastInfo; //if (string.IsNullOrEmpty(DMSMember.MemberCode))//是否会员开通成功 //{ // model.DisposeStatus = 1;//已处理 // model.DisposeTime = DateTime.Now; //} Insert(model); } } return(recid); }
//private void BindQuestionnaireInfo() //{ // repeaterQ.DataSource = BLL.CC_Questionnaire.Instance.GetCC_Questionnaire(string.Empty, "CreateTime"); // repeaterQ.DataBind(); //} //protected void repeaterQ_ItemDataBound(Object Sender, RepeaterItemEventArgs e) //{ // if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) // { // int qustID = int.Parse(DataBinder.Eval(e.Item.DataItem, "QustID").ToString().Trim()); // Repeater rOpt = e.Item.FindControl("repeaterOpt") as Repeater; // rOpt.DataSource = BLL.CC_QuestionnairOption.Instance.GetCC_QuestionnairOption(" QustID=" + qustID, "CreateTime"); // rOpt.DataBind(); // } //} //protected string IsCheck(string custId, string optId) //{ // string result = string.Empty; // Entities.CC_TaskQuestionnaire taskQ = BLL.CC_TaskQuestionnaire.Instance.GetCC_TaskQuestionnaire(OriginalDMSMemberID, int.Parse(custId), 1); // if (taskQ != null) // { // if (taskQ.QustOptID == int.Parse(optId)) // { // result = "checked=true;"; // } // } // return result; //} //protected string GetQustDescript( string custId) //{ // string result = string.Empty; // Entities.CC_TaskQuestionnaire taskQ = BLL.CC_TaskQuestionnaire.Instance.GetCC_TaskQuestionnaire(OriginalDMSMemberID, int.Parse(custId), 1); // if (taskQ != null) // { // result = taskQ.Description; // } // return result; //} #endregion private void LoadMemberInfo() { Control ctl; Control ct2; int memberId = -1; if (int.TryParse(MemberID, out memberId)) { //车易通 Entities.ProjectTask_DMSMember m = BLL.ProjectTask_DMSMember.Instance.GetProjectTask_DMSMember(memberId); //4-19 正式测试注释去掉 if (m != null) { if (m.Status != -1) { OriginalDMSMemberID = m.OriginalDMSMemberID; if (OriginalDMSMemberID != "") { BitAuto.YanFa.Crm2009.Entities.DMSMember dmsM = BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetDMSMember(new Guid(m.OriginalDMSMemberID)); if (dmsM != null) { if (dmsM.SyncStatus != (int)BitAuto.YanFa.Crm2009.Entities.EnumDMSSyncStatus.Rejected) { btnDisplay = "style='display:none;'"; ctl = this.LoadControl("~/CustInfo/DetailV/UCMember.ascx", m); } else { btnDisplay = "style='display:block;'"; ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditMember.ascx", m); } this.PlaceHolder.Controls.Add(ctl); } else { btnDisplay = "style='display:none;'"; } } } } //车商通 Entities.ProjectTask_CSTMember mcst = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMember(memberId); if (mcst != null) { if (mcst.Status != -1) { OriginalCSTRecID = mcst.OriginalCSTRecID; if (OriginalCSTRecID != "") { BitAuto.YanFa.Crm2009.Entities.CstMember cstM = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.GetCSTMember(OriginalCSTRecID); if (cstM != null) { if (cstM.SyncStatus != (int)BitAuto.YanFa.Crm2009.Entities.EnumCSTSyncStatus.Rejected) { btnDisplay = "style='display:none;'"; ct2 = this.LoadControl("~/CustInfo/DetailV/UCCstMember.ascx", cstM); } else { btnDisplay = "style='display:block;'"; ct2 = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditSndCstMember.ascx", cstM); } this.CSTPlaceHolder.Controls.Add(ct2); } else { btnDisplay = "style='display:none;'"; } } } } } }
//add by qizhiqiang 2012-4-25根据已开通易湃会员与cc 中的不用,生成变更信息 /// <summary> /// 根据已开通易湃会员字段信息与CC中的不同,生成变更信息 /// </summary> /// <param name="cc_DMSMember"></param> /// <param name="DMSMember"></param> /// <param name="contrastInfoInside"></param> /// <param name="contrastInfo"></param> private void GetDMSMemberContrastByOpenedDMSMember(Entities.ProjectTask_DMSMember cc_DMSMember, BitAuto.YanFa.Crm2009.Entities.DMSMember DMSMember, ref string contrastInfoInside, ref string contrastInfo) { if (!BLL.Util.IsEqualsByStringArray(cc_DMSMember.BrandIDs, DMSMember.BrandIds)) { contrastInfoInside += "BrandIDs:('" + Util.EscapeString(DMSMember.BrandIds) + "','" + Util.EscapeString(cc_DMSMember.BrandIDs) + "'),"; contrastInfo += "易湃会员主营品牌由:" + DMSMember.BrandNames + ",改为:" + cc_DMSMember.BrandNames + ","; } if (cc_DMSMember.Name != DMSMember.Name) { contrastInfoInside += "Name:('" + Util.EscapeString(DMSMember.Name) + "','" + Util.EscapeString(cc_DMSMember.Name) + "'),"; contrastInfo += "易湃会员名称由:" + DMSMember.Name + ",改为:" + cc_DMSMember.Name + ","; } if (cc_DMSMember.Abbr != DMSMember.Abbr) { contrastInfoInside += "Abbr:('" + Util.EscapeString(DMSMember.Abbr) + "','" + Util.EscapeString(cc_DMSMember.Abbr) + "'),"; contrastInfo += "易湃会员简称由:" + DMSMember.Abbr + ",改为:" + cc_DMSMember.Abbr + ","; } if (cc_DMSMember.ProvinceID != DMSMember.ProvinceID) { contrastInfoInside += "ProvinceID:('" + Util.EscapeString(DMSMember.ProvinceID) + "','" + Util.EscapeString(cc_DMSMember.ProvinceID) + "'),"; contrastInfo += "易湃会员所属省份由:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(DMSMember.ProvinceID) + ",改为:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(cc_DMSMember.ProvinceID) + ","; } if (cc_DMSMember.CityID != DMSMember.CityID) { contrastInfoInside += "CityID:('" + Util.EscapeString(DMSMember.CityID) + "','" + Util.EscapeString(cc_DMSMember.CityID) + "'),"; contrastInfo += "易湃会员所属城市由:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(DMSMember.CityID) + ",改为:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(cc_DMSMember.CityID) + ","; } if (cc_DMSMember.CountyID != DMSMember.CountyID) { contrastInfoInside += "CountyID:('" + Util.EscapeString(DMSMember.CountyID) + "','" + Util.EscapeString(cc_DMSMember.CountyID) + "'),"; contrastInfo += "易湃会员所属区县由:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(DMSMember.CountyID) + ",改为:" + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(cc_DMSMember.CountyID) + ","; } if (cc_DMSMember.MemberType != DMSMember.MemberType) { contrastInfoInside += "MemberType:('" + Util.EscapeString(DMSMember.MemberType) + "','" + Util.EscapeString(cc_DMSMember.MemberType) + "'),"; contrastInfo += "易湃会员类型由:" + GetMemberType(DMSMember.MemberType) + ",改为:" + GetMemberType(cc_DMSMember.MemberType) + ","; } if (cc_DMSMember.Phone != DMSMember.Phone) { contrastInfoInside += "Phone:('" + Util.EscapeString(DMSMember.Phone) + "','" + Util.EscapeString(cc_DMSMember.Phone) + "'),"; contrastInfo += "易湃会员电话由:" + DMSMember.Phone + ",改为:" + cc_DMSMember.Phone + ","; } if (cc_DMSMember.Fax != DMSMember.Fax) { contrastInfoInside += "Fax:('" + Util.EscapeString(DMSMember.Fax) + "','" + Util.EscapeString(cc_DMSMember.Fax) + "'),"; contrastInfo += "易湃会员传真由:" + DMSMember.Fax + ",改为:" + cc_DMSMember.Fax + ","; } if (cc_DMSMember.CompanyWebSite != DMSMember.CompanyWebSite) { contrastInfoInside += "CompanyWebSite:('" + Util.EscapeString(DMSMember.CompanyWebSite) + "','" + Util.EscapeString(cc_DMSMember.CompanyWebSite) + "'),"; contrastInfo += "易湃会员公司网址由:" + DMSMember.CompanyWebSite + ",改为:" + cc_DMSMember.CompanyWebSite + ","; } if (cc_DMSMember.Email != DMSMember.Email) { contrastInfoInside += "Email:('" + Util.EscapeString(DMSMember.Email) + "','" + Util.EscapeString(cc_DMSMember.Email) + "'),"; contrastInfo += "易湃会员Email由:" + DMSMember.Email + ",改为:" + cc_DMSMember.Email + ","; } if (cc_DMSMember.Postcode != DMSMember.Postcode) { contrastInfoInside += "Postcode:('" + Util.EscapeString(DMSMember.Postcode) + "','" + Util.EscapeString(cc_DMSMember.Postcode) + "'),"; contrastInfo += "易湃会员邮编由:" + DMSMember.Postcode + ",改为:" + cc_DMSMember.Postcode + ","; } if (cc_DMSMember.ContactAddress != DMSMember.ContactAddress) { contrastInfoInside += "ContactAddress:('" + Util.EscapeString(DMSMember.ContactAddress) + "','" + Util.EscapeString(cc_DMSMember.ContactAddress) + "'),"; contrastInfo += "易湃会员销售地址由:" + DMSMember.ContactAddress + ",改为:" + cc_DMSMember.ContactAddress + ","; } if (cc_DMSMember.TrafficInfo != DMSMember.TrafficInfo) { contrastInfoInside += "TrafficInfo:('" + Util.EscapeString(DMSMember.TrafficInfo) + "','" + Util.EscapeString(cc_DMSMember.TrafficInfo) + "'),"; contrastInfo += "易湃会员交通信息由:" + DMSMember.TrafficInfo + ",改为:" + cc_DMSMember.TrafficInfo + ","; } if (cc_DMSMember.EnterpriseBrief != DMSMember.EnterpriseBrief) { contrastInfoInside += "EnterpriseBrief:('" + Util.EscapeString(DMSMember.EnterpriseBrief) + "','" + Util.EscapeString(cc_DMSMember.EnterpriseBrief) + "'),"; contrastInfo += "易湃会员企业简介由:" + DMSMember.EnterpriseBrief + ",改为:" + cc_DMSMember.EnterpriseBrief + ","; } if (cc_DMSMember.Remarks != DMSMember.Remarks) { contrastInfoInside += "Remarks:('" + Util.EscapeString(DMSMember.Remarks) + "','" + Util.EscapeString(cc_DMSMember.Remarks) + "'),"; contrastInfo += "易湃会员备注由:" + DMSMember.Remarks + ",改为:" + cc_DMSMember.Remarks + ","; } if (!BLL.Util.IsEqualsByStringArray(cc_DMSMember.SerialIds, DMSMember.SerialIds)) { contrastInfoInside += "SerialIds:('" + Util.EscapeString(DMSMember.SerialIds) + "','" + Util.EscapeString(cc_DMSMember.SerialIds) + "'),"; contrastInfo += "易湃会员附属子品牌由:" + DMSMember.SerialNames + ",改为:" + cc_DMSMember.SerialNames + ","; } }
/// <summary> /// 插入到审核对照表,类型为:会员信息变化,若会员有变化,则生成记录 /// </summary> /// <param name="cC_DMSMember">呼叫中心会员实体</param> /// <param name="DMSMember">CRM系统会员实体</param> /// <returns>返回插入记录主键ID</returns> public int InsertByDMSMemberChange(Entities.ProjectTask_DMSMember cc_DMSMember, BitAuto.YanFa.Crm2009.Entities.DMSMember DMSMember, out bool isChange) { int recid = -1; isChange = false; if (cc_DMSMember != null && DMSMember != null) { Entities.ProjectTask_AuditContrastInfo model = new Entities.ProjectTask_AuditContrastInfo(); model.PTID = cc_DMSMember.PTID; model.DMSMemberID = DMSMember.ID.ToString(); model.CustID = DMSMember.CustID; model.CreateTime = DateTime.Now; model.CreateUserID = BLL.Util.GetLoginUserID(); model.ExportStatus = 0;//0-未导出,1-已导出 string contrastInfoInside = string.Empty; string contrastInfo = string.Empty; //判断会员4个字段是否有过更改 if (cc_DMSMember.Name != DMSMember.Name || cc_DMSMember.Abbr != DMSMember.Abbr || cc_DMSMember.ProvinceID != DMSMember.ProvinceID || cc_DMSMember.CityID != DMSMember.CityID || cc_DMSMember.CountyID != DMSMember.CountyID || cc_DMSMember.MemberType != DMSMember.MemberType) { model.ContrastType = 2; GetDMSMemberContrastByPart1(cc_DMSMember, DMSMember, ref contrastInfoInside, ref contrastInfo); if (contrastInfoInside != string.Empty && contrastInfo != string.Empty) { model.ContrastInfoInside = contrastInfoInside; model.ContrastInfo = contrastInfo; if (string.IsNullOrEmpty(DMSMember.MemberCode)) //是否会员开通成功 { model.DisposeStatus = 1; //已处理 model.DisposeTime = DateTime.Now; } else { model.DisposeStatus = 0;//未处理 model.DisposeTime = null; } isChange = true; Insert(model); } } contrastInfoInside = string.Empty; contrastInfo = string.Empty; //判断会员除去4个字段,是否有过更改 if (cc_DMSMember.Phone != DMSMember.Phone || cc_DMSMember.Fax != DMSMember.Fax || cc_DMSMember.CompanyWebSite != DMSMember.CompanyWebSite || cc_DMSMember.Email != DMSMember.Email || cc_DMSMember.Postcode != DMSMember.Postcode || cc_DMSMember.ContactAddress != DMSMember.ContactAddress //cc_DMSMember.TrafficInfo != DMSMember.TrafficInfo || //cc_DMSMember.EnterpriseBrief != DMSMember.EnterpriseBrief || //cc_DMSMember.Remarks != DMSMember.Remarks ) { model.ContrastType = 3; GetDMSMemberContrastByPart2(cc_DMSMember, DMSMember, ref contrastInfoInside, ref contrastInfo); if (contrastInfoInside != string.Empty && contrastInfo != string.Empty) { model.ContrastInfoInside = contrastInfoInside; model.ContrastInfo = contrastInfo; if (string.IsNullOrEmpty(DMSMember.MemberCode)) //是否会员开通成功 { model.DisposeStatus = 1; //已处理 model.DisposeTime = DateTime.Now; } else { model.DisposeStatus = 0;//未处理 model.DisposeTime = null; } recid = Insert(model); } } } return(recid); }
private static Entities.ProjectTask_DMSMember LoadSingleProjectTask_DMSMember(DataRow row) { Entities.ProjectTask_DMSMember model = new Entities.ProjectTask_DMSMember(); if (row["MemberID"] != DBNull.Value) { model.MemberID = Convert.ToInt32(row["MemberID"].ToString()); } if (row["PTID"] != DBNull.Value) { model.PTID = row["PTID"].ToString(); } if (row["OriginalDMSMemberID"] != DBNull.Value) { model.OriginalDMSMemberID = row["OriginalDMSMemberID"].ToString(); } if (row["MemberCode"] != DBNull.Value) { model.MemberCode = row["MemberCode"].ToString(); } if (row["Name"] != DBNull.Value) { model.Name = row["Name"].ToString(); } if (row["Abbr"] != DBNull.Value) { model.Abbr = row["Abbr"].ToString(); } if (row["MemberType"] != DBNull.Value) { model.MemberType = row["MemberType"].ToString(); } if (row["Phone"] != DBNull.Value) { model.Phone = row["Phone"].ToString(); } if (row["Fax"] != DBNull.Value) { model.Fax = row["Fax"].ToString(); } if (row["CompanyWebSite"] != DBNull.Value) { model.CompanyWebSite = row["CompanyWebSite"].ToString(); } if (row["Email"] != DBNull.Value) { model.Email = row["Email"].ToString(); } if (row["Postcode"] != DBNull.Value) { model.Postcode = row["Postcode"].ToString(); } if (row["ProvinceID"] != DBNull.Value) { model.ProvinceID = row["ProvinceID"].ToString(); } if (row["CityID"] != DBNull.Value) { model.CityID = row["CityID"].ToString(); } if (row["CountyID"] != DBNull.Value) { model.CountyID = row["CountyID"].ToString(); } if (row["ContactAddress"] != DBNull.Value) { model.ContactAddress = row["ContactAddress"].ToString(); } if (row["Longitude"] != DBNull.Value) { model.Longitude = row["Longitude"].ToString(); } if (row["Lantitude"] != DBNull.Value) { model.Lantitude = row["Lantitude"].ToString(); } if (row["TrafficInfo"] != DBNull.Value) { model.TrafficInfo = row["TrafficInfo"].ToString(); } if (row["BrandGroupID"] != DBNull.Value) { model.BrandGroupID = Convert.ToInt32(row["BrandGroupID"].ToString()); } if (row["EnterpriseBrief"] != DBNull.Value) { model.EnterpriseBrief = row["EnterpriseBrief"].ToString(); } if (row["Remarks"] != DBNull.Value) { model.Remarks = row["Remarks"].ToString(); } if (row["Status"] != DBNull.Value) { model.Status = Convert.ToInt32(row["Status"].ToString()); } if (row["SyncStatus"] != DBNull.Value) { model.SyncStatus = Convert.ToInt32(row["SyncStatus"].ToString()); } return(model); }