private float m_fGasStoreGasDOTotal; //total gasDO in store
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 bool UpdateRecharge(RechargeDTO dtoRecharge)
{
bool result = true;
string query = string.Format("UPDATE RECHARGE SET RECHARGE_DATE = @RECHARGE_DATE, RECHARGE_MONEY = @RECHARGE_MONEY, RECHARGE_MONEY_EX = @RECHARGE_MONEY_EX, RECHARGE_NOTE = @RECHARGE_NOTE, " +
" RECHARGE_GAS92_PRICE = @RECHARGE_GAS92_PRICE, RECHARGE_GAS95_PRICE = @RECHARGE_GAS95_PRICE, RECHARGE_GASDO_PRICE = @RECHARGE_GASDO_PRICE, CARD_ID = @CARD_ID " +
" WHERE RECHARGE_ID = @RECHARGE_ID"
);
SqlParameter[] sqlParameters = new SqlParameter[9];
sqlParameters[0] = new SqlParameter("@RECHARGE_DATE", SqlDbType.DateTime);
sqlParameters[0].Value = Convert.ToDateTime(dtoRecharge.RechargeDate);
sqlParameters[1] = new SqlParameter("@RECHARGE_GAS92_PRICE", SqlDbType.Int);
sqlParameters[1].Value = Convert.ToInt32(dtoRecharge.RechargeGas92Price);
sqlParameters[2] = new SqlParameter("@RECHARGE_GAS95_PRICE", SqlDbType.Int);
sqlParameters[2].Value = Convert.ToInt32(dtoRecharge.RechargeGas95Price);
sqlParameters[3] = new SqlParameter("@RECHARGE_GASDO_PRICE", SqlDbType.Int);
sqlParameters[3].Value = Convert.ToInt32(dtoRecharge.RechargeGasDOPrice);
sqlParameters[4] = new SqlParameter("@RECHARGE_MONEY", SqlDbType.Int);
sqlParameters[4].Value = Convert.ToInt32(dtoRecharge.RechargeMoney);
sqlParameters[5] = new SqlParameter("@RECHARGE_MONEY_EX", SqlDbType.Int);
sqlParameters[5].Value = Convert.ToInt32(dtoRecharge.RechargeMoneyEx);
sqlParameters[6] = new SqlParameter("@RECHARGE_NOTE", SqlDbType.NVarChar);
sqlParameters[6].Value = Convert.ToString(dtoRecharge.RechargeNote);
sqlParameters[7] = new SqlParameter("@RECHARGE_ID", SqlDbType.NVarChar);
sqlParameters[7].Value = Convert.ToString(dtoRecharge.RechargeID);
result = m_dbConnection.ExecuteUpdateQuery(query, sqlParameters);
return(result);
}
public RechargeDTO ToDTO(RechargeEntity recharge)
{
RechargeDTO reDTO = new RechargeDTO();
reDTO.ID = recharge.ID;
reDTO.UserID = recharge.UserID;
reDTO.RechargeableMoney = recharge.RechargeableMoney;
reDTO.AgentID = recharge.AgentID;
reDTO.YuAmount = recharge.YuAmount;
reDTO.Flag = recharge.Flag;
reDTO.RechargeDate = recharge.RechargeDate;
reDTO.Recharge001 = recharge.Recharge001;
reDTO.Recharge002 = recharge.Recharge002;
reDTO.Recharge003 = recharge.Recharge003;
reDTO.Recharge004 = recharge.Recharge004;
reDTO.Recharge005 = recharge.Recharge005;
reDTO.Recharge006 = recharge.Recharge006;
reDTO.UserCode = recharge.Users.UserCode;
reDTO.TrueName = recharge.Users.TrueName;
reDTO.CurrencyName = recharge.CurrencyNames.CurrencyName;
reDTO.CurrencyNameEn = recharge.CurrencyNames.CurrencyNameEn;
reDTO.StyleName = recharge.RechargeStyle == 1 ? "增加" : "减少";
return(reDTO);
}
public RechargeDTO GetRecharge(int iRechargeID)
{
RechargeDTO dtoRecharge = null;
string query = string.Format("SELECT * FROM RECHARGE WHERE RECHARGE_ID = @RECHARGE_ID");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@RECHARGE_ID", SqlDbType.Int);
sqlParameters[0].Value = Convert.ToInt32(iRechargeID);
DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, sqlParameters);
if (tblResult.Rows.Count > 0)
{
dtoRecharge = new RechargeDTO();
foreach (DataRow dr in tblResult.Rows)
{
dtoRecharge.RechargeID = Int32.Parse(dr["RECHARGE_ID"].ToString());
dtoRecharge.RechargeDate = DateTime.Parse(dr["RECHARGE_DATE"].ToString());
dtoRecharge.RechargeGas92Price = Int32.Parse(dr["RECHARGE_GAS92_PRICE"].ToString());
dtoRecharge.RechargeGas95Price = Int32.Parse(dr["RECHARGE_GAS95_PRICE"].ToString());
dtoRecharge.RechargeGasDOPrice = Int32.Parse(dr["RECHARGE_GASDO_PRICE"].ToString());
dtoRecharge.RechargeMoney = Int32.Parse(dr["RECHARGE_MONEY"].ToString());
dtoRecharge.RechargeMoneyEx = Int32.Parse(dr["RECHARGE_MONEY_EX"].ToString());
dtoRecharge.RechargeNote = dr["RECHARGE_NOTE"].ToString();
dtoRecharge.CardID = dr["CARD_ID"].ToString();
}
}
return(dtoRecharge);
}
/// <summary> 门店资金流审核
/// </summary>
/// <param name="saleFilialeId"></param>
/// <param name="rechargeDto"></param>
/// <returns></returns>
public static bool AuditingSettlement(Guid saleFilialeId, RechargeDTO rechargeDto)
{
using (var client = ClientProxy.CreateShopStoreWcfClient(saleFilialeId))
{
var result = client.Instance.AuditingSettlement(rechargeDto);
return(result != null && result.IsSuccess);
}
}
private void frmSGMSaleGas_Load(object sender, EventArgs e)
{
SGM_WaitingIdicator.WaitingForm.waitingFrm.SetParentForm(this);
serailReaderHandler = new SerialDataReceivedEventHandler(CardReaderReceivedHandler);
RFIDReader.RegistryReaderListener(Program.ReaderPort, serailReaderHandler);
_cardDTO = null;
_rechargeDTO = null;
txtMoney.Text = _moneyBuying.ToString(MONEY_FORMAT);
lblTitle.Text = _gasStationDTO.GasStationName;
resetForm();
lblCurrentPrice.Text = SGMText.SALEGAS_CURRENT_PRICE + SGMText.GAS_92_TEXT + " : " + m_iCurrentPriceGas92 + " - " + SGMText.GAS_95_TEXT + " : " + m_iCurrentPriceGas95 + " - " + SGMText.GAS_DO_TEXT + " : " + m_iCurrentPriceGasDO;
EnableTransaction(false, true);
}
public DataTransfer AddRecharge(RechargeDTO dtoRecharge)
{
DataTransfer dataResult = new DataTransfer();
bool insertResult = true;
try
{
string query = string.Format("INSERT INTO RECHARGE (RECHARGE_DATE, RECHARGE_GAS92_PRICE, RECHARGE_GAS95_PRICE, RECHARGE_GASDO_PRICE, RECHARGE_MONEY, RECHARGE_MONEY_EX, RECHARGE_NOTE, CARD_ID)" +
" VALUES (@RECHARGE_DATE, @RECHARGE_GAS92_PRICE, @RECHARGE_GAS95_PRICE, @RECHARGE_GASDO_PRICE, @RECHARGE_MONEY, @RECHARGE_MONEY_EX, @RECHARGE_NOTE, @CARD_ID)");
SqlParameter[] sqlParameters = new SqlParameter[8];
sqlParameters[0] = new SqlParameter("@RECHARGE_DATE", SqlDbType.DateTime);
sqlParameters[0].Value = Convert.ToDateTime(dtoRecharge.RechargeDate);
sqlParameters[1] = new SqlParameter("@RECHARGE_GAS92_PRICE", SqlDbType.Int);
sqlParameters[1].Value = Convert.ToInt32(dtoRecharge.RechargeGas92Price);
sqlParameters[2] = new SqlParameter("@RECHARGE_GAS95_PRICE", SqlDbType.Int);
sqlParameters[2].Value = Convert.ToInt32(dtoRecharge.RechargeGas95Price);
sqlParameters[3] = new SqlParameter("@RECHARGE_GASDO_PRICE", SqlDbType.Int);
sqlParameters[3].Value = Convert.ToInt32(dtoRecharge.RechargeGasDOPrice);
sqlParameters[4] = new SqlParameter("@RECHARGE_MONEY", SqlDbType.Int);
sqlParameters[4].Value = Convert.ToInt32(dtoRecharge.RechargeMoney);
sqlParameters[5] = new SqlParameter("@RECHARGE_MONEY_EX", SqlDbType.Int);
sqlParameters[5].Value = Convert.ToInt32(dtoRecharge.RechargeMoneyEx);
sqlParameters[6] = new SqlParameter("@RECHARGE_NOTE", SqlDbType.NVarChar);
sqlParameters[6].Value = Convert.ToString(dtoRecharge.RechargeNote);
sqlParameters[7] = new SqlParameter("@CARD_ID", SqlDbType.NVarChar);
sqlParameters[7].Value = Convert.ToString(dtoRecharge.CardID);
insertResult = m_dbConnection.ExecuteInsertQuery(query, sqlParameters);
}
catch (Exception ex)
{
insertResult = false;
dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace;
}
if (insertResult)
{
dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS;
}
else
{
dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL;
dataResult.ResponseErrorMsg = SGMText.CARD_RECHARGE_INSERT_ERR;
}
return(dataResult);
}
public string Recharge(decimal money, Guid accountId)
{
var account = this._IAccountService.GetByKey(accountId);
account.Balance += money;
var accountList = this._IAccountService.Update(new AccountDTOList {
account
});
var recharge = new RechargeDTO();
recharge.AccountId = accountId;
recharge.CreatedBy = recharge.ModifiedBy = this.User.Id;
recharge.Money = money;
this._IRechargeService.Create(recharge);
return(accountList.Count > 0 ? "充值成功！" : "充值失败！");
}
private void resetForm()
{
_cardDTO = null;
_rechargeDTO = null;
txtCardID.Text = "";
txtCardName.Text = "";
txtCardMoney.Text = 0.ToString(MONEY_FORMAT);
rbGas92.Checked = true;
txtMoney.Text = 0.ToString(MONEY_FORMAT);
grBill.Text = SGMText.SALEGAS_MAIN_BILL;
txtGasBuying.Text = 0.ToString(MONEY_FORMAT);
txtGasType.Text = "";
txtPrice.Text = 0.ToString(MONEY_FORMAT);
txtMoneyBefore.Text = 0.ToString(MONEY_FORMAT);
txtMoneyBuying.Text = 0.ToString(MONEY_FORMAT);
txtMoneyAfter.Text = 0.ToString(MONEY_FORMAT);
txtMoneySaving.Text = 0.ToString(MONEY_FORMAT);
}
private RechargeDTO ToDTO(RechargeEntity entity)
{
RechargeDTO dto = new RechargeDTO();
dto.CreateTime = entity.CreateTime;
dto.Id = entity.Id;
dto.UserID = entity.UserId;
dto.UserCode = entity.User.Mobile;
dto.RechargeableMoney = entity.RechargeableMoney;
dto.YuAmount = entity.YuAmount;
dto.Flag = entity.Flag;
dto.RechargeStyle = entity.RechargeStyle;
dto.RechargeDate = entity.RechargeDate;
dto.RechargeStyleName = entity.RechargeStyle == 1 ? "A积分" : entity.RechargeStyle == 2 ? "B积分" : entity.RechargeStyle == 3 ? "锁仓积分" :"";
dto.RechargeTypeName = entity.RechargeType == 1 ? "增加" : "减少";
dto.Recharge001Name = entity.Recharge001 == 0 ? "后台充值" : "";
dto.FlagName = entity.Flag == 1 ? "成功" : "失败";
return(dto);
}
private void btnUpdateCard_Click(object sender, EventArgs e)
{
if (ValidateDataInput())
{
DataTransfer response = null;
DataTransfer request = new DataTransfer();
Task <String> task;
if (m_bRecharge)
{
RechargeDTO dtoRecharge = new RechargeDTO();
dtoRecharge.RechargeDate = dtpRechargeDate.Value;
dtoRecharge.RechargeGas92Price = m_iPriceGas92;
dtoRecharge.RechargeGas95Price = m_iPriceGas95;
dtoRecharge.RechargeGasDOPrice = m_iPriceGasDO;
dtoRecharge.RechargeMoney = Int32.Parse(txtCardMoney.Text.Trim());
dtoRecharge.RechargeMoneyEx = Int32.Parse(txtExMoney.Text.Trim());
dtoRecharge.RechargeNote = txtRechargeNote.Text.Trim();
dtoRecharge.CardID = txtCardID.Text.Trim();
request.ResponseDataRechargeDTO = dtoRecharge;
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_AddRechargeCard(JSonHelper.ConvertObjectToJSon(request)));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_UpdateRechargeIDForCard(txtCardID.Text.Trim()));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_UpdateMoneyForCard(txtCardID.Text.Trim(), m_iCurrentCardMoney + Int32.Parse(txtCardMoney.Text.Trim()) + Int32.Parse(txtExMoney.Text.Trim())));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
this.Close();
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
else
{
CardDTO dtoCard = new CardDTO();
dtoCard.CardID = txtCardID.Text.Trim();
dtoCard.CardUnlockState = true;
dtoCard.CardRemainingMoney = Int32.Parse(txtCardMoney.Text.Trim());
dtoCard.CardMoneyEx = 0;
dtoCard.CardBuyDate = dtpRechargeDate.Value;
dtoCard.RechargeID = -1;
dtoCard.CustomerID = m_stCusID;
request.ResponseDataCardDTO = dtoCard;
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_AddNewCard(JSonHelper.ConvertObjectToJSon(request)));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
RechargeDTO dtoRecharge = new RechargeDTO();
dtoRecharge.RechargeDate = dtpRechargeDate.Value;
dtoRecharge.RechargeGas92Price = m_iPriceGas92;
dtoRecharge.RechargeGas95Price = m_iPriceGas95;
dtoRecharge.RechargeGasDOPrice = m_iPriceGasDO;
dtoRecharge.RechargeMoney = Int32.Parse(txtCardMoney.Text.Trim());
dtoRecharge.RechargeNote = txtRechargeNote.Text.Trim();
dtoRecharge.CardID = txtCardID.Text.Trim();
request.ResponseDataRechargeDTO = dtoRecharge;
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
if (m_bChangeCard)
{
return(m_service.SGMManager_ChangeCard(m_stCardID, JSonHelper.ConvertObjectToJSon(request)));
}
else
{
return(m_service.SGMManager_AddRechargeCard(JSonHelper.ConvertObjectToJSon(request)));
}
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_UpdateRechargeIDForCard(txtCardID.Text.Trim()));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
this.Close();
}
else
{
frmMsg.ShowMsg(SGMText.SGM_ERROR, response.ResponseErrorMsg + " : " + response.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR);
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
}
}
private void ScanCard(string cardId)
{
Task <String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() => {
return(service.SGMSaleGas_ValidateCardId(cardId));
});
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)
{
EnableTransaction(true, true);
using (DataSet ds = dataResponse.ResponseDataSet)
{
DataTable tblCard = ds.Tables[0];
if (tblCard.Rows.Count == 1)
{
clearForm();
_cardDTO = new CardDTO();
_rechargeDTO = new RechargeDTO();
foreach (DataRow dr in tblCard.Rows)
{
_cardDTO.CardID = dr["CARD_ID"].ToString();;
_cardDTO.CardUnlockState = Boolean.Parse(dr["CARD_STATE"].ToString());
_cardDTO.CardRemainingMoney = Int32.Parse(dr["CARD_MONEY"].ToString());
_cardDTO.CardBuyDate = DateTime.Parse(dr["CARD_BUY_DATE"].ToString());
_cardDTO.RechargeID = Int32.Parse(dr["RECHARGE_ID"].ToString());
_cardDTO.CardMoneyEx = Int32.Parse(dr["CARD_MONEY_EX"].ToString());
_cardDTO.CustomerID = dr["CUS_ID"].ToString();
_rechargeDTO.RechargeID = Int32.Parse(dr["RECHARGE_ID"].ToString());
_rechargeDTO.RechargeDate = DateTime.Parse(dr["RECHARGE_DATE"].ToString());
_rechargeDTO.RechargeGas92Price = Int32.Parse(dr["RECHARGE_GAS92_PRICE"].ToString());
_rechargeDTO.RechargeGas95Price = Int32.Parse(dr["RECHARGE_GAS95_PRICE"].ToString());
_rechargeDTO.RechargeGasDOPrice = Int32.Parse(dr["RECHARGE_GASDO_PRICE"].ToString());
_rechargeDTO.RechargeMoney = Int32.Parse(dr["RECHARGE_MONEY"].ToString());
_rechargeDTO.RechargeNote = dr["RECHARGE_MONEY"].ToString();
_rechargeDTO.CardID = dr["CARD_ID"].ToString();
txtCardName.Text = dr["CUS_NAME"].ToString();
}
//txtCardID.Text = _cardDTO.CardID;
txtCardMoney.Text = _cardDTO.CardRemainingMoney.ToString(MONEY_FORMAT);
// get name customer
updateGasChoice(rbGas92.Checked ? gasTransactType.gas92 : rbGas95.Checked?gasTransactType.gas95: gasTransactType.gasDO);
if (_cardDTO.CardUnlockState == false)
{
frmMsg.ShowMsg(SGMText.SGM_INFO, SGMText.GAS_CARD_LOCK, SGMMessageType.SGM_MESSAGE_TYPE_INFO);
//_cardDTO = null;
//_rechargeDTO = null;
EnableTransaction(false, true);
}
grBill.Text = SGMText.SALEGAS_MAIN_BILL;
btnCardDetail.Enabled = true;
m_bBuy = false;
txtMoney.Focus();
m_iTimeOutReset = 0;
}
else
{
// >>>
}
}
}
else
{
resetForm();
frmMsg.ShowMsg(SGMText.SGM_ERROR, dataResponse.ResponseErrorMsg, SGMMessageType.SGM_MESSAGE_TYPE_ERROR);
EnableTransaction(false, true);
}
}, SynchronizationContext.Current);
}
public frmSGMCardDetail(CardDTO cardDTO, RechargeDTO rechargeDTO)
{
InitializeComponent();
m_dtoCard = cardDTO;
m_dtoRecharge = rechargeDTO;
}