public ActionResult ClubcardDetails(int id, string type)
{
CustomerAndCard cusAndCard = new CustomerAndCard();
CustomerMgm custMgm = new CustomerMgm();
ClubCardMgm cardMgm = new ClubCardMgm();
var ddllist = GetddlList(DDLlist.CardType, false, null, null);
ViewData["CardType"] = ddllist;
if (type == "cust")
{
var recust = custMgm.GetCustomerByID(id);
ClubCardVO recard = new ClubCardVO();
if (recust.CardFlag == 1)
{
recard = cardMgm.GetClubCardByCustID(recust.CustomerID);
}
cusAndCard = GetCusAndCardModel(recard, recust);
}
else if (type == "card")
{
var recard = cardMgm.GetClubCardByID(id);
var recust = custMgm.GetCustomerByID(recard.CustomerID);
cusAndCard = GetCusAndCardModel(recard, recust);
}
return(View(cusAndCard));
}
public ActionResult ChangeCardNo(int id)
{
IClubCardMgm cardMgm = new ClubCardMgm();
ClubCardVO card = cardMgm.GetClubCardByID(id);
return(View(card));
}
public ActionResult SetCardStatus(int id)
{
IClubCardMgm cardMgm = new ClubCardMgm();
ClubCardVO card = cardMgm.GetClubCardByID(id);
return(View(card));
}
public void TestMethod3()
{
//add ClubCard
ClubCardVO clubCardVO = new ClubCardVO();
clubCardVO.Balance = 0.0M;
clubCardVO.Birthday = "19860909";
clubCardVO.CardStatus = 0;
clubCardVO.ClubCardNo = "00001";
clubCardVO.ClubCardPwd = "11111";
clubCardVO.ClubCardTypeID = 1;
clubCardVO.ClubCardTypeName = "金卡";
clubCardVO.CustName = "tianx";
clubCardVO.CustomerID = 1;
clubCardVO.ExpireDate = DateTime.Parse("2025/09/09 12:00");
clubCardVO.SalesMan = "songge";
clubCardVO.SalesTime = DateTime.Parse("2015/09/09 12:00");
clubCardVO.OpenCardStore = "minhangqu";
clubCardVO.CreatedDate = DateTime.Now;
clubCardVO.CreatorID = "001";
clubCardVO.LastModifiedDate = DateTime.Now;
clubCardVO.LastModifierID = "002";
clubCardVO.LogicalStatus = 1;
clubCardVO.PackageDiscount = 0.8M;
clubCardVO.PayDiscount = 0.2M;
//VO to PO
Mapper.CreateMap <ClubCardVO, ClubCardPO>();
ClubCardMgm clubMgm = new ClubCardMgm();
clubMgm.AddClubCard(clubCardVO);
}
public ActionResult ResetPassword(int id)
{
IClubCardMgm cardMgm = new ClubCardMgm();
ClubCardVO card = cardMgm.GetClubCardByID(id);
return(View(card));
}
public JsonResult SearchCustomer(string carno)
{
ICustomerMgm custMgm = new CustomerMgm();
//改为车牌号查询
//CustomerVO cust = custMgm.GetCustomerByMobileNo(mobilno);
//ClubCardVO card = new ClubCardMgm().GetClubCardByCustID(cust.CustomerID);
var cust = custMgm.GetCustomerByCarNo(carno);
ClubCardVO card = new ClubCardMgm().GetClubCardByCustID(cust.CustomerID);
ReturnedData data = new ReturnedData();
if (cust.CustomerID == 0)
{
data.Success = false;
data.Message = "该车牌号没有客户";
}
else
{
data.Success = true;
}
if (card == null)
{
card = new ClubCardVO();
}
CustomerAndCard custandcard = GetCusAndCardModel(card, cust);
data.Data = custandcard;
return(Json(data, JsonRequestBehavior.AllowGet));
}
private List <ConsumeVO> GetConsumeList(List <ConsumePkgViewModel> list, ClubCardVO card, ConsumeType conType)
{
List <ConsumeVO> conList = new List <ConsumeVO>();
DateTime date = DateTime.Now;
list.ForEach(item =>
{
conList.Add(new ConsumeVO
{
ItemID = 0,
ItemName = item.ItemName,
ConsumeStore = Emp.StroeName,
ConsumeCount = item.ItemConNum,
OriginalPrice = 0,
CreatedDate = date,
CreatorID = Emp.UserName,
LastModifiedDate = date,
LastModifierID = Emp.UserName,
ConsumeDate = date,
ConsumeType = (int)conType,
ClubCardPackageID = item.PkgId,
PackageDetailID = item.ItemId,
ClubCardNo = card.ClubCardNo,
ClubCardID = card.ClubCardID,
CustID = card.CustomerID,
CustName = card.CustName,
OriginalStore = card.OpenCardStore,
RemainCount = 0,
Reserved1 = Emp.StoreId.ToString()
});
});
return(conList);
}
public JsonResult ChangeCardNoSub(int id, string CardNo)
{
IClubCardMgm cardMgm = new ClubCardMgm();
ReturnedData data = new ReturnedData();
try
{
ClubCardVO card = cardMgm.GetClubCardByID(id);
if (card.CardStatus == 1)
{
cardMgm.UpdateClubCardNo(id, CardNo);
data.Success = true;
data.Message = "会员卡补卡成功";
}
else
{
data.Success = false;
data.Message = "该会员卡不处于挂失状态，不需要补卡";
}
}
catch (Exception ex)
{
LogHandler.Error(ex.ToString());
data.Success = false;
data.Message = "会员卡补卡成功";
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
public Model.VO.ClubCardVO GetClubCardByID(int id)
{
ClubCardData clubCardData = new ClubCardData();
ClubCardVO clubCardVO = new ClubCardVO();
ClubCardPO clubCardPO = clubCardData.GetClubCardByID(id);
clubCardVO = Mapper.Map <ClubCardPO, ClubCardVO>(clubCardPO);
return(clubCardVO);
}
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 JsonResult SearchCustomerAndCard()
{
string mobileno = NullHelper.Convert <string>(Request["MobileNo"], "");
string cardNo = NullHelper.Convert <string>(Request["CardNo"], "");
ReturnedData data = new ReturnedData();
if (!string.IsNullOrEmpty(mobileno) || !string.IsNullOrEmpty(cardNo))
{
ICustomerMgm custMgm = new CustomerMgm();
IClubCardMgm cardMgm = new ClubCardMgm();
//有缺陷
if (!string.IsNullOrEmpty(mobileno))
{
CustomerVO cust = custMgm.GetCustomerByMobileNo(mobileno);
if (cust != null)
{
ClubCardVO card = cardMgm.GetClubCardByCustID(cust.CustomerID);
data.Data = GetCusAndCardModel(card, cust);
data.Success = true;
}
else
{
data.Success = false;
data.Message = "当前手机号无用户";
}
}
else if (!string.IsNullOrEmpty(cardNo))
{
ClubCardVO card = cardMgm.GetClubCardByCardNo(cardNo);
if (card != null)
{
CustomerVO cust = custMgm.GetCustomerByID(card.CustomerID);
data.Data = GetCusAndCardModel(card, cust);
data.Success = true;
}
else
{
data.Success = false;
data.Message = "当前会员卡号无用户";
}
}
}
else
{
data.Success = false;
data.Message = "请输入会员卡号或用户手机号码";
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
public bool CheckPwd(int clubCardID, string pwd)
{
ClubCardVO clubCardVO = GetClubCardByID(clubCardID);
string dbPwd = clubCardVO.ClubCardPwd;
string encryptPwd = PwdHelper.MD5Encrypt(pwd);
if (encryptPwd.CompareTo(dbPwd) == 0)
{
return(true);
}
else
{
return(false);
}
}
//
// GET: /ClubcardRecharge/
public ActionResult Index()
{
int id = NullHelper.Convert <int>(Request["id"], 0);
CustomerAndCard cuscard = new CustomerAndCard();
if (id > 0)
{
IClubCardMgm cardMgm = new ClubCardMgm();
ClubCardVO card = cardMgm.GetClubCardByID(id);
ICustomerMgm custMgm = new CustomerMgm();
CustomerVO cust = custMgm.GetCustomerByID(card.CustomerID);
cuscard = GetCusAndCardModel(card, cust);
}
return(View(cuscard));
}
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));
}
private ClubCardVO GetCardModel(CustomerAndCard cusandcard)
{
ClubCardVO clubcard = new ClubCardVO()
{
CustomerID = cusandcard.CustID,
CustName = cusandcard.CustName,
ClubCardID = cusandcard.CardID,
ClubCardNo = cusandcard.CardNo,
ClubCardTypeID = cusandcard.CardType,
SalesMan = cusandcard.SaleMan,
OpenCardStore = cusandcard.OpenCardStore,
CardStatus = cusandcard.CardStatu
};
return(clubcard);
}
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);
}
private CustomerAndCard GetCusAndCardModel(ClubCardVO recard, CustomerVO recust)
{
if (recard != null && recust != null)
{
CustomerAndCard cuandcard = new CustomerAndCard()
{
CustID = recust.CustomerID,
CustName = recust.Name,
ICNo = recust.ICNo,
MobileNo = recust.MobileNO,
Birthday = recust.Birthday,
CardID = recard.ClubCardID,
CardNo = recard.ClubCardNo,
CardType = recard.ClubCardTypeID,
CardStatu = recard.CardStatus,
OpenCardStore = recard.OpenCardStore,
SaleMan = recard.SalesMan,
SaleTime = recard.SalesTime,
ExpireDate = recard.ExpireDate
};
cuandcard.CardTypeName = recard.ClubCardTypeName;
switch (recard.CardStatus)
{
case (int)ClubCardStatus.OpenCard: cuandcard.CardStatuName = "开卡";
break;
case (int)ClubCardStatus.Expire: cuandcard.CardStatuName = "过期";
break;
case (int)ClubCardStatus.Froze: cuandcard.CardStatuName = "冻结";
break;
case (int)ClubCardStatus.LogOff: cuandcard.CardStatuName = "注销";
break;
case (int)ClubCardStatus.ReportLoss: cuandcard.CardStatuName = "挂失";
break;
}
return(cuandcard);
}
return(new CustomerAndCard());
}
//
// GET: /ClubcardConsume/
public ActionResult Index()
{
ViewData["ConItem"] = GetddlList(DDLlist.PkgItem, false, null, null, null);
//ViewData["CardPkgItem"]=GetddlList(DDLlist.CardPkg,null,null,null,)
int id = NullHelper.Convert <int>(Request["id"], 0);
ViewBag.StoreName = Emp.StroeName;
ViewBag.Recivor = Emp.UserName;
CustomerAndCard cuscard = new CustomerAndCard();
if (id > 0)
{
IClubCardMgm cardMgm = new ClubCardMgm();
ClubCardVO card = cardMgm.GetClubCardByID(id);
ICustomerMgm custMgm = new CustomerMgm();
CustomerVO cust = custMgm.GetCustomerByID(card.CustomerID);
cuscard = GetCusAndCardModel(card, cust);
}
return(View(cuscard));
}
/// <summary>
/// 修改会员卡
/// </summary>
/// <param name="customer"></param>
/// <returns></returns>
private ReturnedData CustomerCardEdiSub(ClubCardVO clubcard)
{
IClubCardMgm cusmgm = new ClubCardMgm();
ReturnedData data = new ReturnedData();
try
{
clubcard.LastModifiedDate = DateTime.Now;
clubcard.ClubCardTypeName = new ClubCardTypeMgm().GetCardTypeByID(clubcard.ClubCardTypeID).CardTypeName;
clubcard.LastModifierID = Emp.UserName;
cusmgm.Update(clubcard);
data.Message = "会员信息修改成功";
data.Success = true;
}
catch (Exception ex)
{
data.Success = false;
data.Message = "会员信息修改失败";
data.Error = ex.ToString();
}
return(data);
}
private CustomerAndCard GetCusAndCardModel(ClubCardVO recard, CustomerVO recust)
{
if (recard != null && recust != null)
{
CustomerAndCard cuandcard = new CustomerAndCard()
{
CustID = recust.CustomerID,
CustName = recust.Name,
ICNo = recust.ICNo,
MobileNo = recust.MobileNO,
Birthday = recust.Birthday,
CardID = recard.ClubCardID,
CardNo = recard.ClubCardNo,
CardType = recard.ClubCardTypeID,
CardStatu = recard.CardStatus,
OpenCardStore = recard.OpenCardStore,
SaleMan = recard.SalesMan,
SaleTime = recard.SalesTime,
ExpireDate = recard.ExpireDate
};
return(cuandcard);
}
return(new CustomerAndCard());
}
/// <summary>
/// 添加会员卡
/// </summary>
/// <param name="clubcard"></param>
/// <returns></returns>
public ReturnedData CustomerCardAddSub(ClubCardVO clubcard)
{
IClubCardMgm clubCardMgm = new ClubCardMgm();
clubcard.CreatedDate = DateTime.Now;
clubcard.LastModifiedDate = DateTime.Now;
clubcard.SalesTime = DateTime.Now;
clubcard.ExpireDate = clubcard.SalesTime.AddYears(2);
clubcard.CreatorID = Emp.UserName;
clubcard.LastModifierID = Emp.UserName;
clubcard.ClubCardTypeName = new ClubCardTypeMgm().GetCardTypeByID(clubcard.ClubCardTypeID).CardTypeName;
clubcard.ClubCardPwd = "123456";
//clubcard.OpenCardStore = Emp.StroeName;
//clubcard.SalesMan = Emp.Name;//存疑
ReturnedData data = new ReturnedData();
try
{
clubCardMgm.AddClubCard(clubcard);
ICustomerMgm cusMgm = new CustomerMgm();
var cust = cusMgm.GetCustomerByID(clubcard.CustomerID);
cust.CardFlag = 1;
cusMgm.EditCustomer(cust);
data.Message = "开卡成功";
data.Success = true;
}
catch (Exception ex)
{
data.Success = false;
data.Message = "开卡失败";
data.Error = ex.ToString();
}
return(data);
}
public void Update(ClubCardVO clubcard)
{
ClubCardData clubCarddal = new ClubCardData();
clubCarddal.EditCard(Mapper.Map <ClubCardVO, ClubCardPO>(clubcard));
}
public decimal GetBalanceByClubCardID(int id)
{
ClubCardVO clubCardVO = GetClubCardByID(id);
return(clubCardVO.Balance);
}
public int GetCardStatusByClubCardID(int id)
{
ClubCardVO clubCardVO = GetClubCardByID(id);
return(clubCardVO.CardStatus);
}
