public void FillCircuitPlanCreatedDateTime() { var log = HemsLog.Get(this.ConstructionCode, this.PlanNo, this.RevisionNo); if (log == null || !log.KairoPlanOutputDateTime.HasValue) { return; } this.CircuitPlanCreatedDateText = log.KairoPlanOutputDateTime.Value.ToString("yyyy/MM/dd H:mm"); }
public static bool ExistExportHemsData(string constructionCode) { string sql = @" SELECT * FROM ProcessLogs WHERE ConstructionCode = '" + constructionCode + @"' AND IsExportedWithHems = 'true'"; var db = HemsLog.GetDatabase(); var logs = db.ExecuteQuery <ProcessLog>(sql); if (logs.Count == 0) { return(false); } else { return(true); } }