// 撈出此本書的最新的章節 public int 目前最新章節(AddBookChaptersModel ac) { SqlConnection con = new SqlConnection(myDBConnectionString); con.Open(); string tSQL = "select max(bc_Chapters) as bc_Chapters from BooksChapters where b_id = @bId"; SqlCommand cmd = new SqlCommand(tSQL, con); cmd.Parameters.AddWithValue("bId", ac.b_id); SqlDataReader reader = cmd.ExecuteReader(); int 目前最新章節數 = 0; if (ac.b_id != null) { if (reader.Read()) { 目前最新章節數 = (int)reader["bc_Chapters"]; } } reader.Close(); con.Close(); return(目前最新章節數); }
// 將資料儲存到 BookOutline 與 BooksChapters 資料表 public void 儲存章節標題及檔名(AddBookChaptersModel ac) { SqlConnection con = new SqlConnection(myDBConnectionString); con.Open(); // 新增到書籍大綱資料表 string tSQL = "Insert into BooksChapters (b_id,bc_Chapters,bc_Content)Values(@bId,@bcChapters,@bcContent)"; SqlCommand cmd = new SqlCommand(tSQL, con); cmd.Parameters.AddWithValue("bId", ac.b_id); cmd.Parameters.AddWithValue("bcChapters", ac.bc_Chapters); cmd.Parameters.AddWithValue("bcContent", ac.bc_Content); cmd.ExecuteNonQuery(); // 撈回 BooksChapters 資料表,目前自動編號的最大值 (要塞到 BooksFiles 資料表使用的) string tSQL1 = "select max(bc_id) as bc_id from BooksChapters"; SqlCommand cmd1 = new SqlCommand(tSQL1, con); SqlDataReader reader = cmd1.ExecuteReader(); int maxbc_id = 0; if (reader.Read()) { maxbc_id = (int)reader["bc_id"]; } reader.Close(); // 新增到書籍章節資料表 string tSQL2 = ""; SqlCommand cmd2 = new SqlCommand(); cmd2.Connection = con; foreach (string Files in ac.FilesName) { tSQL2 = "Insert into BooksFiles (bc_id,bf_FileName)Values('" + maxbc_id + "','" + Files + "')"; cmd2.CommandText = tSQL2; cmd2.ExecuteNonQuery(); } // 新增到書籍資料表 // 連載情況 string tSQL3 = "update books set b_Series_yn=@bSeries where b_id=@bid"; SqlCommand cmd3 = new SqlCommand(tSQL3, con); cmd3.Parameters.AddWithValue("bid", ac.b_id); char 連載情況; if (ac.b_Series_yn == "連載中") { 連載情況 = 'y'; cmd3.Parameters.AddWithValue("bSeries", 連載情況); } else if (ac.b_Series_yn == "已完結") { 連載情況 = 'n'; cmd3.Parameters.AddWithValue("bSeries", 連載情況); } cmd3.ExecuteNonQuery(); con.Close(); }