db.cs

用Visual C#.net开发企业材料采购管理系统数据库使用的是SqlServer2000

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient; 
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
//定义要操作的命名空间//
namespace  WebApplication5
{
	/// <summary>
	/// Class1 的摘要说明。
	/// 定义要操作的类名DataBase///
	/// 数据库类DataBase的基类为Page
	/// </summary>
	public class DataBase:Page
	{
		 
		 public SqlConnection conn; 
		 public SqlDataAdapter sda;
		 public DataSet ds;
		 public SqlCommand cmd;
		 public SqlDataReader sdr; 
		 
		 //连接数据库///
		 public void OpenConn()
		 {
              conn=new SqlConnection("server=200.200.200.1;Uid=sa;Pwd=;Database=gycdatabase");       
			  conn.Open(); 
		 }
		 /// <summary>
		 ///关闭连接//
		 /// </summary>
		 public void CloseConn()
		 {
              if (conn!=null)
				  conn.Close(); 
		 }
		ICollection CreateDataSource(string strsql,string TableName)
		{
			OpenConn(); 
			sda=new SqlDataAdapter(strsql,conn);
			ds=new DataSet();
			sda.Fill(ds,TableName);
			return ds.Tables[TableName].DefaultView;
		}
		/// <summary>
		/// 执行不返回结果集的查询动作
		/// </summary>
		/// <param name="strSql">sql语句(Insert,delete,update)</param>
		/// <param name="conn">连接对象</param>
		/// <returns></returns>
		public string runNonSql(string strSql)
    
		{
			OpenConn(); 
			string errorstr=null;
			cmd=new SqlCommand(strSql,conn);
			//if (cmd.Connection.State.ToString()=="Open") cmd.Connection.Close();
			//cmd.Connection.Open();
			try
			{
				cmd.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
				if (ex!=null) errorstr=ex.ToString();
			}
			CloseConn();
			return errorstr;
		}
		/// <summary>
		/// 数据绑定控制
		/// </summary>
		/// <param name="ctrl">控件ID名</param>
		/// <param name="strSql">查询的sql语句(select * from list)</param>
		/// <param name="TableName">表名</param>
		public void BindData( Control ctrl,string strSql,string TableName)
		{
			OpenConn(); 
			
			if (ctrl is DataGrid)
			{
				((DataGrid)ctrl).DataSource=CreateDataSource(strSql,TableName);
				((DataGrid)ctrl).DataBind(); 
			}
			if (ctrl is DataList)
			{
				((DataList)ctrl).DataSource=CreateDataSource(strSql,TableName);
				((DataList)ctrl).DataBind(); 
			}
			if (ctrl is  Repeater)
			{
				((Repeater)ctrl).DataSource=CreateDataSource(strSql,TableName);
				((Repeater)ctrl).DataBind(); 
			}

		}
		/// <summary>
		/// 将指定控件数据源绑定到某个表的某个字段上
		/// </summary>
		/// <param name="ctrl">控件的ID名</param>
		/// <param name="strSql">sql语句</param>
		/// <param name="TableName">表名</param>
		/// <param name="FieldName">表中的某个字段名</param>
		public void BindData( Control ctrl,string strSql,string TableName,string FieldName)
		{
			OpenConn();
			if (ctrl is DropDownList)
			{
				((DropDownList)ctrl).DataSource=CreateDataSource(strSql,TableName);
				
				((DropDownList)ctrl).DataTextField=FieldName;
				((DropDownList)ctrl).DataBind();
			    
			}
			if (ctrl is ListBox)
			{
				((ListBox)ctrl).DataSource=CreateDataSource(strSql,TableName);
				
                ((ListBox)ctrl).DataTextField=FieldName;
				((ListBox)ctrl).DataBind();
			} 
		}
        /////取得指定表的记录数//
        ///参数TableName为表名
        ///
		public int GetResultCount(string TableName)
		{
			 OpenConn();
			 string strSql;
			 int RecordCount;
			 strSql="SELECT COUNT(*) FROM  "+TableName; 
			 cmd=new SqlCommand(strSql,conn);
			 RecordCount=(int)cmd.ExecuteScalar();
			 CloseConn();
			 return RecordCount;
			 
		}
		/// <summary>
		/// 查找指定ID值的记录是否存在
		/// </summary>
		/// <param name="strID"></param>
		/// <returns></returns>
		public bool FindID(string TableName,int strID)
		{
			OpenConn();
            string strSql;
			string str_ID=Convert.ToString(strID); 
			strSql="SELECT * FROM  "+TableName+"   where  c_id="+(str_ID).Trim();
			cmd=new SqlCommand(strSql,conn);
			SqlDataReader sdr=null;
			sdr=cmd.ExecuteReader();
			if (sdr.Read())
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		/// <summary>
		/// 定义一个返回数据集的函数
		/// </summary>
		/// <param name="strSql">sql查询语句</param>
		/// <returns>结果0返回数据集对象</returns>
		public DataSet GetDS(string strSql)
		{
			 OpenConn();
			 sda=new SqlDataAdapter(strSql,conn);
			 ds=new DataSet();
			 sda.Fill(ds);
			 return ds;
		}
		/// <summary>
		/// /定义返回reader数据集的函数定义//
		/// </summary>
		/// <param name="strSql"></param>
		/// <returns></returns>
		public SqlDataReader RunSqlReader(string strSql)
		{
			OpenConn();
			cmd=new SqlCommand(strSql,conn);
			sdr=cmd.ExecuteReader();
			
			return sdr;

		}
		public ArrayList GetFieldValue(string strSql)
		{
			ArrayList FieldList=new ArrayList();
			SqlDataReader sd=RunSqlReader(strSql);
			while  (sd.Read())
			{
				 FieldList.Add(sd["c_provider"]); 

			}
			return FieldList;
		}
        /// <summary>
        /// 定义显示提示信息的对话框///
        /// </summary>
        /// <param name="strMessage">为提示信息</param>
        /// <param name="Page">Page类</param>
		public void ShowMessage(string strMessage,Page Page)
		{
			  Page.RegisterStartupScript("","<script>alert('"+strMessage+"');</script>"); 
		}
		/// <summary>
		/// 得到检测框所对应的记录的唯一值
		/// </summary>chk是CheckBox的ID值
		/// <returns></returns>
		public ArrayList GetChecked(string chk,DataGrid DataGrid1)
		{
			ArrayList saveID=new ArrayList();
			CheckBox isChecked;
			foreach(DataGridItem dataitem in DataGrid1.Items)
			{
				isChecked=(CheckBox)dataitem.FindControl(chk);
				if (isChecked.Checked==true)
				{
					string idValue=dataitem.Cells[1].Text;
					saveID.Add(idValue); 
				}
				
			}
														
			return saveID;
		}
		/// <summary>
		/// 为控件增加事件,以及显示的消息
		/// </summary>
		/// <param name="strMessage">消息字符串</param>
		/// <param name="ctrl">控件ID值</param>
		/// <param name="EventName">所要增加的事件名</param>
		public void AddEvent(string strMessage,Control ctrl,string EventName)
        {
			if (ctrl is ImageButton)
			{
				((ImageButton)ctrl).Attributes.Add(EventName,"return confirm('"+strMessage+"');");  
			}
			if (ctrl is Button)
			{
				((Button)ctrl).Attributes.Add(EventName,"return confirm('"+strMessage+"');");  
			}
			if (ctrl is CheckBox)
			{
				((CheckBox)ctrl).Attributes.Add(EventName,"return confirm('"+strMessage+"');");  
			}

		}

	}/////定义类结束

}////定义命名空间结束