public int AddChapter(ChapterDBEntity chapter)
{
OleDbParameter[] parameters = new OleDbParameter[4];
parameters[0] = new OleDbParameter("@NovelId", OleDbType.Integer, 4);
parameters[1] = new OleDbParameter("@ChapterName", OleDbType.VarWChar, 200);
parameters[2] = new OleDbParameter("@ChapterUrl", OleDbType.VarWChar, 200);
parameters[3] = new OleDbParameter("@NovelOrder", OleDbType.Integer, 4);
parameters[0].Value = chapter.NovelId;
parameters[1].Value = chapter.ChapterName;
parameters[2].Value = chapter.ChapterUrl;
parameters[3].Value = chapter.ChapterOrder;
string str_sql = "insert into Chapter (NovelId,ChapterName,ChapterUrl,ChapterOrder) values (@NovelId,@ChapterName,@ChapterUrl,@ChapterOrder)";
return DbHelper.ExecuteInsertScalar(_dbConnection,CommandType.Text, str_sql, parameters);
}
public ChapterDBEntity GetChapterById(int chapterId)
{
OleDbParameter[] parameter = new OleDbParameter[]
{
new OleDbParameter("@ChapterId", OleDbType.Integer, 4)
};
parameter[0].Value = chapterId;
string str_sql = "select * from Chapter where ChapterId=@ChapterId";
ChapterDBEntity info = new ChapterDBEntity();
var dr = DbHelper.ExecuteReader(CommandType.Text, str_sql, parameter);
if (dr.Read())
{
info.ChapterId = int.Parse(dr["ChapterId"].ToString());
info.NovelId = int.Parse(dr["NovelId"].ToString());
info.ChapterName = dr["ChapterName"].ToString();
info.ChapterUrl = dr["ChapterUrl"].ToString();
info.ChapterOrder = int.Parse(dr["ChapterOrder"].ToString());
}
dr.Close();
return info;
}
