public DataSourceResult GetList(String DataSourceID, String pageSize) { String OrderBy = String.Empty; String SearchCondition = String.Empty; int CurPage = 1; //当前的排序 if (String.IsNullOrEmpty(System.Web.HttpContext.Current.Request.QueryString[DataSourceID + "OrderBy"]) == false) { OrderBy = System.Web.HttpContext.Current.Request.QueryString[DataSourceID + "OrderBy"]; } //当前查询条件 if (String.IsNullOrEmpty(System.Web.HttpContext.Current.Request.QueryString[DataSourceID + "SearchCondition"]) == false) { SearchCondition = System.Web.HttpContext.Current.Request.QueryString[DataSourceID + "SearchCondition"]; } //当前页 if (String.IsNullOrEmpty(System.Web.HttpContext.Current.Request.QueryString[DataSourceID + "CurPage"]) == false) { String CurPage1 = System.Web.HttpContext.Current.Request.QueryString[DataSourceID + "CurPage"]; if (WebFrame.Util.JValidator.IsInt(CurPage1)) { CurPage = int.Parse(CurPage1); } } /*----------自己的业务处理代码-------------------------------------*/ int totalRow = 0; JTable tab1 = new JTable(TableName); tab1.PageSize = int.Parse(pageSize); if (String.IsNullOrEmpty(OrderBy) == false) { tab1.OrderBy = OrderBy; } List <SearchField> condition = new List <SearchField>(); if (String.IsNullOrEmpty(SearchCondition) == false) { condition.Add(new SearchField(SearchCondition, "", SearchOperator.UserDefine)); } DataSet ds1 = tab1.SearchData(condition, CurPage, "*"); totalRow = tab1.GetTotalRow(); tab1.Close(); //业务代码处理结束后,返回的结果 DataSourceResult da1 = new DataSourceResult(); da1.DataTable = ds1.Tables[0]; da1.CurPage = CurPage; da1.TotalRow = totalRow; return(da1); }
/// <summary> /// 功能:查询特定的数据 /// </summary> /// <param name="condition">查询条件</param> /// <param name="curPage">当前页</param> /// <param name="pageSize">页大小</param> /// <param name="orderBy">排序表达式</param> /// <param name="totalRow">返回的总行数</param> /// <param name="fs">要显示的字段</param> /// <returns></returns> public DataSet SearchData(List <SearchField> condition, int curPage, int pageSize, String orderBy, out int totalRow, params String[] fs) { totalRow = 0; JTable tab1 = new JTable(TableName); tab1.PageSize = pageSize; if (String.IsNullOrEmpty(orderBy) == false) { tab1.OrderBy = orderBy; } DataSet ds1 = tab1.SearchData(condition, curPage, fs); totalRow = tab1.GetTotalRow(); tab1.Close(); return(ds1); }
/// <summary> /// 根据条件得到列表数据 /// </summary> /// <param name="condition">查询条件</param> /// <param name="PageSize">页大小</param> /// <param name="CurPage">当前页</param> /// <param name="Fields">数据字段</param> /// <param name="orderBy">排序表达式</param> /// <param name="TotalRow">数据总行数</param> /// <param name="Fields">要显示的字段</param> /// <returns>列表数据</returns> public DataTable GetListData(List <SearchField> condition, int PageSize, int CurPage, String orderBy, out int TotalRow, params String[] Fields) { TotalRow = 0; DataTable dt1 = null; JTable tab1 = new JTable(daConnect, TableName); tab1.PageSize = PageSize; if (String.IsNullOrEmpty(orderBy) == false) { tab1.OrderBy = orderBy; } dt1 = tab1.SearchData(condition, CurPage, Fields).Tables[0]; TotalRow = tab1.GetTotalRow(); //得到总的数据行 tab1.Close(); return(dt1); }