using System.Data;
|
using MES.Service.DB;
|
using MES.Service.Dto.service;
|
using MES.Service.Modes;
|
using MES.Service.util;
|
using SqlSugar;
|
using DbType = System.Data.DbType;
|
|
namespace MES.Service.service.QC;
|
|
public class MesLaboratoryService : Repository<MesLaboratory>
|
{
|
//OQCDto
|
public bool SaveLaboratory(OQCDto dto)
|
{
|
//1.根据BillNo查询视图VLaboratory，用dto的OrderNo，使用.First()只返回一个对象
|
var vLaboratory = Context.Queryable<VLaboratory>()
|
.Where(x => x.BillNo == dto.OrderNo)
|
.First();
|
|
//2.将查询出来的VLaboratory转换为MesLaboratory
|
var mesLaboratory = new MesLaboratory
|
{
|
BillNo = vLaboratory.BillNo,
|
LineNo = vLaboratory.LineNo,
|
ItemId = vLaboratory.ItemId,
|
ItemNo = vLaboratory.ItemNo,
|
ItemName = vLaboratory.ItemName,
|
ItemModel = vLaboratory.ItemModel,
|
DepartmentId = vLaboratory.DepartmentId,
|
DepartmentCode = vLaboratory.DepartmentCode,
|
SaleOrderNoc = vLaboratory.SaleOrderNoc,
|
CreateBy = dto.CreateUser,
|
CreateTime = DateTime.Now
|
};
|
|
//3.插入到数据库中
|
return Context.Insertable(mesLaboratory)
|
.IgnoreColumns(ignoreNullColumn: true)
|
.ExecuteCommand() > 0;
|
}
|
|
public new object InsertReturnIdentity(MesLaboratory data)
|
{
|
return base.InsertReturnIdentity(data);
|
}
|
|
public (List<MesLaboratory> item, int TotalCount) GetPage(
|
XJPageResult queryObj)
|
{
|
if (queryObj == null)
|
throw new ArgumentNullException(nameof(queryObj));
|
|
var db = Db;
|
var totalCount = 0;
|
|
if (!decimal.TryParse(queryObj.id, out var id))
|
id = 0;
|
|
var pageList = db
|
.Queryable<MesLaboratory, SysUser, SysUser>((a, b, c) =>
|
new JoinQueryInfos(JoinType.Left, a.CreateBy == b.Fcode,
|
JoinType.Left, a.InspectionBy == c.Fcode
|
))
|
.WhereIF(id > 0, (a, b, c) => a.Id == id)
|
.Select((a, b, c) => new MesLaboratory()
|
{
|
CreateUser = b.Fname,
|
InspectionUser = c.Fname,
|
DepartmentId = a.DepartmentId,
|
}, true)
|
.OrderByDescending(a => a.Id)
|
.ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount);
|
|
return (pageList, totalCount);
|
}
|
|
/// <summary>
|
/// 录入检验结果
|
/// </summary>
|
/// <param name="data">实验室检测数据</param>
|
/// <returns></returns>
|
public bool UpdateInspectionResult(MesLaboratory data)
|
{
|
return Context.Updateable<MesLaboratory>()
|
.SetColumnsIF(!string.IsNullOrEmpty(data.InspectionResult),
|
x => x.InspectionResult == data.InspectionResult)
|
.SetColumnsIF(!string.IsNullOrEmpty(data.InspectionBy),
|
x => x.InspectionBy == data.InspectionBy)
|
.SetColumns(x => x.InspectionTime == DateTime.Now)
|
.Where(x => x.Id == data.Id)
|
.ExecuteCommand() > 0;
|
}
|
}
|
