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;
}
});
}
