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 *******************************
|
/// VXe¼Ì
|
/// @@2@
|
/// Tv
|
/// @@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
|
}
|
}
|
