private void F12() { if (ErrorCheck(12)) { if (mtrbl.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes) { mre = GetRenbanEnity(); switch (OperationMode) { case EOperationMode.INSERT: InsertUpdate(1); break; case EOperationMode.UPDATE: InsertUpdate(2); break; case EOperationMode.DELETE: Delete(); break; } } else { txtContinuous.Focus(); } } }
public bool M_Renban_Delete(M_Renban_Entity mre) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>() { { "@PrefixValue", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.PrefixValue } }, { "@Continuous", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.Continuous } }, { "@Operator", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.Operator } }, { "@Program", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.ProgramID } }, { "@PC", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.PC } }, { "@OperateMode", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.ProcessMode } }, { "@KeyItem", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.Key } } }; return(InsertUpdateDeleteData(dic, "M_Renban_Delete")); }
public DataTable M_Renban_Select(M_Renban_Entity mre) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>() { { "@PrefixValue", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.PrefixValue } } }; return(SelectData(dic, "M_Renban_Select")); }
public M_Renban_Entity M_Renban_Select(M_Renban_Entity mre) { DataTable dtRenban = mrdl.M_Renban_Select(mre); if (dtRenban.Rows.Count > 0) { mre.PrefixValue = dtRenban.Rows[0]["Prefix"].ToString(); mre.Continuous = dtRenban.Rows[0]["SeqNumber"].ToString(); return(mre); } return(null); }
private M_Renban_Entity GetRenbanEnity() { mre = new M_Renban_Entity { PrefixValue = txtPrefixValue.Text, Continuous = txtContinuous.Text, Operator = InOperatorCD, ProcessMode = ModeText, ProgramID = InProgramID, PC = InPcID, Key = txtPrefixValue.Text + " " + txtContinuous.Text }; return(mre); }
private bool DisplayDataInsert(string prefix) { mre = new M_Renban_Entity() { PrefixValue = txtPrefixValue.Text }; mre = mtrbl.M_Renban_Select(mre); if (mre != null) { txtPrefixValue.Text = mre.PrefixValue; txtContinuous.Text = mre.Continuous; txtPrefixValue.Focus(); return(true); } else { txtContinuous.Focus(); return(false); } }
public bool M_Renban_Delete(M_Renban_Entity mre) { return(mrdl.M_Renban_Delete(mre)); }
public bool M_Renban_Insert_Update(M_Renban_Entity mre, int mode) { return(mrdl.M_Renban_Insert_Update(mre, mode)); }