//private void DeleteToTempDB(string szData) //{ // string sql = string.Format("delete from tempdb where db='{0}'", szData); // m_sqliteManager.ExcuteSql(sql); // m_sqliteManager.ExcuteSql("vacuum"); //} public void WriteWorksDoneLog(_WorksDoneLog log) { log.reg_tm = Time.DateTime2DbTime(System.DateTime.Now); string sql = string.Format("insert into site_log_worksdone values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", log.reg_tm, log.tm1, log.tm2, log.value, log.typelevel, log.hourValue, log.name, log.siteId); string szData = string.Format("{0}&{1}&{2}&{3}&{4}&{5}&{6}&{7}&HE", log.siteId, log.reg_tm, log.tm1, log.tm2, log.value, log.typelevel, log.hourValue, log.name); WriteToTempDB(szData); m_sqliteManager.ExcuteSql(sql); }
public void Init() { _WorksDoneLog[] log = new _WorksDoneLog[1000]; int N = m_dbHelper.GetMeasuresLogRecords(log); if (N > 0) { this.dtMeasureLog.Rows.Add(N); for (int i = 0; i < N; i++) { string szStr = null; string[] infos = log[i].name.Split(','); this.dtMeasureLog.Rows[i].Cells[0].Value = Time.DbTime2DateTime(log[i].reg_tm).ToString("yyyy.MM.dd HH:mm"); if (log[i].typelevel > 0) { CWorksDoneReg.GetWorksReason(log[i].tm1, log[i].tm2, log[i].value, log[i].typelevel >> 16, log[i].typelevel & 0xffff, ref szStr, log[i].hourValue); } else { CWorksDoneReg.GetWorksReason(log[i].tm1, log[i].tm2, log[i].value, 5, log[i].typelevel, ref szStr, log[i].hourValue); } this.dtMeasureLog.Rows[i].Cells[2].Value = szStr; if (log[i].typelevel > 0) { CWorksDoneReg.GetWorksDone(log[i].typelevel & 0xfff, ref szStr); } else { CWorksDoneReg.GetWorksDone(log[i].typelevel, ref szStr); } this.dtMeasureLog.Rows[i].Cells[3].Value = szStr; this.dtMeasureLog.Rows[i].Cells[4].Value = infos[0]; this.dtMeasureLog.Rows[i].Cells[5].Value = log[i].siteId; this.dtMeasureLog.Rows[i].Cells[1].Value = infos.Length > 1 ? infos[1] : ""; } } else { this.dtMeasureLog.Rows.Clear(); } this.dtMeasureLog.Rows.Add(10); }