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; }