private void button1_Click(object sender, EventArgs e)
{
List <OpenCode> list2 = new List <OpenCode>();
while (true)
{
try
{
List <OpenCode> list = JsonHelper.ReadJson();
if (list.Count != 0)
{
arg2value = (int.Parse(list.Max(S => S.issueNo)) + 1).ToString();
}
else
{
string y = DateTime.Now.ToString("yy");
arg2value = y + "001";
}
string arg = arg1 + "&" + arg2key + "=" + arg2value;
string json = Post(arg, url);
HisModel model = JsonConvert.DeserializeObject <History.HisModel>(json);
OpenCode code = new OpenCode();
code.issueNo = arg2value;
code.Date = model.openTime;
code.Code = model.openResult.Replace("<i>", "").Replace("</i>", ",");
list2.Add(code);
}
catch (Exception)
{
break;
}
JsonHelper.Insert(list2);
}
his();
}
public static void caiji()
{
Console.WriteLine("开始采集2019年数据");
string url = "https://kaijiang.aicai.com/open/historyIssue.do";
string arg1 = "gameIndex=203";
string arg2key = "issueNo";
string arg2value = "19001";
int i = 0;
while (true)
{
Console.WriteLine("采集中：" + i);
try
{
string sql1 = "select max(issno) issno from tb_hiscode";
DataRow r1 = SQLiteHelper.ExecuteDataRow(sql1);
int num = r1[0].Equals(DBNull.Value) ? 0 : Convert.ToInt32(r1[0]);
if (num != 0)
{
arg2value = (Convert.ToInt32(r1["issno"]) + 1).ToString();
}
else
{
string y = DateTime.Now.ToString("yy");
arg2value = y + "001";
}
string arg = arg1 + "&" + arg2key + "=" + arg2value;
string json = Post(arg, url);
HisModel model = JsonConvert.DeserializeObject <CpWinfrom.History.HisModel>(json);
string rescode = model.openResult.Replace("<i>", "").Replace("</i>", ",");
string n1 = rescode.Split(',')[0];
string n2 = rescode.Split(',')[1];
string n3 = rescode.Split(',')[2];
string n4 = rescode.Split(',')[3];
string n5 = rescode.Split(',')[4];
string sql2 = @"INSERT INTO [tb_hiscode]
([id]
,[Date]
,[Code]
,[IssNo]
,[N1]
,[N2]
,[N3]
,[N4]
,[N5])
VALUES
(null,'" + model.openTime + "','" + rescode + "','" + arg2value + "' ,'" + n1 + "' ,'" + n2 + "' ,'" + n3 + "','" + n4 + "','" + n5 + "')";
SQLiteHelper.ExecuteNonQuery(sql2);
i = i + 1;
}
catch (Exception e)
{
break;
}
}
Console.WriteLine("采集结束,累计：" + i);
Main(null);
}
