public List <KGLanguage> Get(string wherecase = "", string ordercase = "")
{
List <KGLanguage> results = new List <KGLanguage>();
SQLiteConnection conn = DbConnection.Conn;
SQLiteCommand cmd = new SQLiteCommand("select * from kg_language", conn);
try
{
conn.Open();
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
KGLanguage item = new KGLanguage();
item.Name = reader.IsDBNull(0) ? "" : reader.GetString(0);
item.Description = reader.IsDBNull(1) ? "" : reader.GetString(1);
item.IsCompileLanguage = reader.IsDBNull(2) ? false : reader.GetBoolean(2);
item.IsExplainLanguage = reader.IsDBNull(3) ? false : reader.GetBoolean(3);
item.IsProcessLanguage = reader.IsDBNull(4) ? false : reader.GetBoolean(4);
item.IsObjectiveLanguage = reader.IsDBNull(5) ? false : reader.GetBoolean(5);
item.IsScriptLanguage = reader.IsDBNull(6) ? false : reader.GetBoolean(6);
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(results);
}
public void Add(KGLanguage item)
{
SQLiteConnection conn = DbConnection.Conn;
SQLiteCommand cmd = new SQLiteCommand("insert into kg_language values(:Name, :Description, :IsCompileLanguage, :IsExplainLanguage, :IsProcessLanguage, :IsObjectiveLanguage, :IsScriptLanguage)", conn);
cmd.Parameters.Add(new SQLiteParameter("Name", item.Name));
cmd.Parameters.Add(new SQLiteParameter("Description", item.Description));
cmd.Parameters.Add(new SQLiteParameter("IsCompileLanguage", item.IsCompileLanguage));
cmd.Parameters.Add(new SQLiteParameter("IsExplainLanguage", item.IsExplainLanguage));
cmd.Parameters.Add(new SQLiteParameter("IsProcessLanguage", item.IsProcessLanguage));
cmd.Parameters.Add(new SQLiteParameter("IsObjectiveLanguage", item.IsObjectiveLanguage));
cmd.Parameters.Add(new SQLiteParameter("IsScriptLanguage", item.IsScriptLanguage));
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
}
