/*
|
*所有关于Dt_equipmentinfo类的业务代码应在此处编写
|
*可使用repository.调用常用方法，获取EF/Dapper等信息
|
*如果需要事务请使用repository.DbContextBeginTransaction
|
*也可使用DBServerProvider.手动获取数据库相关信息
|
*用户信息、权限、角色等使用UserContext.Current操作
|
*Dt_equipmentinfoService对增、删、改查、导入、导出、审核业务代码扩展参照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.Services.IRepositories;
|
using System;
|
using WIDESEA.Core.Services;
|
using WIDESEA.Core.Enums;
|
using Newtonsoft.Json;
|
using SqlSugar;
|
using WIDESEA_Entity.DomainModels.WCS;
|
|
namespace WIDESEA.Services.Services
|
{
|
public partial class Dt_equipmentinfoService
|
{
|
private readonly IHttpContextAccessor _httpContextAccessor;
|
private readonly IDt_equipmentinfoRepository _repository;//访问数据库
|
|
[ActivatorUtilitiesConstructor]
|
public Dt_equipmentinfoService(
|
IDt_equipmentinfoRepository dbRepository,
|
IHttpContextAccessor httpContextAccessor
|
)
|
: base(dbRepository)
|
{
|
_httpContextAccessor = httpContextAccessor;
|
_repository = dbRepository;
|
//多租户会用到这init代码，其他情况可以不用
|
//base.Init(dbRepository);
|
}
|
|
public override WebResponseContent Update(SaveModel saveModel)
|
{
|
WebResponseContent content = new WebResponseContent();
|
SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
|
{
|
ConnectionString = "Data Source=192.168.2.50;Initial Catalog=WCS_DY;Persist Security Info=True;User ID=sa;Password=123456;Connect Timeout=500;",
|
DbType = DbType.SqlServer,
|
IsAutoCloseConnection = true
|
});
|
try
|
{
|
if (saveModel.MainData["eqment_state"].ToString() == "DisEnable")
|
saveModel.MainData["eqment_state"] = "Enable";
|
else
|
saveModel.MainData["eqment_state"] = "DisEnable";
|
content = base.Update(saveModel);//更行设备状态
|
if (content.Status)
|
{
|
db.Updateable<WIDESEA_Entity.DomainModels.WCS.Dt_equipmentinfo>().SetColumns(x => x.equipment_state == saveModel.MainData["eqment_state"].ToString()).Where(x => x.equipment_name == saveModel.MainData["eqment_id"].ToString()).ExecuteCommand();
|
}
|
Logger.OK(LoggerType.Success, JsonConvert.SerializeObject(saveModel), JsonConvert.SerializeObject(content));
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return content;
|
}
|
}
|
}
|
