轮播图相关

wx

2022-09-05 67bda721de1b5abb032e74f02dde041f3da10047

轮播图相关

 GasolineBlend.Entity/GasolineBlend.Entity.csproj

@@ -54,6 +54,7 @@
    <Compile Include="PatentSearchAll.cs" />
    <Compile Include="PatentSearchCount.cs" />
    <Compile Include="Properties\AssemblyInfo.cs" />
    <Compile Include="SysCarouselImg.cs" />
    <Compile Include="SysCountry.cs" />
    <Compile Include="SysDict.cs" />
    <Compile Include="SysIpcClass.cs" />

 GasolineBlend.Entity/SysCarouselImg.cs

New file
@@ -0,0 +1,55 @@
using System;
using SqlSugar;

namespace GasolineBlend.Entity
{
    /// <summary>
    /// 轮播图
    ///</summary>
    [SugarTable("sys_carousel_img")]
    public class SysCarouselImg
    {
        /// <summary>
        ///  
        ///</summary>
        [SugarColumn(ColumnName = "Id", IsPrimaryKey = true, IsIdentity = true)]
        public int Id { get; set; }
        /// <summary>
        /// 图片名称 
        ///</summary>
        [SugarColumn(ColumnName = "Name")]
        public string Name { get; set; }
        /// <summary>
        /// 路径 
        ///</summary>
        [SugarColumn(ColumnName = "Url")]
        public string Url { get; set; }
        /// <summary>
        /// 是否显示 
        ///</summary>
        [SugarColumn(ColumnName = "IsDisplay")]
        public bool IsDisplay { get; set; } = true;

        /// <summary>
        /// 排序号 
        ///</summary>
        [SugarColumn(ColumnName = "Sort")]
        public int Sort { get; set; } = 0;

        /// <summary>
        /// 创建时间 
        ///</summary>
        [SugarColumn(ColumnName = "CreateTime")]
        public DateTime CreateTime { get; set; } = DateTime.Now;
        /// <summary>
        /// 更新时间 
        ///</summary>
        [SugarColumn(ColumnName = "UpdateTime")]
        public DateTime UpdateTime { get; set; } = DateTime.Now;
        /// <summary>
        /// 上传用户 
        ///</summary>
        [SugarColumn(ColumnName = "CreateUserId")]
        public string CreateUserId { get; set; }
    }
}

 GasolineBlend/Controllers/SysController.cs

@@ -1,8 +1,12 @@
using System.Collections.Generic;
using System;
using System.Collections.Generic;
using System.IO;
using System.Web.Mvc;
using CommonHelper;
using CommonHelper.Format;
using GasolineBlend.Entity;
using Pissa.Service.DbService;
using Quartz.Util;
using SqlSugar;

namespace GasolineBlend.Controllers
@@ -80,5 +84,93 @@
            var res = _countryService.GetEcoindustryTree();
            return SuccessNoShow(data: res);
        }

        /// <summary>
        /// 获取轮播图
        /// </summary>
        /// <param name="isDisplay">是否展示</param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult GetCarouselImg(bool? isDisplay = null)
        {
            var res = _countryService.Context.Queryable<SysCarouselImg>()
                .WhereIF(isDisplay != null, a => a.IsDisplay == isDisplay)
                .OrderBy(a => a.Sort)
                .ToList();
            return Success(data: res);
        }

        /// <summary>
        /// 上传轮播图
        /// </summary>
        /// <param name="imgName"></param>
        /// <param name="sort"></param>
        /// <param name="isDisplay"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult AddCarouselImg(string imgName, int sort = 0, bool isDisplay = true)
        {
            var file = Request.Files["img"];
            if (file == null)
                return Error("请上传文件");
            if (imgName.IsNullOrWhiteSpace())
                imgName = file.FileName;
            if (!Directory.Exists(Server.MapPath("/CarouselImg")))
                Directory.CreateDirectory(Server.MapPath("/CarouselImg"));
            string filePath = $"/CarouselImg/{Guid.NewGuid()}{Path.GetExtension(file.FileName)}";
            string absolutePath = Server.MapPath(filePath);
            file.SaveAs(absolutePath);

            var model = new SysCarouselImg()
            {
                Name = imgName,
                Sort = sort,
                IsDisplay = isDisplay,
                CreateUserId = OperatorProvider.Instance?.Current?.UserId??"0",
                Url = filePath
            };
            var res = _countryService.Context.Insertable(model).ExecuteReturnIdentity();
            return Success(data: res);
        }
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="id"></param>
        /// <param name="imgName"></param>
        /// <param name="sort"></param>
        /// <param name="isDisplay"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult UpdateCarouselImg(int id,string imgName, int? sort = null, bool? isDisplay = null)
        {
            var res = _countryService.Context.Updateable<SysCarouselImg>()
                .SetColumns(a => new SysCarouselImg() { UpdateTime = DateTime.Now})
                .SetColumnsIF(!string.IsNullOrWhiteSpace(imgName),a=>a.Name==imgName)
                .SetColumnsIF(sort!=null,a=>a.Sort==(int)sort)
                .SetColumnsIF(isDisplay != null,a=>a.IsDisplay == (bool)isDisplay)
                .Where(a => a.Id == id)
                .ExecuteCommand();
            return Success();
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult DeleteCarouselImg(int id)
        {
            var img = _countryService.Context.Queryable<SysCarouselImg>()
                .Where(a => a.Id == id)
                .First();
            if (img == null)
                return Error("找不到该图片");

            var res = _countryService.Context.Deleteable<SysCarouselImg>()
                .Where(a => a.Id == id)
                .ExecuteCommand();
            System.IO.File.Delete(Server.MapPath(img.Url));
            return res > 0 ? Success() : Error();
        }
    }
}

 GasolineBlend/GasolineBlend.csproj

@@ -237,6 +237,7 @@
    <Compile Include="Properties\AssemblyInfo.cs" />
  </ItemGroup>
  <ItemGroup>
    <Content Include="CarouselImg\87128ccc-4930-406a-9096-0250c4adcd19.png" />
    <Content Include="favicon.ico" />
    <Content Include="Global.asax" />
    <Content Include="ApplicationInsights.config">

 Pissa.Service/DbService/SysService.cs

@@ -116,5 +116,7 @@
                .ToPage(pageIndex, pageSize);
            return page;
        }

        
    }
}