/// <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> /// 根据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> /// 根据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> /// <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> /// 添加访客及其评论 /// </summary> /// <param name="PostId">帖子id</param> /// <param name="UserName">访客姓名</param> /// <param name="UserEmail">访客邮箱</param> /// <param name="CommentMeta">评论内容</param> /// <param name="UserIP">访客IP</param> /// <returns>返回是否添加成功</returns> public static bool AddComment(string PostId, string UserName, string UserEmail, string CommentMeta, string UserIP) { SqlParameter paramPostId = new SqlParameter(); paramPostId.ParameterName = "@PostId"; paramPostId.DbType = DbType.String; paramPostId.Value = PostId; SqlParameter paramUserName = new SqlParameter(); paramUserName.ParameterName = "@Username"; paramUserName.DbType = DbType.String; paramUserName.Value = UserName; SqlParameter paramUserEmail = new SqlParameter(); paramUserEmail.ParameterName = "@UserEmail"; paramUserEmail.DbType = DbType.String; paramUserEmail.Value = UserEmail; SqlParameter paramCommentMeta = new SqlParameter(); paramCommentMeta.ParameterName = "@Commentsmeta"; paramCommentMeta.DbType = DbType.String; paramCommentMeta.Value = CommentMeta; SqlParameter paramUserIP = new SqlParameter(); paramUserIP.ParameterName = "@UserIP"; paramUserIP.DbType = DbType.String; paramUserIP.Value = UserIP; return(SQLDBHelper.ExecuteNonQuery("proc_Insert_Comment", paramPostId, paramUserName, paramUserEmail, paramCommentMeta, paramUserIP)); }
/// <summary> /// 增 /// </summary> /// <param name="tax"></param> /// <returns></returns> public static bool addTax(Taxonomy_M tax) { SqlParameter paramTaxName = new SqlParameter(); paramTaxName.ParameterName = "@TaxonomyName"; paramTaxName.DbType = DbType.String; paramTaxName.Value = tax.TaxonomyName; SqlParameter paramTaxdesc = new SqlParameter(); paramTaxdesc.ParameterName = "@Taxonomydesc"; paramTaxdesc.DbType = DbType.String; paramTaxdesc.Value = tax.Taxonomydesc; return(SQLDBHelper.ExecuteNonQuery("proc_Insert_Tax", paramTaxName, paramTaxdesc)); }
/// <summary> /// 注册 /// </summary> /// <param name="Admin">接收Admin类</param> /// <returns>返回是否注册成功</returns> public static bool Register(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; return(SQLDBHelper.ExecuteNonQuery("proc_Register", paramAdminName, paramAdminPwd)); }
/// <summary> /// 改 /// </summary> /// <param name="tax"></param> /// <returns></returns> public static bool updateTax(Taxonomy_M tax) { SqlParameter paramTaxName = new SqlParameter(); paramTaxName.ParameterName = "@TaxonomyName"; paramTaxName.DbType = DbType.String; paramTaxName.Value = tax.TaxonomyName; SqlParameter paramTaxdesc = new SqlParameter(); paramTaxdesc.ParameterName = "@Taxonomydesc"; paramTaxdesc.DbType = DbType.String; paramTaxdesc.Value = tax.Taxonomydesc; SqlParameter paramTaxId = new SqlParameter(); paramTaxId.ParameterName = "@TaxonomyId"; paramTaxId.DbType = DbType.String; paramTaxId.Value = tax.TaxonomyId; return(SQLDBHelper.ExecuteNonQuery("proc_Update_Tax", paramTaxName, paramTaxdesc, paramTaxId)); }
/// <summary> /// 添加帖子 /// </summary> /// <param name="post">接收类</param> /// <returns>返回影响行数是否大于0</returns> public static bool addPost(Posts_M post) { SqlParameter paramTaxID = new SqlParameter(); paramTaxID.ParameterName = "@TaxonomyId"; paramTaxID.DbType = DbType.String; paramTaxID.Value = post.TaxonomyId; SqlParameter paramTitle = new SqlParameter(); paramTitle.ParameterName = "@Title"; paramTitle.DbType = DbType.String; paramTitle.Value = post.Title; SqlParameter paramPost = new SqlParameter(); paramPost.ParameterName = "@Post"; paramPost.DbType = DbType.String; paramPost.Value = post.Post; return(SQLDBHelper.ExecuteNonQuery("proc_Insert_Post", paramTaxID, paramTitle, paramPost)); }
/// <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); }
/// <summary> /// 删 /// </summary> /// <param name="commentid">接收评论id</param> /// <returns>返回是否删除成功</returns> public static bool delcomment(string commentid) { string sql = "delete from Comments where CommentId=" + commentid; return(SQLDBHelper.ExecuteNonQuery(sql)); }
/// <summary> /// 根据帖子ID查评论数 /// </summary> /// <param name="postId">接收帖子ID</param> /// <returns>返回评论数</returns> public static int commentCountByPostID(string postId) { string sql = "select count(*) from Comments where PostId=" + postId; return(SQLDBHelper.ExecuteScalar(sql)); }
/// <summary> /// 所有评论数 /// </summary> /// <returns>返回评论数</returns> public static int commentCount() { string sql = "select count(*) from Comments"; return(SQLDBHelper.ExecuteScalar(sql)); }
/// <summary> /// 所有类型数 /// </summary> /// <returns>返回数量</returns> public static int TaxCount() { string sql = "select count(*) from Taxonomy"; return(SQLDBHelper.ExecuteScalar(sql)); }
/// <summary> /// 根据帖子ID删除 /// </summary> /// <param name="postID">接收帖子ID</param> /// <returns>返回是否删除成功</returns> public static bool delBypostId(string postID) { string sql = "delete from Posts where PostId=" + postID; return(SQLDBHelper.ExecuteNonQuery(sql)); }
/// <summary> /// 删 /// </summary> /// <param name="taxId"></param> /// <returns></returns> public static bool delTax(string taxId) { string sql = "delete from Taxonomy where TaxonomyId=" + taxId; return(SQLDBHelper.ExecuteNonQuery(sql)); }