/// <summary>
/// 根据盘点单编号得到盘点单详情
/// </summary>
/// <param name="IID">盘点单编号</param>
/// <returns></returns>
public AssInventoryOutputDto GetAssInventoryById(string IID)
{
try
{
var assInventory = _assInventoryRepository.GetAssInventoryByID(IID);
if (assInventory != null)
{
var list = from Inventory in assInventory
join user in _SMOSECDbContext.coreUsers on Inventory.HANDLEMAN equals user.USER_ID
join location in _SMOSECDbContext.AssLocations on Inventory.LOCATIONID equals location.LOCATIONID
select new AssInventoryOutputDto()
{
NAME = Inventory.NAME,
CREATEDATE = Inventory.CREATEDATE,
DEPARTMENTID = Inventory.DEPARTMENTID,
DEPARTMENTNAME = "",
HANDLEMAN = Inventory.HANDLEMAN,
HANDLEMANNAME = user.USER_NAME,
IID = Inventory.IID,
LOCATIONID = Inventory.LOCATIONID,
LOCATIONNAME = location.NAME,
STATUS = Inventory.STATUS,
STATUSNAME = "",
TYPEID = Inventory.TYPEID,
TYPENAME = "",
TOTAL = Inventory.TOTAL
};
var result = list.FirstOrDefault();
string departmentId = result.DEPARTMENTID;
if (!string.IsNullOrEmpty(departmentId))
{
var depart = from department in _SMOSECDbContext.Departments
where department.DEPARTMENTID == departmentId
select department.NAME;
result.DEPARTMENTNAME = depart.FirstOrDefault();
}
string typeId = result.TYPEID;
if (!string.IsNullOrEmpty(typeId))
{
var typeName = from type in _SMOSECDbContext.AssetsTypes
where type.TYPEID == typeId
select type.NAME;
result.TYPENAME = typeName.FirstOrDefault();
}
result.STATUSNAME = Enum.GetName(typeof(InventoryStatus), result.STATUS);
return(result);
}
else
{
throw new Exception("未找到该盘点");
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据盘点单编号得到盘点单详情
/// </summary>
/// <param name="IID">盘点单编号</param>
/// <returns></returns>
public AssInventoryOutputDto GetAssInventoryById(string IID)
{
try
{
var assInventory = _assInventoryRepository.GetAssInventoryByID(IID);
if (assInventory != null)
{
var list = from Inventory in assInventory
join user in _SMOWMSDbContext.coreUsers on Inventory.HANDLEMAN equals user.USER_ID
join wareHouse in _SMOWMSDbContext.WareHouses on Inventory.WAREID equals wareHouse.WAREID
select new AssInventoryOutputDto()
{
NAME = Inventory.NAME,
CREATEDATE = Inventory.CREATEDATE,
// DEPARTMENTID = Inventory.DEPARTMENTID,
// DEPARTMENTNAME = "",
WAREID = Inventory.WAREID,
WareNAME = wareHouse.NAME,
STID = Inventory.STID,
STNAME = "",
SLID = Inventory.SLID,
SLNAME = "",
HANDLEMAN = Inventory.HANDLEMAN,
HANDLEMANNAME = user.USER_NAME,
IID = Inventory.IID,
// LOCATIONID = Inventory.LOCATIONID,
// LOCATIONNAME = location.NAME,
STATUS = Inventory.STATUS,
STATUSNAME = "",
TYPEID = Inventory.TYPEID,
TYPENAME = "",
TOTAL = Inventory.TOTAL
};
var result = list.FirstOrDefault();
string wareId = result.WAREID;
string stId = result.STID;
string slId = result.SLID;
if (!string.IsNullOrEmpty(stId))
{
var st = from storageType in _SMOWMSDbContext.WHStorageTypes
where storageType.STID == stId && storageType.WAREID == wareId
select storageType.NAME;
result.STNAME = st.FirstOrDefault();
}
if (!string.IsNullOrEmpty(slId))
{
var sl = from storageLocation in _SMOWMSDbContext.WHStorageLocations
where storageLocation.STID == stId && storageLocation.WAREID == wareId && storageLocation.SLID == slId
select storageLocation.NAME;
result.SLNAME = sl.FirstOrDefault();
}
string typeId = result.TYPEID;
if (!string.IsNullOrEmpty(typeId))
{
var typeName = from type in _SMOWMSDbContext.AssetsTypes
where type.TYPEID == typeId
select type.NAME;
result.TYPENAME = typeName.FirstOrDefault();
}
result.STATUSNAME = Enum.GetName(typeof(InventoryStatus), result.STATUS);
return(result);
}
else
{
throw new Exception("未找到该盘点");
}
}
catch (Exception ex)
{
throw ex;
}
}