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