int iSpot = 0; //采集线程停止 public Form1() { if ("Z1W0D3QF" != Pfun.GetMainHardDiskId()) { //System.Environment.Exit(0); } InitializeComponent(); dt_user.Columns.Add("site_ID", System.Type.GetType("System.Int32")); dt_user.Columns.Add("name", System.Type.GetType("System.String")); dt_user.Columns.Add("UserObj", System.Type.GetType("System.Object")); user = database.Querydt("select * from user"); DataRow dr = user.Rows[0]; textBox5.Text = dr["name"].ToString(); Console.WriteLine(dr["name"]); //Gva.ReadOnly = true; //Gva.RowHeadersVisible = false; //Gvb.ReadOnly = true; //Gvb.RowHeadersVisible = false; //Gva.AllowUserToResizeColumns = false; //禁止用户改变DataGridView1の所有行的行高 //Gva.AllowUserToResizeRows = false; //Gvb.AllowUserToResizeColumns = false; //禁止用户改变DataGridView1の所有行的行高 //Gvb.AllowUserToResizeRows = false; //Gvb.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; Conf.ConfInit(); textBox1.Text = Conf.dSw1.ToString(); textBox2.Text = Conf.dSw2.ToString(); textBox3.Text = Conf.htis.ToString(); textBox4.Text = Conf.money.ToString(); checkBox1.Checked = Conf.bDqiu; checkBox2.Checked = Conf.bXqiu; checkBox3.Checked = Conf.d25; Gva.DataSource = Conf.WhereLianSai; for (int j = 0; j < Gvb.Columns.Count; j++) { //Gva.Columns[j].Width = 20; } Gva.Columns[0].Width = 20; Gva.Columns[1].Width = 80; //Gva.AutoGenerateColumns = false; //button9.Visible = false; //button7.Visible = false; }
private void button1_Click(object sender, EventArgs e) { Login log = new Login(); log.Show(); if ("Z1W0D3QF" != Pfun.GetMainHardDiskId()) { //System.Environment.Exit(0); } Loginb.Enabled = false; UserLogin(); }
private void web_DocumentCompleted(object sender, sy.WebBrowserDocumentCompletedEventArgs e) { sy.WebBrowser web = (sy.WebBrowser)sender; if (web.Document != null) { sy.HtmlElementCollection tbs = web.Document.GetElementsByTagName("TABLE"); if (tbs.Count == 8) { sy.HtmlElementCollection trs = tbs[7].GetElementsByTagName("TR"); ArrayList list = new ArrayList(); for (int j = 1; j < trs.Count; j++) { sy.HtmlElementCollection tds = trs[j].GetElementsByTagName("TD"); if (tds.Count == 13) { var bd = new BaseDetail { Time = Pfun.StringtoDatetime1(tds[0].InnerText.Trim(), "MM/dd/yyyy").ToString("yyyyMMdd"), Kp = Pfun.Stringtodouble1(tds[1].InnerText.Trim()), Zg = Pfun.Stringtodouble1(tds[2].InnerText.Trim()), Zd = Pfun.Stringtodouble1(tds[3].InnerText.Trim()), Sp = Pfun.Stringtodouble1(tds[4].InnerText.Trim()), Cjl = Pfun.Stringtodouble1(tds[5].InnerText.Replace(",", "").Trim()), Cjje = Pfun.Stringtodouble1(tds[6].InnerText.Replace(",", "").Trim()), Sdl = Pfun.Stringtodouble1(tds[7].InnerText.Trim()), Sdbl = Pfun.Stringtodouble1(tds[8].InnerText.Replace("%", "").Trim()), S = Pfun.Stringtoint1(tds[9].InnerText), Gdc = Pfun.Stringtodouble1(tds[10].InnerText.Replace("%", "").Trim()), Sz = Pfun.Stringtodouble1(tds[11].InnerText.Trim()), Szl = Pfun.Stringtodouble1(tds[12].InnerText.Replace("%", "").Trim()), }; Detail.Add(bd); list.Add("insert into BaseData_" + Name + "(tradetime,kpjg,zgjg,zdjg,spjg,cjl,cjje,sd,sdbl) " + "values ('" + bd.Time + "'," + bd.Kp + "," + bd.Zg + "," + bd.Zd + "," + bd.Sp + "," + bd.Cjl + "," + bd.Cjje + "," + bd.Sdl + "," + bd.Sdbl + ")"); } } if (list.Count > 0) { if (!DbHelperSqLite.Exists("select count(*) from sqlite_master where type='table' and name='BaseData_" + Name + "'")) { string tableText = (string)DbHelperSqLite.GetSingle("select table_text from need_createtable where Table_name = 'BaseData' Limit 1"); if (tableText == null) { Log.WriteLog("need_createtable表中没有BaseData_表的创建代码"); return; } tableText = tableText.Replace("XX", Name); DbHelperSqLite.ExecuteSql(tableText); } DbHelperSqLite.ExecuteSqlTran(list); if (!DbHelperSqLite.Exists("select count(*) from sqlite_master where type='table' and name='BaseDataReceived_" + Name + "'")) { string tableText = (string)DbHelperSqLite.GetSingle("select table_text from need_createtable where Table_name = 'BaseDataReceived' Limit 1"); if (tableText == null) { Log.WriteLog("need_createtable表中没有BaseDataReceived表的创建代码"); return; } tableText = tableText.Replace("XX", Name); DbHelperSqLite.ExecuteSql(tableText); } if (DbHelperSqLite.Exists("select count(*) from BaseDataReceived_" + Name)) { DbHelperSqLite.ExecuteSql("update BaseDataReceived_" + Name + " set status = 1 where tradedate ='" + DateTime.Now.ToString("yyyyMMdd") + "'"); } else { DbHelperSqLite.ExecuteSql("insert into BaseDatareceived_" + Name + "(tradedate,status) values('" + DateTime.Now.ToString("yyyyMMdd") + "',1) "); } Log.WriteLog("股票【" + Name + "】的数据获取成功"); } } } }
private void button10_Click(object sender, EventArgs e) { Console.WriteLine(20 % 10); string cUrl = "http://baidu.lecai.com/lottery/draw/list/557?d=2015-04-10"; string sp = Connect.getDocument(cUrl); if (sp == null) { Console.WriteLine("NONONO"); return; } ArrayList al = Pfun.HtmlTableId(sp, "draw_list"); int sum1 = 0; int sum2 = 0; int val1 = 0; int val2 = 0; int lp = 0; int _lp = 0; int psum = 0; int po = 0; int _po = 0; for (int i = al.Count - 1; i >= 0; i--) { string[] p = (string[])al[i]; Console.WriteLine(p[0]); if ("开奖号码" == p[0]) { continue; } int in1 = Convert.ToInt32(p[0].Trim()); int in2 = Convert.ToInt32(p[1].Trim()); int in3 = Convert.ToInt32(p[2].Trim()); int in4 = Convert.ToInt32(p[3].Trim()); int in5 = Convert.ToInt32(p[4].Trim()); int in6 = Convert.ToInt32(p[5].Trim()); int in7 = Convert.ToInt32(p[6].Trim()); int in8 = Convert.ToInt32(p[7].Trim()); int in9 = Convert.ToInt32(p[8].Trim()); int in10 = Convert.ToInt32(p[9].Trim()); sum1 = in1 + in2 + in3 + in4 + in5; sum2 = in6 + in7 + in8 + in9 + in10; int bosum = 0; int cosum = 0; if (val1 == in1 || val1 == in2 || val1 == in3 || val1 == in4 || val1 == in5) { // Console.Write("在" + sum1.ToString()); lp++; bosum = 1; } else { bosum = -1; _lp++; } if (val2 == in6 || val2 == in7 || val2 == in8 || val2 == in9 || val2 == in10) { cosum = 1; } else { cosum = -1; } psum++; val1 = sum1 % 10; if (val1 == 0) { val1 = 10; } val2 = sum2 % 10; if (val2 == 0) { val2 = 10; } int bs = bosum + cosum; if (bs == 0) { Console.WriteLine("走水"); } if (bs == -2) { Console.WriteLine("输"); po++; } if (bs == 2) { Console.WriteLine("赢"); _po++; } Console.WriteLine(string.Join(",", p) + "**" + val1.ToString() + "***" + val2.ToString() + "**" + i.ToString()); } Console.WriteLine(po.ToString()); Console.WriteLine(_po.ToString()); //Console.WriteLine(lp.ToString()); //Console.WriteLine(_lp.ToString()); // Console.WriteLine(psum.ToString()); }
private void OnGetdata(object obj) { Task.Factory.StartNew(() => { try { Enable = false; Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, new Action(() => { Detail.Clear(); })); string tableName = Name.Substring(2); if (DbHelperSqLite.Exists("select count(*) from sqlite_master where type='table' and name='DataReceived_" + tableName + "'")) { if (DbHelperSqLite.Exists("select count(*) from DataReceived_" + tableName + " where tradedate = '" + Date + "' and status =1")) { Log.WriteLog("股票【" + tableName + "】【" + Date + "】的数据已获取,不必重新获取"); return; } } string url = "http://market.finance.sina.com.cn/downxls.php?date=" + Date + "&symbol=" + Name; WebClient myWebClient = new WebClient(); Byte[] pageData = myWebClient.DownloadData(url); string pageHtml = Encoding.Default.GetString(pageData); string[] list1 = pageHtml.Split('\n'); if (list1.Length <= 5) { Log.WriteLog("股票【" + tableName + "】【" + Date + "】没有数据"); return; } ArrayList list = new ArrayList(); foreach (string m in list1) { if (m == list1[0]) { continue; } string[] n = m.Split('\t'); if (n.Length >= 5) { Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, new Action(() => { Detail.Add(new Detail { Time = Pfun.StringtoDatetime1(Date + " " + n[0], "yyyy-MM-dd HH:mm:ss"), Price = Pfun.Stringtodouble1(n[1]), Pricechg = Pfun.Stringtodouble1(n[2]), Volume = Pfun.Stringtoint1(n[3]), Amount = Pfun.Stringtoint1(n[4]), Type = n[5] }); list.Add("insert into Detail_" + tableName + "(tradetime,price,pricechg,volume,amount,type) " + "values ('" + Date + " " + n[0] + "'," + Pfun.Stringtodouble1(n[1]).ToString(CultureInfo.InvariantCulture) + "," + Pfun.Stringtodouble1(n[2]).ToString(CultureInfo.InvariantCulture) + "," + Pfun.Stringtoint1(n[3]).ToString() + "," + Pfun.Stringtoint1(n[4]).ToString() + ",'" + n[5] + "')"); })); } } if (list.Count > 0) { if (!DbHelperSqLite.Exists("select count(*) from sqlite_master where type='table' and name='Detail_" + tableName + "'")) { string tableText = (string)DbHelperSqLite.GetSingle("select table_text from need_createtable where Table_name = 'Detail' Limit 1"); if (tableText == null) { Log.WriteLog("need_createtable表中没有Detail表的创建代码"); return; } tableText = tableText.Replace("XX", tableName); DbHelperSqLite.ExecuteSql(tableText); } DbHelperSqLite.ExecuteSqlTran(list); if (!DbHelperSqLite.Exists("select count(*) from sqlite_master where type='table' and name='DataReceived_" + tableName + "'")) { string tableText = (string)DbHelperSqLite.GetSingle("select table_text from need_createtable where Table_name = 'DataReceived' Limit 1"); if (tableText == null) { Log.WriteLog("need_createtable表中没有DataReceived表的创建代码"); return; } tableText = tableText.Replace("XX", tableName); DbHelperSqLite.ExecuteSql(tableText); } if (DbHelperSqLite.Exists("select count(*) from DataReceived_" + tableName + " where tradedate ='" + Date + "'")) { DbHelperSqLite.ExecuteSql("update DataReceived_" + tableName + " set status = 1 where tradedate ='" + Date + "'"); } else { DbHelperSqLite.ExecuteSql("insert into Datareceived_" + tableName + "(tradedate,status) values('" + Date + "',1) "); } Log.WriteLog("股票【" + tableName + "】【" + Date + "】的数据获取成功"); } } catch (Exception ex) { Log.WriteLog(ex.Message); } finally { Enable = true; } }); }