using System;
using System.Data;
using System.Configuration;
using System.Data.OleDb;
using System.IO;
using System.Runtime.InteropServices;

namespace UpdateProduce
{



    /// <summary>
    /// DBClass 的摘要說明
    /// </summary>
    public class DBClass
    {
        public DBClass()
        {
            //
            // TODO: 在此處添加構造函數(shù)邏輯
            //
        }
        private OleDbConnection conn;

        #region 數(shù)據(jù)庫連接

        /// <summary>
        ///獲得數(shù)據(jù)庫連接
        /// </summary>
        /// <returns>SqlConnection對象</returns>
        public OleDbConnection GetConn()
        {
            conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:/3d/data.mdb;" );
            return conn;

        }
        #endregion

        #region 數(shù)據(jù)集
        /// <summary>
        /// 數(shù)據(jù)集
        /// </summary>
        /// <param name="mysql">Sql語句</param>
        /// <param name="name">表名稱</param>
        /// <param name="option_flag">配置標識符</param>
        /// <returns></returns>
        public DataSet MyDBSet(string mysql, string name)
        {
            using (OleDbConnection con = this.GetConn())
            {
                try
                {
                    con.Open();
                    OleDbDataAdapter da = new OleDbDataAdapter(mysql, con);
                    DataSet ds = new DataSet();
                    da.Fill(ds, name);
                    return (ds);
                }
                catch
                {
                    return (null);
                }
            }
        }

        #endregion

        #region 刪除數(shù)據(jù)
        /// <summary>
        /// 刪除數(shù)據(jù)
        /// </summary>
        /// <param name="tablename">表名</param>
        /// <param name="term">條件</param>
        /// <returns></returns>
        public bool delete(string tablename, string term)
        {
            string sql = "delete " + tablename + " where " + term;
            using (OleDbConnection con = this.GetConn())
            {
                OleDbCommand com = new OleDbCommand(sql, con);
                try
                {
                    con.Open();
                    com.ExecuteNonQuery();
                    com.Connection.Close();
                    return true;
                }
                catch
                {
                    com.Connection.Close();
                    return false;
                }
            }
        }
        #endregion
    }

}