/// <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(); } } }