public void Update(SenseEntity entity, SqliteDatabase mdb = null)
{
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE sense SET ")
.Append("id = ")
.Append(entity.Id)
.Append(",")
.Append("display_name = ")
.Append("'")
.Append(entity.DisplayName)
.Append("'")
.Append(",")
.Append("level = ")
.Append(entity.Level)
.Append(",")
.Append("type = ")
.Append(entity.Type)
.Append(",")
.Append("power = ")
.Append(entity.Power)
.Append(" WHERE id = ")
.Append(entity.Id)
.Append(";");
if (mdb == null)
{
DbManager.Instance.ExecuteNonQuery(sb.ToString());
}
else
{
DbManager.Instance.ExecuteNonQuery(sb.ToString(), mdb);
}
}
private SenseEntity CreateEntity(DataRow row)
{
SenseEntity entity = new SenseEntity();
entity.Id = DaoSupport.GetIntValue(row, "id");
entity.DisplayName = DaoSupport.GetStringValue(row, "display_name");
entity.Level = DaoSupport.GetIntValue(row, "level");
entity.Type = DaoSupport.GetIntValue(row, "type");
entity.Power = DaoSupport.GetIntValue(row, "power");
return(entity);
}
public void Insert(SenseEntity entity, SqliteDatabase mdb = null)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO sense VALUES (")
.Append(entity.Id)
.Append(",")
.Append("'")
.Append(entity.DisplayName)
.Append("'")
.Append(",")
.Append(entity.Level)
.Append(",")
.Append(entity.Type)
.Append(",")
.Append(entity.Power)
.Append(");");
if (mdb == null)
{
DbManager.Instance.ExecuteNonQuery(sb.ToString());
}
else
{
DbManager.Instance.ExecuteNonQuery(sb.ToString(), mdb);
}
}
