protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5SR_PTSfSR Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var paramQCI = new P_L5SR_GQCIfRHId_1359() { HeaderID = Parameter.ReceiptHeaderID }; var qualityControlItems = cls_Get_QualityControlItems_for_ReceiptHeaderID.Invoke(Connection, Transaction, paramQCI, securityTicket).Result; Guid[] articleIDs = qualityControlItems.Select(x => x.ProductID).Distinct().ToArray(); var paramArticleStorage = new P_L3WH_GASfA_1924 { ArticleID_List = articleIDs }; var storages = CL3_Warehouse.Atomic.Retrieval.cls_Get_ArticleStorages_for_ArticleIDList.Invoke(Connection, Transaction, paramArticleStorage, securityTicket).Result. Where(x => x.QLShelfID != Guid.Empty && x.IsPointOfSalesArea == true); foreach (var item in qualityControlItems) { var shelf = storages.FirstOrDefault(x => x.ArticleID == item.ProductID); if (shelf == null || shelf.ShelfID == Guid.Empty) { continue; } var query = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query { LOG_RCP_Receipt_Position_QualityControlItem = item.LOG_RCP_Receipt_Position_QualityControlItem, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; var values = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query { Target_WRH_Shelf_RefID = shelf.ShelfID }; CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query.Update(Connection, Transaction, query, values); } return(returnValue); #endregion UserCode }
protected static FR_L3SP_GDSfP_1401 Execute(DbConnection Connection, DbTransaction Transaction, P_L3SP_GDSfP_1401 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L3SP_GDSfP_1401(); //Put your code here List <Guid> article = new List <Guid>() { Parameter.ArticleID }; var storageParam = new P_L3WH_GASfA_1924(); storageParam.ArticleID_List = article.ToArray(); var storages = cls_Get_ArticleStorages_for_ArticleIDList.Invoke(Connection, Transaction, storageParam, securityTicket).Result; L3SP_GDSfP_1401 resultingSupplier = new L3SP_GDSfP_1401(); foreach (var storage in storages) { P_L3SP_GDSfS_1347 supplierParam = new P_L3SP_GDSfS_1347(); supplierParam.AreaID = storage.AreaID; supplierParam.RackID = storage.RackID; supplierParam.WarehouseID = storage.WarehouseID; var supplier = cls_Get_Default_Supplier_from_Storage.Invoke(Connection, Transaction, supplierParam, securityTicket).Result; if (supplier != null) { resultingSupplier.Supplier = supplier; break; } } returnValue.Result = resultingSupplier; return(returnValue); #endregion UserCode }
protected static FR_L3PR_GAwSPfT_1002_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3PR_GAwSPfT_1002 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L3PR_GAwSPfT_1002_Array(); //Put your code here List <L3PR_GAwSPfT_1002> retVal = new List <L3PR_GAwSPfT_1002>(); P_L3WH_GASfA_1924 par = new P_L3WH_GASfA_1924(); par.ArticleID_List = Parameter.ArticleID_List.Select(i => i).ToArray(); var articleStorages = cls_Get_ArticleStorages_for_ArticleIDList.Invoke(Connection, Transaction, par, securityTicket).Result.Where(i => i.ShelfID != Guid.Empty).ToList(); #region Get All StoragePlaces for TenantID var shelfIDs = articleStorages.Select(i => i.ShelfID).Distinct().ToArray(); var productIDs = articleStorages.Select(i => i.ArticleID).Distinct().ToArray(); var filterCriteria = new P_L3WH_GSPfFC_1504() { WarehouseGroupID = null, WarehouseID = null, AreaID = null, RackID = null, UseShelfIDList = shelfIDs.Length != 0, ShelfIDs = shelfIDs.Length == 0 ? new Guid[] { Guid.Empty } : shelfIDs, UseProductIDList = productIDs.Length != 0, ProductIDs = productIDs.Length == 0 ? new Guid[] { Guid.Empty } : productIDs, BottomShelfQuantity = null, TopShelfQuantity = null, UseProductTrackingInstanceIDList = false, ProductTrackingInstanceIDs = new Guid[] { Guid.Empty }, StartExpirationDate = null, EndExpirationDate = null }; var allStoragePlacesForTenant = cls_Get_StoragePlaces_for_FilterCriteria.Invoke(Connection, Transaction, filterCriteria, securityTicket).Result; #endregion L3PR_GAwSPfT_1002 retValItem; L3WH_GSPfFC_1504 storagePlace; foreach (var storage in articleStorages) { retValItem = new L3PR_GAwSPfT_1002(); retValItem.ArticleID = storage.ArticleID; retValItem.ShelfID = storage.ShelfID; retValItem.StoragePlace = "-"; storagePlace = allStoragePlacesForTenant.Where(i => i.LOG_WRH_ShelfID == storage.ShelfID).FirstOrDefault(); if (storagePlace != null && !String.IsNullOrEmpty(storagePlace.Area_Name) && !String.IsNullOrEmpty(storagePlace.Rack_Name) && !String.IsNullOrEmpty(storagePlace.Shelf_Name)) { retValItem.StoragePlace = String.Format("{0}-{1}-{2}-{3}", storagePlace.WarehouseCoordinateCode, storagePlace.AreaCoordinateCode, storagePlace.RackCoordinateCode, storagePlace.ShelfCoordinateCode); } retVal.Add(retValItem); } returnValue.Result = retVal.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_L5AR_GAADfAL_1426_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5AR_GAADfAL_1426 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5AR_GAADfAL_1426_Array(); if (Parameter.ProductITLList != null && Parameter.ProductITLList.Length > 0) { P_L3AR_GAIDfAITLs_1641 articleParam = new P_L3AR_GAIDfAITLs_1641(); articleParam.ProductITLList = Parameter.ProductITLList; var articles = cls_Get_ArticleID_for_ArticleITLs.Invoke(Connection, Transaction, articleParam, securityTicket).Result; Guid[] productIDList = articles.Select(x => x.CMN_PRO_ProductID).ToArray(); #region Get Msr var msrForProducts = cls_Get_MSR_for_ProductIDList.Invoke(Connection, Transaction, new P_L3AS_GSMRfPL_1508 { ProductIDList = productIDList }, securityTicket).Result; #endregion #region Get storage data for ariticle list List <L5AR_GAADfAL_1426> returnValuesList = new List <L5AR_GAADfAL_1426>(); L3WH_GASfA_1924[] storages = new L3WH_GASfA_1924[] { }; Guid[] articlesWithExpectedDelivery = new Guid[] { }; if (productIDList != null && productIDList.Count() > 0) { var storageParam = new P_L3WH_GASfA_1924(); storageParam.ArticleID_List = productIDList; storages = cls_Get_ArticleStorages_for_ArticleIDList.Invoke(Connection, Transaction, storageParam, securityTicket).Result; var expectedDeliveryParam = new P_L3AR_GIHEDfPL_0911 { ProductIDList = productIDList }; articlesWithExpectedDelivery = cls_Get_If_Has_Expected_Delivery_for_ProductIDList.Invoke( Connection, Transaction, expectedDeliveryParam, securityTicket).Result.Select(x => x.ProductID).ToArray(); } foreach (var item in productIDList) { var storage = storages.FirstOrDefault(x => x.ArticleID == item); #region get supplier data string supplierName = String.Empty; Guid supplierID = Guid.Empty; string storagePlace = String.Empty; if (storage != null) { storagePlace = storage.WarehouseCode + storage.AreaCode + storage.RackCode + storage.ShelfCode; P_L3SP_GDSfS_1347 supplierParam = new P_L3SP_GDSfS_1347(); supplierParam.AreaID = storage.AreaID; supplierParam.RackID = storage.RackID; supplierParam.WarehouseID = storage.WarehouseID; var supplier = cls_Get_Default_Supplier_from_Storage.Invoke(Connection, Transaction, supplierParam, securityTicket).Result; supplierName = supplier.SupplierName; supplierID = supplier.SupplierID; } #endregion #region stock quantities P_L3AR_GSQfP_1220 stockParam = new P_L3AR_GSQfP_1220(); stockParam.ProductID = item; var stockQuantities = cls_Get_StockQuantities_for_ProductID.Invoke(Connection, Transaction, stockParam, securityTicket).Result; #endregion var productMSR = msrForProducts.SingleOrDefault(x => x.ProductID == item); #region form output parameter L5AR_GAADfAL_1426 result = new L5AR_GAADfAL_1426(); result.ProductID = item; result.SupplierID = supplierID; result.SupplierName = supplierName; result.StockQuantities = stockQuantities; result.StoragePlace = storagePlace; result.ProductITL = articles.SingleOrDefault(x => x.CMN_PRO_ProductID == item).ProductITL; var expDel = articlesWithExpectedDelivery.SingleOrDefault(x => x == item); result.HasExpectedDelivery = (expDel == Guid.Empty) ? false : true; result.MSR = (productMSR != null) ? productMSR.MSR : (double)0.0; returnValuesList.Add(result); #endregion } #endregion returnValue.Result = returnValuesList.ToArray(); } return(returnValue); #endregion UserCode }