/// <summary> /// 增加一条数据 /// </summary> public int Add(RewardEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sns_reward("); strSql.Append("User_id,worksId,rewardMoney,Status)"); strSql.Append(" values ("); strSql.Append("@User_id,@worksId,@rewardMoney,@Status)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@User_id", SqlDbType.VarChar, 50), new SqlParameter("@worksId", SqlDbType.VarChar, 50), new SqlParameter("@rewardMoney", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.Int, 4) }; parameters[0].Value = model.User_id; parameters[1].Value = model.worksId; parameters[2].Value = model.rewardMoney; parameters[3].Value = model.Status; object obj = SqlHelper.Instance.ExecSqlScalar(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public async Task <bool> AddAsync(RewardEntity entity) { var sql = $@"insert into user_reward (id, user_id, type, date, notes) values(@Id, @UserId, @Type, @Date, @Notes);"; return(await _dbContext.ExecuteAsync <bool>(sql, entity)); }
public List <RewardEntity> Get(string rewardstring, int voc) { var list = new List <RewardEntity>(); if (rewardstring == "") { return(null); } if (rewardstring.Contains('#')) { rewardstring = rewardstring.Split('#')[voc]; } var rewardlist = rewardstring.Split('|'); foreach (var item in rewardlist) { var entity = new RewardEntity(); var typelist = item.Split('_'); var type = Convert.ToInt32(typelist[0]); entity.goods_type = type; if (typelist.Count() == 2) { entity.value = Convert.ToInt32(typelist[1]); list.Add(entity); continue; } entity.base_id = Convert.ToInt32(typelist[1]); entity.value = Convert.ToInt32(typelist[2]); list.Add(entity); } return(list); }
public int InsertOrUpdateReward(int StoreId, int LoggedInUserId, RewardEntity objRewardEntity, int isAddMode) { var ParameterStoreId = new SqlParameter { ParameterName = "StoreId", DbType = DbType.Int32, Value = objRewardEntity.store_id }; var ParameterLoggedInUserId = new SqlParameter { ParameterName = "LoggedInUserId", DbType = DbType.Int32, Value = LoggedInUserId }; var paramRewardId = new SqlParameter { ParameterName = "id", DbType = DbType.Int32, Value = objRewardEntity.id }; var paramRewardTitle = new SqlParameter { ParameterName = "Title", DbType = DbType.String, Value = objRewardEntity.Title }; var paramreward_type_id = new SqlParameter { ParameterName = "reward_type_id", DbType = DbType.Int32, Value = objRewardEntity.reward_type_id }; var paramstart_date = new SqlParameter { ParameterName = "start_date", DbType = DbType.DateTime, Value = objRewardEntity.start_date }; var paramend_date = new SqlParameter { ParameterName = "end_date", DbType = DbType.DateTime, Value = objRewardEntity.end_date }; var paramstatus = new SqlParameter { ParameterName = "status", DbType = DbType.Int32, Value = objRewardEntity.status }; var paramdescription = new SqlParameter { ParameterName = "description", DbType = DbType.String, Value = objRewardEntity.description ?? (object)DBNull.Value }; var paramsent_mail = new SqlParameter { ParameterName = "sent_mail", DbType = DbType.Boolean, Value = objRewardEntity.sent_mail }; var paramdisplay_dashborad = new SqlParameter { ParameterName = "display_dashborad", DbType = DbType.Boolean, Value = objRewardEntity.display_dashborad }; var paramcreated_by = new SqlParameter { ParameterName = "created_by", DbType = DbType.Int32, Value = objRewardEntity.created_by }; var paramisAddMode = new SqlParameter { ParameterName = "isAddMode", DbType = DbType.Int32, Value = isAddMode }; var parammodified_by = new SqlParameter { ParameterName = "modified_by", DbType = DbType.Int32, Value = objRewardEntity.modified_by ?? (object)DBNull.Value }; var paramIsCustomerDepartment = new SqlParameter { ParameterName = "isCustomerDepartment", DbType = DbType.Boolean, Value = objRewardEntity.IsCustomerDepartment }; int rewardId = objGenericRepository.ExecuteSQL <int>("InsertOrUpdateReward", ParameterStoreId, ParameterLoggedInUserId, paramRewardId, paramRewardTitle, paramreward_type_id, paramstart_date, paramend_date, paramstatus, paramdescription, paramsent_mail, paramdisplay_dashborad, paramcreated_by, paramisAddMode, parammodified_by, paramIsCustomerDepartment).SingleOrDefault(); return(rewardId); }
public async Task <Guid> CreateAsync(RewardEntity entity) { if (await _rewardRepository.AddAsync(entity)) { return(entity.Id); } return(Guid.Empty); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { UserEntity.Configure(modelBuilder.Entity <UserEntity>()); BookEntity.Configure(modelBuilder.Entity <BookEntity>()); OrderEntity.Configure(modelBuilder.Entity <OrderEntity>()); PostEntity.Configure(modelBuilder.Entity <PostEntity>()); CommentEntity.Congifure(modelBuilder.Entity <CommentEntity>()); RewardEntity.Configure(modelBuilder.Entity <RewardEntity>()); ShoppingCartEntity.Configure(modelBuilder.Entity <ShoppingCartEntity>()); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(RewardEntity model) { try { return(RewardDb.Instance.Add(model)); } catch (Exception ex) { WriteLog.WriteError(ex); throw ex; } }
public async Task <bool> UpdateAsync(RewardEntity entity) { var sql = $@"update user_reward set user_id = @UserId , type = @Type , date = @Date , updated_at=now() , notes = @Notes where id = @Id"; return(await _dbContext.ExecuteAsync <bool>(sql, entity)); }
public RewardModel(RewardEntity reward) { Id = reward.Id; BookName = reward.BookName; Press = reward.Press; Category = reward.Category; Author = reward.Author; ISBN = reward.ISBN; Price = reward.Price; ImagePath = reward.ImageURL; PublishedDate = reward.PublishedDate; Depreciation = reward.Depreciation; Description = reward.Description; }
internal static RewardEntity ToDataObject(this Reward serviceModel) { RewardEntity dataObject = new RewardEntity(); dataObject.Id = serviceModel.Id; dataObject.GiveawaysProvider = serviceModel.GiveawaysProvider; dataObject.GiveawayId = serviceModel.GiveawayId; dataObject.SteamUsername = serviceModel.SteamUsername; dataObject.SteamAppId = serviceModel.SteamApp.Id; dataObject.ActivationKey = serviceModel.ActivationKey; dataObject.CreationTimestamp = serviceModel.CreationTime.ToString(DateTimeFormat); return(dataObject); }
internal static Reward ToServiceModel(this RewardEntity dataObject) { Reward serviceModel = new Reward(); serviceModel.Id = dataObject.Id; serviceModel.GiveawaysProvider = dataObject.GiveawaysProvider; serviceModel.GiveawayId = dataObject.GiveawayId; serviceModel.SteamUsername = dataObject.SteamUsername; serviceModel.ActivationKey = dataObject.ActivationKey; serviceModel.SteamApp = new SteamApp(); serviceModel.SteamApp.Id = dataObject.SteamAppId; serviceModel.CreationTime = DateTime.ParseExact(dataObject.CreationTimestamp, DateTimeFormat, CultureInfo.InvariantCulture); return(serviceModel); }
public bool CreateReward(RewardCreateRAO model) { var groupService = new GroupService(_userId); var reward = new RewardEntity { RewardName = model.RewardName, Description = model.RewardDescription, Cost = model.RewardCost, GroupId = model.GroupId }; using (var ctx = new ApplicationDbContext()) { ctx.Rewards.Add(reward); return(ctx.SaveChanges() == 1); } }
public DataTable Reward_Save(string pWorkingTag, RewardEntity entity, string pLoginId) { DataTable dtData = new DataTable(); string spName = "PKHR_Reward.sp_Reward_Save"; OracleParameter[] param = new OracleParameter[9]; param[0] = new OracleParameter("pWorkingTag", pWorkingTag); param[1] = new OracleParameter("pEmpId", entity.pEmpID); param[2] = new OracleParameter("pREWARDDATE", entity.RewarDate); param[3] = new OracleParameter("pREWARDKIND", entity.Rewardkind ?? ""); param[4] = new OracleParameter("pAMOUNT", obj: entity.Amount); param[5] = new OracleParameter("pREMARK", entity.Remark ?? ""); param[6] = new OracleParameter("IsConfirm", entity.isConfirm ?? ""); param[7] = new OracleParameter("plogin", pLoginId); param[8] = new OracleParameter("T_TABLE", OracleDbType.RefCursor) { Direction = ParameterDirection.Output }; dtData = DBHelper.getDataTable_SP(spName, param); return(dtData); }
public RequestResponse CreateReward(RewardCreate model) { if (model == null) { return(BadResponse("Request Body was empty.")); } var userMembership = GetUserMembership(model.GroupId); if (userMembership == null || !userMembership.IsOfficer) { return(BadResponse("Invalid permissions.")); } var rewardEntity = new RewardEntity(model.RewardName, model.Cost, model.NumberAvailable, model.GroupId); _context.Rewards.Add(rewardEntity); if (_context.SaveChanges() != 1) { return(BadResponse("Could not save reward.")); } return(OkResponse("Reward created successfully.")); }
/// <summary> 切割奖励字符串并组装数据任务奖励 </summary> public List <RewardVo> GetReward(string reward, Int64 userid, ref List <tg_bag> proplist) { if (!Variable.OnlinePlayer.ContainsKey(userid)) { return(null); } var session = Variable.OnlinePlayer[userid] as TGGSession; if (session == null) { return(null); } var voc = session.Player.User.player_vocation; //获取奖励实体 var rewardlist = new RewardEntity().Get(reward, voc); var props_count = rewardlist.Where(q => q.base_id != 0).Sum(q => q.value); //验证格子数 if (session.Player.Bag.Surplus < props_count) { return(null); } var returnreward = new List <RewardVo>(); var user = session.Player.User.CloneEntity(); var role = session.Player.Role.Kind.CloneEntity(); var otherroles = tg_role.GetWarRoles(user.id); otherroles.Add(role); foreach (var item in rewardlist) { var type = item.goods_type; var count = item.value; var baseid = Convert.ToInt32(item.base_id); switch (type) //奖励类型 { #region 货币 case (int)GoodsType.TYPE_COIN: { user.coin = tg_user.IsCoinMax(user.coin, count); if (user.Update() == 0) { return(null); } session.Player.User = user; count = user.coin; returnreward.Add(new RewardVo { goodsType = (int)GoodsType.TYPE_COIN, value = count }); break; } #endregion #region 内币 case (int)GoodsType.TYPE_RMB: { user.rmb += (int)count; if (user.Update() == 0) { return(null); } ; session.Player.User = user; count = user.rmb; returnreward.Add(new RewardVo() { goodsType = (int)GoodsType.TYPE_RMB, value = Convert.ToDouble(count) }); break; } #endregion #region 金币 case (int)GoodsType.TYPE_GOLD: { user.gold += (int)count; if (user.Update() == 0) { return(null); } session.Player.User = user; count = user.gold; returnreward.Add(new RewardVo() { goodsType = (int)GoodsType.TYPE_GOLD, value = count }); break; } #endregion #region 礼券 case (int)GoodsType.TYPE_COUPON: { user.coupon += (int)count; if (user.Update() == 0) { return(null); } session.Player.User = user; count = user.coupon; returnreward.Add(new RewardVo() { goodsType = (int)GoodsType.TYPE_COUPON, value = count }); break; } #endregion #region 经验 case (int)GoodsType.TYPE_EXP: { foreach (var otherrole in otherroles) { if (otherrole.role_state == (int)RoleStateType.PROTAGONIST) { new Upgrade().UserLvUpdate(user.id, (int)count, otherrole); //用户是否升级 continue; } if (!new Upgrade().RoleLvUpdate(session.Player.User.id, (int)count, otherrole)) { return(null); } } returnreward.Add(new RewardVo() { goodsType = (int)GoodsType.TYPE_EXP, value = count }); break; } #endregion #region 道具 case (int)GoodsType.TYPE_PROP: { var baseinfo = Variable.BASE_PROP.FirstOrDefault(q => q.id == baseid); if (baseinfo == null) { continue; } var prop = BaseToEntity(baseinfo, user.id, (int)count); proplist.Add(prop); break; } #endregion #region 装备 case (int)GoodsType.TYPE_EQUIP: { for (var i = 0; i < count; i++) { var equip = CommonHelper.GreenEquip(user.id, baseid); proplist.Add(equip); } break; } #endregion #region 功勋 case (int)GoodsType.TYPE_HONOR: { new Upgrade().UserIdentifyUpdate(user.id, (int)count, role, user.player_vocation); //用户是否身份提升 returnreward.Add(new RewardVo() { goodsType = (int)GoodsType.TYPE_HONOR, value = count }); } break; #endregion #region 声望 case (int)GoodsType.TYPE_FAME: { user.fame = tg_user.IsFameMax(user.fame, (int)count); if (user.Update() == 0) { return(null); } session.Player.User = user; count = user.fame; returnreward.Add(new RewardVo { goodsType = (int)GoodsType.TYPE_FAME, value = count }); break; } #endregion #region 魂 case (int)GoodsType.TYPE_SPIRIT: { user.spirit = tg_user.IsSpiritMax(user.spirit, (int)count); if (user.Update() == 0) { return(null); } session.Player.User = user; count = user.spirit; returnreward.Add(new RewardVo { goodsType = (int)GoodsType.TYPE_SPIRIT, value = count }); break; } #endregion } } return(returnreward); }
public async Task <bool> UpdateAsync(RewardEntity entity) { return(await _rewardRepository.UpdateAsync(entity)); }
public void ProcessRequest(HttpContext context) { string workId = context.Request.Form["WorksId"]; string userId = context.Request.Form["UserId"]; string money = context.Request.Form["Money"]; string uid = context.Request.Form["Uid"]; int i; //查看cn币余额 MemberEntity memberEntity = MemberBll.Instance.GetModel(int.Parse(userId)); if (memberEntity.CNbi < int.Parse(money)) { i = 0; } else { //记录打赏表 RewardEntity rewardEntity = new RewardEntity(); rewardEntity.User_id = userId; rewardEntity.worksId = workId; rewardEntity.rewardMoney = int.Parse(money); rewardEntity.Status = 1; i = RewardBll.Instance.Add(rewardEntity); if (i > 0) { //记录积分变更表 IntegralChangeEntity integralChangeEntity = new IntegralChangeEntity(); integralChangeEntity.UserId = userId; integralChangeEntity.source = "reward"; integralChangeEntity.Cnbi = "-" + money; integralChangeEntity.integral = 1; integralChangeEntity.ardent = 1; integralChangeEntity.Growth = int.Parse(money) * 10; integralChangeEntity.AddTime = DateTime.Now; integralChangeEntity.Status = 1; IntegralChangeBll.Instance.Add(integralChangeEntity); //更新帖子 WorksBll.Instance.UpdateIntegral(workId, "reward", money); //更新会员表 MemberBll.Instance.UpdateIntegral(userId, "Cnbi", "-" + money); MemberBll.Instance.UpdateIntegral(userId, "integral", "1"); MemberBll.Instance.UpdateIntegral(userId, "ardent", "1"); MemberBll.Instance.UpdateIntegral(userId, "Growth", (int.Parse(money) * 10).ToString()); //记录发帖人积分变更 integralChangeEntity = new IntegralChangeEntity(); integralChangeEntity.UserId = uid; integralChangeEntity.source = "reward"; integralChangeEntity.Cnbi = money; integralChangeEntity.integral = 0; integralChangeEntity.ardent = 0; integralChangeEntity.Growth = 0; integralChangeEntity.AddTime = DateTime.Now; integralChangeEntity.Status = 1; IntegralChangeBll.Instance.Add(integralChangeEntity); //更新发帖人cn币 MemberBll.Instance.UpdateIntegral(uid, "Cnbi", money); } } context.Response.ContentType = "text/plain"; context.Response.Charset = "utf-8"; context.Response.Write(i); }
/// <summary> 切割奖励字符串并组装数据任务奖励 </summary> public List <RewardVo> GetReward(string reward, Int64 userid, int modulenumber, int command, ref List <tg_bag> proplist) { try { if (!Variable.OnlinePlayer.ContainsKey(userid)) { return(null); } var session = Variable.OnlinePlayer[userid] as TGGSession; if (session == null) { return(null); } var voc = session.Player.User.player_vocation; //获取奖励实体 var rewardlist = new RewardEntity().Get(reward, voc); var props_count = rewardlist.Where(q => q.base_id != 0).Sum(q => q.value); //验证格子数 if (session.Player.Bag.Surplus < props_count) { return(null); } var returnreward = new List <RewardVo>(); var user = session.Player.User.CloneEntity(); var role = session.Player.Role.Kind.CloneEntity(); var otherroles = tg_role.GetWarRoles(user.id); otherroles.Add(role); var tuple = new Share.Upgrade().GetName(modulenumber, command); foreach (var item in rewardlist) { var type = item.goods_type; var count = item.value; var baseid = Convert.ToInt32(item.base_id); switch (type) //奖励类型 { #region 货币 case (int)GoodsType.TYPE_COIN: { var coin = user.coin; user.coin = tg_user.IsCoinMax(user.coin, count); if (user.Update() == 0) { return(null); } session.Player.User = user; (new Share.Log()).WriteLog(userid, (int)LogType.Get, modulenumber, command, tuple.Item1, tuple.Item2, "金钱", (int)GoodsType.TYPE_COIN, count, user.coin, "Coin_" + coin + "_" + count + "_" + user.coin); count = user.coin; returnreward.Add(new RewardVo { goodsType = (int)GoodsType.TYPE_COIN, value = count }); break; } #endregion #region 内币 case (int)GoodsType.TYPE_RMB: { user.rmb += (int)count; if (user.Update() == 0) { return(null); } ; session.Player.User = user; (new Share.Log()).WriteLog(userid, (int)LogType.Get, modulenumber, command, tuple.Item1, tuple.Item2, "内币", (int)GoodsType.TYPE_RMB, Convert.ToInt32(count), user.rmb, "Rmb"); count = user.rmb; returnreward.Add(new RewardVo() { goodsType = (int)GoodsType.TYPE_RMB, value = Convert.ToDouble(count) }); break; } #endregion #region 金币 case (int)GoodsType.TYPE_GOLD: { var gold = user.gold; user.gold += (int)count; if (user.Update() == 0) { return(null); } session.Player.User = user; (new Share.Log()).WriteLog(userid, (int)LogType.Get, modulenumber, command, tuple.Item1, tuple.Item2, "元宝", (int)GoodsType.TYPE_GOLD, Convert.ToInt32(count), user.gold, "Gold_" + gold + "_" + count + "_" + user.gold); count = user.gold; returnreward.Add(new RewardVo() { goodsType = (int)GoodsType.TYPE_GOLD, value = count }); break; } #endregion #region 礼券 case (int)GoodsType.TYPE_COUPON: { user.coupon += (int)count; if (user.Update() == 0) { return(null); } session.Player.User = user; count = user.coupon; returnreward.Add(new RewardVo() { goodsType = (int)GoodsType.TYPE_COUPON, value = count }); break; } #endregion #region 经验 case (int)GoodsType.TYPE_EXP: { var upgrade = new Upgrade(); foreach (var otherrole in otherroles) { if (otherrole.role_state == (int)RoleStateType.PROTAGONIST) { upgrade.UserLvUpdate(user.id, (int)count, otherrole, modulenumber, command); //用户是否升级 continue; } var b = upgrade.RoleLvUpdate(session.Player.User.id, (int)count, otherrole, modulenumber, command); if (!b) { return(null); } } returnreward.Add(new RewardVo() { goodsType = (int)GoodsType.TYPE_EXP, value = count }); upgrade.Dispose(); break; } #endregion #region 道具 case (int)GoodsType.TYPE_PROP: { var baseinfo = Variable.BASE_PROP.FirstOrDefault(q => q.id == baseid); if (baseinfo == null) { continue; } if (baseinfo.typeSub == 1) { (new Role()).InsertCollects(user.id, baseinfo); //插入家臣卡收集信息 } var prop = BaseToEntity(baseinfo, user.id, (int)count); proplist.Add(prop); //日志 var ps = tg_bag.GetFindBag(userid, baseid); var c = ps.Count + count; (new Share.Log()).WriteLog(userid, (int)LogType.Get, modulenumber, command, tuple.Item1, tuple.Item2, baseinfo.name, (int)GoodsType.TYPE_PROP, Convert.ToInt32(count), c, "Prop_" + ps.Count + "_" + count + "_" + c); break; } #endregion #region 装备 case (int)GoodsType.TYPE_EQUIP: { for (var i = 0; i < count; i++) { var equip = CommonHelper.GreenEquip(user.id, baseid); proplist.Add(equip); } //日志 var baseinfo = Variable.BASE_EQUIP.FirstOrDefault(q => q.id == baseid); if (baseinfo == null) { continue; } var ps = tg_bag.GetFindBag(userid, baseid); var c = ps.Count + count; (new Share.Log()).WriteLog(userid, (int)LogType.Get, modulenumber, command, tuple.Item1, tuple.Item2, baseinfo.name, (int)GoodsType.TYPE_EQUIP, Convert.ToInt32(count), c, "Equip_" + ps.Count + "_" + count + "_" + c); break; } #endregion #region 功勋 case (int)GoodsType.TYPE_HONOR: { new Upgrade().UserIdentifyUpdate(user.id, (int)count, role, user.player_vocation, modulenumber, command); //用户是否身份提升 returnreward.Add(new RewardVo() { goodsType = (int)GoodsType.TYPE_HONOR, value = count }); } break; #endregion #region 声望 case (int)GoodsType.TYPE_FAME: { var oldfame = user.fame; user.fame = tg_user.IsFameMax(user.fame, (int)count); if (user.Update() == 0) { return(null); } session.Player.User = user; (new Share.Log()).WriteLog(userid, (int)LogType.Get, modulenumber, command, tuple.Item1, tuple.Item2, "声望", (int)GoodsType.TYPE_FAME, Convert.ToInt32(count), user.fame, "Fame_" + oldfame + "_" + count + "_" + user.fame); count = user.fame; returnreward.Add(new RewardVo { goodsType = (int)GoodsType.TYPE_FAME, value = count }); break; } #endregion #region 魂 case (int)GoodsType.TYPE_SPIRIT: { var oldspirit = user.spirit; user.spirit = tg_user.IsSpiritMax(user.spirit, (int)count); if (user.Update() == 0) { return(null); } session.Player.User = user; (new Share.Log()).WriteLog(userid, (int)LogType.Get, modulenumber, command, tuple.Item1, tuple.Item2, "魂", (int)GoodsType.TYPE_SPIRIT, Convert.ToInt32(count), user.spirit, "Spirit_" + oldspirit + "_" + count + "_" + user.spirit); count = user.spirit; returnreward.Add(new RewardVo { goodsType = (int)GoodsType.TYPE_SPIRIT, value = count }); break; } #endregion } } return(returnreward); } catch (Exception e) { XTrace.WriteLine("主线任务领取奖励出错"); return(null); } }
public HttpResponseMessage InsertOrUpdateReward(int StoreId, int LoggedInUserId, int isAddMode, RewardEntity objRewardEntity) { try { var result = _rewardService.InsertOrUpdateReward(StoreId, LoggedInUserId, objRewardEntity, isAddMode); return(Request.CreateResponse(HttpStatusCode.OK, result)); } catch (Exception) { throw; } }