//查询
public List <ViMovieNum> Query(string str, string sql)
{
List <ViMovieNum> list = new List <ViMovieNum>();
//string sql = "select * from viMovieNum where folderName like '%" + str + "%' order by folderName";
using (SQLiteDataReader reader = SqliteHelper.ExecuteReader(sql))
{
if (reader.HasRows)
{
while (reader.Read())
{
ViMovieNum model = new ViMovieNum();
model.ID = reader.GetInt32(0);
model.FolderName = reader["folderName"].ToString();
model.FolderPath = reader["folderPath"].ToString();
model.Num = reader["num"].ToString();
model.SubTitle = reader["subTitle"].ToString();
model.Quality = reader["quality"].ToString();
model.Actors = reader["actors"].ToString();
model.FileSize = (double)reader["fileSize"];
model.Num_ID = reader.IsDBNull(8)?0:reader.GetInt32(8);
model.FolderName_bak = reader["folderName_bak"].ToString();
model.DirCreateTime = (DateTime)reader["dirCreateTime"];
list.Add(model);
}
}
}
return(list);
}
//加载，选择所有数据。
public List <ViMovieNum> Select(string sql)
{
List <ViMovieNum> list = new List <ViMovieNum>();
using (SQLiteDataReader reader = SqliteHelper.ExecuteReader(sql))
{
if (reader.HasRows)
{
while (reader.Read())
{
ViMovieNum model = new ViMovieNum
{
ID = reader.GetInt32(0),
FolderName = reader["folderName"].ToString(),
FolderPath = reader["folderPath"].ToString(),
Num = reader["num"].ToString(),
SubTitle = reader["subTitle"].ToString(),
Quality = reader["quality"].ToString(),
Actors = reader["actors"].ToString(),
FileSize = (double)reader["fileSize"],
Num_ID = reader.IsDBNull(8) ? 0 : reader.GetInt32(8),
FolderName_bak = reader["folderName_bak"].ToString(),
DirCreateTime = (DateTime)reader["dirCreateTime"]
};
list.Add(model);
}
}
}
return(list);
}