private M_Hanyou_Entity GetHanyouEntity()
{
mhe = new M_Hanyou_Entity
{
ID = ScID.Code,
Key = ScKey.Code,
IDName = ScID.LabelText,
Text1 = txtText1.Text,
Text2 = txtText2.Text,
Text3 = txtText3.Text,
Text4 = txtText4.Text,
Text5 = txtText5.Text,
Digital1 = txtDigital1.Text,
Digital2 = txtDigital2.Text,
Digital3 = txtDigital3.Text,
Digital4 = txtDigital4.Text,
Digital5 = txtDigital5.Text,
Day1 = txtDay1.Text + " " + txtDay11.Text,
Day2 = txtDay2.Text + " " + txtDay21.Text,
Day3 = txtDay3.Text + " " + txtDay31.Text,
ProcessMode = ModeText,
InsertOperator = InOperatorCD,
//Key = ScID.Code + " " + ScKey.Code,
ProgramID = InProgramID,
PC = InPcID
};
return(mhe);
}
public M_Hanyou_Entity M_Hanyou_Select(M_Hanyou_Entity mhe)
{
DataTable dtHanyou = new DataTable();
dtHanyou = mhdl.M_Hanyou_KeySelect(mhe);
if (dtHanyou.Rows.Count > 0)
{
mhe.ID = dtHanyou.Rows[0]["ID"].ToString();
mhe.Key = dtHanyou.Rows[0]["Key"].ToString();
mhe.Text1 = dtHanyou.Rows[0]["Char1"].ToString();
mhe.Text2 = dtHanyou.Rows[0]["Char2"].ToString();
mhe.Text3 = dtHanyou.Rows[0]["Char3"].ToString();
mhe.Text4 = dtHanyou.Rows[0]["Char4"].ToString();
mhe.Text5 = dtHanyou.Rows[0]["Char5"].ToString();
mhe.Digital1 = dtHanyou.Rows[0]["Num1"].ToString();
mhe.Digital2 = dtHanyou.Rows[0]["Num2"].ToString();
mhe.Digital3 = dtHanyou.Rows[0]["Num3"].ToString();
mhe.Digital4 = dtHanyou.Rows[0]["Num4"].ToString();
mhe.Digital5 = dtHanyou.Rows[0]["Num5"].ToString();
mhe.Day1 = dtHanyou.Rows[0]["Date1"].ToString();
mhe.Day2 = dtHanyou.Rows[0]["Date2"].ToString();
mhe.Day3 = dtHanyou.Rows[0]["Date3"].ToString();
return(mhe);
}
return(null);
}
public bool M_Hanyou_Delete(M_Hanyou_Entity mhe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>()
{
{ "@ID", new ValuePair {
value1 = SqlDbType.Int, value2 = mhe.ID
} },
{ "@Key", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.Key
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.Operator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.ID + " " + mhe.Key
} }
};
return(InsertUpdateDeleteData(dic, "M_MultiPurpose_Delete"));
}
private void F12()
{
if (ErrorCheck(12))
{
if (mthbl.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
{
mhe = GetHanyouEntity();
switch (OperationMode)
{
case EOperationMode.INSERT:
InsertUpdate(1);
break;
case EOperationMode.UPDATE:
InsertUpdate(2);
break;
case EOperationMode.DELETE:
Delete();
break;
}
}
else
{
PreviousCtrl.Focus();
}
}
}
private M_Hanyou_Entity GetData()
{
mhe = new M_Hanyou_Entity
{
ID = lblID.Text,
KeyFrom = txtKey1.Text,
KeyTo = txtKey2.Text,
};
return(mhe);
}
private void F11()
{
if (ErrorCheck())
{
mhe = GetData();
DataTable dtHanyou = new DataTable();
dtHanyou = shbl.M_Hanyou_KeySearch(mhe);
GvKey.DataSource = dtHanyou;
}
}
private M_Hanyou_Entity GetData()
{
mhe = new M_Hanyou_Entity
{
IDFrom = txtID1.Text,
IDTo = txtID2.Text,
};
return(mhe);
}
public DataTable M_Hanyou_IDSelect(M_Hanyou_Entity mhe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ID", new ValuePair {
value1 = SqlDbType.Int, value2 = mhe.ID
} }
};
return(SelectData(dic, "M_MultiPurpose_IDSelect"));
}
public DataTable M_Hanyou_KeySearch(M_Hanyou_Entity mhe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ID", new ValuePair {
value1 = SqlDbType.Int, value2 = mhe.ID
} },
{ "@KeyFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.KeyFrom
} },
{ "@KeyTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.KeyTo
} }
};
return(SelectData(dic, "M_MultiPurpose_KeySearch"));
}
private bool CheckID()
{
if (string.IsNullOrWhiteSpace(ScID.Code))
{
mthbl.ShowMessage("E102");
ScID.TxtCode.MoveNext = false;
return(false);
}
else
{
DataTable dtID = new DataTable();
mhe = GetHanyouEntity();
//if (Convert.ToInt32(ScID.Code) != 000)
if (ScID.Code != "000")
{
dtID = mthbl.Hanyou_IDSelect(mhe);
if (dtID.Rows.Count == 0)
{
mthbl.ShowMessage("E101");
ScID.TxtCode.MoveNext = false;
return(false);
}
else
{
ScID.LabelText = dtID.Rows[0]["Char1"].ToString();
}
}
else
{
dtID = mthbl.Hanyou_IDSelect(mhe);
if (dtID.Rows.Count > 0)
{
ScID.LabelText = dtID.Rows[0]["Char1"].ToString();
}
}
}
return(true);
}
public bool M_Hanyou_Delete(M_Hanyou_Entity mhe)
{
return(mhdl.M_Hanyou_Delete(mhe));
}
public bool M_Hanyou_Insert_Update(M_Hanyou_Entity mhe, int mode)
{
return(mhdl.M_Hanyou_Insert_Update(mhe, mode));
}
public DataTable Hanyou_KeySelect(M_Hanyou_Entity mhe)
{
return(mhdl.M_Hanyou_KeySelect(mhe));
}
private bool ErrorCheck(int index)
{
if (index == 11)
{
//HeaderCheck on F11
if (OperationMode == EOperationMode.INSERT)
{
if (type == 1)
{
if (!RequireCheck(new Control[] { ScID.TxtCode }))
{
return(false);
}
if (!RequireCheck(new Control[] { ScKey.TxtCode }))
{
return(false);
}
}
else // Copy
{
if (!RequireCheck(new Control[] { ScID.TxtCode }))
{
return(false);
}
if (!RequireCheck(new Control[] { ScKey.TxtCode }))
{
return(false);
}
if (!string.IsNullOrWhiteSpace(ScCopyKey.Code))
{
DataTable dtKey = new DataTable();
mhe = GetHanyouEntity();
dtKey = mthbl.Hanyou_KeySelect(mhe);
if (dtKey.Rows.Count > 0)
{
mthbl.ShowMessage("E132");
ScKey.SetFocus(1);
return(false);
}
else
{
mhe.ID = ScID.Code;
mhe.Key = ScCopyKey.Code;
ScCopyKey.SearchEnable = true;
DataTable dtcopyKey = new DataTable();
dtcopyKey = mthbl.Hanyou_KeySelect(mhe);
if (dtcopyKey.Rows.Count == 0)
{
mthbl.ShowMessage("E133");
ScCopyKey.SetFocus(1);
return(false);
}
}
}
}
}
else
{
DataTable dtKey = new DataTable();
mhe = GetHanyouEntity();
dtKey = mthbl.Hanyou_KeySelect(mhe);
if (dtKey.Rows.Count == 0)
{
mthbl.ShowMessage("E133");
ScKey.SetFocus(1);
return(false);
}
}
}
else if (index == 12)
{
if (!RequireCheck(new Control[] { ScID.TxtCode }))
{
return(false);
}
if (!RequireCheck(new Control[] { ScKey.TxtCode }))
{
return(false);
}
if (OperationMode == EOperationMode.INSERT)
{
DataTable dtKey = new DataTable();
mhe = GetHanyouEntity();
dtKey = mthbl.Hanyou_KeySelect(mhe);
if (dtKey.Rows.Count > 0)
{
mthbl.ShowMessage("E132");
ScKey.SetFocus(1);
return(false);
}
}
}
return(true);
}
public bool M_Hanyou_Insert_Update(M_Hanyou_Entity mhe, int mode)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ID", new ValuePair {
value1 = SqlDbType.Int, value2 = mhe.ID
} },
{ "@Key", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.Key
} },
//{ "@IDName", new ValuePair { value1 = SqlDbType.VarChar, value2 = mhe.IDName } },
{ "@Text1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.Text1
} },
{ "@Text2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.Text2
} },
{ "@Text3", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.Text3
} },
{ "@Text4", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.Text4
} },
{ "@Text5", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.Text5
} },
{ "@Digital1", new ValuePair {
value1 = SqlDbType.Int, value2 = mhe.Digital1
} },
{ "@Digital2", new ValuePair {
value1 = SqlDbType.Int, value2 = mhe.Digital2
} },
{ "@Digital3", new ValuePair {
value1 = SqlDbType.Int, value2 = mhe.Digital3
} },
{ "@Digital4", new ValuePair {
value1 = SqlDbType.Int, value2 = mhe.Digital4
} },
{ "@Digital5", new ValuePair {
value1 = SqlDbType.Int, value2 = mhe.Digital5
} },
{ "@Day1", new ValuePair {
value1 = SqlDbType.DateTime, value2 = mhe.Day1
} },
{ "@Day2", new ValuePair {
value1 = SqlDbType.DateTime, value2 = mhe.Day2
} },
{ "@Day3", new ValuePair {
value1 = SqlDbType.DateTime, value2 = mhe.Day3
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mhe.ID + " " + mhe.Key
} },
{ "@Mode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mode.ToString()
} }
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "M_MultiPurpose_Insert_Update"));
}
public DataTable M_Hanyou_KeySearch(M_Hanyou_Entity mhe)
{
return(mhdl.M_Hanyou_KeySearch(mhe));
}
