/// 分页查询
/// <summary>
/// 分页查询
/// </summary>
/// <param name="query"></param>
/// <param name="order"></param>
/// <param name="currentPage"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetBusinessGroup(QueryBusinessGroup query, string order, int currentPage, int pageSize, out int totalCount)
{
string where = GetWhere(query);
DataSet ds;
SqlParameter[] parameters =
{
new SqlParameter("@where", SqlDbType.NVarChar, 40000),
new SqlParameter("@Employeewhere", SqlDbType.NVarChar, 40000),
new SqlParameter("@order", SqlDbType.NVarChar, 200),
new SqlParameter("@pagesize", SqlDbType.Int, 4),
new SqlParameter("@indexpage", SqlDbType.Int, 4),
new SqlParameter("@totalRecorder", SqlDbType.Int, 4)
};
parameters[0].Value = where;
parameters[1].Value = GetEmployeewhere();
parameters[2].Value = order;
parameters[3].Value = pageSize;
parameters[4].Value = currentPage;
parameters[5].Direction = ParameterDirection.Output;
ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_BusinessGroup_SELECT, parameters);
totalCount = (int)(parameters[5].Value);
return(ds.Tables[0]);
}
private void BindData()
{
QueryBusinessGroup query = new QueryBusinessGroup();
query.BusinessType = StringHelper.SqlFilter(this.BusinessType);
query.Status = StringHelper.SqlFilter(this.Status);
query.Region = StringHelper.SqlFilter(this.Region);
DataTable dt = BLL.BusinessGroup.Instance.GetBusinessGroup(query, "bg.CreateTime DESC", BLL.PageCommon.Instance.PageIndex, pageSize, out RecordCount);
if (dt != null)
{
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, pageSize, BLL.PageCommon.Instance.PageIndex, 1);
}
}
/// 获取查询条件
/// <summary>
/// 获取查询条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private string GetWhere(QueryBusinessGroup query)
{
string where = "";
//业务分类 （热线=1 在线=2 全部=3）
if (!string.IsNullOrEmpty(query.BusinessType))
{
where += " AND bg.BusinessType in (" + Dal.Util.SqlFilterByInCondition(query.BusinessType) + ") ";
}
//状态
if (!string.IsNullOrEmpty(query.Status))
{
where += " AND bg.Status in (" + Dal.Util.SqlFilterByInCondition(query.Status) + ") ";
}
//区域
if (!string.IsNullOrEmpty(query.Region))
{
where += " AND bg.RegionID in (" + Dal.Util.SqlFilterByInCondition(query.Region) + ") ";
}
return(where);
}
/// 分页查询
/// <summary>
/// 分页查询
/// </summary>
/// <param name="query"></param>
/// <param name="order"></param>
/// <param name="currentPage"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetBusinessGroup(QueryBusinessGroup query, string order, int currentPage, int pageSize, out int totalCount)
{
return(Dal.BusinessGroup.Instance.GetBusinessGroup(query, order, currentPage, pageSize, out totalCount));
}
