database.cs

文章的浏览以及后台中文章的添加、修改、删除等操作

using System;
using System.Data;
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;
using System.Configuration;
using System.Web.Configuration;


/// <summary>
/// DataBase 的摘要说明
/// </summary>
public class DataBase
{
	public DataBase()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

   // public string ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
  protected  string ConnectionString = "Data Source=(local);Initial Catalog=Article;User ID=Sa;Password=";
  

    public string  GetConnectstring()
    {
        return ConnectionString;
    }

    public DataSet BindGrid(string table, string col, string condition, string orderby)
    {

        //函数参数：表名，列名，条件，排序方法
        //如："article", "top 8 newsid, title,time","where id>'20'", " order by time desc"
        //
        string Sql = "select ";
        Sql += col;
        Sql += " from " + table;
        Sql += " " + condition;
        Sql += " " + orderby;

        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConnectionString;

        SqlDataAdapter Da = new SqlDataAdapter(Sql, conn);
        DataSet Ds = new DataSet();
        try
        {
            conn.Open();
            Da.Fill(Ds, "Table");
            return Ds;

        }
        catch (Exception )
        {
              return null;

        }
        finally
        {
            conn.Close();
        }

    }

    public string InsertData(string Table, string InsertString) 
    {       
        //调用说明：        
        String Sql = "Insert into " + Table + InsertString;
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConnectionString;
        SqlCommand cmd = new SqlCommand(Sql, conn);
        try
        {
            conn.Open();
            cmd.ExecuteNonQuery();
            return "数据提交成功!";
        }
        catch (Exception Ex)
        {
            return "数据提交失败!<br>错误信息：" + Ex.Message.ToString();

        }
        finally
        {
            conn.Close();
        }
    }

    public string DeleteData(string Table, string Condition)
    {

        //调用说明：输入删除数据的表名，删除条件
        //如:"article", "where id='5'"
        //
        if (Condition =="")
        {
            return "数据删除失败!<br>错误信息：不允许删除数据!";
        }
        String Sql = "Delete from " + Table +" "+ Condition;

        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConnectionString;
        SqlCommand cmd = new SqlCommand(Sql, conn);
        try
        {
            conn.Open();
            cmd.ExecuteNonQuery();
            return "数据删除成功!";
        }
        catch (Exception Ex)
        {
            return "数据删除失败!<br>错误信息：" + Ex.Message.ToString();

        }
        finally
        {
            conn.Close();
        }
    }

    public string UpdateData(string Table, string Col_Val, string Condition)
    {
        //调用说明：输入修改数据的表名，修改数据的字段及值
        //如:"article", "title='测试',wzpath='zxzs'","where id='5'"
        //
        string Sql = "Update " + Table + " set " + Col_Val + " " + Condition;

        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConnectionString;
        SqlCommand cmd = new SqlCommand(Sql, conn);
        try
        {
            conn.Open();
            cmd.ExecuteNonQuery();
            return "数据修改成功!";
        }
        catch (Exception Ex)
        {
            return "数据修改失败!<br>错误信息：" + Ex.Message.ToString();

        }
        finally
        {
            conn.Close();
        }
    }

    public void GetDepart(TreeNode Tnode, Label Lbl)
    {
        if (Tnode.Parent != null)
        {
            Lbl.Text = Tnode.Text + "<font color=red>→</font>" + Lbl.Text;
            GetDepart(Tnode.Parent, Lbl);
        }
        else
        {
            Lbl.Text = Tnode.Text + "<font color=red>→</font>" + Lbl.Text;
        }
    }
}