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