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