public Int32 GetVIPCardTradeList(string cardNo, DateTime beginDate, DateTime endDate, out VIPCardTradeRecord cardTradeRecord)
{
cardTradeRecord = new VIPCardTradeRecord();
VIPCard card = null;
try
{
_daoManager.OpenConnection();
card = _vipCardDao.GetVIPCard(cardNo);
}
catch (Exception exception)
{
LogHelper.GetInstance().Error(string.Format("[GetVIPCardTradeList]参数：cardNo_{0},beginDate_{1},endDate_{2}", cardNo, beginDate, endDate), exception);
}
finally
{
_daoManager.CloseConnection();
}
int result = 0;
if (card != null)
{
result = card.Status;
}
if (result == 1)
{
if (card != null)
{
cardTradeRecord.Balance = card.Balance;
cardTradeRecord.Integral = card.Integral;
cardTradeRecord.DiscountRate = card.DiscountRate;
}
cardTradeRecord.VIPCardTradeList = _vipCardTradeDao.GetVIPCardTradeList(cardNo, beginDate, endDate);
}
return(result);
}
private void btnSearch_Click(object sender, EventArgs e)
{
string cardNo = txtCardNo.Text.Trim();
if (string.IsNullOrEmpty(cardNo))
{
MessageBox.Show("请输入您的会员卡号！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string beginDate = dtBeginDate.Value.ToString("yyyy-MM-dd");
string endDate = dtEndDate.Value.ToString("yyyy-MM-dd");
VIPCardTradeRecord cardTradeRecord = null;
Int32 result = VIPCardTradeService.GetInstance().GetVIPCardTradeList(cardNo, beginDate, endDate, ref cardTradeRecord);
if (result == 1 && cardTradeRecord != null)
{
txtBalance.Text = cardTradeRecord.Balance.ToString("f2");
txtDiscount.Text = cardTradeRecord.DiscountRate.ToString("f2");
txtIntegral.Text = cardTradeRecord.Integral.ToString();
if (cardTradeRecord.VIPCardTradeList != null && cardTradeRecord.VIPCardTradeList.Count > 0)
{
dataGirdViewExt1.Rows.Clear();
foreach (VIPCardTrade item in cardTradeRecord.VIPCardTradeList)
{
int index = dataGirdViewExt1.Rows.Add();
dataGirdViewExt1.Rows[index].Cells["colCardNo"].Value = item.CardNo;
dataGirdViewExt1.Rows[index].Cells["colTradePayNo"].Value = item.TradePayNo;
string tradeType = " ";
if (item.TradeType == 1)
{
tradeType += "储值";
dataGirdViewExt1.Rows[index].Cells["colTradeType"].Style.ForeColor = Color.Green;
}
if (item.TradeType == 2)
{
tradeType += "储值赠送";
dataGirdViewExt1.Rows[index].Cells["colTradeType"].Style.ForeColor = Color.Green;
}
if (item.TradeType == 3)
{
tradeType += "消费";
dataGirdViewExt1.Rows[index].Cells["colTradeType"].Style.ForeColor = Color.Tomato;
}
dataGirdViewExt1.Rows[index].Cells["colTradeType"].Value = tradeType;
dataGirdViewExt1.Rows[index].Cells["colTradeAmount"].Value = item.TradeAmount;
dataGirdViewExt1.Rows[index].Cells["colTradeIntegral"].Value = item.TradeIntegral;
dataGirdViewExt1.Rows[index].Cells["colTradeTime"].Value = item.TradeTime.ToString("yyyy-MM-dd HH:mm");
dataGirdViewExt1.Rows[index].Cells["colOrderNo"].Value = item.OrderNo;
dataGirdViewExt1.Rows[index].Cells["colEmployeeNo"].Value = item.EmployeeNo;
}
}
else
{
dataGirdViewExt1.Rows.Clear();
txtCardNo.Text = string.Empty;
MessageBox.Show("找不到该卡号的交易记录！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
if (result == 0)
{
dataGirdViewExt1.Rows.Clear();
txtCardNo.Text = string.Empty;
MessageBox.Show("该卡未开通！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (result == 2)
{
dataGirdViewExt1.Rows.Clear();
txtCardNo.Text = string.Empty;
MessageBox.Show("该卡已挂失！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (result == 3)
{
dataGirdViewExt1.Rows.Clear();
txtCardNo.Text = string.Empty;
MessageBox.Show("该卡已锁卡！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (result == 4)
{
dataGirdViewExt1.Rows.Clear();
txtCardNo.Text = string.Empty;
MessageBox.Show("该卡已作废！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Int32 GetVIPCardTradeList(string cardNo, string beginDate, string endDate, ref VIPCardTradeRecord cardTradeRecord)
{
int cByte = ParamFieldLength.PACKAGE_HEAD + ParamFieldLength.CARD_NO + ParamFieldLength.BEGINDATE + ParamFieldLength.ENDDATE;
byte[] sendByte = new byte[cByte];
int byteOffset = 0;
Array.Copy(BitConverter.GetBytes((int)Command.ID_GET_VIPCARDTRADELIST), sendByte, BasicTypeLength.INT32);
byteOffset = BasicTypeLength.INT32;
Array.Copy(BitConverter.GetBytes(cByte), 0, sendByte, byteOffset, BasicTypeLength.INT32);
byteOffset += BasicTypeLength.INT32;
byte[] tempByte = null;
//cardNo
tempByte = Encoding.UTF8.GetBytes(cardNo);
Array.Copy(tempByte, 0, sendByte, byteOffset, tempByte.Length);
byteOffset += ParamFieldLength.CARD_NO;
//beginDate
tempByte = Encoding.UTF8.GetBytes(beginDate);
Array.Copy(tempByte, 0, sendByte, byteOffset, tempByte.Length);
byteOffset += ParamFieldLength.BEGINDATE;
//endDate
tempByte = Encoding.UTF8.GetBytes(endDate);
Array.Copy(tempByte, 0, sendByte, byteOffset, tempByte.Length);
byteOffset += ParamFieldLength.ENDDATE;
int result = 0;
using (SocketClient socket = new SocketClient(ConstantValuePool.BizSettingConfig.IPAddress, ConstantValuePool.BizSettingConfig.Port))
{
Byte[] receiveData = null;
Int32 operCode = socket.SendReceive(sendByte, out receiveData);
if (operCode == (int)RET_VALUE.SUCCEEDED)
{
result = BitConverter.ToInt32(receiveData, ParamFieldLength.PACKAGE_HEAD);
string strReceive = Encoding.UTF8.GetString(receiveData, ParamFieldLength.PACKAGE_HEAD + BasicTypeLength.INT32, receiveData.Length - ParamFieldLength.PACKAGE_HEAD - BasicTypeLength.INT32).Trim('\0');
cardTradeRecord = JsonConvert.DeserializeObject <VIPCardTradeRecord>(strReceive);
}
socket.Close();
}
return(result);
}
