/// <summary> /// 设置优惠券属性 /// </summary> /// <param name="GiftCardBatchEntity"></param> /// <param name="entity"></param> /// <returns></returns> public GiftCardEntity setGiftCardEntity(GiftCardBatchEntity GiftCardBatchEntity, CustomerEntity entity) { if (GiftCardBatchEntity != null) { GiftCardEntity GiftCardEntity = new GiftCardEntity(); GiftCardEntity.BatchId = GiftCardBatchEntity.BatchId; GiftCardEntity.BatchName = GiftCardBatchEntity.BatchName; GiftCardEntity.UserId = entity.ID; GiftCardEntity.CardId = StringHelper.GenerateRandomCode(8); GiftCardEntity.CardSum = GiftCardBatchEntity.CardSum; GiftCardEntity.CardType = GiftCardBatchEntity.CardType; GiftCardEntity.Status = 0; GiftCardEntity.BeginTime = entity.CreateTime.Date; GiftCardEntity.EndTime = GiftCardEntity.BeginTime.AddDays(GiftCardBatchEntity.ExpiryDays + 1).AddSeconds(-1); GiftCardEntity.SatisfyPrice = GiftCardBatchEntity.SatisfyPrice; GiftCardEntity.SatisfyProduct = GiftCardBatchEntity.SatisfyProduct; GiftCardEntity.AddTime = DateTime.Now; return(GiftCardEntity); } else { return(null); } }
/// <summary> /// 插入优惠券信息 /// </summary> /// <param name="GiftCardEntity"></param> /// <returns></returns> public bool SaveGiftCard(GiftCardEntity GiftCardEntity, Database db, DbTransaction tran) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into GiftCard("); strSql.Append("BatchId,BatchName,UserId,CardId,CardSum,CardType,Status,BeginTime,EndTime,SatisfyPrice,SatisfyProduct,AddTime)"); strSql.Append(" values ("); strSql.Append("@BatchId,@BatchName,@UserId,@CardId,@CardSum,@CardType,@Status,@BeginTime,@EndTime,@SatisfyPrice,@SatisfyProduct,@AddTime)"); var parameters = DbSFO2OMain.CreateParameterCollection(); parameters.Append("@BatchId", GiftCardEntity.BatchId); parameters.Append("@BatchName", GiftCardEntity.BatchName); parameters.Append("@UserId", GiftCardEntity.UserId); parameters.Append("@CardId", GiftCardEntity.CardId); parameters.Append("@CardSum", GiftCardEntity.CardSum); parameters.Append("@CardType", GiftCardEntity.CardType); parameters.Append("@Status", GiftCardEntity.Status); parameters.Append("@BeginTime", GiftCardEntity.BeginTime); parameters.Append("@EndTime", GiftCardEntity.EndTime); parameters.Append("@SatisfyPrice", GiftCardEntity.SatisfyPrice); parameters.Append("@SatisfyProduct", GiftCardEntity.SatisfyProduct); parameters.Append("@AddTime", GiftCardEntity.AddTime); return(db.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters, tran) > 0); }
/// <summary> /// 添加优惠券 /// </summary> /// <param name="GiftCardEntity"></param> /// <returns></returns> public bool CreateGiftCard(GiftCardEntity GiftCardEntity) { bool result = false; var db = DbSFO2OMain; var connection = db.CreateConnection(); connection.Open(); using (var tran = connection.BeginTransaction()) { try { // 插入优惠券信息 result = SaveGiftCard(GiftCardEntity, db, tran); tran.Commit(); connection.Close(); connection.Dispose(); } catch (Exception ext) { tran.Rollback(); connection.Close(); connection.Dispose(); throw ext; } } return(result); }
/// <summary> /// 插入优惠券信息 /// </summary> /// <param name="GiftCardEntity"></param> /// <returns></returns> public bool SaveGiftCard(GiftCardEntity GiftCardEntity) { try { return(DAL.CreateGiftCard(GiftCardEntity)); } catch (Exception ex) { LogHelper.Error(ex.Message); return(false); } }
/// <summary> /// 添加优惠券 /// </summary> /// <param name="GiftCardBatchEntity"></param> /// <param name="entity"></param> /// <returns></returns> public GiftCardEntity AddGiftCard(GiftCardBatchEntity GiftCardBatchEntity, CustomerEntity entity) { // 设置优惠券属性 GiftCardEntity GiftCardEntity = GiftCardBll.setGiftCardEntity(GiftCardBatchEntity, entity); // 插入优惠券信息 bool result = GiftCardBll.SaveGiftCard(GiftCardEntity); if (result) { return(GiftCardEntity); } else { return(null); } }
/// <summary> /// 优惠券实体转化成ViewModel /// </summary> /// <param name="entity"></param> /// <returns></returns> public CanUseGiftCardViewModel EntityToViewModel(GiftCardEntity entity) { if (entity != null) { CanUseGiftCardViewModel model = new CanUseGiftCardViewModel(); model.Id = entity.ID; model.Name = entity.BatchName; model.CardSum = entity.CardSum.ToString("G0"); model.Type = entity.CardType; model.BeginTime = entity.BeginTime.ToString("yyyy.MM.dd"); model.EndTime = entity.EndTime.ToString("yyyy.MM.dd"); model.FullCutNum = entity.SatisfyPrice; model.Huoli = 0M; model.Money = "0"; return(model); } return(null); }
/// <summary> /// 其他用户类型添加优惠券 /// </summary> /// <param name="GiftCardBatchEntity"></param> /// <param name="entity"></param> /// <returns></returns> public GiftCardEntity ChooseUserToAddGiftCard(GiftCardBatchEntity GiftCardBatchEntity, CustomerEntity entity) { GiftCardEntity GiftCardEntity = null; // 根据具体店铺id查询是否有其店铺存在 bool IsResult = GetDividedPercentStationZDID(entity.ChannelId, entity.SourceValue); // 嘿客店用户 if (entity.ChannelId.ToString() .Equals(System.Web.Configuration.WebConfigurationManager.AppSettings["HeiKeChannelId"].ToString()) && IsResult) { // 添加优惠券 GiftCardEntity = AddGiftCard(GiftCardBatchEntity, entity); } return(GiftCardEntity); }
/// <summary> /// 注册成功返优惠券 /// </summary> /// <param name="entity"></param> /// <returns></returns> public List <GiftCardEntity> SendGiftCard(CustomerEntity entity) { // 注册成功后,获得优惠券批次信息 List <GiftCardBatchEntity> GiftCardBatchEntityList = GiftCardBll.GetGiftCardBatchForRegisterSucc(entity.CreateTime); // 已经发送的优惠券集合 List <GiftCardEntity> SendGiftCardList = new List <GiftCardEntity>(); if (GiftCardBatchEntityList != null && GiftCardBatchEntityList.Count != 0) { foreach (var GiftCardBatchEntity in GiftCardBatchEntityList) { GiftCardEntity GiftCardEntity = null; // 普通用户注册 if (GiftCardBatchEntity.SatisfyUser == 0) { // 添加优惠券 GiftCardEntity = AddGiftCard(GiftCardBatchEntity, entity); } else { //判断注册用户是不是嘿客用户 if (entity.ChannelId != 0) { GiftCardEntity = ChooseUserToAddGiftCard(GiftCardBatchEntity, entity); } } if (GiftCardEntity != null) { SendGiftCardList.Add(GiftCardEntity); } } } return(SendGiftCardList); }
//手工添加更新 public ActionResult PiliangUpdate() { //string[] phones = { "15546799887" }; //string errorMsg = string.Empty; //foreach (string phone in phones) //{ // if (!phone.IsMobilePhoneNum(true)) // { // errorMsg += phone + "&&"; // continue; // } // string thisPhone = phone.Trim(); // //先判定有无注册用户 // AccountBll account = new AccountBll(); // int UserId = 0; // Random rd = new Random(); // string pwd = rd.Next(100000,999999).ToString(); // int userType = 0; // if (!account.IsExistsUserName(thisPhone, "86")) // { // //没有就插入用户表 // CustomerEntity entity = new CustomerEntity() // { // Mobile = thisPhone, // UserName = thisPhone, // Email = "", // Password = pwd, // Gender = 0, // RegionCode = "86" // }; // UserId = account.Insert(entity); // userType = 0; // } // else // { // UserId = account.GetUserInfoByUserName(thisPhone).ID; // userType = 1; // pwd = string.Empty; // } // if (UserId == 0) // { // errorMsg += thisPhone + "&&"; // continue; // } // if (account.GetUserTempByUserName(thisPhone) > 0) // { // errorMsg += phone + "||"; // continue; // } // //先写入用户临时表 // account.InsertTemp(thisPhone, pwd, userType); // //获取到当前的用户ID然后送优惠券 // var loginInfo = new CustomerEntity() // { // ID = UserId, // CreateTime = DateTime.Now // }; // GiftCardBatchEntity giftcardBatch = new GiftCardBatchEntity() // { // BatchId = 6, // BatchName = "丰满券", // CardType = 2, // CardSum = 20, // SatisfyPrice = 159, // SatisfyProduct = 3, // ExpiryDays = 6 // }; // GiftCardEntity GiftCardEntity = account.AddGiftCard(giftcardBatch, loginInfo); //} AccountBll account = new AccountBll(); var userInfos = account.GetUserInfo(); string errorMsg = "成功!"; foreach (var userInfo in userInfos) { if (account.GetUserTempByUserName(userInfo.UserName) > 0) { errorMsg += userInfo.UserName + "||"; continue; } account.InsertTemp(userInfo.UserName, "", 0); var loginInfo = new CustomerEntity() { ID = userInfo.ID, CreateTime = DateTime.Now }; GiftCardBatchEntity giftcardBatch = new GiftCardBatchEntity() { BatchId = 35, BatchName = "丰满券", CardType = 2, CardSum = 20, SatisfyPrice = 159, SatisfyProduct = 3, ExpiryDays = 6 }; GiftCardEntity GiftCardEntity = account.AddGiftCard(giftcardBatch, loginInfo); } return(Content(errorMsg)); }