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