DataGridView DGVout = new DataGridView();
DataGridViewTextBoxColumn OCBianhao = new DataGridViewTextBoxColumn();
OCBianhao.Name = "OCBianhao";
OCBianhao.HeaderText = "编号";
DataGridViewTextBoxColumn OCTongzhishuLeixing = new DataGridViewTextBoxColumn();
OCTongzhishuLeixing.Name = "OCTongzhishuLeixing";
OCTongzhishuLeixing.HeaderText = "通知书类型";
DataGridViewTextBoxColumn OCTiquxinxi = new DataGridViewTextBoxColumn();
OCTiquxinxi.Name = "OCTiquxinxi";
OCTiquxinxi.HeaderText = "提取信息";
DataGridViewTextBoxColumn OCFawenRiqi = new DataGridViewTextBoxColumn();
OCFawenRiqi.Name = "OCFawenRiqi";
OCFawenRiqi.HeaderText = "发文日期";
DataGridViewTextBoxColumn OCShibieRiqi = new DataGridViewTextBoxColumn();
OCShibieRiqi.Name = "OCShibieRiqi";
OCShibieRiqi.HeaderText = "识别日期";
DataGridViewTextBoxColumn OCMobanTianchong = new DataGridViewTextBoxColumn();
OCMobanTianchong.Name = "OCMobanTianchong";
OCMobanTianchong.HeaderText = "邮件模板填充信息";
DataGridViewTextBoxColumn OCMobanbeizhu = new DataGridViewTextBoxColumn();
OCMobanbeizhu.Name = "OCMobanbeizhu";
OCMobanbeizhu.HeaderText = "备注";
DGVout.Columns.AddRange(new DataGridViewColumn[] { OCTongzhishuLeixing, OCTiquxinxi , OCFawenRiqi , OCShibieRiqi , OCMobanTianchong, OCMobanbeizhu });
foreach (DataGridViewRow RowSoc in DGVMain.Rows)
{
if (RowSoc.Cells["Checked"].Value!=null&& (bool)RowSoc.Cells["Checked"].Value )
{
int index = DGVout.Rows.Add();
DataGridViewRow ThisAddRow = DGVout.Rows[index];
foreach (DataGridViewColumn oneDGVoutColumn in DGVout.Columns)
{
foreach (DataGridViewColumn OneDGVMainColumn in DGVMain.Columns)
{
if (OneDGVMainColumn.HeaderText == oneDGVoutColumn.HeaderText)
{
ThisAddRow.Cells[oneDGVoutColumn.Name].Value = RowSoc.Cells[OneDGVMainColumn.Name].Value;
}
}
}
}
}
if (DGVout.Rows.Count>0)
{
Common.ExcelHelper.DgvExportExcel(DGVout, "统计数据", false);
}