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