/// 分页查询 /// <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)); }