public DataTransfer() { m_iResponseCode = RESPONSE_CODE_NONE; m_stResponseErrorMsg = ""; m_stResponseErrorMsgDetail = ""; m_stResponseDataString = ""; m_bResponseDataBool = false; m_dtoResponseDataCustomerDTO = null; m_dtoResponseDataCardDTO = null; m_dtoResponseDataGasStationDTO = null; m_dtoResponseDataRechargeDTO = null; m_dtoResponseDataSaleGasDTO = null; m_dtoResponseDataSystemAdminDTO = null; m_dtoResponseDataGasStoreDTO = null; m_dtoResponseDataGasStoreUpdateDTO = null; m_dsResponseDataSet = null; m_iCurrentPriceGas92 = 0; m_iCurrentPriceGas95 = 0; m_iCurrentPriceGasDO = 0; m_fGasStoreGas92Total = 0; m_fGasStoreGas95Total = 0; m_fGasStoreGasDOTotal = 0; }
public DataTransfer AddSaleGas(SaleGasDTO dtoSaleGas) { bool result = true; DataTransfer dataResult = new DataTransfer(); try { string query = string.Format("INSERT INTO SALE_GAS (SALEGAS_TYPE, SALEGAS_CURRENT_PRICE, SALEGAS_CARD_PRICE, SALEGAS_CARD_MONEY_BEFORE, SALEGAS_CARD_MONEY_AFTER, SALEGAS_CARD_MONEY_SAVING, SALEGAS_LIT, SALEGAS_DATE, GASSTATION_ID, CARD_ID)" + " VALUES (@SALEGAS_TYPE, @SALEGAS_CURRENT_PRICE, @SALEGAS_CARD_PRICE, @SALEGAS_CARD_MONEY_BEFORE, @SALEGAS_CARD_MONEY_AFTER, @SALEGAS_CARD_MONEY_SAVING, @SALEGAS_LIT, @SALEGAS_DATE, @GASSTATION_ID, @CARD_ID)"); SqlParameter[] sqlParameters = new SqlParameter[10]; sqlParameters[0] = new SqlParameter("@SALEGAS_TYPE", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(dtoSaleGas.SaleGasType); sqlParameters[1] = new SqlParameter("@SALEGAS_CURRENT_PRICE", SqlDbType.Int); sqlParameters[1].Value = Convert.ToInt32(dtoSaleGas.SaleGasCurrentPrice); sqlParameters[2] = new SqlParameter("@SALEGAS_CARD_PRICE", SqlDbType.Int); sqlParameters[2].Value = Convert.ToInt32(dtoSaleGas.SaleGasPriceOnCard); sqlParameters[3] = new SqlParameter("@SALEGAS_CARD_MONEY_BEFORE", SqlDbType.Int); sqlParameters[3].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneyBefore); sqlParameters[4] = new SqlParameter("@SALEGAS_CARD_MONEY_AFTER", SqlDbType.Int); sqlParameters[4].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneyAfter); sqlParameters[5] = new SqlParameter("@SALEGAS_LIT", SqlDbType.Float); sqlParameters[5].Value = Convert.ToDouble(dtoSaleGas.NumberBuyLit); sqlParameters[6] = new SqlParameter("@SALEGAS_DATE", SqlDbType.DateTime); sqlParameters[6].Value = (dtoSaleGas.SaleGasDate); sqlParameters[7] = new SqlParameter("@GASSTATION_ID", SqlDbType.NVarChar); sqlParameters[7].Value = Convert.ToString(dtoSaleGas.GasStationID); sqlParameters[8] = new SqlParameter("@CARD_ID", SqlDbType.NVarChar); sqlParameters[8].Value = Convert.ToString(dtoSaleGas.CardID); sqlParameters[9] = new SqlParameter("@SALEGAS_CARD_MONEY_SAVING", SqlDbType.Int); sqlParameters[9].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneySaving); result = m_dbConnection.ExecuteInsertQuery(query, sqlParameters); } catch (Exception ex) { result = false; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } if (result) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = 1 + SGMText.CARD_INSERT_ERR; } return dataResult; }
public SaleGasDTO GetSaleGas(int iSaleGasID) { SaleGasDTO dtoSaleGas = null; string query = string.Format("SELECT * FROM SALE_GAS WHERE SALEGAS_ID = @SALEGAS_ID"); SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@SALEGAS_ID", SqlDbType.Int); sqlParameters[0].Value = iSaleGasID; DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, sqlParameters); if (tblResult.Rows.Count > 0) { dtoSaleGas = new SaleGasDTO(); foreach (DataRow dr in tblResult.Rows) { dtoSaleGas.SaleGasID = Int32.Parse(dr["SALEGAS_ID"].ToString()); dtoSaleGas.SaleGasType = dr["SALEGAS_TYPE"].ToString(); dtoSaleGas.SaleGasCurrentPrice = Int32.Parse(dr["SALEGAS_CURRENT_PRICE"].ToString()); dtoSaleGas.SaleGasPriceOnCard = Int32.Parse(dr["SALEGAS_CARD_PRICE"].ToString()); dtoSaleGas.SaleGasCardMoneyBefore = Int32.Parse(dr["SALEGAS_CARD_MONEY_BEFORE"].ToString()); dtoSaleGas.SaleGasCardMoneyAfter = Int32.Parse(dr["SALEGAS_CARD_MONEY_AFTER"].ToString()); dtoSaleGas.GasStationID = dr["GASSTATION_ID"].ToString(); dtoSaleGas.SaleGasDate = DateTime.Parse(dr["SALEGAS_DATE"].ToString()); dtoSaleGas.CardID = dr["CARD_ID"].ToString(); dtoSaleGas.NumberBuyLit = float.Parse(dr["SALEGAS_LIT"].ToString()); } } return dtoSaleGas; }
public bool UpdateSaleGas(SaleGasDTO dtoSaleGas) { bool result = true; string query = string.Format("UPDATE SALE_GAS SET SALEGAS_TYPE = @SALEGAS_TYPE, SALEGAS_CURRENT_PRICE = @SALEGAS_CURRENT_PRICE, SALEGAS_CARD_PRICE = @SALEGAS_CARD_PRICE, " + " SALEGAS_CARD_MONEY_BEFORE = @SALEGAS_CARD_MONEY_BEFORE, SALEGAS_CARD_MONEY_AFTER = @SALEGAS_CARD_MONEY_AFTER, SALEGAS_CARD_MONEY_SAVING = @SALEGAS_CARD_MONEY_SAVING, SALEGAS_LIT = @SALEGAS_LIT, SALEGAS_DATE = @SALEGAS_DATE, GASSTATION_ID = @GASSTATION_ID, CARD_ID = @CARD_ID " + " WHERE SALEGAS_ID = @SALEGAS_ID"); SqlParameter[] sqlParameters = new SqlParameter[11]; sqlParameters[0] = new SqlParameter("@SALEGAS_ID", SqlDbType.Int); sqlParameters[0].Value = Convert.ToInt32(dtoSaleGas.SaleGasID); sqlParameters[1] = new SqlParameter("@SALEGAS_TYPE", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(dtoSaleGas.SaleGasType); sqlParameters[2] = new SqlParameter("@SALEGAS_CURRENT_PRICE", SqlDbType.Int); sqlParameters[2].Value = Convert.ToInt32(dtoSaleGas.SaleGasCurrentPrice); sqlParameters[3] = new SqlParameter("@SALEGAS_CARD_PRICE", SqlDbType.Int); sqlParameters[3].Value = Convert.ToInt32(dtoSaleGas.SaleGasPriceOnCard); sqlParameters[4] = new SqlParameter("@SALEGAS_CARD_MONEY_BEFORE", SqlDbType.Int); sqlParameters[4].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneyBefore); sqlParameters[5] = new SqlParameter("@SALEGAS_CARD_MONEY_AFTER", SqlDbType.Int); sqlParameters[5].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneyAfter); sqlParameters[6] = new SqlParameter("@SALEGAS_LIT", SqlDbType.Float); sqlParameters[6].Value = Convert.ToDouble(dtoSaleGas.NumberBuyLit); sqlParameters[7] = new SqlParameter("@SALEGAS_DATE", SqlDbType.DateTime); sqlParameters[7].Value = Convert.ToDateTime(dtoSaleGas.GasStationID); sqlParameters[8] = new SqlParameter("@GASSTATION_ID", SqlDbType.NVarChar); sqlParameters[8].Value = Convert.ToString(dtoSaleGas.GasStationID); sqlParameters[9] = new SqlParameter("@CARD_ID", SqlDbType.NVarChar); sqlParameters[9].Value = Convert.ToString(dtoSaleGas.CardID); sqlParameters[10] = new SqlParameter("@SALEGAS_CARD_MONEY_SAVING", SqlDbType.NVarChar); sqlParameters[10].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneySaving); result = m_dbConnection.ExecuteUpdateQuery(query, sqlParameters); return result; }
private void btnBuy_Click(object sender, EventArgs e) { m_iTimeOutReset = 0; if (txtMoney.Text == "0") { SGMHelper.ShowToolTip(txtMoney, SGMText.GAS_BUYING_INPUT_MONEY_INVALID); return; } SaleGasDTO dto = new SaleGasDTO(); dto.CardID = _cardDTO.CardID; dto.GasStationID = _gasStationDTO.GasStationID; dto.SaleGasType = rbGas92.Checked ? SaleGasDTO.GAS_TYPE_92 : rbGas95.Checked ? SaleGasDTO.GAS_TYPE_95 : SaleGasDTO.GAS_TYPE_DO; dto.SaleGasPriceOnCard = Int32.Parse(txtPrice.Text, System.Globalization.NumberStyles.Currency); dto.SaleGasCardMoneyBefore = Int32.Parse(txtMoneyBefore.Text, System.Globalization.NumberStyles.Currency); dto.SaleGasCardMoneyAfter = Int32.Parse(txtMoneyAfter.Text, System.Globalization.NumberStyles.Currency); dto.SaleGasCardMoneySaving = Int32.Parse(txtMoneySaving.Text, System.Globalization.NumberStyles.Currency); dto.SaleGasCurrentPrice = m_iCurrentPrice; dto.NumberBuyLit = float.Parse(txtGasBuying.Text, System.Globalization.NumberStyles.Currency); dto.GasStoreID = _gasStationDTO.GasStoreID; DataTransfer df = new DataTransfer(); df.ResponseDataSaleGasDTO = dto; Task<String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask( () => { return service.SGMSaleGas_GasBuying(JSonHelper.ConvertObjectToJSon(df)); }); SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () => { String stResponse = task.Result as String; DataTransfer dataResponse = JSonHelper.ConvertJSonToObject(stResponse); if (dataResponse.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS) { m_bBuy = true; //frmMsg.ShowMsg(SGMText.SGM_INFO, SGMText.GAS_BUYING_SUCCESS, SGMMessageType.SGM_MESSAGE_TYPE_INFO); // _cardDTO.CardRemainingMoney = _cardDTO.CardRemainingMoney - _moneyBuying; // txtCardMoney.Text = _cardDTO.CardRemainingMoney.ToString(MONEY_FORMAT); // calculatePay(); EnableTransaction(false, false); grBill.Text = SGMText.SALEGAS_MAIN_BILL + txtCardName.Text; txtCardID.Text = ""; txtCardMoney.Text = ""; txtMoney.Text = "0"; txtCardName.Text = ""; //rbGas92.Enabled = false; //rbGas95.Enabled = false; //rbGasDO.Enabled = false; } else { frmMsg.ShowMsg(SGMText.SGM_ERROR, dataResponse.ResponseErrorMsg + "\n" + dataResponse.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR); } }, SynchronizationContext.Current); }
private DataTransfer GasBuyingAddSaleGas(SaleGasDTO saleGasDTO) { SaleGasDAL dal = new SaleGasDAL(); return dal.AddSaleGas(saleGasDTO); }
private DataTransfer GasBuyingUpdateGasStore(SaleGasDTO saleGasDTO) { GasStoreDAL dal = new GasStoreDAL(); float money = saleGasDTO.SaleGasCardMoneyBefore - saleGasDTO.SaleGasCardMoneyAfter; float amount = money / saleGasDTO.SaleGasCurrentPrice; DataTransfer res = dal.UpdateGasStoreTotal(saleGasDTO.GasStoreID, saleGasDTO.SaleGasType, amount); return res; }