/// <summary>
/// 返回一个数据表 List的前身
/// </summary>
public DataTable GetListForMoreTable(int pageSize, int pageIndex, string strWhere, string order)
{
var db = new DAL.Common();
var condition = "u.userid=m.userid";
if (!string.IsNullOrEmpty(strWhere))
{
condition += " and " + strWhere;
}
var ds = db.GetListForMoreTable("UserInfo u,member m", pageSize, pageIndex, condition, order, "u.*,m.State");
return(ds.Tables[0]);
}
/// <summary>
/// 分页获取数据列表（使用原则：程序内设定数据，非客户端提交数据。使用前提，保证SQL字符串安全，Utils.SqlStringFormat；适合多表连时使用）-吴菁,20100813
/// </summary>
/// <param name="tblName">表的名字</param>
/// <param name="PageSize">每页数据条数，-1：全部</param>
/// <param name="PageIndex">第几页，-1：全部</param>
/// <param name="strWhere">搜索条件</param>
/// <param name="strOrder">排序</param>
/// <param name="fldName">输出字段,空字符串表示*</param>
/// <returns></returns>
public DataSet GetListForMoreTable(string tblName, int PageSize, int PageIndex, string strWhere, string strOrder, string fldName)
{
return(dal.GetListForMoreTable(tblName, PageSize, PageIndex, strWhere, strOrder, fldName));
}