using Common.WinForm.Component;
using Common.Util;
using Common.WinForm.Util;
using Pms.Forms.Util;
using Pms.Core.Interface;
using System;
using System.Data;
using System.Windows.Forms;

namespace Pms.Forms.Master
{
    /// <summary>								
    /// ****************************** Description *******************************								
    /// žƒVƒXƒeƒ€–¼Ì								
    /// @@2@								
    /// žŠT—v								
    /// @@3@								
    /// ž—š—ð								
    /// @@4@@Ž©“®ì¬								
    /// ****************************** Declarations ******************************								
    /// </summary>	
    public partial class @0@ : BaseMaster, IMasterCtrl
    {							
        #region  ššššš@Declartions@ššššš

        private Pms.Core.Access.@1@ m_DataAccess = null;

        #endregion

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

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

        public @0@()
        {
            InitializeComponent();
            base.MasterCtrl = this;
        }

        private void Form_Load(object sender, EventArgs e)
        {
            m_DataAccess = new Pms.Core.Access.@1@();
            MasterCtrl.ShowData();
            if (dgvData.Rows.Count == 0)
            {
                SetNewMode();
            }
        }

        #endregion

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

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

        #region  ššššš@Public  Function@ššššš
				    
        public bool Save()
        {
            if (m_ValueChangeListener.CurUpdateMode != UpdateFormMode.Inputting && m_ValueChangeListener.CurUpdateMode != UpdateFormMode.Edit) { return true; }

            bool isNew = false;
            Pms.Data.Master.@5@ item = null;
            UpdateFormMode orgMode = m_ValueChangeListener.CurUpdateMode;
            if (orgMode == UpdateFormMode.Edit) { item = m_DataAccess.GetItem(msSqlNet, @11@); }
            if (item == null)
            {
                item = new Pms.Data.Master.@5@();
                isNew = true;
            }
@6@

            int orgIndex = (dgvData.CurrentRow == null) ? 0 : dgvData.CurrentRow.Index;
            bool result = msSqlNet.ExecuteNonQuery(isNew ? item.AddSql() : item.UpdateSql()) != -1;

            MasterCtrl.ShowData(orgIndex);
            if (orgMode == UpdateFormMode.Inputting) { SetNewMode(); }
            m_ValueChangeListener.SetUpdateFormMode(orgMode == UpdateFormMode.Edit ? UpdateFormMode.Normal : UpdateFormMode.New);
            return result;
        }

        public void SetDispName(TextBox sender)
        {
@8@
#if false
            if(sender.Equals(txtTypeID))
            {
                tbArray.MstNameCtrlDict[sender].Text = Setting.Master.GetName(MasterData.DataType.HM_RoomType, CConvert.ToInt(sender.Text).ToString());
            }
            else if (sender.Equals(txtOpeFlg))
            {
                tbArray.MstNameCtrlDict[sender].Text = Setting.Master.GetName(MasterData.DataType.BoolType, CConvert.ToInt(sender.Text).ToString());
            }
            else if (sender.Equals(txtSmorkType))
            {
                tbArray.MstNameCtrlDict[sender].Text = Setting.Master.GetName(MasterData.DataType.SmorkType, CConvert.ToInt(sender.Text).ToString());
            }
#endif
        }


        public void ShowList(CTextBox sender)
        {
            DataTable data = null;
@9@
#if false
            if (sender.Equals(txtTypeID)) { data = Setting.Master.GetTable(MasterData.DataType.HM_RoomType); }
            else if (sender.Equals(txtOpeFlg)) { data = Setting.Master.GetTable(MasterData.DataType.BoolType); }
            else if (sender.Equals(txtSmorkType)) { data = Setting.Master.GetTable(MasterData.DataType.SmorkType); }
#endif

            if (data == null) { return; }
            string ret = MstList.ExecuteTable(sender, data);            
            if (ret.Length == 0) { return; }
            sender.Text = ret;
            tbArray.PerformKeyDown(sender, new KeyEventArgs(Keys.Enter));
        }

        public bool IsCorrectEtc(object sender, bool isCheckAll, bool isShowErrMsg)
        {
            if(sender.Equals(@10@) && m_ValueChangeListener.CurUpdateMode == UpdateFormMode.Inputting)
            {
                if (m_DataAccess.Exists(msSqlNet, @11@))
                {
                    MessageBox.Show(ExistsMsg, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
                    @10@.Focus();
                    return false;
                }
            }

            return true;
        }


        public void ShowData()
        {
            ShowData(0);
        }

        public void ShowData(int gridIndex)
        {
            try
            {
                m_DisableSelectionChanged = true;
                DataTable orgData = m_Data;
                string where = string.Empty;
                if (txtSearchKey.Text.Trim().Length > 0)
                {
                    where += string.Format(" WHERE A.Name LIKE '%{0}%' ", txtSearchKey.Text);
                }

                string sql = string.Format(@"@12@", where);
                m_Data = msSqlNet.GetDataTable(sql);
                dgvData.DataSource = m_Data;
				SetGridColNameDict();
                SetGridStyle();
                if (dgvData.Rows.Count > 0)
                {
                    SetCellFocus(gridIndex, 0, true);
                    ShowDetail();
                }
                if (orgData != null) { orgData.Dispose(); orgData = null; }
            }
            catch { }
            finally
            {
                m_DisableSelectionChanged = false;
            }
        }

        private void SetGridStyle()
        {
            DataGridViewColumn col = null;
@13@
        }

        public void ShowDetail()
        {
            if (dgvData.CurrentRow == null) { return; }
            tbArray.DisbleValidating = true;
            int index = dgvData.CurrentRow.Index;
@14@
            m_ValueChangeListener.SetUpdateFormMode(UpdateFormMode.Normal);
            tbArray.DisbleValidating = false;
        }

        public bool Delete()
        {
            int orgIndex = dgvData.CurrentRow.Index;
@15@
            ShowData(orgIndex < dgvData.RowCount ? orgIndex : dgvData.RowCount - 1);
            if (dgvData.Rows.Count == 0) { SetNewMode(); }
            return true;
        }

        #endregion
    }
}