private bool DisplayData(CKM_SearchControl sc)
{
mge = new M_Ginkou_Entity
{
ginko_CD = sc.Code,
ginko_Changedate = sc.ChangeDate
};
mge = mgbl.M_Ginkou_Entity_select(mge);
if (mge != null)
{
ginko_name.Text = mge.ginko_Name;
ginko_kananame.Text = mge.ginko_kananame;
ginko_remarks.Text = mge.ginko_remarks;
ChkDeleteFlg.Checked = mge.ginko_DeleteFlag.Equals("1") ? true : false;
ginko_useflg.Text = mge.ginko_useflag;
ginko_name.Focus();
return(true);
}
else
{
mgbl.ShowMessage("E133");
return(false);
}
}
public bool M_Ginkou_Delete(M_Ginkou_Entity mge)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>()
{
{ "@Ginko_CD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.ginko_CD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mge.ginko_Changedate
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.ginko_insertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.Program
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.KeyItem
} }
};
return(InsertUpdateDeleteData(dic, "M_Ginkou_Delete"));
}
private void F12()
{
if (ErrorCheck(12))
{
if (mgbl.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
{
mge = GetGinkouEntity();
switch (OperationMode)
{
case EOperationMode.INSERT:
InsertUpdate(1);
break;
case EOperationMode.UPDATE:
InsertUpdate(2);
break;
case EOperationMode.DELETE:
Delete();
break;
}
}
//else PreviousCtrl.Focus();
}
}
public DataTable M_Ginkou_Select(M_Ginkou_Entity mge)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@GinkoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.ginko_CD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mge.ginko_Changedate
} }
};
return(SelectData(dic, "M_Ginkou_Select"));
}
public M_Ginkou_Entity M_Ginkou_Entity_select(M_Ginkou_Entity mge)
{
DataTable dtginKou = mgdl.M_Ginkou_Select(mge);
if (dtginKou.Rows.Count > 0)
{
mge.ginko_Name = dtginKou.Rows[0]["BankName"].ToString();
mge.ginko_kananame = dtginKou.Rows[0]["BankKana"].ToString();
mge.ginko_remarks = dtginKou.Rows[0]["Remarks"].ToString();
mge.ginko_DeleteFlag = dtginKou.Rows[0]["DeleteFlg"].ToString();
mge.ginko_useflag = dtginKou.Rows[0]["UsedFlg"].ToString();
return(mge);
}
return(null);
}
public bool M_Ginkou_Insert_Update(M_Ginkou_Entity mge, int mode)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@BankCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.ginko_CD
} },
{ "@ChangeDate", new ValuePair {
value1 = System.Data.SqlDbType.Date, value2 = mge.ginko_Changedate
} },
{ "@BankName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.ginko_Name
} },
{ "@BankKana", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.ginko_kananame
} },
{ "@Remarks", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.ginko_remarks
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.ginko_DeleteFlag
} },
{ "@UsedFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mge.ginko_useflag
} },
{ "@InsertOperator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.ginko_insertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.Program
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.OperateMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mge.KeyItem
} },
{ "@Mode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mode.ToString()
} }
};
return(InsertUpdateDeleteData(dic, "M_Ginkou_Insert_Update"));
}
private bool GinkoExist(CKM_SearchControl sc)
{
if (string.IsNullOrWhiteSpace(sc.Code))
{
return(true);
}
mge = new M_Ginkou_Entity
{
FieldsName = "1",
TableName = "M_bank",
Condition = "BankCD = '" + sc.Code + "' and " +
"ChangeDate = '" + (string.IsNullOrWhiteSpace(sc.ChangeDate) ? DateTime.Now.ToString("yyyy/MM/dd") : sc.ChangeDate.Replace("/", "-")) + "'"
};
return(mgbl.M_Ginkou_Exist(sc.Code, sc.ChangeDate));
}
private M_Ginkou_Entity GetGinkouEntity()
{
mge = new M_Ginkou_Entity {
ginko_CD = ginKou_CD.Code,
ginko_Changedate = ginKou_CD.ChangeDate,
ginko_Name = ginko_name.Text,
ginko_kananame = ginko_kananame.Text,
ginko_remarks = ginko_remarks.Text,
ginko_DeleteFlag = ChkDeleteFlg.Checked ? "1" : "0",
ginko_insertOperator = InOperatorCD,
ginko_useflag = "0",
PC = InPcID,
Program = InProgramID,
ProcessMode = ModeText,
KeyItem = ginKou_CD.Code + " " + ginKou_CD.ChangeDate
};
return(mge);
}
public bool M_Ginkou_Delete(M_Ginkou_Entity mge)
{
return(mgdl.M_Ginkou_Delete(mge));
}
public bool insert_update_mginko(M_Ginkou_Entity mge, int mode)
{
return(mgdl.M_Ginkou_Insert_Update(mge, mode));
}
private bool ErrorCheck(int index)
{
if (index == 11)
{
if (OperationMode == EOperationMode.INSERT)
{
if (type == 1)
{
if (!RequireCheck(new Control[] { ginKou_CD.TxtCode, ginKou_CD.TxtChangeDate })) // go that focus
{
return(false);
}
}
else
{
if (!RequireCheck(new Control[] { ginKou_CD.TxtCode, ginKou_CD.TxtChangeDate }))
{
return(false);
}
if (!RequireCheck(new Control[] { copy_ginKou_CD.TxtCode }, copy_ginKou_CD.TxtChangeDate))
{
return(false);
}
if (!RequireCheck(new Control[] { copy_ginKou_CD.TxtChangeDate }, copy_ginKou_CD.TxtCode))
{
return(false);
}
if (ginKou_CD.IsExists(1))
{
mgbl.ShowMessage("E132");
ginKou_CD.SetFocus(1);
return(false);
}
if (!string.IsNullOrWhiteSpace(copy_ginKou_CD.TxtCode.Text) && !string.IsNullOrWhiteSpace(copy_ginKou_CD.TxtChangeDate.Text))
{
if (!copy_ginKou_CD.IsExists(1))
{
mgbl.ShowMessage("E133");
copy_ginKou_CD.SetFocus(1);
return(false);
}
}
}
}
else
{
if (!ginKou_CD.IsExists(1))
{
mgbl.ShowMessage("E133");
ginKou_CD.SetFocus(1);
return(false);
}
}
}
else if (index == 12)
{
if (OperationMode != EOperationMode.DELETE)
{
if (!RequireCheck(new Control[] { ginKou_CD.TxtCode, ginKou_CD.TxtChangeDate, ginko_name, ginko_kananame }))
{
return(false);
}
}
if (OperationMode == EOperationMode.INSERT)
{
if (ginKou_CD.IsExists(1))
{
mgbl.ShowMessage("E132");
ginKou_CD.SetFocus(1);
return(false);
}
}
if (OperationMode == EOperationMode.DELETE)
{
mge = GetGinkouEntity();
// Use - Flag == 1 Condition >> do nothing
if (mgbl.IsuseFlag(mge.ginko_CD, mge.ginko_Changedate) || mgbl.IsGinkoExistInShiten(mge.ginko_CD, mge.ginko_Changedate))
{
mgbl.ShowMessage("E154");
ginKou_CD.SetFocus(1);
return(false);
}
}
}
return(true);
}
