public async Task <JsonResult> GetDataByPage(UserPermissionRequest request) { var returnValue = new List <UserPromotionCodeModel>(); if (request == null) { return(Json(new { code = -1, msg = "无参数信息", count = 0, data = returnValue }, JsonRequestBehavior.AllowGet)); } if (request.Page <= 0) { request.Page = 1; } if (request.Limit <= 0) { request.Limit = 50; } var memberBll = new MemberService(); var requestModel = new UserPromotionCodeModel { MembershipsGradeId = request.MembershipsGradeId <= 0 ? 1 : request.MembershipsGradeId, Name = request.Name }; var count = DALUserPromotionCode.QueryPageCount(requestModel); returnValue = DALUserPromotionCode.QueryPageList(requestModel, request.Page, request.Limit); return(Json(new { code = 0, msg = "加载成功", count = count, data = returnValue.OrderByDescending(t => t.Id) }, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(int id, int membershipsGradeId, string memberGradeName) { if (membershipsGradeId > 0) { var queryModel = new UserPermissionModel() { MembershipsGradeId = membershipsGradeId }; //获取对应的生活权益(当前可观的时间范围内,相同等级下的会员权益不会超过100条) var userPermissionList = DALUserPermission.QueryPageList(queryModel, 1, 100); ViewBag.UserPermissionList = userPermissionList; } if (ViewBag.UserPermissionList == null) { ViewBag.UserPermissionList = new List <UserPermissionModel>(); } ViewBag.MembershipsGradeId = membershipsGradeId; ViewBag.MemberGradeName = memberGradeName; if (id <= 0) { ViewBag.Title = "添加权益奖励信息"; return(View(new UserPromotionCodeModel())); } else { ViewBag.Title = "编辑权益奖励信息"; var model = DALUserPromotionCode.GetModelById(id); if (model == null) { model = new UserPromotionCodeModel(); } return(View(model)); } }
/// <summary> /// 更新权益奖励 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Update(UserPromotionCodeModel model) { var sqlParamerts = new List <SqlParameter>(); #region sql脚本 var strSql = @" UPDATE [Gungnir].[dbo].[tbl_UserPromotionCode] WITH(ROWLOCK) SET [SImage] = @SImage , [BImage] = @BImage , [RuleID] = @RuleID , [UserRank] = @UserRank , [CouponName] = @CouponName , [CouponDescription] = @CouponDescription , [MembershipsGradeId] = @MembershipsGradeId , [Name] = @Name , [UserPermissionId] = @UserPermissionId , [PermissionType] = @PermissionType , [RewardType] = @RewardType , [RewardId] = @RewardId , [RewardValue] = @RewardValue , [SortIndex] = @SortIndex , [LastUpdateDateTime] = @LastUpdateDateTime , [LastUpdateBy] = @LastUpdateBy WHERE ID = @ID "; #endregion #region 参数化赋值 sqlParamerts.Add(new SqlParameter("@SImage", model.SImage)); sqlParamerts.Add(new SqlParameter("@BImage", model.BImage)); sqlParamerts.Add(new SqlParameter("@RuleID", model.RuleID)); sqlParamerts.Add(new SqlParameter("@UserRank", model.UserRank)); sqlParamerts.Add(new SqlParameter("@CouponName", model.CouponName)); sqlParamerts.Add(new SqlParameter("@CouponDescription", model.CouponDescription)); sqlParamerts.Add(new SqlParameter("@MembershipsGradeId", model.MembershipsGradeId)); sqlParamerts.Add(new SqlParameter("@Name", model.Name)); sqlParamerts.Add(new SqlParameter("@UserPermissionId", model.UserPermissionId)); sqlParamerts.Add(new SqlParameter("@PermissionType", model.PermissionType)); sqlParamerts.Add(new SqlParameter("@RewardType", model.RewardType)); sqlParamerts.Add(new SqlParameter("@RewardId", model.RewardId)); sqlParamerts.Add(new SqlParameter("@RewardValue", model.RewardValue)); sqlParamerts.Add(new SqlParameter("@SortIndex", model.SortIndex)); sqlParamerts.Add(new SqlParameter("@LastUpdateDateTime", model.LastUpdateDateTime)); sqlParamerts.Add(new SqlParameter("@LastUpdateBy", model.LastUpdateBy)); sqlParamerts.Add(new SqlParameter("@ID", model.Id)); #endregion using (var cmd = new SqlCommand(strSql)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddRange(sqlParamerts.ToArray()); return(DbHelper.ExecuteNonQuery(cmd)); } }
/// <summary> /// 获取权益奖励数量 /// </summary> /// <param name="search"></param> /// <returns></returns> public static int QueryPageCount(UserPromotionCodeModel search) { var strCount = new StringBuilder(); var strCondition = new StringBuilder(); var sqlParamerts = new List <SqlParameter>(); #region 获取数量 strCondition.Append(@" SELECT ISNULL(COUNT(*), 0) AS totalCount FROM [Gungnir].[dbo].[tbl_UserPromotionCode] WITH ( NOLOCK ) WHERE IsDeleted = 0 "); #endregion #region 查询条件 if (search != null) { if (!string.IsNullOrWhiteSpace(search.Name)) { strCondition.AppendFormat(" And Name like @Name"); sqlParamerts.Add(new SqlParameter("@Name", "%" + search.Name + "%")); } if (!string.IsNullOrWhiteSpace(search.CouponName)) { strCondition.AppendFormat(" And CouponName like @CouponName"); sqlParamerts.Add(new SqlParameter("@CouponName", "%" + search.CouponName + "%")); } if (!string.IsNullOrWhiteSpace(search.CouponDescription)) { strCondition.AppendFormat(" And CouponDescription like @CouponDescription"); sqlParamerts.Add(new SqlParameter("@CouponDescription", "%" + search.CouponDescription + "%")); } if (search.MembershipsGradeId > 0) { strCondition.AppendFormat(" And MembershipsGradeId = @MembershipsGradeId"); sqlParamerts.Add(new SqlParameter("@MembershipsGradeId", search.MembershipsGradeId)); } } #endregion using (var countCmd = new SqlCommand(strCondition.ToString())) { countCmd.Parameters.AddRange(sqlParamerts.ToArray()); var count = DbHelper.ExecuteScalar(countCmd); return(Convert.ToInt32(count)); } }
public JsonResult Save(UserPromotionCodeModel model) { if (model == null) { return(Json(new { result = 0, msg = "无法获取数据对象" })); } var result = 0; model.LastUpdateBy = HttpContext.User.Identity.Name; if (string.IsNullOrWhiteSpace(model.RewardValue)) { model.RewardValue = "0"; } if (string.IsNullOrWhiteSpace(model.RewardId)) { model.RewardId = "0"; } if (model.Id <= 0) { model.LastUpdateBy = model.LastUpdateBy; result = DALUserPromotionCode.Add(model); } else { model.LastUpdateDateTime = DateTime.Now; result = DALUserPromotionCode.Update(model); } var oprLog = new Tuhu.Provisioning.DataAccess.Entity.OprLog { ObjectID = model.Id, ObjectType = "UserPromotionCode", Author = HttpContext.User.Identity.Name, Operation = model.Id > 0 ? "更新" : "新增" + "UserPromotionCode配置" }; var operLogManager = new Business.OprLogManagement.OprLogManager(); operLogManager.AddOprLogAsync(oprLog); return(Json(new { result = result, msg = "操作成功" })); }
/// <summary> /// 获取权益奖励列表 /// </summary> /// <param name="search"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public static List <UserPromotionCodeModel> QueryPageList(UserPromotionCodeModel search, int pageIndex, int pageSize) { var strSql = new StringBuilder(); var strCondition = new StringBuilder(); var sqlParamerts = new List <SqlParameter>(); #region 查询条件 if (search != null) { if (!string.IsNullOrWhiteSpace(search.Name)) { strCondition.AppendFormat(" And Name like @Name"); sqlParamerts.Add(new SqlParameter("@Name", "%" + search.Name + "%")); } if (!string.IsNullOrWhiteSpace(search.CouponName)) { strCondition.AppendFormat(" And CouponName like @CouponName"); sqlParamerts.Add(new SqlParameter("@CouponName", "%" + search.CouponName + "%")); } if (!string.IsNullOrWhiteSpace(search.CouponDescription)) { strCondition.AppendFormat(" And CouponDescription like @CouponDescription"); sqlParamerts.Add(new SqlParameter("@CouponDescription", "%" + search.CouponDescription + "%")); } if (search.MembershipsGradeId > 0) { strCondition.AppendFormat(" And MembershipsGradeId = @MembershipsGradeId"); sqlParamerts.Add(new SqlParameter("@MembershipsGradeId", search.MembershipsGradeId)); } } #endregion #region sql语句 strSql.AppendFormat(@"Select [ID] , [SImage] , [BImage] , [RuleID] , [UserRank] , [CouponName] , [CouponDescription] , [MembershipsGradeId] , [Name] , [UserPermissionId] , [PermissionType] , [RewardType] , [RewardId] , [RewardValue] , [SortIndex] , [CreateDatetime] , [CreateBy] , [LastUpdateDateTime] , [LastUpdateBy] , [IsDeleted] FROM [Gungnir].[dbo].[tbl_UserPromotionCode] WITH ( NOLOCK ) WHERE IsDeleted=0 {0} ORDER BY ID DESC OFFSET(@PageIndex-1) * @PageSize ROWS FETCH NEXT @PageSize ROWS ONLY", strCondition.ToString()); #endregion sqlParamerts.Add(new SqlParameter("@PageIndex", pageIndex)); sqlParamerts.Add(new SqlParameter("@PageSize", pageSize)); using (var dataCmd = new SqlCommand(strSql.ToString())) { dataCmd.Parameters.AddRange(sqlParamerts.ToArray()); return(DbHelper.ExecuteDataTable(dataCmd)?.ConvertTo <UserPromotionCodeModel>().ToList()); } }
/// <summary> /// 添加权益奖励 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Add(UserPromotionCodeModel model) { var sqlParamerts = new List <SqlParameter>(); #region sql脚本 var strSql = @" INSERT INTO [Gungnir].[dbo].[tbl_UserPromotionCode] ( [SImage] , [BImage] , [RuleID] , [UserRank] , [CouponName] , [CouponDescription] , [MembershipsGradeId] , [Name] , [UserPermissionId] , [PermissionType] , [RewardType] , [RewardId] , [RewardValue] , [SortIndex] , [CreateDatetime] , [CreateBy] , [LastUpdateDateTime] , [LastUpdateBy] , [IsDeleted] ) VALUES ( @SImage , @BImage , @RuleID , @UserRank , @CouponName , @CouponDescription , @MembershipsGradeId , @Name , @UserPermissionId , @PermissionType , @RewardType , @RewardId , @RewardValue , @SortIndex , GETDATE(), @LastUpdateBy , GETDATE(), @LastUpdateBy , 0 )"; #endregion #region 参数化赋值 sqlParamerts.Add(new SqlParameter("@SImage", model.SImage)); sqlParamerts.Add(new SqlParameter("@BImage", model.BImage)); sqlParamerts.Add(new SqlParameter("@RuleID", model.RuleID)); sqlParamerts.Add(new SqlParameter("@UserRank", model.UserRank)); sqlParamerts.Add(new SqlParameter("@CouponName", model.CouponName)); sqlParamerts.Add(new SqlParameter("@CouponDescription", model.CouponDescription)); sqlParamerts.Add(new SqlParameter("@MembershipsGradeId", model.MembershipsGradeId)); sqlParamerts.Add(new SqlParameter("@Name", model.Name)); sqlParamerts.Add(new SqlParameter("@UserPermissionId", model.UserPermissionId)); sqlParamerts.Add(new SqlParameter("@PermissionType", model.PermissionType)); sqlParamerts.Add(new SqlParameter("@RewardType", model.RewardType)); sqlParamerts.Add(new SqlParameter("@RewardId", model.RewardId)); sqlParamerts.Add(new SqlParameter("@RewardValue", model.RewardValue)); sqlParamerts.Add(new SqlParameter("@SortIndex", model.SortIndex)); sqlParamerts.Add(new SqlParameter("@LastUpdateBy", model.LastUpdateBy)); #endregion using (var cmd = new SqlCommand(strSql)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddRange(sqlParamerts.ToArray()); return(DbHelper.ExecuteNonQuery(cmd)); } }