/// <summary> /// 更新全部书籍 /// </summary> public static void BooksUpdate(object ob) { //获取全部书籍 DataTable dt = SQLiteDBHelper.ExecuteDataTable("select *from Books", null); List <Book> Books = ModelConvertHelper <Book> .DataTableToList(dt); foreach (Book book in Books) { //获取初始搜索文本 string html = GetHtml.GetHttpWebRequest(book.Url); BookSource bs = GetBookSource(book.Source); //检测书源有效性 if (bs.Title is null) { Tips tips = new Tips(book.Name + "的书源不存在,请检查书源是否已经被删除掉?"); tips.Show(); return; } //获取最新章节 string LatestChapters = Tool.GetRegexStr(html, bs.NewestRegular).Trim(); //获取更新时间 string Update = Tool.GetRegexStr(html, bs.UpdateRegular).Trim(); SQLiteDBHelper.ExecuteNonQuery("Update Books set 'Newest' = '" + LatestChapters + "', 'Update' = '" + Tool.GetUpdataDate(Update) + "' where Id =" + book.Id, null); } ((MainWindow)ob).Dispatcher.Invoke(new Action(() => { ((MainWindow)ob).DataContext = DataFetch.GetBooks(); })); }
/// <summary> /// 获取全部书源 /// </summary> /// <returns>返回全部书源</returns> public static List <BookSource> GetBookSources() { //获取DataTable DataTable dt = SQLiteDBHelper.ExecuteDataTable("select *from BookSource where State=1", null); //获取所有书源 return(ModelConvertHelper <BookSource> .DataTableToList(dt)); }
/// <summary> /// 获取我的书架 /// </summary> /// <param name="fattening">判断是否为养肥区,默认不是</param> /// <returns></returns> public static List <Book> GetBooks(bool fattening = false) { int Fattening = fattening ? 1 : 0; //获取DataTable DataTable dt = SQLiteDBHelper.ExecuteDataTable("select *from Books where Fattening=" + Fattening, null); List <Book> Books = ModelConvertHelper <Book> .DataTableToList(dt); foreach (Book book in Books) { book.Newest = Tool.InterceptStr(book.Newest); } //获取所有书籍 return(Books); }
public static void c() { //row["Name"] = "张三"; //row["Month"] = "2016-01"; //row["Area"] = "江夏区"; //row["DfMoney"] = 1; DataTable dt = InitTable(); List <string> DataColumn = new List <string>() { "DfMoney" }; string DynamicColumn = "Month"; List <string> AllDynamicColumn = null; //DataTablePivotOne dp1 = new DataTablePivotOne(); //DataTable dtResult = new DataTablePivotOne().DataTablePivot(dt, DimensionList, DynamicColumn, DataColumn, out AllDynamicColumn); #region DataTable行转列1 DataTable dtResult = RowToColumn(dt, DataColumn, DynamicColumn, out AllDynamicColumn); #endregion #region List集合行转列(dynamiclinq) List <string> DimensionList = new List <string> { "Name", "Area" }; AllDynamicColumn = null; IList <money> list = ModelConvertHelper <money> .DataTableToList(dt);//先转集合 List <dynamic> dlist = DynamicLinqDemo.DynamicLinq <money>(list.ToList(), DimensionList, "Month", out AllDynamicColumn); //var dlistC= dlist.ToList(); //dlist.OrderBy(s=>s.Name).ToList(); var gArea = dlist.GroupBy(s => s.Area); List <dynamic> dlistNew = new List <dynamic>(); foreach (var itemArea in gArea) { dlistNew.Add(itemArea); } //var G //dlistNew.Add(itemArea); #endregion Console.WriteLine(JsonConvert.SerializeObject(dtResult, Formatting.Indented)); Console.Read(); }