public int InsertLogData(Indihiang.DomainObject.LogData obj) { SQLiteConnection con = null; int id = -1; try { con = new SQLiteConnection(GetConnectionStrng()); con.Open(); string query = String.Format("insert into logdata(logdate,logtime) values('{0}','{1}');select last_insert_rowid();", obj.LogDate, obj.LogTime); using (SQLiteCommand cmd = new SQLiteCommand(query, con)) { id = Convert.ToInt32(cmd.ExecuteScalar()); } } catch (Exception err) { System.Diagnostics.Debug.WriteLine(err.StackTrace); } finally { if (con != null) { con.Close(); } } return(id); }
public List <Indihiang.DomainObject.LogData> GetLogDataByFilter(string filter) { SQLiteConnection con = null; SQLiteDataReader rd = null; List <Indihiang.DomainObject.LogData> list = new List <Indihiang.DomainObject.LogData>(); try { con = new SQLiteConnection(GetConnectionStrng()); con.Open(); string query = string.Format("select id,logdate,logtime from logdata where {0}", filter); SQLiteCommand cmd = new SQLiteCommand(query, con); rd = cmd.ExecuteReader(); while (rd.Read()) { Indihiang.DomainObject.LogData obj = new Indihiang.DomainObject.LogData(); if (!rd.IsDBNull(rd.GetOrdinal("id"))) { obj.Id = Convert.ToInt32(rd["id"].ToString()); } else { obj.Id = -1; } if (!rd.IsDBNull(rd.GetOrdinal("logdate"))) { obj.LogDate = (string)rd["logdate"]; } if (!rd.IsDBNull(rd.GetOrdinal("logtime"))) { obj.LogTime = (string)rd["logtime"]; } list.Add(obj); } } catch (Exception err) { System.Diagnostics.Debug.WriteLine(err.StackTrace); } finally { if (rd != null) { rd.Close(); } if (con != null) { con.Close(); } } return(list); }