using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Core.LZMes.Client.UIL
{
    public class DBManager
    {
        public static System.Data.DataSet GetDataSet(string LogName, string WinServer, string SQL, string TableName, System.Data.OleDb.OleDbConnection Conn)
        {
            if (Conn == null)
                return null;
            System.Data.DataSet rtndst = new System.Data.DataSet();
            System.Data.OleDb.OleDbDataAdapter DataAdapter = new System.Data.OleDb.OleDbDataAdapter(SQL, Conn);
            DataAdapter.Fill(rtndst);
            rtndst.AcceptChanges();
            rtndst.Tables[0].TableName = TableName;
            DataAdapter.Dispose();
            return rtndst;

        }
        public static bool ExecuteDB(string LogName, string WinServer, string SQL, System.Data.OleDb.OleDbConnection Conn)
        {
            try
            {
                if (Conn == null)
                    return false;
                System.Data.OleDb.OleDbCommand Command = new System.Data.OleDb.OleDbCommand(SQL, Conn);
                Command.ExecuteNonQuery();
                Command.Dispose();
                return true;
            }
            catch (System.Exception ex)
            {
                //ELog.Log(LogName,WinServer,ex.ToString(),System.Diagnostics.EventLogEntryType.Error);
                System.Diagnostics.EventLog.WriteEntry(LogName, WinServer + ex.ToString(), System.Diagnostics.EventLogEntryType.Error);
                return false;
            }
        }
    }
}