/*
|
*所有关于dt_stationinfo类的业务代码应在此处编写
|
*可使用repository.调用常用方法，获取EF/Dapper等信息
|
*如果需要事务请使用repository.DbContextBeginTransaction
|
*也可使用DBServerProvider.手动获取数据库相关信息
|
*用户信息、权限、角色等使用UserContext.Current操作
|
*dt_stationinfoService对增、删、改查、导入、导出、审核业务代码扩展参照ServiceFunFilter
|
*/
|
using WIDESEA_Core.BaseProvider;
|
using WIDESEA_Core.Extensions.AutofacManager;
|
using WIDESEA_Entity.DomainModels;
|
using System.Linq;
|
using WIDESEA_Core.Utilities;
|
using System.Linq.Expressions;
|
using WIDESEA_Core.Extensions;
|
using Microsoft.EntityFrameworkCore;
|
using Microsoft.Extensions.DependencyInjection;
|
using Microsoft.AspNetCore.Http;
|
using WIDESEA_WMS.IRepositories;
|
using Newtonsoft.Json;
|
using WIDESEA_Comm.LogInfo;
|
using WIDESEA_Core.FreeDB;
|
using WIDESEA_Core.ManageUser;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
|
|
namespace WIDESEA_WMS.Services
|
{
|
public class Parm
|
{
|
public List<string> data { get; set; }
|
public int type { get; set; }
|
}
|
public partial class dt_stationinfoService
|
{
|
private readonly IHttpContextAccessor _httpContextAccessor;
|
private readonly Idt_stationinfoRepository _repository;//访问数据库
|
|
[ActivatorUtilitiesConstructor]
|
public dt_stationinfoService(
|
Idt_stationinfoRepository dbRepository,
|
IHttpContextAccessor httpContextAccessor
|
)
|
: base(dbRepository)
|
{
|
_httpContextAccessor = httpContextAccessor;
|
_repository = dbRepository;
|
//多租户会用到这init代码，其他情况可以不用
|
//base.Init(dbRepository);
|
}
|
FreeDB freeDB=new FreeDB();
|
/// <summary>
|
/// 设置缓存架禁用启用
|
/// </summary>
|
/// <param name="json"></param>
|
/// <returns></returns>
|
public WebResponseContent SetStationEnable(object json)
|
{
|
WebResponseContent webResponse = new WebResponseContent();
|
try
|
{
|
var Tel = UserContext.Current.UserInfo.Tel;//缓存架权限
|
var data = JsonConvert.DeserializeObject<Parm>(json.ToString());
|
//var updateList = FreeDB.DB.Select<dt_stationinfo>().Where(t => data.data.Contains(t.id.ToString())).ToList();
|
var updateList = _repository.Find(x => data.data.Contains(x.id.ToString())).ToList();
|
if (!string.IsNullOrEmpty(Tel))
|
{
|
var types = Tel.Split(',');
|
foreach (var update in updateList)
|
{
|
var OK = false;
|
foreach (var type in types)
|
{
|
if (update.stationCode.Contains(type))
|
OK = true;
|
}
|
if (!OK) throw new Exception("当前账号无禁用权限!");
|
}
|
}
|
|
var res = freeDB.Update<dt_stationinfo>()
|
.Set(t => t.enable, data.type == 1)
|
.Where(t => data.data.Contains(t.id.ToString()))
|
.ExecuteAffrows();
|
|
var msg = data.type == 1 ? "启用" : "禁用";
|
WriteDBLog.Write($"手动{msg}站点 ", $"{string.Join('、', updateList.Select(t => t.stationCode).ToArray())}", LogState.Sucess, "WCS", UserContext.Current.UserName);
|
|
webResponse.OK();
|
}
|
catch (Exception ex)
|
{
|
WriteDBLog.Write($"手动启用或禁用站点 ", new { 错误信息 = ex.Message, 数据 = json }, LogState.Error, "WCS", UserContext.Current.UserName);
|
webResponse.Error(ex.Message);
|
}
|
return webResponse;
|
}
|
public override WebResponseContent Add(SaveModel saveDataModel)
|
{
|
|
return base.Add(saveDataModel);
|
}
|
}
|
}
|
