public List <string> ReadComicBookfileContent(ReadBooksModel rb)
{
SqlConnection con = new SqlConnection(myDBConnectionString);
con.Open();
string where條件 = rb.b_id + "-" + rb.bc_Chapters + "%";
// 找出章節檔名
//string tSQL = "select c_FileName from BooksChapters where c_FileName like '123-1%'";
string tSQL = "select bf_FileName from BooksFiles where bf_FileName like @Where條件";
SqlCommand cmd = new SqlCommand(tSQL, con);
cmd.Parameters.AddWithValue("Where條件", where條件);
SqlDataReader reader = cmd.ExecuteReader();
List <string> 章節圖片檔名 = new List <string>();
while (reader.Read())
{
章節圖片檔名.Add((string)reader["bf_FileName"]);
}
reader.Close();
con.Close();
return(章節圖片檔名);
}
public List <string> ReadfileContent(ReadBooksModel rb)
{
SqlConnection con = new SqlConnection(myDBConnectionString);
con.Open();
//找出章節檔案名稱
string tSQL = "select bf_FileName from BooksFiles as b inner join BooksChapters as c on b.bc_id=c.bc_id where c.b_id=@Searchb_id and c.bc_Chapters=@Searchc_Chapters";
SqlCommand cmd = new SqlCommand(tSQL, con);
cmd.Parameters.AddWithValue("Searchb_id", rb.b_id);
cmd.Parameters.AddWithValue("Searchc_Chapters", rb.bc_Chapters);
SqlDataReader reader = cmd.ExecuteReader();
string bf_FileName = "";
if (reader.Read())
{
bf_FileName = (string)reader["bf_FileName"];
}
reader.Close();
con.Close();
List <string> 書籍內容 = new List <string>();
if (rb.b_id != "")
{
if (!File.Exists(System.Web.HttpContext.Current.Server.MapPath("~/書籍素材/小說素材/" + rb.b_id + "/" + rb.b_id + "-" + rb.bc_Chapters + "/" + bf_FileName)))
{
}
else
{
StreamReader sr = new StreamReader(System.Web.HttpContext.Current.Server.MapPath("~/書籍素材/小說素材/" + rb.b_id + "/" + rb.b_id + "-" + rb.bc_Chapters + "/" + bf_FileName), System.Text.Encoding.UTF8);
while (sr.Peek() >= 0)
{
書籍內容.Add(sr.ReadLine());
}
//String input = sr.ReadLine();
sr.Close();
}
return(書籍內容);
}
else
{
書籍內容.Add("沒有書籍資料，請稍後在試");
return(書籍內容);
}
}
