using AutoMapper;
|
using Model.ModelDto.SysDto;
|
using System;
|
using System.Collections.Generic;
|
using System.Security.Cryptography;
|
using System.Text;
|
using System.Text.RegularExpressions;
|
using System.Threading.Tasks;
|
using SqlSugar;
|
using WMS.DAL;
|
using WMS.Entity.Context;
|
using WMS.Entity.SysEntity;
|
using WMS.IBLL.ISysServer;
|
using WMS.IDAL.ISysInterface;
|
using Utility;
|
using Microsoft.AspNetCore.Identity;
|
|
namespace WMS.BLL.SysServer
|
{
|
public class FunSettingServer : DbHelper<SysFunSetting>, IFunSettingServer
|
{
|
private static readonly SqlSugarScope Db = DataContext.Db;
|
|
/// <summary>
|
/// 依赖注入
|
/// </summary>
|
private readonly IFunSettingRepository _setting;
|
private readonly IMapper _mapper;
|
private readonly UserManager _userManager;
|
/// <summary>
|
/// 构造函数
|
/// </summary>
|
/// <param name="setting">功能设定</param>
|
/// <param name="mapper">automapper</param>
|
public FunSettingServer(IFunSettingRepository setting, IMapper mapper, UserManager userManager) : base(Db)
|
{
|
_setting = setting;//功能设定
|
_mapper = mapper;//automapper
|
_userManager = userManager;
|
}
|
|
|
/// <summary>
|
/// 获取功能设定信息列表
|
/// </summary>
|
/// <param name="FunSetName">功能名称</param>
|
/// <param name="IsEnable">开启状态</param>
|
/// <param name="GroupNo">组号</param>
|
/// <returns></returns>
|
public async Task<List<FunSettingDto>> GetFunSettingList(string FunSetName, string IsEnable, string GroupNo)
|
{
|
return await Db.Queryable<SysFunSetting>()
|
.LeftJoin<SysUserInfor>((a, b) => a.CreateUser == b.Id)
|
.WhereIF(!string.IsNullOrEmpty(FunSetName), a => a.FunSetName.Contains(FunSetName))
|
.WhereIF(!string.IsNullOrEmpty(GroupNo), a => a.GroupNo.Contains(GroupNo))
|
.WhereIF(!string.IsNullOrEmpty(IsEnable), a => a.IsEnable == IsEnable)
|
.Where(a => a.IsDel == "0")
|
.Select<FunSettingDto>((a, b) => new FunSettingDto() { CreateName = b.RealName }, true)
|
.ToListAsync();
|
}
|
|
/// <summary>
|
/// 根据id查询功能设定信息
|
/// </summary>
|
/// <param name="id">功能id</param>
|
/// <returns></returns>
|
public async Task<SysFunSetting> GetFunSettingById(int id)
|
{
|
return await Db.Queryable<SysFunSetting>().FirstAsync(s => s.Id == id);
|
}
|
|
/// <summary>
|
/// 根据编号查询功能设定消息
|
/// </summary>
|
/// <param name="funSetNo">功能编号</param>
|
/// <returns></returns>
|
public async Task<SysFunSetting> GetFunSettingByNo(string funSetNo)
|
{
|
return await Db.Queryable<SysFunSetting>().FirstAsync(a => a.IsDel == "0" && a.FunSetNo == funSetNo);
|
}
|
|
///// <summary>
|
///// 根据编号查询功能设定信息
|
///// </summary>
|
///// <param name="FunSetNo">功能编号</param>
|
///// <returns></returns>
|
//public int GetFunSettingByNo(string FunSetNo)
|
//{
|
// List<SysFunSetting> funSettings = _setting.GetFunSettingByNo(FunSetNo);
|
// return funSettings.Count;
|
//}
|
|
/// <summary>
|
/// 新增功能信息
|
/// </summary>
|
/// <param name="settingdto">功能设定dto</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> AddFunSettings(FunSettingDto settingdto)
|
{
|
//映射模型
|
SysFunSetting setting = _mapper.Map<SysFunSetting>(settingdto);
|
var setData = await Db.Queryable<SysFunSetting>().FirstAsync(m => m.IsDel == "0" && m.GroupNo == settingdto.GroupNo && m.SetValue == settingdto.SetValue);
|
if (setData != null)
|
{
|
throw Oops.Bah("同组内设定值重复");
|
}
|
setting.CreateTime = DateTime.Now;
|
setting.CreateUser = _userManager.UserId;
|
return await Db.Insertable(setting).ExecuteCommandAsync();
|
}
|
|
/// <summary>
|
/// 删除功能信息
|
/// </summary>
|
/// <param name="funSetting">功能设定实体模型</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> DelFunSettings(SysFunSetting funSetting)
|
{
|
return await Db.Updateable<SysFunSetting>()
|
.Where(s => s.Id == funSetting.Id)
|
.SetColumns(s => s.IsDel == "1")
|
.SetColumns(s => s.UpdateTime == DateTime.Now)
|
.SetColumns(s => s.UpdateUser == _userManager.UserId)
|
.ExecuteCommandAsync();
|
}
|
|
/// <summary>
|
/// 编辑功能信息
|
/// </summary>
|
/// <param name="setting">功能设定实体</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> ExitFunSettings(FunSettingDto settingdto)
|
{
|
SysFunSetting setting = _mapper.Map<SysFunSetting>(settingdto);
|
|
var setData = await Db.Queryable<SysFunSetting>()
|
.FirstAsync(m => m.IsDel == "0" && m.GroupNo == settingdto.GroupNo && m.SetValue == settingdto.SetValue && m.Id != settingdto.Id);
|
if (setData != null)
|
{
|
throw Oops.Bah("同组内设定值重复");
|
}
|
setting.UpdateUser = _userManager.UserId;
|
setting.UpdateTime = DateTime.Now;
|
return await Db.Updateable(setting)
|
.UpdateColumns(s => new { s.FunSetName, s.SetValue, s.FunText, s.IsEnable, s.Ord, s.GroupNo, s.UpdateUser, s.UpdateTime })
|
.ExecuteCommandAsync();
|
}
|
}
|
}
|
