public DataTable D_StorePayment_Select(D_StorePayment_Entity dse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dse.StoreCD } }, { "@SalesNO", new ValuePair { value1 = SqlDbType.VarChar, value2 = dse.SalesNO } }, }; return(SelectData(dic, "D_StorePayment_Select")); }
public TempoRegiSiharaiTouroku(Base.Client.FrmMainForm.EOperationMode mode, D_Sales_Entity dse1, D_StorePayment_Entity dspe1, EPSON_TM30.CashDrawerOpen cdo, string Up, string Lp) { this.Up = Up; this.Lp = Lp; this.cdo = cdo; InitializeComponent(); ckmShop_Label7.Visible = false; lblZan.Visible = false; ShowCloseMessage = false; OperationMode = mode; dse = dse1; dspe = dspe1; }
public bool D_StorePayment_Select(D_StorePayment_Entity dse) { D_StorePayment_DL dl = new D_StorePayment_DL(); DataTable dt = dl.D_StorePayment_Select(dse); if (dt.Rows.Count > 0) { dse.PurchaseAmount = dt.Rows[0]["PurchaseAmount"].ToString(); dse.TaxAmount = dt.Rows[0]["TaxAmount"].ToString(); dse.DiscountAmount = dt.Rows[0]["DiscountAmount"].ToString(); dse.BillingAmount = dt.Rows[0]["BillingAmount"].ToString(); dse.PointAmount = dt.Rows[0]["PointAmount"].ToString(); dse.CardDenominationName = dt.Rows[0]["CardDenominationName"].ToString(); dse.CardDenominationCD = dt.Rows[0]["CardDenominationCD"].ToString(); dse.CardAmount = dt.Rows[0]["CardAmount"].ToString(); dse.CashAmount = dt.Rows[0]["CashAmount"].ToString(); dse.DepositAmount = dt.Rows[0]["DepositAmount"].ToString(); dse.RefundAmount = dt.Rows[0]["RefundAmount"].ToString(); dse.CreditAmount = dt.Rows[0]["CreditAmount"].ToString(); dse.DenominationName1 = dt.Rows[0]["DenominationName1"].ToString(); dse.Denomination1CD = dt.Rows[0]["Denomination1CD"].ToString(); dse.Denomination1Amount = dt.Rows[0]["Denomination1Amount"].ToString(); dse.DenominationName2 = dt.Rows[0]["DenominationName2"].ToString(); dse.Denomination2CD = dt.Rows[0]["Denomination2CD"].ToString(); dse.Denomination2Amount = dt.Rows[0]["Denomination2Amount"].ToString(); dse.AdvanceAmount = dt.Rows[0]["AdvanceAmount"].ToString(); dse.TotalAmount = dt.Rows[0]["TotalAmount"].ToString(); dse.SalesRate = dt.Rows[0]["SalesRate"].ToString(); return(true); } else { return(false); } }
public bool PRC_TempoRegiHanbaiTouroku(D_Sales_Entity dse, D_StorePayment_Entity dspe, DataTable dt, short operationMode) { TempoRegiHanbaiTouroku_DL dl = new TempoRegiHanbaiTouroku_DL(); return(dl.PRC_TempoRegiHanbaiTouroku(dse, dspe, dt, operationMode)); }
/// <summary> /// 店舗レジ出荷売上入力更新処理 /// TempoRegiHanbaiTourokuより更新時に使用 /// </summary> /// <param name="dse"></param> /// <param name="operationMode"></param> /// <returns></returns> public bool PRC_TempoRegiHanbaiTouroku(D_Sales_Entity dse, D_StorePayment_Entity dspe, DataTable dt, short operationMode) { string sp = "PRC_TempoRegiHanbaiTouroku"; command = new SqlCommand(sp, GetConnection()); command.CommandType = CommandType.StoredProcedure; command.CommandTimeout = 0; AddParam(command, "@OperateMode", SqlDbType.Int, operationMode.ToString()); AddParam(command, "@SalesNO", SqlDbType.VarChar, dse.SalesNO); AddParam(command, "@JuchuuNO", SqlDbType.VarChar, dse.JuchuuNO); AddParam(command, "@StoreCD", SqlDbType.VarChar, dse.StoreCD); AddParam(command, "@CustomerCD", SqlDbType.VarChar, dse.CustomerCD); AddParam(command, "@Age", SqlDbType.TinyInt, dse.Age); AddParam(command, "@CustomerChangeDate", SqlDbType.VarChar, dse.ChangeDate); AddParam(command, "@SalesRate", SqlDbType.Int, dspe.SalesRate); AddParam(command, "@AdvanceAmount", SqlDbType.Money, dspe.AdvanceAmount); AddParam(command, "@PointAmount", SqlDbType.Money, dspe.PointAmount); AddParam(command, "@CashAmount", SqlDbType.Money, dspe.CashAmount); AddParam(command, "@RefundAmount", SqlDbType.Money, dspe.RefundAmount); AddParam(command, "@DenominationCD", SqlDbType.VarChar, dspe.CardDenominationCD); AddParam(command, "@CardAmount", SqlDbType.Money, dspe.CardAmount); AddParam(command, "@Discount", SqlDbType.Money, dspe.DiscountAmount); AddParam(command, "@CreditAmount", SqlDbType.Money, dspe.CreditAmount); AddParam(command, "@Denomination1Amount", SqlDbType.Money, dspe.Denomination1Amount); AddParam(command, "@DenominationCD1", SqlDbType.VarChar, dspe.Denomination1CD); AddParam(command, "@Denomination2Amount", SqlDbType.Money, dspe.Denomination2Amount); AddParam(command, "@DenominationCD2", SqlDbType.VarChar, dspe.Denomination2CD); AddParam(command, "@DepositAmount", SqlDbType.Money, dspe.DepositAmount); AddParam(command, "@Keijobi", SqlDbType.VarChar, dse.SalesDate); AddParam(command, "@SalesGaku", SqlDbType.Money, dse.SalesGaku); AddParam(command, "@SalesTax", SqlDbType.Money, dse.SalesTax); AddParam(command, "@SalesHontaiGaku0", SqlDbType.Money, dse.SalesHontaiGaku0); AddParam(command, "@SalesHontaiGaku8", SqlDbType.Money, dse.SalesHontaiGaku8); AddParam(command, "@SalesHontaiGaku10", SqlDbType.Money, dse.SalesHontaiGaku10); AddParam(command, "@HanbaiTax10", SqlDbType.Money, dse.SalesTax10); AddParam(command, "@HanbaiTax8", SqlDbType.Money, dse.SalesTax8); AddParam(command, "@InvoiceGaku", SqlDbType.Money, dspe.BillingAmount); AddParam(command, "@Discount8", SqlDbType.Money, dse.Discount8); AddParam(command, "@Discount10", SqlDbType.Money, dse.Discount10); AddParam(command, "@DiscountTax", SqlDbType.Money, dse.DiscountTax); AddParam(command, "@DiscountTax8", SqlDbType.Money, dse.DiscountTax8); AddParam(command, "@DiscountTax10", SqlDbType.Money, dse.DiscountTax10); AddParam(command, "@TotalAmount", SqlDbType.Money, dspe.TotalAmount); AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt); AddParam(command, "@Operator", SqlDbType.VarChar, dse.Operator); AddParam(command, "@PC", SqlDbType.VarChar, dse.PC); //OUTパラメータの追加 string outPutParam = "@OutSalesNO"; command.Parameters.Add(outPutParam, SqlDbType.VarChar, 11); command.Parameters[outPutParam].Direction = ParameterDirection.Output; UseTransaction = true; bool ret = InsertUpdateDeleteData(sp, ref outPutParam); if (ret) { dse.SalesNO = outPutParam; } return(ret); }