public static List <RoomLayout> Get(string constructionCode)
{
var db = RoomLayout.GetDatabase();
string sql = @"
SELECT * FROM RoomLayouts
WHERE
ConstructionCode = '" + constructionCode + @"'
AND Floor <> 0";
return(db.ExecuteQuery <RoomLayout>(sql));
}
public static List <SiyoHeya> Get(string constructionCode, int siyoCode)
{
var rooms = new List <SiyoHeya>();
if (ConstructionSchedule.IsBeforeProcessRequest(constructionCode))
{
var heyas = tbl_siyo_heya.Get(constructionCode, siyoCode);
foreach (var heya in heyas)
{
var siyoheya = new SiyoHeya();
siyoheya.ConstructionCode = heya.customerCode;
siyoheya.Floor = heya.floorNum;
siyoheya.RoomCode = heya.roomCd;
siyoheya.RoomName = heya.roomName;
rooms.Add(siyoheya);
}
}
else
{
var heyas = RoomLayout.Get(constructionCode);
foreach (var heya in heyas)
{
var siyoheya = new SiyoHeya();
siyoheya.ConstructionCode = heya.ConstructionCode;
siyoheya.Floor = heya.Floor;
siyoheya.RoomCode = heya.RoomCode;
siyoheya.RoomName = heya.RoomName;
rooms.Add(siyoheya);
}
}
return(rooms);
}