/// <summary>
/// 得到分页员工信息数据
/// </summary>
/// <param name="strWhere">查询条件</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页大小</param>
/// <param name="count">out类型总计</param>
/// <returns>返回DataTable</returns>
private static DataTable GetTable(string strWhere, int pageIndex, int pageSize, out int count)
{
return(CommonBase.GetTable("Agents", "ID", "ID desc", strWhere, pageIndex, pageSize, out count));
}
/// <summary>
/// 得到分页员工信息数据
/// </summary>
/// <param name="strWhere">查询条件</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页大小</param>
/// <param name="count">out类型总计</param>
/// <returns>返回DataTable</returns>
private static DataTable GetTable(string strWhere, int pageIndex, int pageSize, out int count)
{
return CommonBase.GetTable("Member", "MID", "MDate asc,MCreateDate asc,MID asc", strWhere, pageIndex, pageSize, out count);
}
/// <summary>
/// 得到分页员工信息数据
/// </summary>
/// <param name="strWhere">查询条件</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页大小</param>
/// <param name="count">out类型总计</param>
/// <returns>返回DataTable</returns>
private static DataTable GetTable(string strWhere, int pageIndex, int pageSize, out int count)
{
return(CommonBase.GetTable("BCenter", "MID", "AddDate asc,MID asc", strWhere, pageIndex, pageSize, out count));
}
public static System.Data.DataTable GetTable(string strWhere, int pageIndex, int pageSize, out int count)
{
return(CommonBase.GetTable("BonusList", "Code", "ID desc,BonusCode desc", strWhere, pageIndex, pageSize, out count));
}
public static System.Data.DataTable GetTable(string strWhere, int pageIndex, int pageSize, out int count, string orderBy)
{
return(CommonBase.GetTable("BMember", "BMID", orderBy, strWhere, pageIndex, pageSize, out count));
}
public static System.Data.DataTable GetTable(string strWhere, int pageIndex, int pageSize, out int count)
{
return(CommonBase.GetTable("SMS", "SID", "SID", strWhere, pageIndex, pageSize, out count));
}
/// <summary>
/// 得到分页员工信息数据
/// </summary>
/// <param name="strWhere">查询条件</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页大小</param>
/// <param name="count">out类型总计</param>
/// <returns>返回DataTable</returns>
public static DataTable GetTableQ(string strWhere, int pageIndex, int pageSize, out int count)
{
return(CommonBase.GetTable("View_LuckyMoney", "ID", "EditTime desc, ID asc", strWhere, pageIndex, pageSize, out count));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="query"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static IEnumerable <Model.OperationRecord> QueryByPage(Model.QueryOperationRecord query, int pageIndex, int pageSize, out int totalCount)
{
string where = GetWhere(query);
return(CommonBase.GetTable("Member_OperationRecord", "ID", "ID DESC", where, pageIndex, pageSize, out totalCount).AsEnumerable().Select(row => row.ToEntity <Model.OperationRecord>()));
}
public static System.Data.DataTable GetTable(string strWhere, int pageIndex, int pageSize, out int count)
{
return(CommonBase.GetTable("[Accounts]", "ACode", "CreateDate asc,ACode asc", strWhere, pageIndex, pageSize, out count));
}
public static System.Data.DataTable GetTable(string strWhere, int pageIndex, int pageSize, out int count)
{
return(CommonBase.GetTable("MemberBonus", "Code", "ID asc,Code asc", strWhere, pageIndex, pageSize, out count));
}