/// <summary>
/// 根据当前登录人取管辖分组所有人回访记录，提交以及接通，成功等统计量
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public DataTable GetB_ReturnVisitReport_ForExcel(Entities.BusinessReport.QueryReturnVisitReport query)
{
//and a.[year]=2015 and a.[month]=10 and c.bgid =17
//and b.createuserid=11447 and c.agentnum
string where = string.Empty;
if (!string.IsNullOrEmpty(query.AgentNum))
{
where += " and c.AgentNum= '" + StringHelper.SqlFilter(query.AgentNum) + "'";
}
if (query.UserID != Constant.INT_INVALID_VALUE)
{
where += " and b.createuserid= " + query.UserID;
}
if (query.BGID != Constant.INT_INVALID_VALUE)
{
where += " and c.bgid= " + query.BGID;
}
DataSet ds;
SqlParameter[] parameters =
{
new SqlParameter("@where", SqlDbType.NVarChar, 4000),
new SqlParameter("@dqtime", SqlDbType.DateTime, 4),
new SqlParameter("@year", SqlDbType.Int, 4),
new SqlParameter("@month", SqlDbType.Int, 4)
};
parameters[0].Value = where;
parameters[1].Value = Convert.ToDateTime(query.Year.ToString() + "-" + query.Month.ToString() + "-10");
parameters[2].Value = query.Year;
parameters[3].Value = query.Month;
ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, "p_ReturnVisitBussiness_Excel", parameters);
return(ds.Tables[0]);
}
/// <summary>
/// 根据当前登录人取管辖分组所有人回访记录，提交以及接通，成功等统计量
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public DataTable GetB_ReturnVisitReport(Entities.BusinessReport.QueryReturnVisitReport query, string order, int currentPage, int pageSize, out int totalCount)
{
//and a.[year]=2015 and a.[month]=10 and c.bgid =17
//and b.createuserid=11447 and c.agentnum
string where = string.Empty;
if (!string.IsNullOrEmpty(query.AgentNum))
{
where += " and c.AgentNum= '" + StringHelper.SqlFilter(query.AgentNum) + "'";
}
if (query.UserID != Constant.INT_INVALID_VALUE)
{
where += " and b.createuserid= " + query.UserID;
}
if (query.BGID != Constant.INT_INVALID_VALUE)
{
where += " and c.bgid= " + query.BGID;
}
order = " dyfzmembercount desc";
DataSet ds;
SqlParameter[] parameters =
{
new SqlParameter("@where", SqlDbType.NVarChar, 4000),
new SqlParameter("@order", SqlDbType.NVarChar, 200),
new SqlParameter("@pagesize", SqlDbType.Int, 4),
new SqlParameter("@indexpage", SqlDbType.Int, 4),
new SqlParameter("@totalRecorder", SqlDbType.Int, 4),
new SqlParameter("@dqtime", SqlDbType.DateTime, 4),
new SqlParameter("@year", SqlDbType.Int, 4),
new SqlParameter("@month", SqlDbType.Int, 4)
};
parameters[0].Value = where;
parameters[1].Value = order;
parameters[2].Value = pageSize;
parameters[3].Value = currentPage;
parameters[4].Direction = ParameterDirection.Output;
parameters[5].Value = Convert.ToDateTime(query.Year.ToString() + "-" + query.Month.ToString() + "-10");
parameters[6].Value = query.Year;
parameters[7].Value = query.Month;
ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, "p_ReturnVisitBussiness_Select", parameters);
totalCount = (int)(parameters[4].Value);
return(ds.Tables[0]);
}
/// <summary>
/// 导出根据当前登录人取管辖分组所有回访记录，提交以及接通，成功等统计量总计
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public DataTable GetB_ReturnVisitReportSum_ForExcel(Entities.BusinessReport.QueryReturnVisitReport query)
{
return(Dal.ProjectInfo.Instance.GetB_ReturnVisitReportSum_ForExcel(query));
}
/// <summary>
/// 根据当前登录人取管辖分组所有项目的分配，提交以及接通，成功等统计量
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public DataTable GetB_ReturnVisitReport(Entities.BusinessReport.QueryReturnVisitReport query, string order, int currentPage, int pageSize, out int totalCount)
{
return(Dal.ProjectInfo.Instance.GetB_ReturnVisitReport(query, order, currentPage, pageSize, out totalCount));
}
