/// <summary> /// 根据条件查询从呼叫中心系统创建的车商通会员申请状态——统计数 /// </summary> /// <param name="query"></param> /// <param name="applyForCount"></param> /// <param name="createSuccessfulCount"></param> /// <param name="createUnsuccessful"></param> /// <param name="rejected"></param> public void StatProjectTask_CSTMembersBySourceCC(Entities.QueryProjectTask_CSTMember query, out int applyForCount, out int createSuccessfulCount, out int createUnsuccessful, out int rejected) { DataTable dt = Dal.ProjectTask_CSTMember.Instance.StatProjectTask_CSTMemberBySourceCC(query); if (dt != null && dt.Rows.Count > 0) { applyForCount = GetStatCountBySyncStatus(dt, (int)BitAuto.YanFa.Crm2009.Entities.EnumDMSSyncStatus.ApplyFor); createSuccessfulCount = GetStatCountBySyncStatus(dt, (int)BitAuto.YanFa.Crm2009.Entities.EnumDMSSyncStatus.CreateSuccessful); createUnsuccessful = GetStatCountBySyncStatus(dt, (int)BitAuto.YanFa.Crm2009.Entities.EnumDMSSyncStatus.CreateUnsuccessful); rejected = GetStatCountBySyncStatus(dt, (int)BitAuto.YanFa.Crm2009.Entities.EnumDMSSyncStatus.Rejected); } else { applyForCount = createSuccessfulCount = createUnsuccessful = rejected = 0; } }
public DataTable StatProjectTask_CSTMemberBySourceCC(Entities.QueryProjectTask_CSTMember query) { string where = GetProjectTask_CSTMemberBySourceCCWhere(query); DataSet ds; SqlParameter[] parameters = { new SqlParameter("@where", SqlDbType.VarChar, 8000) }; parameters[0].Value = where; ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_CSTMEMBER_SELECT_STATCREATESOURCEBYCC, parameters); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(ds.Tables[0]); } return(null); }
private void CSTStatusCountStat(Entities.QueryProjectTask_CSTMember query, int allCount) { int applyForCount = 0; int createSuccessfulCount = 0; int createUnsuccessful = 0; int rejected = 0; BLL.ProjectTask_CSTMember.Instance.StatProjectTask_CSTMembersBySourceCC(query, out applyForCount, out createSuccessfulCount, out createUnsuccessful, out rejected); sml.InnerHtml = "总计:"; sml.InnerHtml += allCount; sml.InnerHtml += " 审批中:"; sml.InnerHtml += applyForCount; sml.InnerHtml += " 通过:"; sml.InnerHtml += createSuccessfulCount; sml.InnerHtml += " 失败:"; sml.InnerHtml += createUnsuccessful; sml.InnerHtml += " 打回:"; sml.InnerHtml += rejected; }
//车商通会员信息查询方法 private void BindCSTData() { Entities.QueryProjectTask_CSTMember query = new Entities.QueryProjectTask_CSTMember(); if (!string.IsNullOrEmpty(RequestMemberName)) { query.FullName = RequestMemberName; } if (!string.IsNullOrEmpty(RequestMemberAddr)) { query.ShortName = RequestMemberAddr; } if (!string.IsNullOrEmpty(RequestCustName)) { query.CustName = RequestCustName; } if (!string.IsNullOrEmpty(RequestCustID)) { query.CustID = RequestCustID; } if (!string.IsNullOrEmpty(RequestApplyStartTime)) { query.ApplyStartTime = RequestApplyStartTime; } if (!string.IsNullOrEmpty(RequestApplyEndTime)) { query.ApplyEndTime = RequestApplyEndTime; } if (!string.IsNullOrEmpty(RequestApplyUserName)) { query.ApplyUserName = RequestApplyUserName; } if (!string.IsNullOrEmpty(RequestMemberOptStartTime)) { query.MemberOptStartTime = RequestMemberOptStartTime; } if (!string.IsNullOrEmpty(RequestMemberOptEndTime)) { query.MemberOptEndTime = RequestMemberOptEndTime; } if (!string.IsNullOrEmpty(RequestDMSSyncStatus)) { query.CSTSyncStatus = RequestDMSSyncStatus; } else { query.CSTSyncStatus = "170001,170002,170003,170008"; } if (BLL.UserDataRigth.Instance.IsExistsByUserID(BLL.Util.GetLoginUserID())) { query.CSTMemberApplyUserID = Constant.INT_INVALID_VALUE; } else { query.CSTMemberApplyUserID = BLL.Util.GetLoginUserID(); } if (!string.IsNullOrEmpty(RequestDMSStatus)) { query.CSTStatus = RequestDMSStatus; } int count; DataTable dt = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMembersBySourceCC(query, "ApplyTime Desc", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount); repeaterList.DataSource = dt; repeaterList.DataBind(); //AjaxPager_Member.InitPager(count); //selectDown.Value = RequestPageSize.ToString(); litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1); CSTStatusCountStat(query, RecordCount); }
/// <summary> /// 从CC_Custs中读取客户信息与会员信息。 /// </summary> private void LoadInfoFromCC_Cust(Entities.ProjectTaskInfo task) { #region 加载客户信息 Entities.ProjectTask_Cust ccCust = BLL.ProjectTask_Cust.Instance.GetProjectTask_Cust(task.PTID); this.OriginalCustID = ccCust.OriginalCustID; this.tfCustName.Value = ccCust.CustName; this.tfCustAbbr.Value = ccCust.AbbrName; ListItem li = this.selCustType.Items.FindByValue(ccCust.TypeID); this.selCustType.SelectedIndex = this.selCustType.Items.IndexOf(li); if (task.Source == 2) //CRM库来源 { selCustType.Attributes.Add("disabled", "disabled"); //不能编辑客户类别 } li = this.selCustIndustry.Items.FindByValue(ccCust.IndustryID); this.selCustIndustry.SelectedIndex = this.selCustIndustry.Items.IndexOf(li); this.InitialProvinceID = ccCust.ProvinceID; this.InitialCityID = ccCust.CityID; this.InitialCountyID = ccCust.CountyID; this.tfAddress.Value = ccCust.Address; this.tfZipcode.Value = ccCust.Zipcode; if (!string.IsNullOrEmpty(ccCust.TradeMarketID)) { //this.sltTradeMarket.Value = ccCust.TradeMarketID.ToString(); BitAuto.YanFa.Crm2009.Entities.CustInfo custInfo = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.TradeMarketID.ToString()); if (custInfo != null) { tfCustPidName.Value = custInfo.CustName; tfCustPid.Value = ccCust.TradeMarketID.ToString(); } } if (ccCust.CarType == 2) { this.chkOldCarType.Checked = true; #region Modify=masj,Date=2012-04-13 注释掉 //if (ccCust.CstMemberID != "" && ccCust.CstMemberID != null) //{ // this.txtCtsMemberID.Value = ccCust.CstMemberID; //} #endregion //if (!string.IsNullOrEmpty(ccCust.UsedCarBusinessType)) //{ // this.sltUsedCarBusinessType.Value = ccCust.UsedCarBusinessType.ToString(); //} } if (!string.IsNullOrEmpty(ccCust.OriginalCustID)) { if (ccCust.Status != null) { switch (ccCust.Status.Value) { case 0: imgCustStatus.Src = "/Images/xt.gif"; imgCustStatus.Attributes.Add("title", "在用"); break; case 1: imgCustStatus.Src = "/Images/xt_1.gif"; imgCustStatus.Attributes.Add("title", "停用"); break; default: break; } } if (ccCust.Lock != null && ccCust.Lock.Value == 1) { imgCustStatusLock.Src = "/Images/lock.gif"; imgCustStatusLock.Attributes.Add("title", "锁定"); } else if (ccCust.Lock != null && ccCust.Lock.Value == 0) { imgCustStatusLock.Src = "/Images/unlock.gif"; imgCustStatusLock.Attributes.Add("title", "未锁定"); } liCustStatus.Style.Remove("display"); liCustLock.Style.Remove("display"); } li = this.selCustLevel.Items.FindByValue(ccCust.LevelID); this.selCustLevel.SelectedIndex = this.selCustLevel.Items.IndexOf(li); this.tfOfficeTel.Value = ccCust.OfficeTel; this.tfFax.Value = ccCust.Fax; this.tfContactName.Value = ccCust.ContactName; this.tfNotes.Value = ccCust.Notes; #endregion BindCCMemberList(); #region 加载车商通会员信息 //如果是新车二手车或二手车 if (ccCust.CarType == 2 || ccCust.CarType == 3) { Entities.QueryProjectTask_CSTMember queryCstMember = new Entities.QueryProjectTask_CSTMember(); List <Entities.ProjectTask_CSTMember> ccCstMembers = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberByTID(task.PTID); if (ccCstMembers.Count > 0) { Control ctl; foreach (Entities.ProjectTask_CSTMember m in ccCstMembers) { ////在CRM中有会员 //if (string.IsNullOrEmpty(m.OriginalDMSMemberID) == false) { HasMembersInCrm = true; } ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditCstMember.ascx", m); this.PlaceHolderCstMember.Controls.Add(ctl); } } //else //{ // if (task.Source == 1) // { // Control ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditCstMember.ascx", task.TID); // this.PlaceHolderCstMember.Controls.Add(ctl); // } //} } #endregion }