Xiezn.Core/Business/Services/ShangpinxinxiService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Xiezn.Core.Common.Helpers;
using Xiezn.Core.Models;
using Xiezn.Core.Models.DbModel;

namespace Xiezn.Core.Business.Services
{
    public class ShangpinxinxiService : BaseService<ShangpinxinxiDbModel>
    {
        private readonly long _uid;
        private readonly string _role;

        public ShangpinxinxiService()
        {
            try
            {
                _uid = CacheHelper.TokenModel.Uid;
                _role = CacheHelper.TokenModel.Role;
            }
            catch
            {
                _uid = 0;
                _role = "游客";
            }
        }



        public int IntelRecom(long id)
        {
            ShangpinxinxiDbModel updateObj = new ShangpinxinxiDbModel();
            //return Db.Updateable(updateObj).UpdateColumns(it => new { it.Clicktime }).ReSetValue(it => it.Clicktime == (it.Clicktime + 1)).Where(it => it.Id == id).ExecuteCommand();
            return Db.Updateable(updateObj).UpdateColumns(it => new { it.Clicktime }).ReSetValue(it => it.Clicktime == DateTime.Now).Where(it => it.Id == id).ExecuteCommand();
        }

		public int BrowseClick(long id)
        {
            ShangpinxinxiDbModel updateObj = new ShangpinxinxiDbModel();
            return Db.Updateable(updateObj).UpdateColumns(it => new { it.Clicknum }).ReSetValue(it => it.Clicknum == (it.Clicknum + 1)).Where(it => it.Id == id).ExecuteCommand();
        }


        public PageModel<ShangpinxinxiDbModel> GetPageList(int page, int limit, string sort, string order, List<IConditionalModel> conModels)
        {
            PageModel pageModel = new PageModel() { PageIndex = page, PageSize = limit };

            int totalNumber = 0;
            int totalPage = 0;

            string dbColumnName = Db.EntityMaintenance.GetDbColumnName<ShangpinxinxiDbModel>(sort);
            order = order.ToLower() == "asc" ? "ASC" : "DESC";


            List<ShangpinxinxiDbModel> ts = Db.Queryable<ShangpinxinxiDbModel>().Where(conModels).OrderBy(dbColumnName + " " + order).ToPageList(page, limit, ref totalNumber, ref totalPage);

            PageModel<ShangpinxinxiDbModel> t = new PageModel<ShangpinxinxiDbModel>()