Пример #1
0
        private void hudong_Thread_Timer_Method(object o)
        {
            long            hudong_maxtime;
            MySqlConnection connection = new MySqlConnection("Database=zyg;Data Source=sirius0427.jios.org;User Id=cst;Password=q1w2e3r4t5Y^U&I*O(P);pooling=false;CharSet=utf8;port=3307");

            connection.Open();
            MySqlDataReader reader = new MySqlCommand("select max(collectiontime) as time from newsinfo where articletype='2'", connection).ExecuteReader();

            reader.Read();
            hudong_maxtime = reader["time"].ToLong();
            reader.Close();
            object[] objArray1 = new object[] { "select from_unixtime(collectiontime/1000) as time,title,digest,sourcename from newsinfo where articletype='2' and collectiontime >", hudong_lasttime, " and collectiontime <=", hudong_maxtime, " order by collectiontime" };
            reader = new MySqlCommand(string.Concat(objArray1), connection).ExecuteReader();
            try
            {
                int insertflag = 0;
                while (reader.Read())
                {
                    if (reader.HasRows)
                    {
                        int    startIndex = 0;
                        int    num2       = 0;
                        string str        = "";
                        string str2       = "";
                        MyData data       = new MyData
                        {
                            time = reader["time"].ToString()
                        };
                        string str3 = reader["title"].ToString().Replace("\n", "");
                        if (reader["sourcename"].Equals("深证互动"))
                        {
                            startIndex = str3.IndexOf("问", 0) + 2;
                            num2       = str3.IndexOf("):", 0) + 2;
                            str        = str3.Substring(startIndex, (num2 - startIndex) - 1);
                            str2       = str3.Substring(num2, str3.Length - num2);
                        }
                        else if (reader["sourcename"].Equals(" 上证互动"))
                        {
                            startIndex = str3.IndexOf(":", 0) + 1;
                            num2       = str3.IndexOf(")", 0) + 1;
                            str        = str3.Substring(startIndex, num2 - startIndex);
                            str2       = str3.Substring(num2, str3.Length - num2);
                        }
                        str.Trim();
                        str2.Trim();
                        string[] textArray1 = new string[] { "  问:", str2, Environment.NewLine, "  答:", reader["digest"].ToString() };
                        data.title      = string.Concat(textArray1);
                        data.sourcename = str + "\n" + reader["time"].ToString();
                        string[] textArray2 = new string[] { str, "\t", reader["time"].ToString(), "\n问:", str2, Environment.NewLine, "\n答:", reader["digest"].ToString() };
                        string   parameter  = string.Concat(textArray2);
                        //Thread thread1 = new Thread(new ParameterizedThreadStart(new StartMessageBox().CreateCounterWindowThread));
                        //thread1.SetApartmentState(ApartmentState.STA);
                        //thread1.IsBackground = true;
                        //thread1.Start(parameter);

                        //base.Dispatcher.BeginInvoke((Action)delegate
                        //{
                        //    NotifyData data1 = new NotifyData();
                        //    data1.Title = "抓妖股实时互动";
                        //    data1.Content = parameter;

                        //    NotificationWindow dialog = new NotificationWindow();//new 一个通知
                        //    dialog.Closed += Dialog_Closed;
                        //    dialog.TopFrom = GetTopFrom();
                        //    _dialogs.Add(dialog);
                        //    dialog.DataContext = data1;//设置通知里要显示的数据
                        //    dialog.Show();
                        //}, null);

                        Dispatcher.BeginInvoke((Action) delegate
                        {
                            if (hudong_filter.IsChecked.Value)
                            {
                                insertflag = 0;
                                foreach (string str1 in Regex.Split(hudong_filtertext.Text, ",", RegexOptions.IgnoreCase))
                                {
                                    if (data.title.IndexOf(str1) >= 0)
                                    {
                                        insertflag += 1;
                                    }
                                    else
                                    {
                                        insertflag += 0;
                                    }
                                }
                            }
                            else
                            {
                                insertflag = 1;
                            }
                            if (insertflag >= 1)
                            {
                                dataset_hudong.Insert(0, data);
                                new SoundPlayer("ring.wav").Play();
                                NotifyData data1 = new NotifyData();
                                data1.Title      = "抓妖股实时互动" + insertflag.ToString();
                                data1.Content    = parameter;

                                NotificationWindow dialog = new NotificationWindow();//new 一个通知
                                dialog.Closed            += Dialog_Closed;
                                dialog.TopFrom            = GetTopFrom();
                                _dialogs.Add(dialog);
                                dialog.DataContext = data1;//设置通知里要显示的数据
                                dialog.Show();
                            }
                        }, null);
                    }
                }
                hudong_lasttime = hudong_maxtime;
                Dispatcher.BeginInvoke((Action) delegate()
                {
                    ListView_hudong.ItemsSource = dataset_hudong;
                }, null);
            }
            catch (Exception)
            {
                MessageBox.Show("查询失败了!" + reader["title"].ToString().Replace("\n", ""));
            }
            finally
            {
                reader.Close();
                connection.Close();
            }
        }
Пример #2
0
        private void search_hudong(object sender, RoutedEventArgs e)
        {
            //List<MyData> dataset_hudong = new List<MyData>();
            dataset_hudong.Clear();
            String          mysqlStr = "Database=zyg;Data Source=sirius0427.jios.org;User Id=cst;Password=q1w2e3r4t5Y^U&I*O(P);pooling=false;CharSet=utf8;port=3307";
            MySqlConnection mysql    = new MySqlConnection(mysqlStr);

            mysql.Open();
            String          sqlSearch    = "select max(collectiontime) as time from newsinfo where articletype='2'";
            MySqlCommand    mySqlCommand = new MySqlCommand(sqlSearch, mysql);
            MySqlDataReader reader       = mySqlCommand.ExecuteReader();

            reader.Read();
            hudong_lasttime = reader["time"].ToLong();
            reader.Close();
            sqlSearch    = "select from_unixtime(collectiontime/1000) as time,title,digest,sourcename from newsinfo where (title like '%" + KeyWord.Text + "%' or digest like '%" + KeyWord.Text + "%') and articletype='2' order by collectiontime desc limit 100";
            mySqlCommand = new MySqlCommand(sqlSearch, mysql);
            reader       = mySqlCommand.ExecuteReader();
            try
            {
                while (reader.Read())
                {
                    if (reader.HasRows)
                    {
                        int    startIndex = 0;
                        int    num2       = 0;
                        string str        = "";
                        string str2       = "";
                        MyData item       = new MyData
                        {
                            time = reader["time"].ToString()
                        };
                        string str3 = reader["title"].ToString().Replace("\n", "");
                        if (reader["sourcename"].Equals("深证互动"))
                        {
                            startIndex = str3.IndexOf("问", 0) + 2;
                            num2       = str3.IndexOf("):", 0) + 2;
                            str        = str3.Substring(startIndex, (num2 - startIndex) - 1);
                            str2       = str3.Substring(num2, str3.Length - num2);
                        }
                        else if (reader["sourcename"].Equals(" 上证互动"))
                        {
                            startIndex = str3.IndexOf(":", 0) + 1;
                            num2       = str3.IndexOf(")", 0) + 1;
                            str        = str3.Substring(startIndex, num2 - startIndex);
                            str2       = str3.Substring(num2, str3.Length - num2);
                        }
                        str.Trim();
                        str2.Trim();
                        string[] textArray1 = new string[] { "  问:", str2, Environment.NewLine, "  答:", reader["digest"].ToString() };
                        item.title      = string.Concat(textArray1);
                        item.sourcename = str + "\n" + reader["time"].ToString();
                        //int num3 = 0;
                        //if (hudong_filter.IsChecked.Value)
                        //{
                        //    foreach (string str4 in Regex.Split(hudong_filtertext.Text, ","))
                        //    {
                        //        if (item.title.IndexOf(str4) >= 0)
                        //        {
                        //            num3 = 1;
                        //        }
                        //    }
                        //}
                        //else
                        //{
                        //    num3 = 1;
                        //}
                        //if (num3 == 1)
                        //{
                        dataset_hudong.Add(item);
                        //}
                    }
                }
            }
            catch (Exception)
            {
                MessageBox.Show("查询失败了!" + reader["title"].ToString().Replace("\n", ""));
            }
            finally
            {
                ListView_hudong.ItemsSource = null;
                ListView_hudong.ItemsSource = dataset_hudong;
                reader.Close();
                mysql.Close();
            }
        }