public static decimal?GetBalanceStoreSpaceByBinNo(string WarehouseCode, string BinNo) { var connection = ApiService.dbConnection; decimal?balanceStoreSpace = null; decimal?whStoreSpace = null; whwh2 myWhDetail = WarehouseHelper.GetWarehouseDetail(WarehouseCode, BinNo); whStoreSpace = myWhDetail.StoreSpace; decimal invStoreSpace = 0; try { connection.Open(); invStoreSpace = connection.ExecuteScalar <decimal>(qryInventory.selectInvStoreSpaceByBin, new { WarehouseCode, BinNo }); } catch (Exception) { throw; } finally { connection.Close(); } if (whStoreSpace.HasValue) { balanceStoreSpace = whStoreSpace - invStoreSpace; } return(balanceStoreSpace); }
public static whwh2 GetWarehouseDetail(string WarehouseCode, string BinNo) { var connection = ApiService.dbConnection; whwh2 myWhDetail = null; try { // select whwh2 connection.Open(); myWhDetail = connection.QuerySingleOrDefault <whwh2>(qryWarehouse.selectWhDetail, new { WarehouseCode, BinNo }); } catch (Exception) { throw; } finally { connection.Close(); } return(myWhDetail); }