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)); }