?using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

namespace LixyNews.Sql
{
    /// <summary>
    /// 本類是方便對新聞系統(tǒng)的數(shù)據(jù)庫進(jìn)行操作，為了使用時(shí)方便，特寫了這樣一個(gè)類，以方便大家慢慢養(yǎng)成面向?qū)ο缶幊痰牧?xí)慣。    李錫遠(yuǎn) 寫
    /// </summary>
    public class AdoSql     
    {
        public AdoSql()
        {
            //
            // TODO: 在此處添加構(gòu)造函數(shù)邏輯
            //
        }

        /// <summary>
        ///  執(zhí)行SQL語句－讀      李錫遠(yuǎn) 寫
        /// </summary>
        /// <param name="SqlString">SQL語句</param>
        /// <returns></returns>
        public DataTable ExecuteSqlRead(string SqlString)      
        {
            SqlCommand SqlCmd = new SqlCommand();
            SqlCmd.Connection = new SqlConnection(ConfigurationSettings.AppSettings["ConnString"]);
            SqlCmd.CommandText = SqlString;
            SqlCmd.CommandType = CommandType.Text;
            SqlDataAdapter SqlAd = new SqlDataAdapter(SqlCmd);
            DataSet Rs = new DataSet();
            SqlAd.Fill(Rs);
            return Rs.Tables[0];
        }

        /// <summary>
        /// 執(zhí)行SQL語句－寫     李錫遠(yuǎn) 寫
        /// </summary>
        /// <param name="SqlString">SQL語句</param>
        /// <returns></returns>
        public Boolean ExecuteSqlWrite(string SqlString)        
        {
            SqlCommand SqlCmd = new SqlCommand();
            SqlCmd.Connection = new SqlConnection(ConfigurationSettings.AppSettings["ConnString"]);
            SqlCmd.CommandText = SqlString;
            SqlCmd.CommandType = CommandType.Text;
            SqlCmd.Connection.Open();
            SqlCmd.ExecuteNonQuery();
            SqlCmd.Connection.Close();
            return true;

        }

        /// <summary>
        /// 讀取新聞系統(tǒng)的數(shù)據(jù)列表
        /// </summary>
        /// <returns></returns>
        public DataTable ReadAllNews()        
        {
            string SqlString = "select NewsID,NameStr,NewsType,TitleStr,DateTimeTxt,VisitInt from NewsTxt order by NewsID desc";
            return ExecuteSqlRead(SqlString);

        }

        /// <summary>
        /// 讀取新聞分類
        /// </summary>
        /// <returns></returns>
        public DataTable ReadAllType()      
        {
            String SqlString = "select NewsType from NewsType";
            return ExecuteSqlRead(SqlString);
        }


        /// <summary>
        /// 發(fā)布新聞
        /// </summary>
        /// <param name="NewsType"></param>
        /// <param name="TitleStr"></param>
        /// <param name="NameStr"></param>
        /// <param name="ContentTxt"></param>
        public void AddNews(string NewsType, string TitleStr, string NameStr, string ContentTxt)       
        {
            int n = 0;      //初始化訪問次數(shù)為0
            String SqlString = "insert NewsTxt (NameStr,NewsType,TitleStr,ContentTxt,DateTimeTxt,VisitInt) values ('" + NameStr + "','" + NewsType + "','" + TitleStr + "','" + ContentTxt + "','" + DateTime.Now + "','" + n + "')";
            ExecuteSqlWrite(SqlString);

        }


        /// <summary>
        /// 驗(yàn)證登陸    
        /// </summary>
        /// <param name="UserNameStr"></param>
        /// <param name="PassWordStr"></param>
        public static Boolean LoginCheck(string UserNameStr, string PassWordStr)        
        {

            string SqlString = "select UserNameStr,PassWordStr from MUser where UserNameStr='" + UserNameStr + "'and PassWordStr='" + PassWordStr + "'";
            SqlConnection SqlConn = new SqlConnection(ConfigurationSettings.AppSettings["ConnString"]);
            SqlCommand SqlCmd = new SqlCommand(SqlString, SqlConn);
            SqlConn.Open();

            SqlDataReader SqlReader = SqlCmd.ExecuteReader();
            Boolean FindUser = false;
            while (SqlReader.Read())
            {
                FindUser = true;

            }

            if (FindUser)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        public DataTable ReadNewsByID(int NewsID)
        {
            string SqlString = "select NameStr,TitleStr,ContentTxt,DateTimeTxt,VisitInt from NewsTxt where NewsID=" + NewsID;
            return ExecuteSqlRead(SqlString);

        }

        public void SetCount(int NewsID)
        {
            string SqlString = "update NewsTxt set VisitInt=VisitInt+1 where NewsId=" + NewsID;
            ExecuteSqlWrite(SqlString);
        }

        public void UpdateNews(string TitleStr, string ContentTxt, int NewsID)
        {
            String SqlString = "Update NewsTxt set TitleStr='" + TitleStr + "',ContentTxt='" + ContentTxt + "' where NewsID=" + NewsID;
            ExecuteSqlWrite(SqlString);

        }

  
    }
    }