public static List <LayoutText> GetBySiyoCode(string constructionCode, int siyoCode)
{
var layoutTexts = LayoutText.GetAll();
foreach (var layoutText in layoutTexts)
{
var query = Query.Get(layoutText.QueryId);
var sql = string.Format(query.SqlStatement, constructionCode, siyoCode);
#if DEBUG
//KSKのデバッグ環境では、HRDSQL,HRDSQL2へリンクを張っていない為、一部クエリが通らない。ここでごまかす。
sql = sql.Replace("HRDSQL.", "");
sql = sql.Replace("HRDSQL2.", "");
#endif
var db = Construction.GetDatabase(); //HRDSQL4のConnectionStringにするため、Constructionを使っている。手抜き
var result = db.ExecuteScalar(sql);
if (result != null)
{
layoutText.Value = result.ToString();
}
else
{
layoutText.Value = "";
}
}
return(layoutTexts);
}
// 物件情報一括取得
public static List <Construction> Get(List <string> constructionCodes)
{
if (constructionCodes.Count == 0)
{
return(new List <Construction>());
}
var codes = string.Empty;
constructionCodes.ForEach(p => codes += "'" + p + "',");
if (codes.Length == 0)
{
return(new List <Construction>());
}
codes = codes.Substring(0, codes.Length - 1);
var sql = "SELECT * FROM Constructions WHERE ConstructionCode IN (" + codes + ")";
var db = Construction.GetDatabase();
return(db.ExecuteQuery <Construction>(sql));
}
