public CPComponetInventoryViewModel()
{
using (K3BhDBContext _context = new K3BhDBContext())
{
CPItemslist = _context.K3Items.Where(w => w.FNumber.StartsWith("5.18.") && w.FDeleted == 0).ToList();
}
}
public static List <ICInventory> GetICInventories(int itemId)
{
using (K3BhDBContext _context = new K3BhDBContext())
{
return(_context.Set <ICInventory>().
Include("K3AuxItem").Where(x => x.Id == itemId && x.FQty > 0).ToList());
}
}
internal async static Task <List <POInventory> > GetPOInventoriesAsync(int itemId)
{
using (K3BhDBContext _context = new K3BhDBContext())
{
return(await _context.Set <POInventory>().
Include("K3AuxItem").Where(x => x.Id == itemId && x.FQty > 0).ToListAsync());
}
}
public ERKeViewModel()
{
using (K3BhDBContext _context = new K3BhDBContext())
{
var qj = _context.QJItems.Where(q => q.StartDate.Year == DateTime.Now.Year && q.StartDate.Month == DateTime.Now.Month).FirstOrDefault();
QJItemView = _context.QJItems.Where(q => q.FItemId > qj.FItemId - 3 && q.FItemId < qj.FItemId + 3).ToList();
};
//齐套
}
public async static Task <decimal> GetNoCheckItemQtyAsync(int itemId)
{
using (K3BhDBContext _context = new K3BhDBContext())
{
return(await(from s in _context.K3SongJianDans
join
n in _context.K3SongJianDanEntries on
s.ID equals n.FID
where s.FMultiCheckStatus != "16" && n.FItemID == itemId
select n.FQty - n.FQty1).DefaultIfEmpty(0).SumAsync());
}
}
/// <summary>
/// Initializes a new instance of the MainViewModel class.
/// </summary>
///
public MpsSelecteViewModel()
{
////if (IsInDesignMode)
////{
//// // Code runs in Blend --> create design time data.
////}
////else
////{
//// // Code runs "for real"
////}
///
using (K3BhDBContext _context = new K3BhDBContext())
{
var qj = _context.QJItems.Where(q => q.StartDate.Year == DateTime.Now.Year && q.StartDate.Month == DateTime.Now.Month).FirstOrDefault();
QJItemView = _context.QJItems.Where(q => q.FItemId > qj.FItemId - 3 && q.FItemId < qj.FItemId + 3).ToList();
};
//齐套
}
private async Task MPSDataLoad(QJItem qJItem)
{
using (K3BhDBContext k3DBContext = new K3BhDBContext())
{
LoadWaitvisibility = Visibility.Visible;
PlanProItemView = await new K3MPSRepository().GetAll()
.Where(x => x.QJId == qJItem.FItemId)
.Where(x => x.K3Dep.FName != "制造二科")
.GroupBy(g => new
{
g.FItemID,
FNumber = g.K3Item.FNumber,
CPCJ = g.K3Dep,
FItem = g.K3Item
})
.Select(s => new MPSPlanItem
{
PlanTotalQty = (int)s.Sum(l => l.FQty),
PlanCount = s.Count(),
CPItem = new K3CPItemBase
{
K3FNumber = s.Key.FItem.FNumber,
K3FModel = s.Key.FItem.FModel,
DepId = s.Key.CPCJ.Id,
DepFName = s.Key.CPCJ.FName,
K3ItemID = s.Key.FItemID
},
QJId = SelectedQJItem.FItemId
}).ToListAsync();
}
PlanProItemView.ForEach(async x => await x.GetQtyAsync(qJItem));
WorkShopView = PlanProItemView.Select(s => s.CPItem?.DepFName).DefaultIfEmpty().Distinct().ToList();
FilterPlanQty = PlanProItemView.Select(s => s.PlanTotalQty).DefaultIfEmpty().Sum();
RaisePropertyChanged("MPSListView");
LoadWaitvisibility = Visibility.Collapsed;
}
public BOMDecompose(K3CPItemBase cpitem)
{
_cpItem = cpitem;
_dbContext = new K3BhDBContext();
}
public static int GetItemIdByFNumber(string fnumber)
{
K3BhDBContext _dbcontext = new K3BhDBContext();
return(_dbcontext.CustObjs.Where(x => x.FNumber == fnumber).Select(x => x.ID).FirstOrDefault());
}
