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