/*************************************************************************************************************
 * 功能：數(shù)據(jù)庫(kù)操作相關(guān)
 * 作者：flashicp
 * 時(shí)間：2005-7-22
 * **********************************************************************************************************/
using system;
using system.data;
using system.data.sqlclient;
using system.web;
namespace moban
{
 public class data
 {
  protected static string con="server=[yourserver];database=[yourdata];user id=[your id];password=[youpassword]";
  //數(shù)據(jù)庫(kù)字符串
  protected system.data.sqlclient.sqlconnection dataconnection;
  //數(shù)據(jù)庫(kù)連接對(duì)象
  protected system.data.sqlclient.sqldataadapter dataadapter;
  //sqldataadapter對(duì)象
  protected system.data.sqlclient.sqlcommand datacommand;
  //sqlcommand對(duì)象
  protected system.data.sqlclient.sqlcommandbuilder datacombuilder;
  //sqlcommandbuilder對(duì)象
  protected system.data.dataset dataset;
  //dataset對(duì)象
  protected system.data.datarow datarow;
  //datarow對(duì)象
  protected system.data.sqlclient.sqldatareader datareader=null;
  //構(gòu)造函數(shù)
  public data()
  {
   dataconnection=dataconn();
   
  }
  //連接數(shù)據(jù)庫(kù)參數(shù)
  public string con
  {
   
   get{return con;}
   set{con= value;}
   
  }
  //數(shù)據(jù)庫(kù)連接參數(shù)
  public sqlconnection dataconn()
  {
   dataconnection=new sqlconnection(con); 
   return dataconnection;
   
  }
  //返回?cái)?shù)據(jù)庫(kù)連接對(duì)象
  public sqldatareader dataquery(string sql)
  {
   sql=sql.replace("--","");
   sql=sql.replace(";","");
   dataconnection=dataconn();
   dataconnection.open();
   datareader=null;
   datacommand=new sqlcommand(sql,dataconnection);
   datareader=datacommand.executereader();
   datacommand.dispose();
   return datareader;
  }
  //返回dataset
  public virtual dataset datasetquery(string sql,string tablename)
  {
   dataconnection=dataconn();
   dataadapter=new sqldataadapter(sql,dataconnection);
   dataset=new dataset();
   dataadapter.fill(dataset,tablename);
   dataadapter.dispose();
   dataconnection.close();
   dataconnection.dispose();
   return dataset;
  }
  //返回dataset
  public dataset datasetquery(dataset myds,string tablename,string sql)
  {
   dataconnection=dataconn();
   dataadapter=new sqldataadapter(sql,dataconnection);
   dataadapter.fill(myds,tablename);
   dataconnection.close();
   dataconnection.dispose();
   return dataset;

  }
  //返回dataset
  public dataset datasetquery(string sql,string tablename,int starindex,int count)
  {
   dataconnection=dataconn();
   dataconnection.open();
   dataadapter=new sqldataadapter(sql,dataconnection);
   dataset=new dataset();
   dataadapter.fill(dataset,starindex,count,tablename);
   dataconnection.close();
   dataconnection.dispose();
   return dataset;
  }
  public void datado(string sqlstr)
  {  
   dataconnection=dataconn();
   sqlcommand mycom=dataconnection.createcommand();
   mycom.commandtext=sqlstr;
   dataconnection.open();
   mycom.executenonquery();
   dataconnection.close();
  }
  //返回dataset 開始行到結(jié)束行
  public bool editdata(string sql)
  {
   dataconnection=dataconn();
   dataconnection.open();
   datacommand=new sqlcommand(sql,dataconnection);
   try
   {
    datacommand.executenonquery();
    dataconnection.close();
    return true;
   }
   catch(exception ex)
   { 
    system.console.write(ex.message.tostring());
    dataconnection.close();
    return false;
   }
  }
  //執(zhí)行成功返回真,否則返回假．
  public object executescalar(string sql)
  {
   dataconnection=dataconn();
   dataconnection.open();
   datacommand=new sqlcommand(sql,dataconnection);
   try
   {
    object back = datacommand.executescalar();
    dataconnection.close();
    return back;
   }
   catch(exception ex)
   { 
    system.console.write(ex.message.tostring());
    dataconnection.close();
    return null;
   }
  }
  //返回一個(gè)值的查詢語句
  public dataset editdata(dataset dataset,sqldataadapter myda,string tablename)
  {
    
   
   datacombuilder=new sqlcommandbuilder(myda);
   myda.updatecommand=datacombuilder.getupdatecommand();
   myda.deletecommand=datacombuilder.getdeletecommand();
   myda.insertcommand=datacombuilder.getinsertcommand();
   myda.update(dataset,tablename);
   dataset.acceptchanges();
   this.closeconnection();
   return dataset;
  }
  //修改dataset 并且修改數(shù)據(jù)庫(kù)值存儲(chǔ)過程
  public bool dataprocedure(string procedurename)
  {
   dataconnection=dataconn();
   dataconnection.open();
   datacommand=new sqlcommand();
   datacommand.commandtext=procedurename;
   datacommand.connection=dataconnection;
   
     
   datacommand.commandtype=system.data.commandtype.storedprocedure;
   try
   {
    datacommand.executenonquery();
    return true;
   }
   catch(exception ex)
   { 
    system.console.write(ex.message.tostring());
    return false;
   }
  }
  
  //無參數(shù)存儲(chǔ)過程的執(zhí)行　返回執(zhí)行真假
  public void closeconnection()
  {
   if(datareader!=null)
   {
    datareader.close();
    datareader=null;

   }
   dataconnection.close();
   dataconnection.dispose();
  }
  //關(guān)閉連接
 

 }
}