public BAT_Class_Library.Buffer GetPaletteInfoByProductId(int productID)
{
BAT_Class_Library.Buffer buffer;
using (var conn = new SqlConnection(conStr))
{
conn.Open();
buffer = conn.QuerySingleOrDefault <BAT_Class_Library.Buffer>(
@"SELECT *
FROM Buffers a(NOLOCK)
WHERE LastPaletteInfo = @ProductId;" ,
new { ProductId = productID },
commandType: System.Data.CommandType.Text);
conn.Close();
}
return(buffer);
}
public Address GetFirstRowIsEmpty(string addressCode)
{
Address address;
using (var conn = new SqlConnection(conStr))
{
conn.Open();
address = conn.QuerySingleOrDefault <Address>(
@"SELECT *
FROM Addresses a(NOLOCK)
WHERE Direction ='WH_IN'
AND Code = @Code;" ,
new { Code = addressCode },
commandType: System.Data.CommandType.Text);
conn.Close();
}
return(address);
}
public Address GetFirstRowIsEmptyByProductId(int productID)
{
Address address;
using (var conn = new SqlConnection(conStr))
{
conn.Open();
address = conn.QuerySingleOrDefault <Address>(
@"SELECT *
FROM Addresses a(NOLOCK)
WHERE Direction ='WH_IN'
AND DependedProductId = @ProductId;" ,
new { ProductId = productID },
commandType: System.Data.CommandType.Text);
conn.Close();
}
return(address);
}
public bool GetFirstRowIsEmptyByAddressCode(string code, string location)
{
//task başlamadan(assign etmeden) önce ki kontrolleri yapmayı amaçlar
bool IsEmpty;
using (var conn = new SqlConnection(conStr))
{
conn.Open();
IsEmpty = conn.QuerySingleOrDefault <bool>(
@"SELECT FirstRowIsEmpty FROM Addresses a(NOLOCK)
WHERE Direction = @Direction
AND Code = @Code;" ,
new { Direction = location, Code = code },
commandType: System.Data.CommandType.Text);
conn.Close();
}
return(IsEmpty);
}
public Shuttle GetMoveableShuttleByAddress(string code)
{
Shuttle shuttle;
//TODO: sp ye çevir, adrese göre ayarla
using (var conn = new SqlConnection(conStr))
{
conn.Open();
shuttle = conn.QuerySingleOrDefault <Shuttle>(
@" SELECT TOP 1 s.*
FROM Shuttles s(NOLOCK)
LEFT OUTER JOIN Addresses a(NOLOCK) ON s.LastAddress = a.Code
WHERE a.Direction = 'WH_OUT'
AND s.IsActive = 1
and s.Status = 'WAITING'
and s.Id NOT IN (SELECT ShuttleId FROM AddressDedicatedShuttles)",
new { Code = code }, //code parametresi mesafeye göre seçim için eklenecek
commandType: System.Data.CommandType.Text);
conn.Close();
}
return(shuttle);
}