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 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 ConsumeForNoCard(List <Model.VO.ConsumeVO> list)
{
if (list.Count < 1)
{
throw new Exception("请选择消费项目");
}
string strBatchNo = "";
CustClubCardModule.ClubCardMgm clubCardMgm = new CustClubCardModule.ClubCardMgm();
ClubCardVO clubCardVO = clubCardMgm.GetClubCardByID(list[0].ClubCardID);
if (clubCardVO.ClubCardNo.Trim() != "")
{
throw new Exception("会员卡用户，请选择会员消费");
}
ConsumeLogData consumeLogData = new ConsumeLogData();
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));
}
tx.Commit();
}
catch
{
tx.Rollback();
throw new Exception("非会员现金消费失败");
}
return(strBatchNo);
}
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 ConsumeForNoCard(List<Model.VO.ConsumeVO> list)
{
if (list.Count < 1)
{
throw new Exception("请选择消费项目");
}
string strBatchNo = "";
CustClubCardModule.ClubCardMgm clubCardMgm = new CustClubCardModule.ClubCardMgm();
ClubCardVO clubCardVO = clubCardMgm.GetClubCardByID(list[0].ClubCardID);
if (clubCardVO.ClubCardNo.Trim() != "" )
{
throw new Exception("会员卡用户，请选择会员消费");
}
ConsumeLogData consumeLogData = new ConsumeLogData();
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));
}
tx.Commit();
}
catch
{
tx.Rollback();
throw new Exception("非会员现金消费失败");
}
return strBatchNo;
}
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 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;
}
public int RechargePkg(Model.VO.RechargeVO entity)
{
//尚需完善
CustClubCardModule.ClubCardMgm clubCardMgm = new CustClubCardModule.ClubCardMgm();
int clubCardState = clubCardMgm.GetCardStatusByClubCardID(entity.ClubCardID);
if (clubCardState != Convert.ToInt32(ClubCardStatus.OpenCard))
{
throw new Exception("非有效会员卡，请联系后台管理员");
}
RechargeLogData rechargeLogData = new RechargeLogData();
ClubCardPackagePO clubCardPkgPO = new ClubCardPackagePO();
List <ClubCardPackageDetailPO> clubCardPkgDetailPOList = new List <ClubCardPackageDetailPO>();
ClubCardPackageData clubCardPkgData = new ClubCardPackageData();
MarktingPlanModule.PackageMgm pkgMgm = new MarktingPlanModule.PackageMgm();
MarktingPlanModule.IPkgItemsMgm pkgItemsMgm = new MarktingPlanModule.PkgItemsMgm();
//PackageData packageData = new PackageData();
//PkgItemsData pkgItemsData = new PkgItemsData();
PackageVO packageVO = pkgMgm.GetPackageByID(Convert.ToInt32(entity.ClubCardPackageID));//此处ClubCardPackageID即为PackageID
PackagePO packagePO = Mapper.Map <PackageVO, PackagePO>(packageVO);
List <PkgItemVO> pkgItemList = pkgItemsMgm.GetItemsByPkgID(packagePO.PackageID);
clubCardPkgPO.PackageID = packagePO.PackageID;
clubCardPkgPO.ClubCardID = entity.ClubCardID;
clubCardPkgPO.PackageName = packagePO.PackageName;
clubCardPkgPO.OriginalAmount = entity.PlatformRechargeAmount;
clubCardPkgPO.ActualAmount = entity.ActualRechargeAmount;
clubCardPkgPO.DiscountRate = entity.DiscountRate;
clubCardPkgPO.DiscountInfo = entity.DiscountInfo;
clubCardPkgPO.DiscountRate = Convert.ToDecimal(CardSPackageStatus.Available);
clubCardPkgPO.Salesman = entity.SalesMan;
clubCardPkgPO.SalesTime = DateTime.Now;
clubCardPkgPO.SaleStore = entity.RechargeStore;//从login信息中获取
clubCardPkgPO.CreatedDate = DateTime.Now;
clubCardPkgPO.CreatorID = entity.CreatorID;
clubCardPkgPO.LastModifiedDate = DateTime.Now;
clubCardPkgPO.LastModifierID = entity.LastModifierID;
clubCardPkgPO.ClubCardPackageID = SerialNoGenerator.GenClubCardPkgID();
foreach (var item in pkgItemList)
{
ClubCardPackageDetailPO clubCardPkgDetailPO = new ClubCardPackageDetailPO();
clubCardPkgDetailPO.ClubCardPackageID = clubCardPkgPO.ClubCardPackageID;
clubCardPkgDetailPO.ItemID = item.ItemID;
clubCardPkgDetailPO.ItemName = item.ItemName;
clubCardPkgDetailPO.OriginalCount = item.ConsumeCount;//消费项目次数
clubCardPkgDetailPO.RemainCount = item.ConsumeCount;
clubCardPkgDetailPO.CreatedDate = DateTime.Now;
clubCardPkgDetailPO.CreatorID = entity.CreatorID;
clubCardPkgDetailPO.LastModifiedDate = DateTime.Now;
clubCardPkgDetailPO.LastModifierID = entity.LastModifierID;
clubCardPkgDetailPOList.Add(clubCardPkgDetailPO);
}
ClubCardData clubCardData = new ClubCardData();
ClubCardPO clubCardPO = clubCardData.GetClubCardByID(entity.ClubCardID);
clubCardPO.Balance = clubCardPO.Balance + entity.PlatformRechargeAmount;
clubCardPO.LastModifiedDate = DateTime.Now;
clubCardPO.LastModifierID = entity.LastModifierID;
SqlConnection conn = new SqlConnection(PubConstant.ConnectionString);
conn.Open();
SqlTransaction tx = conn.BeginTransaction();
try
{
clubCardPkgData.AddClubCardPkg(clubCardPkgPO);
clubCardPkgData.AddClubCardPkgDetailList(clubCardPkgDetailPOList);
// entity.RechargeSerialNo = SerialNoGenerator.GenRechargeSerialNo(entity.RechargeStore);
rechargeLogData.AddRechargeLog(Mapper.Map <RechargeVO, RechargeLogPO>(entity));
tx.Commit();
}
catch
{
tx.Rollback();
throw new Exception("套餐充值失败");
}
return(1);
}
public int RechargePkg(Model.VO.RechargeVO entity)
{
//尚需完善
CustClubCardModule.ClubCardMgm clubCardMgm = new CustClubCardModule.ClubCardMgm();
int clubCardState = clubCardMgm.GetCardStatusByClubCardID(entity.ClubCardID);
if (clubCardState != Convert.ToInt32(ClubCardStatus.OpenCard))
{
throw new Exception("非有效会员卡，请联系后台管理员");
}
RechargeLogData rechargeLogData = new RechargeLogData();
ClubCardPackagePO clubCardPkgPO = new ClubCardPackagePO();
List<ClubCardPackageDetailPO> clubCardPkgDetailPOList = new List<ClubCardPackageDetailPO>();
ClubCardPackageData clubCardPkgData = new ClubCardPackageData();
MarktingPlanModule.PackageMgm pkgMgm = new MarktingPlanModule.PackageMgm();
MarktingPlanModule.IPkgItemsMgm pkgItemsMgm = new MarktingPlanModule.PkgItemsMgm();
//PackageData packageData = new PackageData();
//PkgItemsData pkgItemsData = new PkgItemsData();
PackageVO packageVO = pkgMgm.GetPackageByID(Convert.ToInt32(entity.ClubCardPackageID));//此处ClubCardPackageID即为PackageID
PackagePO packagePO = Mapper.Map<PackageVO, PackagePO>(packageVO);
List<PkgItemVO> pkgItemList = pkgItemsMgm.GetItemsByPkgID(packagePO.PackageID);
clubCardPkgPO.PackageID = packagePO.PackageID;
clubCardPkgPO.ClubCardID = entity.ClubCardID;
clubCardPkgPO.PackageName = packagePO.PackageName;
clubCardPkgPO.OriginalAmount = entity.PlatformRechargeAmount;
clubCardPkgPO.ActualAmount = entity.ActualRechargeAmount;
clubCardPkgPO.DiscountRate = entity.DiscountRate;
clubCardPkgPO.DiscountInfo = entity.DiscountInfo;
clubCardPkgPO.DiscountRate = Convert.ToDecimal(CardSPackageStatus.Available);
clubCardPkgPO.Salesman = entity.SalesMan;
clubCardPkgPO.SalesTime = DateTime.Now;
clubCardPkgPO.SaleStore = entity.RechargeStore;//从login信息中获取
clubCardPkgPO.CreatedDate = DateTime.Now;
clubCardPkgPO.CreatorID = entity.CreatorID;
clubCardPkgPO.LastModifiedDate = DateTime.Now;
clubCardPkgPO.LastModifierID =entity.LastModifierID;
clubCardPkgPO.ClubCardPackageID = SerialNoGenerator.GenClubCardPkgID();
foreach (var item in pkgItemList)
{
ClubCardPackageDetailPO clubCardPkgDetailPO = new ClubCardPackageDetailPO();
clubCardPkgDetailPO.ClubCardPackageID = clubCardPkgPO.ClubCardPackageID;
clubCardPkgDetailPO.ItemID = item.ItemID;
clubCardPkgDetailPO.ItemName = item.ItemName;
clubCardPkgDetailPO.OriginalCount = item.ConsumeCount;//消费项目次数
clubCardPkgDetailPO.RemainCount = item.ConsumeCount;
clubCardPkgDetailPO.CreatedDate = DateTime.Now;
clubCardPkgDetailPO.CreatorID = entity.CreatorID;
clubCardPkgDetailPO.LastModifiedDate = DateTime.Now;
clubCardPkgDetailPO.LastModifierID = entity.LastModifierID;
clubCardPkgDetailPOList.Add(clubCardPkgDetailPO);
}
ClubCardData clubCardData = new ClubCardData();
ClubCardPO clubCardPO = clubCardData.GetClubCardByID(entity.ClubCardID);
clubCardPO.Balance = clubCardPO.Balance + entity.PlatformRechargeAmount;
clubCardPO.LastModifiedDate = DateTime.Now;
clubCardPO.LastModifierID = entity.LastModifierID;
SqlConnection conn = new SqlConnection(PubConstant.ConnectionString);
conn.Open();
SqlTransaction tx = conn.BeginTransaction();
try
{
clubCardPkgData.AddClubCardPkg(clubCardPkgPO);
clubCardPkgData.AddClubCardPkgDetailList(clubCardPkgDetailPOList);
// entity.RechargeSerialNo = SerialNoGenerator.GenRechargeSerialNo(entity.RechargeStore);
rechargeLogData.AddRechargeLog(Mapper.Map<RechargeVO, RechargeLogPO>(entity));
tx.Commit();
}
catch
{
tx.Rollback();
throw new Exception("套餐充值失败");
}
return 1;
}
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);
}