Ejemplo n.º 1
0
        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");
        }
Ejemplo n.º 2
0
        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);
            }
        }