main1

[tieuquyngok1995]

using System; using System.Data.SqlClient; using System.Windows.Forms; using System.Configuration; using System.Data; using System.Collections.Generic; using System.Linq; using System.Text.RegularExpressions; using ToolDatabase.Utils; using ToolDatabase.Model;

namespace ToolDatabase.View { public partial class Main : Form { SQLConnection con; public SqlConnection SqlConnection;

    private DataTable dataSQL = new DataTable();
    private DataTable dataParam = new DataTable();
    private DataRow row;

    private Dictionary<string, List<string>> lstDic = new Dictionary<string, List<string>>();
    private Dictionary<string, string> lstDicParam = new Dictionary<string, string>();
    private List<string> lstParam = new List<string>();

    private string strSQLChar = string.Empty;
    private string strInputSQL = string.Empty;

    private bool statusConnection = false;

    private int numSelectCase = 0;

    #region Main
    public Main()
    {
        InitializeComponent();
    }

    private void settingToolStripMenuItem_Click(object sender, EventArgs e)
    {
        Setting frmSetting = new Setting();

        //frmSetting.ShowDialog();
        //frmSetting.Dispose();

        if (frmSetting.DialogResult == DialogResult.OK)
        {
            SqlConnection = frmSetting.SqlConnection;
            if (SqlConnection != null && SqlConnection.State.Equals(System.Data.ConnectionState.Open))
            {
                statusConnection = true;
                btnExcute.Enabled = true;
                txtStatus.Text = string.Format(CONSTANTS.CONST_STRING_STATUS, CONSTANTS.CONST_STRING_STATUS_CONNECTION);
            }
            else
            {
                statusConnection = false;
                btnExcute.Enabled = false;
                txtStatus.Text = string.Format(CONSTANTS.CONST_STRING_STATUS, CONSTANTS.CONST_STRING_STATUS_DISCONNECT);
            }
        }
    }

    private void Main_Load(object sender, EventArgs e)
    {
        //txtStatus.Text = CheckIsConnection()
        //    ? string.Format(CONSTANTS.CONST_STRING_STATUS, CONSTANTS.CONST_STRING_STATUS_CONNECTION)
        //    : string.Format(CONSTANTS.CONST_STRING_STATUS, CONSTANTS.CONST_STRING_STATUS_DISCONNECT);
        txtStatus.Text = string.Format(CONSTANTS.CONST_STRING_STATUS, CONSTANTS.CONST_STRING_STATUS_CONNECTION);

        // load data input sql
        dataSQL.Columns.Add(CONSTANTS.CONST_STRING_COLUMNS_ID);
        dataSQL.Columns.Add(CONSTANTS.CONST_STRING_COLUMNS_SQL);

        // load data input param
        dataParam.Columns.Add(CONSTANTS.CONST_STRING_COLUMNS_PARAM);
        dataParam.Columns.Add(CONSTANTS.CONST_STRING_COLUMNS_VALUE);

        txtSQLChar.Text = ConfigurationManager.AppSettings[CONSTANTS.CONST_STRING_SQL_CHAR];
        btnConvert.Enabled = false;
        btnExcute.Enabled = false;
    }

    private void Main_Shown(object sender, EventArgs e)
    {
        if (statusConnection) return;

        Setting frmSetting = new Setting();

        //frmSetting.ShowDialog();
        //frmSetting.Dispose();

        if (frmSetting.DialogResult == DialogResult.OK)
        {
            SqlConnection = frmSetting.SqlConnection;
            if (SqlConnection != null && SqlConnection.State.Equals(System.Data.ConnectionState.Open))
            {
                statusConnection = true;