using HotelPms.Share.Data;
using HotelPms.Share.Util;
using HotelPms.Share.Windows.Util;
using System;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Drawing;
using System.Windows.Forms;


namespace HotelPms.Share.Windows.Tool
{
    public partial class MstList : Form
    {
        /// ****************************** Description *******************************
        /// žƒVƒXƒeƒ€–¼Ì
        /// @—\–ñƒZƒ“ƒ^[ŠÇ—ƒVƒXƒeƒ€
        /// žŠT—v
        /// @ˆê——‘I‘ð‰æ–Ê
        /// ž—š—ð
        /// @20090126 vic V‹Kì¬
        /// ****************************** Declarations ******************************

        #region  ššššš@Declartions@ššššš

        [Flags]
        public enum Style : int
        {
            None = 0x1,
            HideBottom = 0x2,
            HideReturnField = 0x4,
            HideGridHeader = 0x8,
        }


        private bool isReturnRow = false;

        public bool IsReturnRow
        {
            set { isReturnRow = value; }
        }

        private DataGridViewRow m_CurrentRow = null;


        public object SelecetdItem
        {
            get
            {
                return m_CurrentRow;
            }
        }


        /// <summary>
        /// ŒŸõŽí—Þ
        /// </summary>
        public enum SearchType
        {
            Custom = 0,     //Sql•¶‚ðƒ†[ƒU[‚©‚çŽw’è‚·‚é
            DataTable,      //.ShowDataTable‚ÉDataTable‚ðŽw’è‚·‚é
        }

        private DataView DtView = new DataView();

        // ‹¤’ʕϐ”
        private int intReturnField_IndexNo; // ReturnField‚ÌIndex
        private string strSqlSelected;      // Sql•¶‚Ì‘I‘ðiŽÀÛ‚ÉŽÀs‚·‚éSQL•¶)
        private string strSql = string.Empty;
        private string strAddCondition = string.Empty;
        private string strReturnField = "ƒR[ƒh";
        private string strSearchField = "–¼Ì";
        private string strReturnValue = string.Empty;
        private List<int> colWidth = new List<int>();
        private bool strVisibleBottom = true;
        private bool strVisibleReturnField = true;
        private bool visibleGridHeader = true;
        private Style style = Style.None;

        #endregion

        #region  ššššš@Property@ššššš

        /// <summary>
        /// OwnerControl
        /// </summary>
        public DBConnectItem DBConnectData { get; set; }

        /// <summary>
        /// OwnerControl
        /// </summary>
        public Control OwnerControl { get; set; }

        /// <summary>
        /// SelectType
        /// </summary>
        public SearchType SelectType { get; set; }

        /// <summary>
        /// ShowDataTable(•\Ž¦‚·‚éƒf[ƒ^ƒe[ƒuƒ‹‚ðŽw’è‚·‚éA‚½‚¾‚µAƒfƒtƒHƒ‹ƒg‚̏ꍇƒR[ƒhA–¼ÌƒJƒ‰ƒ€‚ª•K—v)
        /// </summary>
        public DataTable DtTable { get; set; }

        /// <summary>
        /// Sql
        /// </summary>
        public string Sql
        {
            set { strSql = value; }
            get { return strSql; }
        }

        /// <summary>
        /// AddCondition
        /// </summary>
        public string AddCondition
        {
            set { strAddCondition = value; }
            get { return strAddCondition; }
        }

        /// <summary>
        /// ReturnField(‘I‘ð‚µ‚½‚Æ‚«‚É•Ô‚·ƒtƒB[ƒ‹ƒh–¼)
        /// </summary>
        public string ReturnField
        {
            set { strReturnField = value; }
            get { return strReturnField; }
        }

        /// <summary>
        /// SearchField
        /// </summary>
        public string SearchField
        {
            set { strSearchField = value; }
            get { return strSearchField; }
        }

        public Style CurStyle
        {
            set { style = value; }
            get { return style; }
        }

        /// <summary>
        /// VisibleBottom
        /// </summary>
        public List<int> ColWidth
        {
            set { colWidth = value; }
            get { return colWidth; }
        }

        /// <summary>
        /// ReturnValue(‘I‘ðŒã‚Ɏ擾‚Å‚«‚é’l)
        /// </summary>
        public string ReturnValue
        {
            get { return strReturnValue; }
        }

        #endregion

        #region  ššššš@Class Event@ššššš

        /// <summary>
        /// MstList
        /// </summary>
        public MstList()
        {
            InitializeComponent();
        }

        private void SetLocation()
        {
            DataGridView grid = OwnerControl as DataGridView;
            Form ownerForm = GeneralSub.GetOwnerForm(grid);
            //•\Ž¦ˆÊ’u’²®
            System.Drawing.Point location = new System.Drawing.Point(0, 0);
            System.Drawing.Point baseLocation = GeneralSub.GetPopUpLocationEx(ownerForm, grid);
            location.X = baseLocation.X;
            location.Y = baseLocation.Y;
            if (location.X + this.Width > Screen.PrimaryScreen.Bounds.Width)
            {
                location.X = baseLocation.X - (location.X + this.Width - Screen.PrimaryScreen.Bounds.Width + 2);
            }
            if (location.Y + this.Height > Screen.PrimaryScreen.Bounds.Height)
            {
                location.Y = baseLocation.Y - grid.Rows[grid.CurrentCell.RowIndex].Height - this.Height;
            }
            this.SetBounds(location.X, location.Y, this.Width, this.Height);
        }

        /// <summary>
        /// MstList_Load
        /// </summary>
        private void MstList_Load(object sender, EventArgs e)
        {
            //•\Ž¦ƒŒƒCƒAƒEƒg
            if (OwnerControl != null)
            {
                if (OwnerControl is DataGridView)
                {
                    SetLocation();
                }
                else
                {
                    this.StartPosition = FormStartPosition.Manual;
                    Point p = this.OwnerControl.PointToScreen(new Point(0, 0));

                    int x = p.X;
                    int y = p.Y + OwnerControl.Height;

                    if (p.Y + OwnerControl.Height + this.Height > Screen.PrimaryScreen.Bounds.Height)
                    {
                        y = p.Y - this.Height;
                    }

                    if (p.X + this.Width > Screen.PrimaryScreen.Bounds.Width)
                    {
                        x = Screen.PrimaryScreen.Bounds.Width - this.Width;
                    }

                    this.Location = new Point(x, y);
                }
            }
            //if (msSqlNet == null) { msSqlNet = EnvironmentSetting.DbAccess; }

            if ((style & Style.HideBottom) == Style.HideBottom) { strVisibleBottom = false; }
            if ((style & Style.HideGridHeader) == Style.HideGridHeader) { visibleGridHeader = false; }
            if ((style & Style.HideReturnField) == Style.HideReturnField) { strVisibleReturnField = false; }

            //DefaultDataTableÝ’è
            SetDefaultHeader();

            //Sql•¶‚Ì‘I‘ð
            GetData();
            DtTable.TableName = "SelectTable";

            // DataView‚ÉDataSet‚̃e[ƒuƒ‹‚ð˜AŒ‹‚·‚é
            DtView.Table = DtTable;
            DtView.RowFilter = "";

            // ƒf[ƒ^‚ð•\Ž¦
            this.DataGridView1.DataSource = DtView;

            //‰º•”‚ÌŒŸõƒL[‚ƕ‚¶‚éƒ{ƒ^ƒ“‚ð•\Ž¦‚·‚é‚©(‰Šú’l:True(•\Ž¦))
            if (this.strVisibleBottom == false)
            {
                this.panel2.Visible = false; // ƒpƒlƒ‹’PˆÊ‚Å”ñ•\Ž¦‚Ö
            }

            // DataGridView1‚̐ݒè 
            //this.DataGridView1.RowHeadersVisible = false; //sƒwƒbƒ_[‚ð”ñ•\Ž¦
            //this.DataGridView1.AutoResizeColumns( "AllCells", true); // —ñ•‚ðŽ©“®’²®


            //ReturnField(–ß‚è’l‚ð•Ô‚·€–Ú—ñ–¼)‚ÌIndexNo‚ðŽæ“¾‚·‚éB
            intReturnField_IndexNo = -1;

            if (strReturnField == string.Empty)
            {
                intReturnField_IndexNo = 0;
            }
            else
            {
                for (int i = 0; i < this.DataGridView1.Columns.Count; i++)
                {
                    if (this.DataGridView1.Columns[i].HeaderText.ToString() == strReturnField.ToString())
                    {
                        intReturnField_IndexNo = i;
                    }
                }
            }

            if (intReturnField_IndexNo == -1)
            {
                intReturnField_IndexNo = 0;
                strReturnField = string.Empty;
                strSearchField = string.Empty;
            }

            //ReturnField(–ß‚è’l‚ð•Ô‚·€–Ú—ñ–¼)‚ðŽæ“¾‚·‚éB
            if (this.strReturnField.Length == 0)
            {
                this.strReturnField = this.DtView.Table.Columns[intReturnField_IndexNo].ColumnName.ToString();
            }

            //SearchField(ŒŸõƒL[‚ÉŠÖ˜A‚³‚¹‚鍀–Ú—ñ–¼)‚ðŽæ“¾‚·‚éB
            if (this.strSearchField.Length == 0)
            {
                this.strSearchField = this.DtView.Table.Columns[intReturnField_IndexNo + 1].ColumnName.ToString();
            }

            //VisibleReturnField = false‚̏ꍇAReturnField‚ð”ñ•\Ž¦‚Æ‚·‚éB
            if ((strVisibleReturnField == false) && (intReturnField_IndexNo > -1))
            {
                this.DataGridView1.Columns[intReturnField_IndexNo].Visible = false;
            }

            if (DtTable.Rows.Count == 0)
            {
                MessageBox.Show("ŠY“–ƒf[ƒ^‚ª‚ ‚è‚Ü‚¹‚ñB");
                this.Close();
                return;
            }

            this.DataGridView1.ColumnHeadersVisible = visibleGridHeader;

            //ƒGƒ‰[ˆ—
            if (!ValidateInput())
            {
                Debug.Assert(false, "ŠJ”­—pError", "Select‚ª•s“KØAsearchField‚ª”’lA•¶Žš—ñˆÈŠO");

            }

            DataGridView1.EnableHeadersVisualStyles = false;
            DataGridView1.ColumnHeadersHeight = 25;
            foreach (DataGridViewColumn col in DataGridView1.Columns)
            {
                col.HeaderCell.Style.BackColor = System.Drawing.Color.FromArgb(50, 50, 100);
                col.HeaderCell.Style.ForeColor = Color.White;
            }

            DataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;//COMMENT:20080918 –Ñ—˜ No1060
            DataGridView1.AllowUserToResizeColumns = true;
            if (colWidth == null || colWidth.Count == 0)
            {
                DataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
                return;
            }
            for (int i = 0; i < colWidth.Count; i++)
            {
                DataGridView1.Columns[i].Width = colWidth[i];
            }
        }

        #region EscƒL[@•Â‚¶‚é

        protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
        {
            if (keyData == Keys.Escape)
            {
                //ƒeƒXƒg—pƒƒbƒZ[ƒW
                //MessageBox.Show("•Â‚¶‚éƒ{ƒ^ƒ“ƒNƒŠƒbƒN");

                //–ß‚è’l‚Æ‚µ‚Đݒè(Empty’l)
                strReturnValue = string.Empty;

                //‰æ–Ê‚ð•Â‚¶‚é
                this.Close();
            }

            return base.ProcessCmdKey(ref msg, keyData);
        }

        #endregion

        #endregion

        #region  ššššš@Control Event@ššššš

        /// <summary>
        /// •Â‚¶‚éƒ{ƒ^ƒ“@ƒNƒŠƒbƒNƒCƒxƒ“ƒg
        /// </summary>
        private void btnClose_Click(object sender, EventArgs e)
        {
            //ƒeƒXƒg—pƒƒbƒZ[ƒW
            //MessageBox.Show("•Â‚¶‚éƒ{ƒ^ƒ“ƒNƒŠƒbƒN");

            //–ß‚è’l‚Æ‚µ‚Đݒè(Empty’l)
            strReturnValue = string.Empty;

            //‰æ–Ê‚ð•Â‚¶‚é
            this.Close();

        }

        /// <summary>
        /// DataGridView1_CellMouseDoubleClick
        /// </summary>
        private void DataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (DataGridView1.RowCount > 0)
            {

                //ƒeƒXƒg—pƒƒbƒZ[ƒW
                //int iCol = intReturnField_IndexNo;                                   //—ñ(ReturnField‚Ì—ñ‚֌Œè)
                //int iRow = this.DataGridView1.CurrentCell.RowIndex;                  //s(‘I‘ðs)
                //MessageBox.Show("—ñ" + iCol.ToString() + ":s" + iRow.ToString() + "‚Ì" + CellValue.ToString.ToString() + "‚ª‘I‘ð‚³‚ê‚Ä‚¢‚Ü‚·");


                // ƒAƒNƒeƒBƒu‚ȃZƒ‹‚Ì’l‚ð–ß‚è’l‚Æ‚µ‚Đݒè
                if (!isReturnRow)
                {
                    strReturnValue = this.DataGridView1[this.strReturnField.ToString(), this.DataGridView1.CurrentCell.RowIndex].Value.ToString();     //Cell’l
                }
                else
                {
                    m_CurrentRow = this.DataGridView1.CurrentRow;
                }

                //‰æ–Ê‚ð•Â‚¶‚é
                this.Close();

            }
        }

        /// <summary>
        /// DataGridView1_KeyDown
        /// </summary>
        private void DataGridView1_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (DataGridView1.RowCount > 0)
                {

                    if (!isReturnRow)
                    {
                        strReturnValue = this.DataGridView1[this.strReturnField.ToString(), this.DataGridView1.CurrentCell.RowIndex].Value.ToString();     //Cell’l
                    }
                    else
                    {
                        m_CurrentRow = this.DataGridView1.CurrentRow;
                    }
                    //‰æ–Ê‚ð•Â‚¶‚é
                    this.Close();

                }
            }
            else if (e.KeyCode == Keys.Tab)
            {
                e.Handled = true;

                if (e.Shift == true)
                {
                    this.btnClose.Focus();
                }
                else
                {
                    this.txtSearch.Focus();
                }
            }
        }

        /// <summary>
        /// txtSearch_KeyDown
        /// </summary>
        private void txtSearch_KeyDown(object sender, KeyEventArgs e)
        {

            //string strFilterSql;

            //EnterƒL[“ü—͂̏ꍇ
            if (e.KeyCode == Keys.Enter)
            {
                //DataGridView1‚ÖƒtƒH[ƒJƒXˆÚ“®
                this.DataGridView1.Focus();
            }

        }

        /// <summary>
        /// txtSearch_KeyDown
        /// </summary>
        private void txtSearch_TextChanged(object sender, EventArgs e)
        {

            string strFilterSql;

            // ƒtƒBƒ‹ƒ^[ðŒ‚ð”»•Ê
            if ((this.txtSearch.Text.ToString() == string.Empty) || (this.strSearchField.ToString() == string.Empty))
            {
                //ƒtƒBƒ‹ƒ^ðŒ–³‚µ(‘S‚Ä‚ð•\Ž¦)
                strFilterSql = string.Empty;
            }
            else
            {
                //ƒtƒBƒ‹ƒ^ðŒŽw’è
                strFilterSql = this.strSearchField.ToString() + " LIKE '%" + this.txtSearch.Text.ToString() + "%'";
            }

            //ƒeƒXƒg—pƒƒbƒZ[ƒW
            //MessageBox.Show("ƒtƒBƒ‹ƒ^[F" + strFilterSql.ToString());

            // ƒtƒBƒ‹ƒ^[ðŒ‚ðŽw’肵‚ÄDataView‚ÉŠi”[
            DtView.RowFilter = strFilterSql.ToString();

            // ƒf[ƒ^‚ð•\Ž¦
            this.DataGridView1.DataSource = DtView;

        }

        private void txtSearch_Enter(object sender, EventArgs e)
        {
            txtSearch.BackColor = Color.LightSteelBlue;
        }

        private void txtSearch_Leave(object sender, EventArgs e)
        {
            txtSearch.BackColor = Color.White;
        }

        #endregion

        #region  ššššš@Private Function@ššššš

        /// <summary>
        /// Default‚̐ݒè
        /// </summary>
        private void SetDefaultHeader()
        {
            if (SelectType != SearchType.DataTable)
            {
                DtTable.Columns.AddRange(new DataColumn[] { new DataColumn("ƒR[ƒh"), new DataColumn("–¼Ì") });
            }
        }

        /// <summary>
        /// ValidateInput
        /// </summary>
        private bool ValidateInput()
        {
            if (isReturnRow) { return true; }
            if (DtTable.Rows.Count == 0)
                return false;
            if (
                  DtTable.Columns[this.strSearchField].DataType != typeof(string)
                // && DtSet.Tables[0].Columns[this.strSearchField].DataType != typeof(int)
               )
                return false;
            return true;
        }

        /// <summary>
        /// SelectSql
        /// </summary>
        private void GetData()
        {
            strSqlSelected = string.Empty;

            //Sql•¶‚Ì‘I‘ð
            if (SelectType.Equals(SearchType.Custom))
            { //ƒJƒXƒ^ƒ€Ý’è

                strSqlSelected = this.strSql.ToString() + " " + this.strAddCondition.ToString();
                // ƒf[ƒ^‚ðŽæ“¾
                using (MsSqlNet msSqlNet = new MsSqlNet(DBConnectData.HostName, DBConnectData.UserID, DBConnectData.Password, DBConnectData.DBName))
                {
                    DtTable = msSqlNet.GetDataTable(this.strSqlSelected.ToString());
                }
            }
        }


        #region ------------   ŒÅ’èƒf[ƒ^‚̃e[ƒuƒ‹ƒf[ƒ^    -------------------

        /// <summary>
        /// Enum‚É‚æ‚èƒf[ƒ^ƒe[ƒuƒ‹‚ðì‚é
        /// </summary>
        public DataTable GetTypeData(Type enumType)
        {
            DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[] { new DataColumn("ƒR[ƒh"), new DataColumn("–¼Ì") });
            DataRow row = null;
            foreach (object item in Enum.GetValues(enumType))
            {
                row = dt.NewRow();
                dt.Rows.Add(row);
                row["ƒR[ƒh"] = ((int)item).ToString();
                row["–¼Ì"] = item.ToString();
            }
            return dt;
        }

        #endregion

        #endregion

        #region  ššššš@Public Function@ššššš

        public static string GetTypeName(Type enumType,int code)
        {
            try
            {
                return CConvert.ToString(Enum.GetName(enumType, code));
            }
            catch 
            {
                return string.Empty;
            }
        }

        public static string ExecuteSql(Control owner, DBConnectItem dbItem, string sql)
        {
            return Execute(SearchType.Custom, owner, dbItem, Style.None, Size.Empty, string.Empty, string.Empty, string.Empty, null, sql, null);
        }

        public static string ExecuteTable(Control owner, DataTable data)
        {
            return Execute(SearchType.DataTable, owner, null, Style.None, Size.Empty, string.Empty, string.Empty, string.Empty, null, string.Empty, data);
        }

        /// <summary>
        /// ˆê——•\Ž¦
        /// </summary>
        /// <returns></returns>
        public static string Execute(SearchType type, Control owner, DBConnectItem dbItem)
        {
            return Execute(type, owner, dbItem, Style.None, Size.Empty, string.Empty, string.Empty, string.Empty, null, string.Empty, null);
        }

        public static string Execute(SearchType type, Control owner, DBConnectItem dbItem, Style style)
        {
            return Execute(type, owner, dbItem, style, Size.Empty, string.Empty, string.Empty, string.Empty, null, string.Empty, null);
        }

        public static string Execute(SearchType type, Control owner, DBConnectItem dbItem, Style style, Size size)
        {
            return Execute(type, owner, dbItem, style, size, string.Empty, string.Empty, string.Empty, null, string.Empty, null);
        }

        public static string Execute(SearchType type, Control owner, DBConnectItem dbItem, Style style, Size size, string addCondition)
        {
            return Execute(type, owner, dbItem, style, size, addCondition, string.Empty, string.Empty, null, string.Empty, null);
        }

        public static string Execute(SearchType type, Control owner, DBConnectItem dbItem, Style style, Size size, string addCondition,
                                     string returnField, string searchField, List<int> colWidth)
        {
            return Execute(type, owner, dbItem, style, size, addCondition, returnField, searchField, colWidth, string.Empty, null);
        }

        public static string Execute(SearchType type, Control owner, DBConnectItem dbItem, Style style, Size size, string addCondition,
                                     string returnField, string searchField, List<int> colWidth, string sql, DataTable data)
        {
            string result = string.Empty;
            MstList mstList = new MstList();
            mstList.SelectType = type;
            mstList.OwnerControl = owner;
            mstList.DBConnectData = dbItem;
            mstList.CurStyle = style;
            if (!size.Equals(Size.Empty)) { mstList.Size = size; }
            if (returnField.Length > 0) { mstList.ReturnField = returnField; }
            if (searchField.Length > 0) { mstList.SearchField = searchField; }
            if (colWidth != null) { mstList.ColWidth = colWidth; }
            mstList.AddCondition = addCondition;
            mstList.Sql = sql;
            mstList.DtTable = data;
            mstList.ShowDialog();
            if (mstList.ReturnValue.Length > 0)
            {
                result = mstList.ReturnValue;
            }
            mstList.Dispose();
            return result;
        }

        #endregion
    }
}