public void Insert(QuestChapterEntity entity, SqliteDatabase mdb = null)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO quest_chapter VALUES (")
.Append(entity.Id)
.Append(",")
.Append(entity.ChapterNo)
.Append(",")
.Append("'")
.Append(entity.DisplayName)
.Append("'")
.Append(");");
if (mdb == null)
{
DbManager.Instance.ExecuteNonQuery(sb.ToString());
}
else
{
DbManager.Instance.ExecuteNonQuery(sb.ToString(), mdb);
}
}
private QuestChapterEntity CreateEntity(DataRow row)
{
QuestChapterEntity entity = new QuestChapterEntity();
entity.Id = DaoSupport.GetIntValue(row, "id");
entity.ChapterNo = DaoSupport.GetIntValue(row, "chapter_no");
entity.DisplayName = DaoSupport.GetStringValue(row, "display_name");
return(entity);
}
public void Update(QuestChapterEntity entity, SqliteDatabase mdb = null)
{
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE quest_chapter SET ")
.Append("id = ")
.Append(entity.Id)
.Append(",")
.Append("chapter_no = ")
.Append(entity.ChapterNo)
.Append(",")
.Append("display_name = ")
.Append("'")
.Append(entity.DisplayName)
.Append("'")
.Append(" WHERE id = ")
.Append(entity.Id)
.Append(";");
if (mdb == null)
{
DbManager.Instance.ExecuteNonQuery(sb.ToString());
}
else
{
DbManager.Instance.ExecuteNonQuery(sb.ToString(), mdb);
}
}
