public static void UpdateProcessLogsForHems(string constructionCode) { string sql = string.Empty; sql = @"UPDATE ProcessLogs SET IsExportedWithHems = 'true' WHERE ConstructionCode = '" + constructionCode + "'"; var db = ProcessLog.GetDatabase(); db.ExecuteNonQuery(sql); }
public static void Update(string constructionCode, string planNo, string revisionNo) { var log = ProcessLog.Get(constructionCode); if (log == null) { log = new ProcessLog(); log.ConstructionCode = constructionCode; } var now = DateTime.Now; log.ExportedDateTime = now; log.DenkiOrderImportStatus = false; log.UpdatedDateTime = now; log.PlanNo = planNo; log.RevisionNo = revisionNo; log.IsExportedWithHems = false; log.Store(); }