using System;
using System.Data;
using MySql.Data.MySqlClient;

namespace Cyberpipe
{
    class MySqlHelper
    {
        public static DataTable queryDataTable(string sql)
        {
            string connSql = Utility.sensorConnectString;// "Server=222.128.120.176;Port=3306;Database=pc_dlog_dma;Uid=spaceTest;Pwd=123";
            DataTable dt = new DataTable();
            MySqlDataReader reader = null;
            MySqlConnection conn = null;
            try
            {
                conn = new MySqlConnection(connSql);
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                conn.Open();
                reader = cmd.ExecuteReader();
                dt.Load(reader);
            }
            catch (Exception e)
            {
                LogError.PublishError(e);
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                }
                if (conn != null)
                {
                    conn.Close();
                }
            }
            return dt;
        }
    }
}