//하나의 Bible객체를 넣으면 phase를 채워서 리턴
public Bible GetSinglePhase(Bible bible)
{
SQLiteConnection con = new SQLiteConnection(strConn);
con.Open();
SQLiteDataReader reader;
using (SQLiteCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM " + bible.ver + " WHERE name = '" + bible.name + "' and chapter = " + bible.chapter + " and verse = " + bible.verse;
reader = cmd.ExecuteReader();
}
while (reader.Read())
{
string phase = Convert.ToString(reader["phase"]);
bible.phase = phase;
}
reader.Close();
con.Close();
return(bible);
}
//name까지 채워진 Bible객체를 넣으면 총 장수를 리턴.
public int GetChapterCount(Bible bible)
{
SQLiteConnection con = new SQLiteConnection(strConn);
con.Open();
SQLiteDataReader reader;
int count = 0;
using (SQLiteCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT count(DISTINCT chapter) as count FROM " + bible.ver + " WHERE name = '" + bible.name + "'";
reader = cmd.ExecuteReader();
}
while (reader.Read())
{
count = Convert.ToInt32(reader["count"]);
}
reader.Close();
con.Close();
return(count);
}
//처음절과 끝절이 들어간 Bible객체를 넣으면 해당 구간의 BibleList를 리턴
public ArrayList GetMultiPhase(Bible bibleA, Bible bibleB)
{
SQLiteConnection con = new SQLiteConnection(strConn);
con.Open();
SQLiteDataReader reader;
ArrayList biblePhaseList = new ArrayList();
using (SQLiteCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM " + bibleA.ver + " WHERE name = '" + bibleA.name + "' and chapter = " + bibleA.chapter + " and verse BETWEEN " + bibleA.verse + " and " + bibleB.verse;
reader = cmd.ExecuteReader();
}
while (reader.Read())
{
string phase = Convert.ToString(reader["phase"]);
Bible tempBible = new Bible(bibleA.ver, bibleA.name, bibleA.chapter, bibleA.verse, phase);
biblePhaseList.Add(tempBible);
}
reader.Close();
con.Close();
return(biblePhaseList);
}
