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); }