/// <summary>
/// 创建
/// </summary>
public void Create(List<RemainderLCLCreateInput> mCreateObjs)
{
try
{
//
foreach (var item in mCreateObjs)
{
Entities.RemainderLCL m = new Entities.RemainderLCL();
m.LCLId = Guid.NewGuid().ToString();
m.LCLCode = "PDH" + m.LCLId;
m.LCLTime = DateTime.Now;
m.CreateUserId = AbpSession.UserId.ToString();
m.CreateTime = DateTime.Now;
m.Remark = "";
//
if (item.LCLMxCreateInput.Count > 0)
{
JIT_RemainderLCL.InsertAsync(m);
foreach (var tmp in item.LCLMxCreateInput)
{
Entities.RemainderLCLMx Mx = new Entities.RemainderLCLMx()
{
LCLMxId = Guid.NewGuid().ToString(),
RemainderLCLId = m.LCLId,
ICMOInspectBillId = tmp.ICMOInspectBillId,
SpelledQty = tmp.SpelledQty,
LCLMxTime = DateTime.Now
};
JIT_RemainderLCLMx.InsertAsync(Mx);
}
}
}
}
catch (Exception e)
{
EX(-1, "创建失败", "请稍后再试！" + e.Message);
}
}
/// <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);
}
/// <summary>
/// 余数拼箱
/// </summary>
public async Task<PagedResultDto<Entities.RemainderLCL>> GetAll(PagedAndSortedResultRequestDto input)
{
var list = await JIT_RemainderLCL.GetAll().PageBy(input).ToListAsync();
return new PagedResultDto<Entities.RemainderLCL>(JIT_RemainderLCL.GetAll().Count(), list);
}
