// 撈出此本書的最新的章節
public int 目前最新章節(AddBooks b)
{
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", b.b_id);
SqlDataReader reader = cmd.ExecuteReader();
int 目前最新章節數 = 0;
if (b.b_id != null)
{
if (reader.Read())
{
目前最新章節數 = (int)reader["bc_Chapters"];
}
}
reader.Close();
con.Close();
return(目前最新章節數);
}
public string 書籍封面圖片命名(AddBooks b)
{
// 取得副檔名
int point = b.Image.FileName.IndexOf(".");
string extention = b.Image.FileName.Substring(point, b.Image.FileName.Length - point);
// 命名封面檔名
string photoName = b.b_id + "-cover" + extention;
return(photoName);
}
// 將資料儲存到 BookOutline 與 BooksChapters 資料表
public void 儲存章節標題及檔名(AddBooks b, AddBooksFiles bf, AddBooksChapters bc)
{
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", b.b_id);
cmd.Parameters.AddWithValue("bcChapters", bc.bc_Chapters);
cmd.Parameters.AddWithValue("bcContent", bc.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 bf.FilesName)
{
tSQL2 = "Insert into BooksFiles (bc_id,bf_FileName)Values('" + maxbc_id + "','" + Files + "')";
cmd2.CommandText = tSQL2;
cmd2.ExecuteNonQuery();
}
con.Close();
}
// 新增書籍基本資料
// 使用資料表：Books、BooksAuthor
// 將資料儲存到 Books 資料表
public void Create(AddBooks b)
{
SqlConnection con = new SqlConnection(myDBConnectionString);
con.Open();
//Insert into Books (b_id,b_Name,b_Info,b_Image,b_Type,b_PublishedDate,b_DatePrice,b_ISBN,b_AgeRating,p_id)Values(1234,'aaa','bbb','c','d','1996/09/07','1','g',1,1)
string tSQL = "Insert into Books (b_id,b_Name,b_Info,b_Image,b_Type,b_PublishedDate,b_DatePrice,b_ISBN,b_AgeRating,b_Series_yn,b_Put_yn,p_id)Values(" +
"@bid,@bName,@bInfo,@bImage,@bType,@bPublishedDate,@bDatePrice,@bISBN,@bAgeRating,@bSeries,'n',@pID)";
SqlCommand cmd = new SqlCommand(tSQL, con);
cmd.Parameters.AddWithValue("bid", b.b_id);
cmd.Parameters.AddWithValue("bName", b.b_Name);
cmd.Parameters.AddWithValue("bInfo", b.b_Info);
cmd.Parameters.AddWithValue("bImage", b.b_Image);
cmd.Parameters.AddWithValue("bType", b.b_Type);
cmd.Parameters.AddWithValue("bPublishedDate", b.b_PublishedDate);
cmd.Parameters.AddWithValue("bDatePrice", b.b_DatePrice);
cmd.Parameters.AddWithValue("bISBN", b.b_ISBN);
cmd.Parameters.AddWithValue("bAgeRating", b.b_AgeRating);
// 連載情況
char 連載情況;
if (b.b_Series_yn == "連載中")
{
連載情況 = 'y';
cmd.Parameters.AddWithValue("bSeries", 連載情況);
}
else if (b.b_Series_yn == "已完結")
{
連載情況 = 'n';
cmd.Parameters.AddWithValue("bSeries", 連載情況);
}
cmd.Parameters.AddWithValue("pID", b.p_id);
cmd.ExecuteNonQuery();
con.Close();
}
