using NewPdaSqlServer.DB;
|
using NewPdaSqlServer.Dto.service;
|
using NewPdaSqlServer.entity;
|
using NewPdaSqlServer.util;
|
using SqlSugar;
|
|
namespace NewPdaSqlServer.service.Warehouse;
|
|
public class MesInvItemArnManager : Repository<MesInvItemArn>
|
{
|
//当前类已经继承了 Repository 增、删、查、改的方法
|
|
//这里面写的代码不会给覆盖,如果要重新生成请删除 MesInvItemArnManager.cs
|
public List<MesInvItemArn> GetPagedResults(WarehouseQuery query)
|
{
|
var parsedGuid = Guid.Empty;
|
if (!string.IsNullOrEmpty(query.id))
|
{
|
var isValid = Guid.TryParse(query.id, out parsedGuid);
|
if (!isValid)
|
throw new ApplicationException("GUID转换错误");
|
}
|
|
// 查询并分页
|
var result = Db.Queryable<MesInvItemArn, MesDepots, MesSupplier>(
|
(a, d, f) => new object[]
|
{
|
JoinType.Left, a.DepotsId == d.DepotId.ToString(),
|
JoinType.Left, a.SuppId == f.Id.ToString()
|
})
|
.Where((a, d, f) => a.BillTypeId == 700
|
&& a.TransctionNo == "701"
|
&& a.IsVisual == 0)
|
.WhereIF(UtilityHelper.CheckGuid(parsedGuid),
|
(a, d, f) => a.Guid == parsedGuid)
|
.Select((a, d, f) => new MesInvItemArn
|
{
|
Status = a.Status,
|
SuppNo = f.SuppNo,
|
FType = a.FType,
|
Fstatus = a.Fstatus,
|
Remark = a.Remark,
|
CheckDate = a.CheckDate,
|
DepotsCode = d.DepotCode,
|
Guid = a.Guid,
|
UrgentFlag = a.UrgentFlag,
|
CreateBy = a.CreateBy,
|
BillNo = a.BillNo,
|
PaperBillNo = a.PaperBillNo,
|
DepotName = d.DepotName,
|
SuppName = f.SuppName
|
}).OrderByDescending(a => a.BillNo)
|
.ToPageList(query.PageIndex, query.Limit);
|
|
return result;
|
}
|
|
public List<MesSupplier> GetSuppliers()
|
{
|
return Db.Queryable<MesInvItemArn, MesSupplier>((a, b) =>
|
new JoinQueryInfos(JoinType.Left, a.SuppId == b.Id.ToString()))
|
.GroupBy((a, b) => new { b.Id, b.SuppNo, b.SuppName })
|
.Select((a, b) => new MesSupplier
|
{
|
SuppNo = b.SuppNo,
|
SuppName = b.SuppName,
|
Id = b.Id
|
})
|
.ToList();
|
}
|
}
|
