private void ScBankCD_CodeKeyDownEvent(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (!string.IsNullOrWhiteSpace(ScBankCD.TxtCode.Text))
{
if (ScBankCD.SelectData())
{
ScBranchCD.Value1 = ScBankCD.TxtCode.Text;
ScBranchCD.Value2 = ScBankCD.LabelText;
mb = GetDate();
mb = mtbstbl.M_Bank_ChangeDate_Select(mb);
if (mb != null)
{
date = mb.ChangeDate;
}
}
else
{
mtbstbl.ShowMessage("E101");
ScBankCD.SetFocus(1);
}
}
}
}
private void F11()
{
if (ErrorCheck())
{
mbe = GetSearchInfo();
DataTable dtBank = sgbl.M_Bank_Search(mbe);
GdvGinkou.DataSource = dtBank;
}
}
private M_Bank_Entity GetDate()
{
mb = new M_Bank_Entity
{
BankCD = ScBankCD.TxtCode.Text,
ChangeDate = string.IsNullOrWhiteSpace(ScBranchCD.ChangeDate) ? bbl.GetDate() : ScBranchCD.ChangeDate
};
return(mb);
}
public M_Bank_Entity M_Bank_ChangeDate_Select(M_Bank_Entity mb)
{
DataTable dt = mbdl.M_Bank_ChangeDate_Select(mb);
if (dt.Rows.Count > 0)
{
mb.ChangeDate = dt.Rows[0]["ChangeDate"].ToString();
return(mb);
}
return(null);
}
public M_Bank_Entity M_Bank_Select(M_Bank_Entity mbe)
{
DataTable dtBank = mbdl.M_Bank_Select(mbe);
if (dtBank.Rows.Count > 0)
{
mbe.BankName = dtBank.Rows[0]["BankName"].ToString();
mbe.BankKana = dtBank.Rows[0]["BankKana"].ToString();
return(mbe);
}
return(null);
}
public DataTable M_Bank_ChangeDate_Select(M_Bank_Entity mbe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@BankCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BankCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mbe.ChangeDate
} }
};
return(SelectData(dic, "M_Bank_ChangeDate_Select"));
}
private M_Bank_Entity GetSearchInfo()
{
mbe = new M_Bank_Entity
{
BankCDFrom = txtBankCDFrom.Text,
BankCDTo = txtBankCDTo.Text,
ChangeDate = lblChangeDate.Text,
BankName = txtBankName.Text,
BankKana = txtBankKana.Text,
searchType = RdoKijunBi.Checked ? "0" : "1",
DeleteFlg = "0",
};
return(mbe);
}
public DataTable M_Bank_Search(M_Bank_Entity mbe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@Fields", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.FieldsName
} },
{ "@BankCDFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BankCDFrom
} },
{ "@BankCDTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BankCDTo
} },
{ "@BankName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BankName
} },
{ "@BankKana", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BankKana
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mbe.ChangeDate
} },
{ "@SearchType", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.searchType
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mbe.DeleteFlg
} },
{ "@OrderBy", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.OrderBy
} },
};
UseTransaction = true;
return(SelectData(dic, "M_Bank_Search"));
}
public DataTable Bank_Select(M_Bank_Entity mbe)
{
return(mbdl.M_Vendor_Bank_Select(mbe));
}
public DataTable M_Bank_Search(M_Bank_Entity mbe)
{
return(mbankdl.M_Bank_Search(mbe));
}