#region ///重载下一章
/// <summary>
///重载下一章
/// </summary>
/// <param name="nowId">当前ID</param>
/// <param name="tbId">数据表主键列</param>
/// <param name="tbName">数据表名</param>
/// <param name="title">链接文字</param>
/// <param name="url">链接地址</param>
/// <param name="sortId">当前数据表对应的类别ID</param>
/// <param name="stbName">类别表</param>
/// <param name="sId">类别ID</param>
/// <returns>返回String</returns>
public static string NextBus(string nowId, string tbId, string tbName, string title, string url, string sortId, string sId)
{
StringBuilder sbHtml = null;
sbHtml = new StringBuilder();
sbHtml.Append("select * from ");
sbHtml.Append(tbName + " where " + tbId);
sbHtml.Append("= (select MIN(" + tbId + ") from " + tbName + " where ");
sbHtml.Append(tbName + "." + sortId + "=" + sId + " and ");
sbHtml.Append(tbId + ">" + nowId + ")");
string sql = sbHtml.ToString();
DataTable dt = AccessHelper.AccessData(sql);
if (dt.Rows.Count== 0)
{
return "没有下一章";
}
else
{
string id = dt.Rows[0][tbId].ToString();
string name = dt.Rows[0][title].ToString();
sbHtml = new StringBuilder();
sbHtml.Append("<a href='" + url + "?id=" + id + "&sId=" + sId + "'>");
sbHtml.Append(name + "</a>");
string str = sbHtml.ToString();
return str;
}
}
#endregion
/// <summary>
///重载下一章
/// </summary>
/// <param name="nowId">当前ID</param>
/// <param name="tbId">数据表主键列</param>
/// <param name="tbName">数据表名</param>
/// <param name="title">链接文字</param>
/// <param name="url">链接地址</param>
/// <param name="sortId">当前数据表对应的类别ID</param>
/// <param name="stbName">类别表</param>
/// <param name="sId">类别ID</param>
/// <returns>返回String</returns>
public static string NextBus(string nowId, string tbId, string tbName, string title, string url, string sortId, string sId)
{
StringBuilder sbHtml = null;
sbHtml = new StringBuilder();
sbHtml.Append("select * from ");
sbHtml.Append(tbName + " where " + tbId);
sbHtml.Append("= (select MIN(" + tbId + ") from " + tbName + " where ");
sbHtml.Append(tbName + "." + sortId + "=" + sId + " and ");
sbHtml.Append(tbId + ">" + nowId + ")");
string sql = sbHtml.ToString();
DataTable dt = AccessHelper.AccessData(sql);
if (dt.Rows.Count== 0)
{
return "没有下一章";
}
else
{
string id = dt.Rows[0][tbId].ToString();
string name = dt.Rows[0][title].ToString();
sbHtml = new StringBuilder();
sbHtml.Append("<a href='" + url + "?id=" + id + "&sId=" + sId + "'>");
sbHtml.Append(name + "</a>");
string str = sbHtml.ToString();
return str;
}
}
#endregion