/// <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_DMSMembersBySourceCC(Entities.QueryProjectTask_DMSMember query, out int applyForCount, out int createSuccessfulCount, out int createUnsuccessful, out int rejected)
{
DataTable dt = Dal.ProjectTask_DMSMember.Instance.StatProjectTask_DMSMemberBySourceCC(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;
}
}
private void StatusCountStat(Entities.QueryProjectTask_DMSMember query, int allCount)
{
int applyForCount = 0;
int createSuccessfulCount = 0;
int createUnsuccessful = 0;
int rejected = 0;
BLL.ProjectTask_DMSMember.Instance.StatCC_DMSMembersBySourceCC(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;
}
public DataTable StatProjectTask_DMSMemberBySourceCC(Entities.QueryProjectTask_DMSMember query)
{
string where = GetProjectTask_DMSMemberBySourceCCWhere(query);
DataSet ds;
SqlParameter[] parameters =
{
new SqlParameter("@where", SqlDbType.VarChar, 8000)
};
parameters[0].Value = where;
ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_DMSMEMBER_SELECT_STATCREATESOURCEBYCC, parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
return(ds.Tables[0]);
}
return(null);
}
/// <summary>
/// 根据条件查询从呼叫中心系统创建的会员列表
/// </summary>
/// <param name="query">查询实体</param>
/// <param name="order">排序字段</param>
/// <param name="index">当前页</param>
/// <param name="pageSize">页大小</param>
/// <param name="count">总条数</param>
/// <returns>返回DataTable</returns>
public DataTable GetProjectTask_DMSMemberBySourceCC(Entities.QueryProjectTask_DMSMember query, string order, int index, int pageSize, out int count)
{
return(Dal.ProjectTask_DMSMember.Instance.GetProjectTask_DMSMemberBySourceCC(query, order, index, pageSize, out count));
}
//易湃会员信息查询方法
private void BindDMSData()
{
Entities.QueryProjectTask_DMSMember query = new Entities.QueryProjectTask_DMSMember();
if (!string.IsNullOrEmpty(RequestMemberName))
{
query.MemberName = RequestMemberName;
}
if (!string.IsNullOrEmpty(RequestMemberAddr))
{
query.MemberAbbr = 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.DMSSyncStatus = RequestDMSSyncStatus;
}
else
{
query.DMSSyncStatus = "170001,170002,170003,170008";
}
if (BLL.UserDataRigth.Instance.IsExistsByUserID(BLL.Util.GetLoginUserID()))
{
query.DMSMemberApplyUserID = Constant.INT_INVALID_VALUE;
}
else
{
query.DMSMemberApplyUserID = BLL.Util.GetLoginUserID();
}
if (!string.IsNullOrEmpty(RequestDMSStatus))
{
query.DMSStatus = RequestDMSStatus;
}
int count;
DataTable dt = BLL.ProjectTask_DMSMember.Instance.GetProjectTask_DMSMemberBySourceCC(query, "ApplyTime Desc", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount);
repeaterList.DataSource = dt;
repeaterList.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1);
//AjaxPager_Member.InitPager(count);
//selectDown.Value = RequestPageSize.ToString();
StatusCountStat(query, RecordCount);
}