/// <summary>
/// 获取分页数据
/// </summary>
public DataTable GetPaginationData(DBTAB_Module_RelationQuery TAB_Module_RelationQuery)
{
StringBuilder strSqlOption = new StringBuilder();
StringBuilder strSql = new StringBuilder();
SqlParameter[] sqlParams;
TAB_Module_RelationQuery.OutPut(out strSqlOption, out sqlParams);
strSql.Append(@"select top " + TAB_Module_RelationQuery.rows.ToString() + " * from WebPlatForm_Module_Relation where 1=1 " + strSqlOption.ToString() + " and nID not in ( select top " + (TAB_Module_RelationQuery.page - 1) * TAB_Module_RelationQuery.rows + " nID from WebPlatForm_Module_Relation where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc");
return(SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]);
}
/// <summary>
/// 获取数据总数
/// </summary>
/// <param name="jcid"></param>
/// <returns></returns>
public int GetDataCount(DBTAB_Module_RelationQuery TAB_Module_RelationQuery)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
TAB_Module_RelationQuery.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) ");
strSql.Append(" FROM WebPlatForm_Module_Relation where 1=1" + strSqlOption.ToString());
return(ObjectConvertClass.static_ext_int(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams)));
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public DataTable GetData(DBTAB_Module_RelationQuery TAB_Module_RelationQuery)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
TAB_Module_RelationQuery.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM WebPlatForm_Module_Relation where 1=1" + strSqlOption.ToString());
return(SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]);
}