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