public void RechargeCash(Model.VO.RechargeVO entity)
{
CustClubCardModule.ClubCardMgm clubCardMgm = new CustClubCardModule.ClubCardMgm();
int clubCardID = clubCardMgm.GetCardStatusByClubCardID(entity.ClubCardID);
if(clubCardID != Convert.ToInt32(ClubCardStatus.OpenCard))
{
throw new Exception("非有效会员卡，请联系后台管理员");
}
RechargeLogData rechargeLogData = new RechargeLogData();
ClubCardData clubCardData = new ClubCardData();
ClubCardPO clubCardPO = clubCardData.GetClubCardByID(entity.ClubCardID);
clubCardPO.Balance += entity.PlatformRechargeAmount;
SqlConnection conn = new SqlConnection(PubConstant.ConnectionString);
conn.Open();
SqlTransaction tx = conn.BeginTransaction();
try
{
//entity.RechargeSerialNo = SerialNoGenerator.GenRechargeSerialNo(entity.RechargeStore);
rechargeLogData.AddRechargeLog(Mapper.Map<RechargeVO, RechargeLogPO>(entity));
clubCardData.UpdateClubCard(clubCardPO);
tx.Commit();
}
catch
{
tx.Rollback();
throw new Exception("现金充值失败");
}
}
public string ConsumeCash(List<Model.VO.ConsumeVO> list)
{
string strBatchNo = "";
CustClubCardModule.ClubCardMgm clubCardMgm = new CustClubCardModule.ClubCardMgm();
int clubCardStat = clubCardMgm.GetCardStatusByClubCardID(list[0].ClubCardID);
if (clubCardStat != Convert.ToInt32(ClubCardStatus.OpenCard))
{
throw new Exception("非有效会员卡，请联系后台管理员");
}
ConsumeLogData consumeLogData = new ConsumeLogData();
ClubCardData clubCardData = new ClubCardData();
ClubCardPO clubCardPO = clubCardData.GetClubCardByID(list[0].ClubCardID);
SqlConnection conn = new SqlConnection(PubConstant.ConnectionString);
conn.Open();
SqlTransaction tx = conn.BeginTransaction();
int storeId = Convert.ToInt32(list.FirstOrDefault().Reserved1);
list.ForEach(itm => itm.Reserved1 = null);
try
{
decimal dConsumeAmount = 0.0M;
strBatchNo = SerialNoGenerator.GenConsumeBatchNo(storeId);
foreach (var item in list)
{
dConsumeAmount += item.OriginalPrice;
item.ConsumeBatchNo = strBatchNo;
consumeLogData.AddConsumeLog(Mapper.Map<ConsumeVO, ConsumeLogPO>(item));
}
clubCardPO.Balance = clubCardPO.Balance - dConsumeAmount;
clubCardData.UpdateClubCard(clubCardPO);
tx.Commit();
}
catch
{
tx.Rollback();
throw new Exception("会员现金消费失败");
}
return strBatchNo;
}
public string UpdatePwd(int clubCardID, string oldpwd, string newPwd)
{
IClubCardData carddal = new ClubCardData();
string restr;
var result = Mapper.Map<ClubCardPO, ClubCardVO>(carddal.GetCardByID(clubCardID, 0));
if (result == null)
{
restr = "当前会员卡不存在";
}
else
{
if (result.ClubCardPwd == StringHelper.MD5Encrypt(oldpwd))
{
try
{
result.ClubCardPwd = StringHelper.MD5Encrypt(newPwd);
carddal.UpdateClubCard(Mapper.Map<ClubCardVO, ClubCardPO>(result));
restr = null;
}
catch (Exception ex)
{
LogHandler.Error(ex.ToString());
restr = "出现错误，密码重置失败";
}
}
else
{
restr = "原始密码不正确";
}
}
return restr;
}
public void UpdatePwd(int clubCardID, string newPwd)
{
ClubCardData clubCardData = new ClubCardData();
ClubCardVO clubCardVO = GetClubCardByID(clubCardID);
string encryptPwd = PwdHelper.MD5Encrypt(newPwd);
clubCardVO.ClubCardPwd = encryptPwd;
clubCardData.UpdateClubCard(Mapper.Map<ClubCardVO, ClubCardPO>(clubCardVO));
}
public void UpdateClubCardStatus(int clubCardID, int status)
{
ClubCardData clubCardData = new ClubCardData();
ClubCardVO clubCardVO = GetClubCardByID(clubCardID);
if ((status != Convert.ToInt32(ClubCardStatus.OpenCard)) && (status != Convert.ToInt32(ClubCardStatus.ReportLoss)) && (status != Convert.ToInt32(ClubCardStatus.Froze)) && (status != Convert.ToInt32(ClubCardStatus.LogOff)) && (status != Convert.ToInt32(ClubCardStatus.Expire)))
{
throw new Exception("ClubCard Status invalid");
}
clubCardVO.CardStatus = status;
clubCardData.UpdateClubCard(Mapper.Map<ClubCardVO, ClubCardPO>(clubCardVO));
}
public void UpdateClubCardNo(int clubCardID, string newClubCardNo)
{
ClubCardData clubCardData = new ClubCardData();
ClubCardVO clubCardVO = GetClubCardByID(clubCardID);
if (string.IsNullOrEmpty(newClubCardNo.Trim()))
{
throw new Exception("New ClubCardNo cannot empty ");
}
clubCardVO.ClubCardNo = newClubCardNo;
clubCardVO.CardStatus = 0;
clubCardData.UpdateClubCard(Mapper.Map<ClubCardVO, ClubCardPO>(clubCardVO));
}