/// <summary> /// 查询配置 /// </summary> /// <param name="name"></param> /// <returns></returns> public static List <ConfigClass> query(string name) { try { List <ConfigClass> list = new List <ConfigClass>(); SQLiteConnection conn = new SQLiteConnection(); System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder(); connstr.DataSource = SqlLiteHelper.getSQLiteConn(); connstr.Password = "******"; //设置密码,SQLite ADO.NET实现了数据库密码保护 conn.ConnectionString = connstr.ToString(); SQLiteCommand cmd = new SQLiteCommand(); //是不是很熟悉呢? DateTime StartComputerTime = DateTime.Now; cmd.Connection = conn; if (name == null) { cmd.CommandText = "select * from t_config order by id asc"; } else { cmd.CommandText = "select * from t_config where name='" + name + "' order by id asc"; } conn.Close(); conn.Open(); SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ConfigClass config = new ConfigClass(); config.Id = reader["id"].ToString(); config.Name = reader["name"].ToString(); config.FormalValue = reader["formalValue"].ToString(); config.TestValue = reader["testValue"].ToString(); config.Remark = reader["remark"].ToString(); list.Add(config); } conn.Close(); return(list); }catch (Exception ex) { return(new List <ConfigClass>()); } }
/// <summary> /// 修改配置 /// </summary> /// <param name="config"></param> /// <returns></returns> public static bool update(ConfigClass config) { try { SQLiteConnection conn = new SQLiteConnection(); System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder(); connstr.DataSource = SqlLiteHelper.getSQLiteConn(); connstr.Password = "******";//设置密码,SQLite ADO.NET实现了数据库密码保护 conn.ConnectionString = connstr.ToString(); SQLiteCommand comm = new SQLiteCommand(conn); comm.CommandText = "update t_config set testValue='" + config.FormalValue + "',formalValue='" + config.FormalValue + "' where name='" + config.Name + "'"; conn.Open(); int result = comm.ExecuteNonQuery(); if (result > 0) { return(true); } conn.Close(); return(false); } catch (Exception ex) { return(false); } }