public bool M_Prefix_Delete(M_Prefix_Entity prefix)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>()
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.StoreCD
} },
{ "@SeqKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = prefix.SeqKBN
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = prefix.ChangeDate
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.Key
} }
};
return(InsertUpdateDeleteData(dic, "M_Prefix_Delete"));
}
private void F12()
{
if (ErrorCheck(12))
{
if (mtscbl.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
{
prefixdata = GetPrefixEntity();
switch (OperationMode)
{
case EOperationMode.INSERT:
InsertUpdate(1);
break;
case EOperationMode.UPDATE:
InsertUpdate(2);
break;
case EOperationMode.DELETE:
Delete();
break;
}
}
else
{
PreviousCtrl.Focus();
}
}
}
private bool PrefixExist()
{
prefixdata = new M_Prefix_Entity
{
StoreCD = cboStore.SelectedValue.ToString(),
SeqKBN = cboSeqKBN.SelectedValue.ToString(),
ChangeDate = txtDate.Text
};
dtPrefix = mtscbl.ShowPrefix(prefixdata);
return(dtPrefix.Rows.Count > 0 ? true : false);
}
private M_Prefix_Entity GetPrefixEntity()
{
prefixdata = new M_Prefix_Entity
{
StoreCD = cboStore.SelectedValue.ToString(),
SeqKBN = cboSeqKBN.SelectedValue.ToString(),
ChangeDate = txtDate.Text.ToString(),
Prefix = txtPrefix.Text.ToString(),
ProcessMode = ModeText,
InsertOperator = InOperatorCD,
ProgramID = InProgramID,
PC = InPcID,
Key = cboStore.AccessibilityObject.Value.ToString() + " " + cboSeqKBN.AccessibilityObject.Value.ToString() + " " + txtPrefix.Text
};
return(prefixdata);
}
public DataTable ShowPrefix(M_Prefix_Entity prefix)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>();
dic.Add("@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.StoreCD
});
dic.Add("@SeqKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = prefix.SeqKBN
});
dic.Add("@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = prefix.ChangeDate
});
UseTransaction = true;
return(SelectData(dic, "M_Prefix_Display"));
}
private bool DisplayData()
{
prefixdata = new M_Prefix_Entity
{
StoreCD = cboStore.SelectedValue.ToString(),
SeqKBN = cboSeqKBN.SelectedValue.ToString(),
ChangeDate = txtDate.Text
};
dtStore = mtscbl.ShowPrefix(prefixdata);
if (dtStore.Rows.Count > 0)
{
txtPrefix.Text = dtStore.Rows[0]["Prefix"].ToString();
return(true);
}
else
{
mtscbl.ShowMessage("E133");
return(false);
}
}
public bool M_Prefix_Insert_Update(M_Prefix_Entity prefix, int mode)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>();
dic.Add("@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.StoreCD
});
dic.Add("@SeqKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = prefix.SeqKBN
});
dic.Add("@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = prefix.ChangeDate
});
dic.Add("@Prefix", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.Prefix
});
dic.Add("@Mode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mode.ToString()
});
dic.Add("@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.InsertOperator
});
dic.Add("@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.ProgramID
});
dic.Add("@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.PC
});
dic.Add("@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.ProcessMode
});
dic.Add("@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = prefix.Key
});
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "M_Prefix_Insert_Update"));
}
public bool M_Prefix_Delete(M_Prefix_Entity prefix)
{
return(MprefixDL.M_Prefix_Delete(prefix));
}
public bool M_Prefix_Insert_Update(M_Prefix_Entity prefix, int mode)
{
return(MprefixDL.M_Prefix_Insert_Update(prefix, mode));
}
public DataTable ShowPrefix(M_Prefix_Entity prefix)
{
return(MprefixDL.ShowPrefix(prefix));
}
