void TitleList_FetchCompleted(object sender, Natsuhime.Events.ReturnCompletedEventArgs e) { if (e.Error == null) { Dictionary <string, string> posts = e.ReturnObject as Dictionary <string, string>; foreach (KeyValuePair <string, string> post in posts) { string sql = string.Format( "INSERT INTO posts(`title`,`url`) VALUES('{0}','{1}')", post.Value, post.Key ); try { Natsuhime.Data.DbHelper.ExecuteNonQuery(CommandType.Text, sql); } catch (Exception ex) { throw ex; } } MessageBox.Show(string.Format("{0} Completed!", posts.Count)); } else { MessageBox.Show(e.Error.Message); } }
void FileList_FetchCompleted(object sender, Natsuhime.Events.ReturnCompletedEventArgs e) { if (e.Error == null) { int postId = int.Parse(e.UserState.ToString()); List <string> files = e.ReturnObject as List <string>; foreach (string file in files) { string sqlFile = string.Format( "INSERT INTO files(`url`) VALUES('{0}');select last_insert_rowid()", file ); try { //Natsuhime.Data.DbHelper.ExecuteNonQuery(CommandType.Text, sqlFile); object fileId = Natsuhime.Data.DbHelper.ExecuteScalar( CommandType.Text, sqlFile ); string sqlFile2Post = string.Format( "INSERT INTO file2post(`postid`,`fileid`) VALUES({0},{1})", postId, Convert.ToInt32(fileId) ); Natsuhime.Data.DbHelper.ExecuteNonQuery( CommandType.Text, sqlFile2Post ); } catch (Exception ex) { throw ex; } } MessageBox.Show(string.Format("{0} Files Completed!", files.Count)); } else { MessageBox.Show(e.Error.Message); } }
void ps_Completed(object sender, Natsuhime.Events.ReturnCompletedEventArgs e) { if (e.Error == null) { ShowMessage("获取列表", "完成.", ""); List <ProxyInfo> list = (List <ProxyInfo>)e.ReturnObject; List <ProxyInfo> oldList = ProxyUtility.GetProxyList_FromConfig(_ProxyListFilePath); if (oldList != null && oldList.Count > 0) { list.AddRange(oldList); } ProxyUtility.SaveProxyList_ToConfig(RemoveExitsProxy(list), _ProxyListFilePath); ShowMessage("获取列表", "保存配置成功.", ""); } else { //TODO } }