/// <summary>
/// 获得数据列表
/// </summary>
public DataTable GetList()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select a.ID,a.TypeId,a.ImgName,a.ImgUrl,a.Imgsdescribe,a.date,b.TypeName ");
strSql.Append(" FROM Picture a join PictureType b on a.TypeId = b.ID order by a.ID desc");
return SQLHelper.ExecuteTable(strSql.ToString());
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataTable GetList()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,TypeName,date ");
strSql.Append(" FROM PictureType order by ID desc ");
return(SQLHelper.ExecuteTable(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataTable GetList()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,[User],Pwd,Name,Img,sex,Birthday,Fristaddress,Secondaddress,School,Email,date ");
strSql.Append(" FROM [User] ");
return(SQLHelper.ExecuteTable(strSql.ToString()));
}
/// <summary>
/// 要据类型获得新闻列表
/// </summary>
public DataTable GetListTypeNew(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM Article where TypeId = " + id);
return(SQLHelper.ExecuteTable(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataTable GetList(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM myRevert where ArticleID=" + id + "order by ID desc");
return(SQLHelper.ExecuteTable(strSql.ToString()));
}
/// <summary>
/// 获得全部数据条数
/// </summary>
public DataTable Getli(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) ");
strSql.Append("from myRevert");
strSql.Append("where ArticleID=" + id);
return(SQLHelper.ExecuteTable(strSql.ToString()));
}
/// <summary>
/// 通过类别获取数据列表
/// </summary>
public DataTable GetlestID(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" ID,TypeId,ImgName,ImgUrl,Imgsdescribe,date ");
strSql.Append(" from Picture ");
strSql.Append(" where TypeId=" + ID + " ");
return SQLHelper.ExecuteTable(strSql.ToString());
}
/// <summary>
/// 获得数据
/// </summary>
public DataTable selectt(int top)
{
StringBuilder strSql = new StringBuilder();
string addsql = "top " + top;
if (top <= 0)
{
addsql = "";
}
strSql.Append("select " + addsql + " * ");
strSql.Append(" FROM myRevert order by ID desc");
return(SQLHelper.ExecuteTable(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataTable GetList(int top)
{
StringBuilder strSql = new StringBuilder();
string addsql = "top " + top;
if (top <= 0)
{
addsql = "";
}
strSql.Append("select " + addsql + " a.ID,a.Author,a.TypeId,a.[Subject],a.[Content],a.[Count],a.date,b.Type ");
strSql.Append(" FROM Article a join [type] b on a.TypeId = b.ID order by a.ID desc");
return(SQLHelper.ExecuteTable(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataTable GetList(int top)
{
string addsql = "top " + top;
if (top <= 0)
{
addsql = "";
}
StringBuilder strSql = new StringBuilder();
strSql.Append("select " + addsql + " ID,[User],UserMessage,date ");
strSql.Append(" FROM Message ");
return(SQLHelper.ExecuteTable(strSql.ToString()));
}
/// <summary>
/// 获得数据
/// </summary>
public DataTable GetListRevert(int top)
{
StringBuilder strSql = new StringBuilder();
string addsql = "top " + top;
if (top <= 0)
{
addsql = "";
}
//strSql.Append("select " + addsql + " a.ID,a.Author,a.TypeId,a.[Subject],a.[Content],a.[Count],a.date,b.Type ");
//strSql.Append(" FROM Article a join [type] b on a.TypeId = b.ID order by a.ID desc");
//strSql.Append("select "+addsql+" * from Article as a join (select count(ArticleID)as b,ArticleID from myRevert group by ArticleID) as c on a.id=c.ArticleID order by ID desc");
strSql.Append("select " + addsql + " a.*,c.*,d.Type from Article as a left join (select count(ArticleID)as b,ArticleID from myRevert group by ArticleID) as c on a.id=c.ArticleID join [Type] as d on a.TypeId=d.ID order by a.ID desc");
return(SQLHelper.ExecuteTable(strSql.ToString()));
}
