public List <MultiWorkResultEntryViewDTO> LoadChildItemToInputMultiWorkResult(NZString childItemCode, NZString orderLoc, NZString lotNo, DataDefine.eTRAN_SUB_CLS workResultType)
{
InventoryBIZ biz = new InventoryBIZ();
return(biz.LoadChildItemToInputMultiWorkResult(childItemCode, orderLoc, lotNo, workResultType));
}
public List <MultiWorkResultEntryViewDTO> LoadChildItemToInputMultiWorkResult(Database database, NZString ITEM_CD, NZString ORDER_LOC, NZString LOT_NO, DataDefine.eTRAN_SUB_CLS workResultType)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
InventoryPeriodDAO periodDao = new InventoryPeriodDAO(db);
InventoryPeriodDTO periodDto = periodDao.LoadCurrentYearMonth(null);
#region SQL Statement
sb.AppendLine(@"select stk.LOT_NO, stk.ON_HAND_QTY ");
sb.AppendLine(@"from TB_INV_ONHAND_TR stk");
sb.AppendLine(@"where (STK.LOC_CD = :ORDER_LOC)");
sb.AppendLine(@"and (STK.YEAR_MONTH = :YEAR_MONTH)");
sb.AppendLine(@"and (STK.ITEM_CD = :ITEM_CD)");
sb.AppendLine(@"and (STK.ON_HAND_QTY > 0)");
sb.AppendLine(@"and (STK.LOT_NO like :LOT_NO + '%' or :LOT_NO is null)");
if (workResultType == DataDefine.eTRAN_SUB_CLS.WR)
{
sb.AppendLine(@"and (STK.LOT_NO not like '%#R')"); //work result หา lot ปกติ
}
else if (workResultType == DataDefine.eTRAN_SUB_CLS.RW)
{
sb.AppendLine(@"and (STK.LOT_NO like '%#R')"); //rework หา lot ที่เป็น reserve
}
else
{
throw new NotSupportedException();
}
#endregion
DataRequest req = new DataRequest(sb.ToString());
req.Parameters.Add("ITEM_CD", DataType.NVarChar, ITEM_CD.Value);
req.Parameters.Add("ORDER_LOC", DataType.NVarChar, ORDER_LOC.Value);
req.Parameters.Add("YEAR_MONTH", DataType.NVarChar, periodDto.YEAR_MONTH.Value);
req.Parameters.Add("LOT_NO", DataType.VarChar, LOT_NO.Value);
return(db.ExecuteForList <MultiWorkResultEntryViewDTO>(req));
}
