private D_StoreCalculation_Entity GetStoreCalculation()
{
string date = DateTime.Today.ToString();
dsce = new D_StoreCalculation_Entity
{
StoreCD = StoreCD,
Change = txtChange.Text.Replace(",", ""),
Yen10000 = txt10000.Text.Replace(",", ""),
Yen5000 = txt5000.Text.Replace(",", ""),
Yen2000 = txt2000.Text.Replace(",", ""),
Yen1000 = txt1000.Text.Replace(",", ""),
Yen500 = txt500.Text.Replace(",", ""),
Yen100 = txt100.Text.Replace(",", ""),
Yen50 = txt50.Text.Replace(",", ""),
Yen10 = txt10.Text.Replace(",", ""),
Yen5 = txt5.Text.Replace(",", ""),
Yen1 = txt1.Text.Replace(",", ""),
EtcYen = txtotheramount.Text.Replace(",", ""),
InsertOperator = InOperatorCD,
ProgramID = InProgramID,
PC = InPcID
};
return(dsce);
}
private void InsertUpdate()
{
dsce = GetStoreCalculation();
if (seisanbl.D_StoreCalculation_Insert_Update(dsce))
{
chkDel.Enabled = true;
seisanbl.ShowMessage("I101");
}
}
public bool D_StoreCalculation_Insert_Update(D_StoreCalculation_Entity dsce)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dsce.StoreCD
} },
{ "@Change", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.Change
} },
{ "@10000yen", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.Yen10000
} },
{ "@5000yen", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.Yen5000
} },
{ "@2000yen", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.Yen2000
} },
{ "@1000yen", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.Yen1000
} },
{ "@500yen", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.Yen500
} },
{ "@100yen", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.Yen100
} },
{ "@50yen", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.Yen50
} },
{ "@10yen", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.Yen10
} },
{ "@5yen", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.Yen5
} },
{ "@1yen", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.Yen1
} },
{ "@etcyen", new ValuePair {
value1 = SqlDbType.Int, value2 = dsce.EtcYen
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dsce.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dsce.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dsce.PC
} },
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "D_StoreCalculation_Insert_Update"));
}
public DataTable D_Store_Calculation_SelectForSeiSan(D_StoreCalculation_Entity dsce)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dsce.StoreCD
} },
{ "@Date", new ValuePair {
value1 = SqlDbType.Date, value2 = dsce.CalculationDate
} },
};
UseTransaction = true;
return(SelectData(dic, "D_Store_Calculation_SelectForSeiSan"));
}
public bool D_StoreCalculation_Delete(D_StoreCalculation_Entity dsce)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dsce.StoreCD
} },
{ "@Date", new ValuePair {
value1 = SqlDbType.Date, value2 = dsce.CalculationDate
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dsce.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dsce.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dsce.PC
} },
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "D_Store_CalculationDelete"));
}
