/// <summary>
/// Load lookup for lot number by item and location code
/// If these lot no has no onhand qty will be supressed.
/// </summary>
/// <param name="ItemCD"></param>
/// <param name="LocationCD"></param>
/// <returns></returns>
public LookupData LoadLookupLotNo(NZString ItemCD, NZString LocationCD, NZString YearMonth)
{
InventoryOnhandDAO dao = new InventoryOnhandDAO(CommonLib.Common.CurrentDatabase);
InventoryPeriodBIZ inventoryPeriodBIZ = new InventoryPeriodBIZ();
InventoryPeriodDTO inventoryPeriodDTO = inventoryPeriodBIZ.LoadCurrentPeriod();
List <InventoryOnhandDTO> listOnhand = dao.LoadLotNoWithHasOnhandQty(null, YearMonth, inventoryPeriodDTO.YEAR_MONTH, ItemCD, LocationCD);
DataTable dt = DTOUtility.ConvertListToDataTable(listOnhand);
LookupData lookupData = new LookupData(dt,
InventoryOnhandDTO.eColumns.LOT_NO.ToString(),
InventoryOnhandDTO.eColumns.LOT_NO.ToString());
return(lookupData);
}
//public int AddNew(ItemDTO dtoItem, ItemProcessDTO dtoItemProcess)
//{
// ItemValidator validator = new ItemValidator();
// validator.ValidateBeforeSaveNew(dtoItem, dtoItemProcess);
// Database db = CommonLib.Common.CurrentDatabase;
// db.KeepConnection = true;
// db.BeginTransaction();
// try
// {
// ItemDAO daoItem = new ItemDAO(CommonLib.Common.CurrentDatabase);
// daoItem.AddNew(null, dtoItem);
// //ItemProcessDAO daoItemProcess = new ItemProcessDAO(CommonLib.Common.CurrentDatabase);
// //daoItemProcess.AddNew(null, dtoItemProcess);
// db.Commit();
// return 1;
// }
// catch (Exception err)
// {
// db.Rollback();
// throw err;
// }
// finally
// {
// if (db.DBConnectionState == ConnectionState.Open)
// db.Close();
// }
//}
public int DeleteItem(NZString ItemCD)
{
Database db = CommonLib.Common.CurrentDatabase;
db.KeepConnection = true;
db.BeginTransaction();
try
{
ItemDAO dao = new ItemDAO(CommonLib.Common.CurrentDatabase);
dao.Delete(null, ItemCD);
ItemProcessDAO daoProc = new ItemProcessDAO(CommonLib.Common.CurrentDatabase);
daoProc.DeleteByItem(null, ItemCD);
InventoryTransactionDAO daoInvTrans = new InventoryTransactionDAO(db);
daoInvTrans.DeleteByItem(null, ItemCD);
InventoryOnhandDAO daoInv = new InventoryOnhandDAO(CommonLib.Common.CurrentDatabase);
daoInv.DeleteByItem(null, ItemCD);
//ItemImageBIZ bizImage = new ItemImageBIZ();
//bizImage.DeleteImage(ItemCD);
db.Commit();
return(1);
}
catch (Exception err)
{
db.Rollback();
throw err;
}
finally
{
if (db.DBConnectionState == ConnectionState.Open)
{
db.Close();
}
}
}
