public List <Model.VO.ClubCardPkgDetailVO> GetDetailByClubCardPkgID(string id)
{
ClubCardData clubCardData = new ClubCardData();
List <ClubCardPkgDetailVO> clubCardPkgDetailVOList = new List <ClubCardPkgDetailVO>();
DataSet ds = clubCardData.GetDetailByClubCardPkgID(id);
List <ClubCardPackageDetailPO> clubCardPkgDetailPOList = ds.GetEntity <List <ClubCardPackageDetailPO> >();
if (clubCardPkgDetailPOList != null && clubCardPkgDetailPOList.Count > 0)
{
clubCardPkgDetailPOList.ForEach(i =>
{
clubCardPkgDetailVOList.Add(Mapper.Map <ClubCardPackageDetailPO, ClubCardPkgDetailVO>(i));
});
}
return(clubCardPkgDetailVOList);
}
public string ConsumePkg(List <Model.VO.ConsumeVO> list)
{
if (list.Count < 1)
{
throw new Exception("请选择套餐消费项目");
}
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();
DataSet ds = clubCardData.GetDetailByClubCardPkgID(list[0].ClubCardPackageID.ToString());
List <ClubCardPackageDetailPO> clubCardPkgDetailPOList = ds.GetEntity <List <ClubCardPackageDetailPO> >();
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
{
strBatchNo = SerialNoGenerator.GenConsumeBatchNo(storeId);
foreach (var item in list)
{
ClubCardPackageDetailPO tmpPkgDetail = null;
foreach (var item1 in clubCardPkgDetailPOList)
{
if (item.PackageDetailID == item1.PackageDetailID)
{
item1.RemainCount -= item.ConsumeCount;
tmpPkgDetail = item1;
item.ItemID = item1.ItemID;
break;
}
}
if (tmpPkgDetail == null)
{
throw new Exception("消费项目套餐中不存在");
}
ClubCardPackageData clubCardPackageData = new ClubCardPackageData();
clubCardPackageData.EditClubCardPkgDetail(tmpPkgDetail);
item.ConsumeBatchNo = strBatchNo;
consumeLogData.AddConsumeLog(Mapper.Map <ConsumeVO, ConsumeLogPO>(item));
}
if (clubCardPkgDetailPOList.Any(i => i.RemainCount == 0))
{
var cardPkg = new ClubCardPackageData();
var cardPkgData = cardPkg.GetClubCardPkgByID(list[0].ClubCardPackageID);
cardPkgData.PackageStatus = (int)CardSPackageStatus.Unavailable;
cardPkg.EditClubCardPkg(cardPkgData);
}
tx.Commit();
}
catch
{
tx.Rollback();
throw new Exception("会员套餐消费失败");
}
return(strBatchNo);
}