private void 导出至ExcelToolStripMenuItem_Click(object sender, EventArgs e)
{
//var data = listView_data.SelectedItems.Cast<dynamic>().ToArray();
//var a = listView_data.SelectedItems[1].SubItems[1].Text;
var dbName = (comboDbList.Text ?? "").ToString().Split('[')[0].Trim(']');
if (string.IsNullOrWhiteSpace(dbName))
{
label_message.Text = "没有历史存留数据";
return;
}
IList <string> data = new List <string>();
for (int i = 0; i < listView_data.SelectedItems.Count; i++)
{
data.Add(listView_data.SelectedItems[i].SubItems[2].Text);
}
string localFilePath = "";
var saveFile = new SaveFileDialog
{
Filter = @"xls files(*.xls)|*.txt|All files(*.*)|*.*",
FileName = "导出数据.xls",
FilterIndex = 2,
RestoreDirectory = true
};
if (saveFile.ShowDialog() == DialogResult.OK)
{
localFilePath = saveFile.FileName;
}
if (string.IsNullOrEmpty(localFilePath))
{
return;
}
var selectIndex = radiob_qg.Checked ? 0 : 1;
new Thread(delegate()
{
byte[] bytes = null;
if (radiob_qg.Checked)
{
bytes = DoSql.SelectInfoByDb <CrawlerQgOut>($"select * from {(radiob_qg.Checked ? "Crawler_Qg" : "Crawler_Bj")}", dbName, data).ListToExcel("导出数据");
}
else
{
bytes = DoSql.SelectInfoByDb <CrawlerBjOut>($"select * from {(radiob_qg.Checked ? "Crawler_Qg" : "Crawler_Bj")}", dbName, data).ListToExcel("导出数据");
}
File.WriteAllBytes(localFilePath, bytes);
Invoke(new Action(() =>
{
MessageBox.Show(@"导出成功！");
}));
})
{
IsBackground = true
}.Start();
}
private void 导出ExcelToolStripMenuItem_Click(object sender, EventArgs e)
{
var data = lb_return.SelectedItems.Cast <dynamic>().ToArray();
string localFilePath = "";
var saveFile = new SaveFileDialog
{
Filter = @"xls files(*.xls)|*.txt|All files(*.*)|*.*",
FileName = "导出数据.xls",
FilterIndex = 2,
RestoreDirectory = true
};
if (saveFile.ShowDialog() == DialogResult.OK)
{
localFilePath = saveFile.FileName;
}
if (string.IsNullOrEmpty(localFilePath))
{
return;
}
var selectIndex = cb_type.SelectedIndex;
new Thread(delegate()
{
byte[] bytes = null;
switch (selectIndex)
{
case 0: //全国
var exportQg = DoSql.SelectQgInfo(" and 机构名称 in @机构名称", new { 机构名称 = data });
bytes = exportQg.ListToExcel("导出数据");
break;
case 1: //北京
var exportBj = DoSql.SelectBjInfo(" and 市工商局_名称 in @市工商局_名称", new { 市工商局_名称 = data });
bytes = exportBj.ListToExcel("导出数据");
break;
default:
break;
}
File.WriteAllBytes(localFilePath, bytes);
Invoke(new Action(() =>
{
MessageBox.Show(@"导出成功！");
}));
})
{
IsBackground = true
}.Start();
}
private void ExportExcel()
{
var index = cb_type.SelectedIndex;
var localFilePath = "";
var saveFile = new SaveFileDialog
{
Filter = @"xls files(*.xls)|*.txt|All files(*.*)|*.*",
FileName = "导出.xls",
FilterIndex = 2,
RestoreDirectory = true
};
if (saveFile.ShowDialog() == DialogResult.OK)
{
localFilePath = saveFile.FileName;
}
if (string.IsNullOrEmpty(localFilePath))
{
return;
}
new Thread(delegate()
{
byte[] bytes = null;
switch (index)
{
case 0:
bytes = DoSql.SelectQgInfo().ListToExcel("全国库导出数据");
break;
case 1:
bytes = DoSql.SelectBjInfo().ListToExcel("北京库导出数据");
break;
default:
break;
}
File.WriteAllBytes(localFilePath, bytes);
Invoke(new Action(() =>
{
MessageBox.Show(@"导出成功！");
}));
})
{
IsBackground = true
}.Start();
}
private void b_go_Click(object sender, EventArgs e)
{
//IsExist(); //检查是否存在历史数据
//初始化
DoSql.ValidateDb();
try
{
MessageBox.Show(@"任务列表文本文件中，企业名一行一个。", @"温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
OpenFileDialog openfile = new OpenFileDialog
{
Multiselect = true,
Title = @"请选择文本文件",
Filter = @"文本文件|*.txt"
};
openfile.Multiselect = false;
if (openfile.ShowDialog() == DialogResult.OK)
{
groupBox1.Enabled = false;
gmRollingBar1.Visible = true;
gmRollingBar1.StartRolling();
var fileUrl = openfile.FileName;
_task = new TaskList(fileUrl);
GetTaskList(_task);
var crawlerType = cb_type.SelectedIndex;
switch (crawlerType)
{
case 0:
new CountrywideCrawler(_setting).CookieInitialization(_task); //全国组织机构代码爬虫线程
break;
case 1:
new CrawlerBegin(label_ip).CrawlerBeginFunc(_task, _setting.ThreadCount); //北京企业信息爬虫线程
break;
default:
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, @"致命错误");
}
}
public void BindListView()
{
label_message.Text = "";
var dbName = (comboDbList.Text ?? "").ToString().Split('[')[0].Trim(']');
if (string.IsNullOrWhiteSpace(dbName))
{
label_message.Text = "没有历史存留数据";
ClearListView();
return;
}
if (radiob_qg.Checked)
{
ShowListView(DoSql.SelectInfoByDb <CrawlerQgOut>($"select * from {(radiob_qg.Checked ? "Crawler_Qg" : "Crawler_Bj")}", dbName));
}
else
{
ShowListView(DoSql.SelectInfoByDb <CrawlerBjOut>($"select * from {(radiob_qg.Checked ? "Crawler_Qg" : "Crawler_Bj")}", dbName));
}
}
public bool Commit()
{
bool bRet = Validate();
if (!bRet)
{
return(bRet);
}
bRet = DoSql.TestConn(ServerIP, UserName, Password);
if (bRet)
{
Framework.Container.Instance.EvtAggregator.GetEvent <AnalyseMessageEvent>().Publish(
new Tuple <uint, string>(100, string.Format("连接服务器 {0}:{1} ...【检索服务{2}:{3}】【图片接入服务{4}:{5}】", m_ServerIP, m_ServerPort, m_SearchIP, m_SearchPort, m_PicIP, m_PicPort)));
Framework.Environment.ServerIP = ServerIP;
Framework.Environment.TaskPort = (int)ServerPort;
Framework.Environment.PicIP = PicIP;
Framework.Environment.PicPort = (int)PicPort;
Framework.Environment.UserName = UserName;
Framework.Environment.Password = Password;
Framework.Environment.SearchPort = (int)SearchPort;
Framework.Environment.SearchIP = SearchIP;
Framework.Environment.SavePassword = RememberPassword;
Framework.Environment.SaveConfig();
}
else
{
Framework.Container.Instance.InteractionService.ShowMessageBox("无法连接服务器", Framework.Environment.PROGRAM_NAME,
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return(bRet);
}
private void LoadFirst()
{
tb_logs.AppendText((string.IsNullOrWhiteSpace(tb_logs.Text) ? "" : "\r\n") + DateTime.Now + " 采集引擎初始化...");
DoSql.ValidateDb();
}
private void b_search_Click(object sender, EventArgs e)
{
var searchText = t_search.Text;
if (string.IsNullOrWhiteSpace(searchText))
{
MessageBox.Show("查询不能为空，我想你应该知道~", "消息", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
b_search.Enabled = false;
LoadFirst();
var crawlerType = cb_type.SelectedIndex;
searchThread = new Thread(() =>
{
switch (crawlerType)
{
case 0:
//全国组织机构代码爬虫线程
new CountrywideCrawler(new Setting()).SingelThreadRun(searchText, tb_logs);
foreach (var item in DoSql.SelectQgInfo().Select(m => m.机构名称))
{
if (item != null && !lb_return.Items.Contains(item))
{
Invoke(new MethodInvoker(() =>
{
lb_return.Items.Add(item);
}));
}
}
;
break;
case 1:
//北京企业信息爬虫线程
var Ip = new CrawlerBegin(l_ipaddress).SingelCrawlerThread(searchText, lb_return, tb_logs, (string)objCache["Ip"]);
objCache["Ip"] = Ip;
foreach (var item in DoSql.SelectBjInfo().Select(m => m.市工商局_名称))
{
if (item != null && !lb_return.Items.Contains(item))
{
Invoke(new MethodInvoker(() =>
{
lb_return.Items.Add(item);
}));
}
}
;
break;
default:
//爬你妹，没有这个选项
break;
}
Invoke(new MethodInvoker(() => { b_search.Enabled = true; }));
})
{
IsBackground = true
};
searchThread.Start();
}
