public bool Insert(EraModel this_)
{
string connStr = Config.GetDstConstr();
SQLiteConnection conn = new SQLiteConnection(connStr);
try
{
conn.Open();
string sql = "insert into user (id,name,pwd,acc,telephonenumber) values (@id,@name,@pwd,@acc,@telephonenumber)";
SQLiteCommand cmd = new SQLiteCommand(sql, conn);
cmd.Parameters.AddWithValue("@name", this_.name);
cmd.Parameters.AddWithValue("@era", this_.era);
cmd.Parameters.AddWithValue("@year", this_.year);
cmd.Parameters.AddWithValue("@fromTime", this_.fromTime);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
public EraModel GetById(string id)
{
string connStr = Config.GetDstConstr();
SQLiteConnection conn = new SQLiteConnection(connStr);
EraModel result = null;
try
{
conn.Open();
string sql = "select * from user where id=@id";
SQLiteCommand cmd = new SQLiteCommand(sql, conn);
cmd.Parameters.AddWithValue("@id", id);
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader.HasRows)
{
result = new EraModel();
result.name = DBUtils.GetString(reader, "name");
result.era = DBUtils.GetString(reader, "era");
result.year = DBUtils.GetString(reader, "year");
result.fromTime = DBUtils.GetString(reader, "fromTime");
}
}
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(result);
}