public override void OpenRecord(long Id)
{
base.OpenRecord(Id);
AllowRefresh = true;
itmInventory = BL.ITM.ITM_Inventory.Load(Id, DataContext);
sysInventoryEntity = BL.SYS.SYS_Entity.Load(itmInventory.EntityId, DataContext);
itmHistory = BL.ITM.ITM_History.GetItemCurrentHistory(itmInventory, DataContext);
foreach (var item in BL.ITM.ITM_Surcharge.LoadByEntityId(sysInventoryEntity.Id, DataContext))
{
itmSurcharge.Add(item);
}
foreach (var item in BL.ITM.ITM_InventorySupplier.LoadByEntityId(sysInventoryEntity.Id, DataContext))
{
itmInventorySupplier.Add(item);
}
}
//public static DB.ITM_Inventory GetNextItem(DB.ITM_Inventory ITM_Inventory, DataContext dataContext)
//{
// return dataContext.EntityInventoryContext.ITM_Inventory.OrderBy(o => o.SYS_Entity.CodeMain).ThenBy(o => o.SYS_Entity.CodeSub).FirstOrDefault(n => n.SYS_Entity.CodeMain.CompareTo(ITM_Inventory.SYS_Entity.CodeMain) > 0 && n.SYS_Entity.CodeMain.CompareTo(ITM_Inventory.SYS_Entity.CodeMain) != 0);
//}
//public static DB.ITM_Inventory GetPreviousItem(DB.ITM_Inventory ITM_Inventory, DataContext dataContext)
//{
// return dataContext.EntityInventoryContext.ITM_Inventory.OrderByDescending(o => o.SYS_Entity.CodeMain).ThenByDescending(o => o.SYS_Entity.CodeSub).FirstOrDefault(n => n.SYS_Entity.CodeMain.CompareTo(ITM_Inventory.SYS_Entity.CodeMain) < 0 && n.SYS_Entity.CodeMain.CompareTo(ITM_Inventory.SYS_Entity.CodeMain) != 0);
//}
public static int GenerateInventoryHistory(DB.ITM_Inventory inventory, DataContext dataContext)
{
return(dataContext.EntityInventoryContext.Database.ExecuteSqlCommand("EXEC CDS_SYS.spGenerateInventoryHistory {0}, {1}", inventory.EntityId, inventory.SiteId));
}
