protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GetProductOpenKey(); Entities.ProjectTask_CSTMember info = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberModel(this.MemberID); if (info != null) { string cstRecId = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.SelectCstMemberIDByCSTRecID(info.OriginalCSTRecID); int recId = -1; if (int.TryParse(cstRecId, out recId)) { BitAuto.YanFa.Crm2009.Entities.CstMember cstMemberInfo = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.GetCstMemberModel(info.OriginalCSTRecID); OriginalCstMemberID = cstMemberInfo.CSTRecID; this.syncTime = cstMemberInfo.SyncTime.ToShortDateString(); } BitAuto.YanFa.Crm2009.Entities.CSTExpandInfo dstCSTExpandInfo = BitAuto.YanFa.Crm2009.BLL.CSTExpandInfo.Instance.GetModelByCSTRecID(info.OriginalCSTRecID); if (dstCSTExpandInfo != null) { if (dstCSTExpandInfo.UCount != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.INT_INVALID_VALUE) { this.UCount = dstCSTExpandInfo.UCount.ToString(); } if (dstCSTExpandInfo.LastAddUbTime != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.DATE_INVALID_VALUE) { this.lastAddUbTime = dstCSTExpandInfo.LastAddUbTime.ToShortDateString(); } if (dstCSTExpandInfo.UBTotalAmount != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.INT_INVALID_VALUE) { this.UbTotalAmount = dstCSTExpandInfo.UBTotalAmount.ToString(); } if (dstCSTExpandInfo.UBTotalExpend != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.INT_INVALID_VALUE) { this.UbTotalExpend = dstCSTExpandInfo.UBTotalExpend.ToString(); } if (dstCSTExpandInfo.ActiveTime != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.DATE_INVALID_VALUE) { this.activeTime = dstCSTExpandInfo.ActiveTime.ToShortDateString(); } } } } }
//用于把查询出的数据存入页面变量(客户基本信息) private void GetCSTMemberProperties(DataTable dt) { if (!string.IsNullOrEmpty(dt.Rows[0]["Status"].ToString())) { this.clientStatus = GetCstStatusString(Convert.ToInt32(dt.Rows[0]["Status"].ToString())); } this.Status = dt.Rows[0]["Status"].ToString(); this.clientFullName = dt.Rows[0]["FullName"].ToString(); this.clientShortName = dt.Rows[0]["ShortName"].ToString(); this.clientCode = dt.Rows[0]["VendorCode"].ToString(); if (!string.IsNullOrEmpty(dt.Rows[0]["VendorClass"].ToString())) { this.clientType = GetCstTypeString(Convert.ToInt32(dt.Rows[0]["VendorClass"].ToString())); vendorClass = dt.Rows[0]["VendorClass"].ToString(); } if (!string.IsNullOrEmpty(dt.Rows[0]["SuperId"].ToString())) { this.upCompanyName = GetSuperCompanyString(Convert.ToInt32(dt.Rows[0]["SuperId"].ToString())); } //this.region = dt.Rows[0]["ProvinceID"].ToString(); this.region = GetRegionString(dt.Rows[0]["ProvinceID"].ToString(), dt.Rows[0]["CityID"].ToString(), dt.Rows[0]["CountyID"].ToString()); this.detailAddr = dt.Rows[0]["Address"].ToString(); this.postCode = dt.Rows[0]["PostCode"].ToString(); if (dt.Rows[0]["SyncTime"] != DBNull.Value) { this.syncTime = Convert.ToDateTime(dt.Rows[0]["SyncTime"]).ToShortDateString(); } BitAuto.YanFa.Crm2009.Entities.CSTExpandInfo dstCSTExpandInfo = BitAuto.YanFa.Crm2009.BLL.CSTExpandInfo.Instance.GetModelByCSTRecID(Member.CSTRecID); if (dstCSTExpandInfo != null) { if (dstCSTExpandInfo.UCount != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.INT_INVALID_VALUE) { this.UCount = dstCSTExpandInfo.UCount.ToString(); } if (dstCSTExpandInfo.LastAddUbTime != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.DATE_INVALID_VALUE) { this.lastAddUbTime = dstCSTExpandInfo.LastAddUbTime.ToShortDateString(); } if (dstCSTExpandInfo.UBTotalAmount != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.INT_INVALID_VALUE) { this.UbTotalAmount = dstCSTExpandInfo.UBTotalAmount.ToString(); } if (dstCSTExpandInfo.UBTotalExpend != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.INT_INVALID_VALUE) { this.UbTotalExpend = dstCSTExpandInfo.UBTotalExpend.ToString(); } if (dstCSTExpandInfo.ActiveTime != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.DATE_INVALID_VALUE) { this.activeTime = dstCSTExpandInfo.ActiveTime.ToShortDateString(); } } this.CustID = dt.Rows[0]["CustID"].ToString(); this.SyncStatus = GetSyncStatusDesc(dt.Rows[0]["SyncStatus"].ToString()); this.SyncStatusValue = dt.Rows[0]["SyncStatus"].ToString(); this.TrafficInfo = dt.Rows[0]["TrafficInfo"].ToString(); this.CreateTime = string.Format("{0:yyyy-MM-dd}", dt.Rows[0]["CreateTime"]); DataTable dstTable = BitAuto.YanFa.Crm2009.BLL.CSTMember_Brand.Instance.GetList(" CSTRecID ='" + Member.CSTRecID + "'").Tables[0]; if (dstTable.Rows.Count > 0) { string BrandIds = ""; foreach (DataRow row in dstTable.Rows) { BrandIds += row["BrandID"].ToString() + ","; } BrandIds = BrandIds.TrimEnd(','); BrandIdsName = BitAuto.YanFa.Crm2009.BLL.CarBrand.Instance.GetBrandNames(BrandIds); } CSTMemberID = dt.Rows[0]["CSTMemberID"].ToString(); }
private void BindData() { //把对象信息存入页面变量中 Entities.ProjectTask_CSTMember cstMember = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberModel(this.Member.ID); if (cstMember != null) { vendorClass = cstMember.VendorClass.ToString(); if (cstMember.OriginalCSTRecID != null) { BitAuto.YanFa.Crm2009.Entities.CstMember info = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.GetCSTMember(cstMember.OriginalCSTRecID); if (info != null) { SyncStatusValue = info.SyncStatus.ToString(); CSTMemberID = info.CstMemberID.ToString(); } if (BLL.ProjectTask_CSTMember.Instance.IsOpenSuccessMember(this.Member.ID)) { //是否有名称变更 DataTable dtFullName = BLL.ProjectTask_AuditContrastInfo.Instance.GetProjectTask_AuditContrastInfo(cstMember.OriginalCSTRecID, 7, "FullName"); if (dtFullName.Rows.Count > 0) { FullNameHavHistory = true; } } } this.clientFullName = cstMember.FullName; this.clientShortName = cstMember.ShortName; this.clientCode = cstMember.VendorCode; this.clientType = GetCstTypeString((int)cstMember.VendorClass); this.upCompanyName = GetSuperCompanyString((int)cstMember.SuperId); this.region = GetRegionString(cstMember.ProvinceID, cstMember.CityID, cstMember.CountyID); this.detailAddr = cstMember.Address; this.postCode = cstMember.PostCode; this.TrafficInfo = cstMember.TrafficInfo; //主营品牌 List <Entities.ProjectTask_CSTMember_Brand> listCstMember = BLL.ProjectTask_CSTMember_Brand.Instance.GetProjectTask_CSTMember_Brand(Member.ID); if (listCstMember != null) { string BrandIds = ""; foreach (Entities.ProjectTask_CSTMember_Brand cstMemberBrand in listCstMember) { BrandIds += cstMemberBrand.BrandID + ","; } BrandIds = BrandIds.TrimEnd(','); BrandIdsName = BitAuto.YanFa.Crm2009.BLL.CarBrand.Instance.GetBrandNames(BrandIds); } //联系人 Entities.ProjectTask_CSTLinkMan linkManInfo = BLL.ProjectTask_CSTLinkMan.Instance.GetProjectTask_CSTLinkManModel(cstMember.ID); if (linkManInfo != null) { this.contact = linkManInfo.Name; this.depart = linkManInfo.Department; this.position = linkManInfo.Position; this.phone = linkManInfo.Mobile; this.email = linkManInfo.Email; } //车商币信息 if (Member.OriginalCSTRecID != null) { BitAuto.YanFa.Crm2009.Entities.CSTExpandInfo dstCSTExpandInfo = BitAuto.YanFa.Crm2009.BLL.CSTExpandInfo.Instance.GetModelByCSTRecID(Member.OriginalCSTRecID); if (dstCSTExpandInfo != null) { if (dstCSTExpandInfo.UCount != Constant.INT_INVALID_VALUE) { this.UCount = dstCSTExpandInfo.UCount.ToString(); } if (dstCSTExpandInfo.LastAddUbTime != Constant.DATE_INVALID_VALUE) { this.lastAddUbTime = dstCSTExpandInfo.LastAddUbTime.ToShortDateString(); } if (dstCSTExpandInfo.UBTotalAmount != Constant.INT_INVALID_VALUE) { this.UbTotalAmount = dstCSTExpandInfo.UBTotalAmount.ToString(); } if (dstCSTExpandInfo.UBTotalExpend != Constant.INT_INVALID_VALUE) { this.UbTotalExpend = dstCSTExpandInfo.UBTotalExpend.ToString(); } if (dstCSTExpandInfo.ActiveTime != Constant.DATE_INVALID_VALUE) { this.activeTime = dstCSTExpandInfo.ActiveTime.ToShortDateString(); } } } } }