/// <summary>
/// 根据ID查找帖子
/// </summary>
/// <param name="PostID">获取PostID</param>
/// <returns>返回一个对象</returns>
public static Posts_M PostByID(string PostID)
{
Posts_M Post = new Posts_M();
string sql = "select * from Posts where PostId=" + PostID;
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
dr.Read();
if (dr["PostId"] != DBNull.Value)
{
Post.PostId = Convert.ToInt32(dr["PostId"]);
}
if (dr["TaxonomyId"] != DBNull.Value)
{
Post.TaxonomyId = Convert.ToInt32(dr["TaxonomyId"]);
}
if (dr["Title"] != DBNull.Value)
{
Post.Title = Convert.ToString(dr["Title"]);
}
if (dr["Post"] != DBNull.Value)
{
Post.Post = Convert.ToString(dr["Post"]);
}
if (dr["PublishTime"] != DBNull.Value)
{
Post.PublishTime = Convert.ToDateTime(dr["PublishTime"]);
}
}
dr.Close();
return(Post);
}
/// <summary>
/// 登录判断
/// </summary>
/// <param name="Admin">接收Admin类</param>
/// <returns>返回是否登录成功</returns>
public static bool Login(Admin_M Admin)
{
SqlParameter paramAdminName = new SqlParameter();
paramAdminName.ParameterName = "@AdminName";
paramAdminName.DbType = DbType.String;
paramAdminName.Value = Admin.Adminlogin;
SqlParameter paramAdminPwd = new SqlParameter();
paramAdminPwd.ParameterName = "@AdminPwd";
paramAdminPwd.DbType = DbType.String;
paramAdminPwd.Value = Admin.Adminpassword;
SqlDataReader dr = SQLDBHelper.ExecuteReader("proc_Login", paramAdminName, paramAdminPwd);
if (dr.HasRows)
{
dr.Close();
return(true);
}
else
{
dr.Close();
return(false);
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="pageSize">每页数据行数</param>
/// <param name="pageIndex">页码</param>
/// <returns>返回集合</returns>
public static List <Taxonomy_M> TaxListPager(string pageSize, string pageIndex)
{
List <Taxonomy_M> list = new List <Taxonomy_M>();
string sql = string.Format("select top ({0}) *from Taxonomy where TaxonomyId not in(select top (({1}-1)*{0}) TaxonomyId from Taxonomy order by TaxonomyId) order by TaxonomyId", pageSize, pageIndex);
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
Taxonomy_M tax = new Taxonomy_M();
if (dr["TaxonomyId"] != DBNull.Value)
{
tax.TaxonomyId = Convert.ToInt32(dr["TaxonomyId"]);
}
if (dr["TaxonomyName"] != DBNull.Value)
{
tax.TaxonomyName = dr["TaxonomyName"].ToString();
}
if (dr["Taxonomydesc"] != DBNull.Value)
{
tax.Taxonomydesc = dr["Taxonomydesc"].ToString();
}
list.Add(tax);
}
}
dr.Close();
return(list);
}
/// <summary>
/// 查询所有类型
/// </summary>
/// <returns>返回集合</returns>
public static List <Taxonomy_M> TaxList()
{
List <Taxonomy_M> list = new List <Taxonomy_M>();
string sql = "select * from Taxonomy";
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
Taxonomy_M tax = new Taxonomy_M();
if (dr["TaxonomyId"] != DBNull.Value)
{
tax.TaxonomyId = Convert.ToInt32(dr["TaxonomyId"]);
}
if (dr["TaxonomyName"] != DBNull.Value)
{
tax.TaxonomyName = dr["TaxonomyName"].ToString();
}
if (dr["Taxonomydesc"] != DBNull.Value)
{
tax.Taxonomydesc = dr["Taxonomydesc"].ToString();
}
list.Add(tax);
}
}
dr.Close();
return(list);
}
/// <summary>
/// 根据ID查访客
/// </summary>
/// <param name="id">访客ID</param>
/// <returns>返回类</returns>
public static Users_M UserByID(string id)
{
Users_M user = new Users_M();
string sql = "select * from Users where UserId=" + id;
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
dr.Read();
if (dr["UserId"] != DBNull.Value)
{
user.UserId = Convert.ToInt32(dr["UserId"]);
}
if (dr["Username"] != DBNull.Value)
{
user.Username = Convert.ToString(dr["Username"]);
}
if (dr["UserEmail"] != DBNull.Value)
{
user.UserEmail = Convert.ToString(dr["UserEmail"]);
}
if (dr["UserIP"] != DBNull.Value)
{
user.UserIP = Convert.ToString(dr["UserIP"]);
}
}
dr.Close();
return(user);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="pageSize">每页数据</param>
/// <param name="pageIndex">页码</param>
/// <returns>返回集合</returns>
public static List <Comments_M> CommentsListPager(string pageSize, string pageIndex)
{
List <Comments_M> list = new List <Comments_M>();
string sql = string.Format("select top ({0}) *from Comments where CommentId not in(select top (({1}-1)*{0}) CommentId from Comments order by CommentId)order by CommentId", pageSize, pageIndex);
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
Comments_M comment = new Comments_M();
if (dr["CommentId"] != DBNull.Value)
{
comment.CommentId = Convert.ToInt32(dr["CommentId"]);
}
if (dr["PostId"] != DBNull.Value)
{
comment.PostId = Convert.ToInt32(dr["PostId"]);
}
if (dr["UserId"] != DBNull.Value)
{
comment.UserId = Convert.ToInt32(dr["UserId"]);
}
if (dr["Commentsmeta"] != DBNull.Value)
{
comment.Commentsmeta = Convert.ToString(dr["Commentsmeta"]);
}
if (dr["CommentsTime"] != DBNull.Value)
{
comment.CommentsTime = Convert.ToDateTime(dr["CommentsTime"]);
}
list.Add(comment);
}
}
dr.Close();
return(list);
}
/// <summary>
/// 查询所有评论
/// </summary>
/// <returns>返回集合</returns>
public static List <Comments_M> CommentsList()
{
List <Comments_M> list = new List <Comments_M>();
string sql = "select * from Comments";
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
Comments_M comment = new Comments_M();
if (dr["CommentId"] != DBNull.Value)
{
comment.CommentId = Convert.ToInt32(dr["CommentId"]);
}
if (dr["PostId"] != DBNull.Value)
{
comment.PostId = Convert.ToInt32(dr["PostId"]);
}
if (dr["UserId"] != DBNull.Value)
{
comment.UserId = Convert.ToInt32(dr["UserId"]);
}
if (dr["Commentsmeta"] != DBNull.Value)
{
comment.Commentsmeta = Convert.ToString(dr["Commentsmeta"]);
}
if (dr["CommentsTime"] != DBNull.Value)
{
comment.CommentsTime = Convert.ToDateTime(dr["CommentsTime"]);
}
list.Add(comment);
}
}
dr.Close();
return(list);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="pageSize">页数大小</param>
/// <param name="pageIndex">页码</param>
/// <returns>返回集合</returns>
public static List <Posts_M> PostListPager(string pageSize, string pageIndex)
{
List <Posts_M> list = new List <Posts_M>();
string sql = string.Format("select top ({0}) *from Posts where PostId not in (select top (({1}-1)*{0}) PostId from Posts order by PostId) order by PostId", pageSize, pageIndex);
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
Posts_M post = new Posts_M();
if (dr["PostId"] != DBNull.Value)
{
post.PostId = Convert.ToInt32(dr["PostId"]);
}
if (dr["TaxonomyId"] != DBNull.Value)
{
post.TaxonomyId = Convert.ToInt32(dr["TaxonomyId"]);
}
if (dr["Title"] != DBNull.Value)
{
post.Title = Convert.ToString(dr["Title"]);
}
if (dr["Post"] != DBNull.Value)
{
post.Post = Convert.ToString(dr["Post"]);
}
if (dr["PublishTime"] != DBNull.Value)
{
post.PublishTime = Convert.ToDateTime(dr["PublishTime"]);
}
list.Add(post);
}
}
dr.Close();
return(list);
}
/// <summary>
/// 通过类型ID查找帖子集合
/// </summary>
/// <param name="TaxID">获取类型ID</param>
/// <returns>返回集合</returns>
public static List <Posts_M> PostListByTaxID(string TaxID)
{
List <Posts_M> list = new List <Posts_M>();
string sql = "select * from Posts where TaxonomyId =" + TaxID;
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
Posts_M post = new Posts_M();
if (dr["PostId"] != DBNull.Value)
{
post.PostId = Convert.ToInt32(dr["PostId"]);
}
if (dr["TaxonomyId"] != DBNull.Value)
{
post.TaxonomyId = Convert.ToInt32(dr["TaxonomyId"]);
}
if (dr["Title"] != DBNull.Value)
{
post.Title = Convert.ToString(dr["Title"]);
}
if (dr["Post"] != DBNull.Value)
{
post.Post = Convert.ToString(dr["Post"]);
}
if (dr["PublishTime"] != DBNull.Value)
{
post.PublishTime = Convert.ToDateTime(dr["PublishTime"]);
}
list.Add(post);
}
}
dr.Close();
return(list);
}
/// <summary>
/// 根据类型ID获取类型
/// </summary>
/// <param name="id">类型id</param>
/// <returns>返回类型对象</returns>
public static Taxonomy_M getTaxonomyByID(string id)
{
Taxonomy_M tax = new Taxonomy_M();
string sql = "select * from Taxonomy where TaxonomyId=" + id;
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
dr.Read();
if (dr["TaxonomyId"] != DBNull.Value)
{
tax.TaxonomyId = Convert.ToInt32(dr["TaxonomyId"]);
}
if (dr["TaxonomyName"] != DBNull.Value)
{
tax.TaxonomyName = dr["TaxonomyName"].ToString();
}
if (dr["Taxonomydesc"] != DBNull.Value)
{
tax.Taxonomydesc = dr["Taxonomydesc"].ToString();
}
}
return(tax);
}
