data.cs

毕业设计内容： 1、 作者投稿功能 2、 专家审稿 3、 系统管理员对所有稿件的管理功能 管理权限设置:分为三级权限。包括用户:添加文章、查询自己稿件的审稿情况、审稿意见、查看个人资料等 专家:审批文

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;
/// <summary>
/// Data 的摘要说明
/// </summary>
public class Data
{
        private readonly string SqlConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConStr"];
        private  SqlConnection con;
        private  SqlCommand cmd;
        private  SqlDataAdapter sda;
        private SqlDataReader sdr;
        private DataSet ds;
        private DataView dv;
 
        /// <summary>
        /// 打开数据库连接
        /// </summary>
        public void OpenDataBase()
        {
            con = new SqlConnection(SqlConnectionString);
            con.Open();
        }
        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        public void CloseDataBase()
        {
            if (con != null)
            {
                con.Close();
                con.Dispose();
            }
        }
        /// <summary>
        /// 返回DataSet数据集
        /// </summary>
        /// <param name="SqlStr">数据库查询字符串</param>
        /// <returns>dataset</returns>
        public void  GetDs(string SqlStr,string TableName)
        {
            OpenDataBase();
            sda = new SqlDataAdapter(SqlStr,con);
            ds = new DataSet();
            sda.Fill(ds,TableName);
            CloseDataBase();
     
        }
        public DataView GetDv(string SqlStr)
        {
            OpenDataBase();
            sda = new SqlDataAdapter(SqlStr,con);
            ds = new DataSet();
            sda.Fill(ds);
            dv=ds.Tables[0].DefaultView;
            return dv;
        
        }
      /// <summary>
      /// 返回Datareader对象
      /// </summary>
      /// <param name="Sqlstr">查询字符串</param>
      /// <returns>返回值</returns>
        public SqlDataReader GetDataReader(string Sqlstr)
        {
            OpenDataBase();
            cmd = new SqlCommand(Sqlstr,con);
            sdr=cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
          
            return sdr;
        
        }
        /// <summary>
        /// 执行Sql语句方法没有返回值
        /// </summary>
        /// <param name="SqlStr">传入的查询参数</param>
        public void RunSql(string SqlStr)
        {
            OpenDataBase();
            cmd = new SqlCommand(SqlStr,con);
            cmd.ExecuteNonQuery();
            CloseDataBase();
        }
        /// <summary>
        /// 返回查询结果的首行首列
        /// </summary>
        /// <param name="SqlStr">查询字符串</param>
        /// <returns>返回结果</returns>
        public string ReturnSql(string SqlStr)
        {
            OpenDataBase();
            string ReturnSql = "";
            try
            {
                cmd = new SqlCommand(SqlStr, con);
                ReturnSql = cmd.ExecuteScalar().ToString();
            }
            catch { }
            CloseDataBase();
            return ReturnSql;
        }
     

        


        public object GetDs(string p)
        {
            throw new Exception("The method or operation is not implemented.");
        }
    }