public async Task <PagedResultDto <VM_Inventory> > GetAll(VM_InventoryGetAllInput input)
{
var query = JIT_VM_Inventory.GetAll();
var data = await query.OrderBy(input.Sorting).PageBy(input).ToListAsync();
var list = data.MapTo <List <VM_Inventory> >();
return(new PagedResultDto <VM_Inventory>(query.Count(), list));
}
/// <summary>
/// 查询任务数量
/// </summary>
public async Task <List <TaskQty> > GetTaskQty(string StrKey)
{
string isAll = StrKey;
StrKey = "," + StrKey + ",";
List <TaskQty> listTaskQty = new List <TaskQty>();
// 开始形成数据
if (isAll == "*" || StrKey.Contains(TaskType.派工任务.ToDescription()))
{
TaskQty tmpTaskQty = new TaskQty()
{
StrKey = TaskType.派工任务.ToDescription().Replace(",", ""),
Total = await JIT_VW_MODispBillList.GetAll()
.Where(w => w.操作者 == AbpSession.UserId && w.FStatus == 0).CountAsync(),
BZ = "待开工任务数量"
};
listTaskQty.Add(tmpTaskQty);
}
if (isAll == "*" || StrKey.Contains(TaskType.质量检验.ToDescription()))
{
TaskQty tmpTaskQty = new TaskQty()
{
StrKey = TaskType.质量检验.ToDescription().Replace(",", ""),
Total = await JIT_VW_MODispBillList.GetAll().Where(w => w.FStatus == 1).CountAsync(),
BZ = "质量检验待检验数量"
};
listTaskQty.Add(tmpTaskQty);
}
if (isAll == "*" || StrKey.Contains(TaskType.库存查询.ToDescription()))
{
TaskQty tmpTaskQty = new TaskQty()
{
StrKey = TaskType.库存查询.ToDescription().Replace(",", ""),
Total = await JIT_VM_Inventory.GetAll().CountAsync(),
BZ = "库存查询数量"
};
listTaskQty.Add(tmpTaskQty);
}
if (isAll == "*" || StrKey.Contains(TaskType.条码打印.ToDescription()))
{
TaskQty tmpTaskQty = new TaskQty()
{
StrKey = TaskType.条码打印.ToDescription().Replace(",", ""),
Total = 0,
BZ = ""
};
listTaskQty.Add(tmpTaskQty);
}
if (isAll == "*" || StrKey.Contains(TaskType.派工任务待开工.ToDescription()))
{
TaskQty tmpTaskQty = new TaskQty()
{
StrKey = TaskType.派工任务待开工.ToDescription().Replace(",", ""),
Total = await JIT_VW_MODispBillList.GetAll()
.Where(w => w.操作者 == AbpSession.UserId && w.FStatus == 0).CountAsync(),
BZ = "派工任务待开工"
};
listTaskQty.Add(tmpTaskQty);
}
if (isAll == "*" || StrKey.Contains(TaskType.派工任务待汇报.ToDescription()))
{
TaskQty tmpTaskQty = new TaskQty()
{
StrKey = TaskType.派工任务待汇报.ToDescription().Replace(",", ""),
Total = await JIT_VW_MODispBillList.GetAll()
.Where(w => w.操作者 == AbpSession.UserId && w.FStatus == 1).CountAsync(),
BZ = "派工任务待汇报"
};
listTaskQty.Add(tmpTaskQty);
}
if (isAll == "*" || StrKey.Contains(TaskType.质量检验待检验.ToDescription()))
{
TaskQty tmpTaskQty = new TaskQty()
{
StrKey = TaskType.质量检验待检验.ToDescription().Replace(",", ""),
Total = await JIT_VW_MODispBillList.GetAll().Where(w => w.FStatus == 1).CountAsync(),
BZ = "质量检验待检验"
};
listTaskQty.Add(tmpTaskQty);
}
if (isAll == "*" || StrKey.Contains(TaskType.质量检验已检验.ToDescription()))
{
TaskQty tmpTaskQty = new TaskQty()
{
StrKey = TaskType.质量检验已检验.ToDescription().Replace(",", ""),
Total = await JIT_VW_MODispBillList.GetAll().Where(w => w.FStatus == 2).CountAsync(),
BZ = "质量检验已检验"
};
listTaskQty.Add(tmpTaskQty);
}
if (isAll == "*" || StrKey.Contains(TaskType.包装余数.ToDescription()))
{
TaskQty tmpTaskQty = new TaskQty()
{
StrKey = TaskType.包装余数.ToDescription().Replace(",", ""),
Total = await JIT_ICMODispBill.GetAll().Join(JIT_ICMOInspectBill.GetAll(), A => A.FID,
B => B.ICMODispBillID,
(A, B) => new
{
A.FBillNo,
A.FBiller,
A.FDate,
FBillNo2 = B.FBillNo,
B.BatchNum,
B.FYSQty,
B.FInspector,
B.FInspectTime,
A.employee.FName,
//
A.FStatus
}).Where(A => A.FStatus >= PublicEnum.ICMODispBillState.已检验.EnumToInt() && A.FYSQty > 0)
.CountAsync(),
BZ = "包装余数"
};
listTaskQty.Add(tmpTaskQty);
}
if (isAll == "*" || StrKey.Contains(TaskType.拼箱记录.ToDescription()))
{
TaskQty tmpTaskQty = new TaskQty()
{
StrKey = TaskType.拼箱记录.ToDescription().Replace(",", ""),
Total = await JIT_RemainderLCL.GetAll().CountAsync(),
BZ = "拼箱记录"
};
listTaskQty.Add(tmpTaskQty);
}
// 所有枚举信息
string[] listTaskType = new string[Enum.GetValues(typeof(TaskType)).Length];
int i = 0;
foreach (TaskType ty in Enum.GetValues(typeof(TaskType)))
{
listTaskType[i] = ty.ToDescription();
i++;
}
if (isAll != "*" && !listTaskType.Contains(StrKey))
{
TaskQty tmpTaskQty = new TaskQty()
{
StrKey = StrKey.Replace(",", ""),
Total = 0,
BZ = StrKey.Replace(",", "") + ",未定义,所以数量为0"
};
listTaskQty.Add(tmpTaskQty);
}
return(listTaskQty);
}
