public static List <SpecificationProductDetail> Get(string constructionCode)
{
var db = SpecificationProductDetail.GetDatabase();
string sql = @"
SELECT * FROM SpecificationProductDetails
WHERE
ConstructionCode = '" + constructionCode + @"'";
return(db.ExecuteQuery <SpecificationProductDetail>(sql));
}
public static List <SpecificationProductDetail> Get(string constructionCode, int specificationType, string class1Code, string class2Code)
{
var db = SpecificationProductDetail.GetDatabase();
string sql = @"
SELECT * FROM SpecificationProductDetails
WHERE
ConstructionCode = '" + constructionCode + @"' AND
SpecificationType = " + specificationType + @" AND
Class1Code = '" + class1Code + @"' AND
Class2Code = '" + class2Code + @"'";
return(db.ExecuteQuery <SpecificationProductDetail>(sql));
}
public static List <SpecificationProductDetail> GetRimokonNicheSA(string constructionCode)
{
var db = SpecificationProductDetail.GetDatabase();
string sql = @"
SELECT * FROM SpecificationProductDetails
WHERE
ConstructionCode = '" + constructionCode + @"' AND
SpecificationType = 3 AND
Class1Code IS NULL AND
Class2Code = '0035' AND
(ProductCode = '0400107' OR ProductCode = '0400108')";
return(db.ExecuteQuery <SpecificationProductDetail>(sql));
}
public static string GetRoomName(string roomCode)
{
var db = SpecificationProductDetail.GetDatabase();
string sql = @"
SELECT RoomNameJapanese FROM Rooms WHERE RoomCode ='" + roomCode + "'";
var obj = db.ExecuteScalar(sql);
if (obj == null)
{
return(string.Empty);
}
return(obj.ToString());
}
private static SpecificationProductDetail Get(string constructionCode, int floor, int specificationType, string class1Code, string class2Code)
{
string sql = @"
SELECT * FROM SpecificationProductDetails
WHERE
ConstructionCode = '" + constructionCode + @"' AND
Floor = " + floor + @" AND
SpecificationType = " + specificationType + @" AND
Class1Code = '" + class1Code + @"' AND
Class2Code = '" + class2Code + @"'";
var db = SpecificationProductDetail.GetDatabase();
var list = db.ExecuteQuery <SpecificationProductDetail>(sql);
if (list.Count == 0)
{
return(null);
}
return(list[0]);
}