2008/04/16 一个表的操作类

private void btnClose_Click(object sender, System.EventArgs e)
  {
   pnlSearch.Hide();
  }

  private void btnSearch_Click(object sender, System.EventArgs e)
  {
   pnlSearch.Show();
  }

  private void frmList_Load(object sender, System.EventArgs e)
  {
       
   Cname = new string[50];
   Fname = new string[50];
   Ftype = new string[50];
   initControl();
  
  }

  private void initControl()
  {
   connect = new SqlConnection(ComString.ConnectS);
   DisplayDataSet = new DataSetFSYH();

  }

  public void DataLoading()
  {
   this.DaList=new SqlDataAdapter(cmdtxt,connect);
   _SqlCommandBuilder = new SqlCommandBuilder(DaList);
   DaList.Fill(DisplayDataSet, TableName);

   dvm = new DataViewManager(DisplayDataSet);

   BindingControl();
  }

  private void BindingControl()
  {
   m_dataGrid.DataSource=DisplayDataSet.Tables[0].DefaultView;
   vmlist=this.BindingContext[m_dataGrid.DataSource];

  }

  /// <summary>
  ///  顯示的Table 
  /// </summary>
  private static DataSet _DisplayTable;

  public static DataSet DisplayTable
  {
   set
   {
    _DisplayTable = value;
   }
   get
   {
    return _DisplayTable;
   }
  }

  private static string _tablename;

  public string TableName
  {
   set
   {
    _tablename = value;
   }
   get
   {
    return _tablename;
   }
  }

 

  /// <summary>
  ///   執行的Sql Command
  /// </summary>
  private static string _cmdtxt;

  public  string cmdtxt
  {
   set
   {
    _cmdtxt = value;
   }
   get
   {
    return _cmdtxt;
   }
  }

  /// <summary>
  /// 設定窗體的DataSource 
  /// </summary>
  
  public DataSet DataSource
  {
   set
   {
    m_dataGrid.DataSource = value;
   }
   
  }

  /// <summary>
  ///  顯示的DataSet 
  /// </summary>
  private static DataSet _DisplayDataSet;

  public static DataSet DisplayDataSet
  {
   set
   {
    _DisplayDataSet = value;
   }
   get
   {
    return _DisplayDataSet;
   }
  }

  

  private void btnAdd_Click(object sender, System.EventArgs e)
  {
   
  
  }

  

  private void btnSave_Click(object sender, System.EventArgs e)
  {
     ComFun.saveDB(DaList, DisplayDataSet, DisplayDataSet.Tables[0].TableName);
  }

  

  private void btnChange_Click(object sender, System.EventArgs e)
  {

   ComFun.dbDown(vmlist);
   ComFun.saveDB(DaList,DisplayDataSet, DisplayDataSet.Tables[0].TableName);
  
  }

  private void btnDelete_Click(object sender, System.EventArgs e)
  {
   DisplayDataSet.Tables[0].DefaultView.Delete(vmlist.Position);
   ComFun.saveDB(DaList, DisplayDataSet, DisplayDataSet.Tables[0].TableName);
  }