/// <summary>
/// 查询列表
/// </summary>
/// <param name="SelectCol">选择列</param>
/// <param name="Criteria">查询条件</param>
/// <param name="OrderBy">排序</param>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageCount">通过该查询条件，返回的查询记录的页数</param>
/// <returns>查询列表</returns>
public DataView GetList(
string SelectCol,
string Criteria,
string OrderBy,
ref long CurrentPage,
long PageSize,
ref long PageCount)
{
Common.CommonFunction comm = new Tz888.SQLServerDAL.Common.CommonFunction();
DataView dv = comm.GetList("CommendTabList", "ID", SelectCol, Criteria, OrderBy, ref CurrentPage, PageSize, ref PageCount);
return(dv);
}
/// <summary>
/// 查询对应记录
/// </summary>
/// <param name="Key">关键字</param>
/// <returns>是否操作成功（true成功，false失败）</returns>
public bool GetDetail(string Key)
{
long PageCount = 0;
long CurrentPage = 1;
Common.CommonFunction comm = new Tz888.SQLServerDAL.Common.CommonFunction();
DataView dv = comm.GetList("CommendTabList", "ID", "*", "(ID=" + Key.Trim() + ")", "ID Asc", ref CurrentPage, 1, ref PageCount);
if (dv != null && dv.Count == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取全部的信息列表
/// </summary>
/// <param name="mySql">连接数据库类</param>
/// <param name="FNStrName">函数字符串</param>
/// <param name="Key">关键字</param>
/// <param name="SelectStr">选择列字符串</param>
/// <param name="Criteria">查询条件</param>
/// <param name="Sort">排序字符串</param>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="TotalCount">通过该查询条件，返回的查询记录的总页数</param>
/// <returns>返回当前页的信息列表</returns>
public DataView GetList(
string FNStrName,
string Key,
string SelectStr,
string Criteria,
string Sort,
ref long CurrentPage,
long PageSize,
ref long TotalCount
)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetList(
FNStrName,
Key,
SelectStr,
Criteria,
Sort,
ref CurrentPage,
PageSize,
ref TotalCount
));
}