啊啊啊
#region 开始分析事件事件
/// <summary>
/// 开始分析事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, EventArgs e)
{
//DataBle模糊过滤字符
//出现输入关键字的日志
if (label4.Text.Length <= 0)
{
MessageBox.Show("请选择日志目录(*.txt)");
}
else
{
if (label5.Text.Length > 0)
{
dv_All = PipingFileReader(fileNames).DefaultView;
dtSameRowCount = dv_All.Table.Rows.Count;
//dataGridView1.DataSource = dv_All;
//Excel中日志信息
DataView dt = ParseExcel(ExcelName, 1).DefaultView;
//dataGridView1.DataSource = dt;
FileStream fs = null;
FileStream fs_Same = null;
StreamWriter sw = null;
StreamWriter sw_Same = null;
fs = new FileStream("D:\\LogFile\\UnSame_Log.txt", FileMode.Create);
sw = new StreamWriter(fs, Encoding.Default);
fs_Same = new FileStream("D:\\LogFile\\Same_Log.txt", FileMode.Create);
sw_Same = new StreamWriter(fs_Same, Encoding.Default);
//1.遍历dt中数据,取出用于比对的数据
//2.循环传入到方法中进行比对
//过滤不相同的日志信息
//10-09-16 修改拼查询字符串
string strCheck = string.Empty;
DataTable dt2 = new DataTable();
for (int j = 1; j < dt.Table.Rows.Count; j++)
{
if (j < dt.Table.Rows.Count - 1)
{
strCheck += "'" + dt.Table.Rows[j]["Id2"].ToString() + "' AND UnNum <> ";
}
else
{
strCheck += "'" + dt.Table.Rows[j]["Id2"].ToString() + "'";
}
}