public static string IssueReceived(IssueReceivedEntity entity) { IssueReceivedDal IRDal = new IssueReceivedDal(); IRDal.DataBase.BeginTransaction(); string rmesid = IRDal.Insert(entity); LineSideStockFactory.Storage(entity.ITEM_CODE, entity.VENDOR_CODE, "", entity.LOCATION_CODE, entity.PLINE_CODE, entity.ITEM_QTY); IRDal.DataBase.CompleteTransaction(); return(rmesid); }
public static string TransToWMSStore(string planCode, string resourceStore, string itemCode, string destinationStore, int transQTY) { DB.GetInstance().BeginTransaction(); try { List <PlanBomEntity> planBOMs = PlanBOMFactory.GetByOrderCode(planCode); planBOMs = (from p in planBOMs where p.ITEM_CODE == itemCode && p.LINESIDE_STOCK_CODE == resourceStore select p).ToList <PlanBomEntity>(); List <LineSideStockEntity> all = DB.GetInstance().Fetch <LineSideStockEntity>(""); PlanBomEntity resouece = planBOMs[0]; LineSideStockEntity rsourceStore = LineSideStockFactory.GetStoreItem(resourceStore, itemCode); LineSideStockEntity destination = LineSideStockFactory.GetStoreItem(destinationStore, itemCode); rsourceStore.ITEM_QTY = rsourceStore.ITEM_QTY - transQTY; DB.GetInstance().Update(rsourceStore); IMESLine2LineEntity line2lineEntity = new IMESLine2LineEntity { AUFNR = resouece.ORDER_CODE, WERKS = resouece.FACTORY, VORNR = resouece.PROCESS_CODE, SUBMAT = resouece.ITEM_CODE, MENGE = transQTY.ToString(), TLGORT = destinationStore, SLGORT = resourceStore, PRIND = "0", }; DB.GetInstance().Insert(line2lineEntity); SAPMessageTransEntity msgEntity = new SAPMessageTransEntity { MESSAGE_CODE = "0047", WORK_DATE = DateTime.Now, HANDLE_FLAG = "0", }; DB.GetInstance().Insert(msgEntity); DB.GetInstance().CompleteTransaction(); return("true"); } catch (Exception e) { DB.GetInstance().AbortTransaction(); return(e.Message); } }