/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.ProjectTask_AuditContrastInfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@PTID", SqlDbType.VarChar),
new SqlParameter("@CustID", SqlDbType.VarChar, 50),
new SqlParameter("@DMSMemberID", SqlDbType.VarChar, 50),
new SqlParameter("@ContrastInfoInside", SqlDbType.VarChar, 8000),
new SqlParameter("@ContrastInfo", SqlDbType.VarChar, 8000),
new SqlParameter("@ExportStatus", SqlDbType.Int, 4),
new SqlParameter("@ContrastType", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@DisposeStatus", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 2000),
new SqlParameter("@DisposeTime", SqlDbType.DateTime)
};
parameters[0].Value = model.RecID;
parameters[1].Value = model.PTID;
parameters[2].Value = model.CustID;
parameters[3].Value = model.DMSMemberID;
parameters[4].Value = model.ContrastInfoInside;
parameters[5].Value = model.ContrastInfo;
parameters[6].Value = model.ExportStatus;
parameters[7].Value = model.ContrastType;
parameters[8].Value = model.CreateTime;
parameters[9].Value = model.CreateUserID;
parameters[10].Value = model.DisposeStatus;
parameters[11].Value = model.Remark;
parameters[12].Value = model.DisposeTime;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASL_AUDITCONTRASTINFO_UPDATE, parameters));
}
/// <summary>
/// 根据RecID，初始化核对的会员信息（仅6个字段和4个关键字）
/// </summary>
/// <param name="recID">RecID</param>
/// <returns></returns>
public BitAuto.YanFa.Crm2009.Entities.DMSMember GetCC_DMSMemberByRecID(int recID)
{
BitAuto.YanFa.Crm2009.Entities.DMSMember DMSMember = new BitAuto.YanFa.Crm2009.Entities.DMSMember();
Entities.ProjectTask_AuditContrastInfo model = GetProjectTask_AuditContrastInfo(recID);
if (model != null && model.ContrastType != null &&
(model.ContrastType.Value == 2 || model.ContrastType.Value == 3) &&
!string.IsNullOrEmpty(model.ContrastInfoInside))
{
return(BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetDMSMember(model.DMSMemberID, model.ContrastInfoInside));
}
return(null);
}
/// <summary>
/// 插入到审核对照表，类型为：客户名称变化
/// </summary>
/// <param name="cc_Custs">呼叫中心客户实体</param>
/// <param name="custInfo">CRM系统客户实体</param>
public int InsertByCustNameChange(Entities.ProjectTask_Cust cc_Custs, BitAuto.YanFa.Crm2009.Entities.CustInfo custInfo)
{
Entities.ProjectTask_AuditContrastInfo model = new Entities.ProjectTask_AuditContrastInfo();
model.PTID = cc_Custs.PTID;
model.CustID = custInfo.CustID;
model.ContrastInfoInside = "CustName:('" + BLL.Util.EscapeString(custInfo.CustName) + "','" + BLL.Util.EscapeString(cc_Custs.CustName) + "')";
model.ContrastInfo = "客户名称由：" + custInfo.CustName + "，改为：" + cc_Custs.CustName;
model.ExportStatus = 0;//0-未导出，1-已导出
model.ContrastType = 1;
model.CreateTime = DateTime.Now;
model.CreateUserID = BLL.Util.GetLoginUserID();
model.DisposeStatus = 0;//未处理
return(Insert(model));
}
/// <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);
}
private Entities.ProjectTask_AuditContrastInfo LoadSingleProjectTask_AuditContrastInfo(DataRow row)
{
Entities.ProjectTask_AuditContrastInfo model = new Entities.ProjectTask_AuditContrastInfo();
if (row["RecID"].ToString() != "")
{
model.RecID = int.Parse(row["RecID"].ToString());
}
if (row["PTID"].ToString() != "")
{
model.PTID = row["PTID"].ToString();
}
model.CustID = row["CustID"].ToString();
model.DMSMemberID = row["DMSMemberID"].ToString();
model.ContrastInfoInside = row["ContrastInfoInside"].ToString();
model.ContrastInfo = row["ContrastInfo"].ToString();
if (row["ExportStatus"].ToString() != "")
{
model.ExportStatus = int.Parse(row["ExportStatus"].ToString());
}
if (row["DisposeStatus"].ToString() != "")
{
model.DisposeStatus = int.Parse(row["DisposeStatus"].ToString());
}
if (row["ContrastType"].ToString() != "")
{
model.ContrastType = int.Parse(row["ContrastType"].ToString());
}
model.Remark = row["Remark"].ToString();
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreateUserID"].ToString() != "")
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
if (row["DisposeTime"].ToString() != "")
{
model.DisposeTime = DateTime.Parse(row["DisposeTime"].ToString());
}
return(model);
}
/// <summary>
/// 插入删除客户申请记录
/// </summary>
/// <param name="tid">任务ID</param>
/// <returns></returns>
public int InsertByDelCustRelation(string tid, string cc_CustOriginalName, string cc_CustChangeName)
{
Entities.ProjectTask_DelCustRelation delModel = BLL.ProjectTask_DelCustRelation.Instance.GetProjectTask_DelCustRelationByTID(tid);
if (delModel != null)
{
Entities.ProjectTask_AuditContrastInfo model = new Entities.ProjectTask_AuditContrastInfo();
model.PTID = tid;
model.CustID = delModel.CustID;
model.ContrastInfoInside = delModel.DelCustIDs;
string contrastInfo = "客户名称重复，关联客户ID：" + delModel.DelCustIDs;
if (cc_CustOriginalName != cc_CustChangeName)
{
contrastInfo = "客户名称由：" + cc_CustOriginalName + "，改为：" + cc_CustChangeName + "," + contrastInfo;
}
model.ContrastInfo = contrastInfo; //"客户名称由：" + cc_CustOriginalName + "，改为：" + cc_CustChangeName + "，客户名称重复，关联客户ID：" + delModel.DelCustIDs;
model.ExportStatus = 0; //0-未导出，1-已导出
model.ContrastType = 4;
model.CreateTime = DateTime.Now;
model.CreateUserID = BLL.Util.GetLoginUserID();
model.DisposeStatus = 0;//未处理
return(Insert(model));
}
return(-1);
}
/// <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);
}
//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);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.ProjectTask_AuditContrastInfo model)
{
return(Dal.ProjectTask_AuditContrastInfo.Instance.Update(model));
}
/// <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);
}
}
}
}
