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