private void toolStripButton导出_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = m_marketPartBillServer.GetExcelData(
checkBillDateAndStatus1.dtpStartTime.Value, checkBillDateAndStatus1.dtpEndTime.Value,
checkBillDateAndStatus1.cmbBillStatus.Text);
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1);
RefreshDataGridView();
}
private void btnOutExcel_Click(object sender, EventArgs e)
{
if (tabControl1.SelectedTab.Name == "tpMachineAccount")
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView_MachineAccount);
}
else if (tabControl1.SelectedTab.Name == "tpDayToDay")
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView_DayToDay);
}
}
private void btnExcel_Click(object sender, EventArgs e)
{
DataGridView dgv = new DataGridView();
foreach (Control cl in tabControl1.SelectedTab.Controls)
{
if (cl is DataGridView)
{
dgv = (DataGridView)cl;
}
}
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dgv);
}
private void btnOutExcel_Click(object sender, EventArgs e)
{
foreach (Control cl in tabControl1.SelectedTab.Controls)
{
if (cl is TabControl)
{
foreach (Control clSon in ((TabControl)cl).SelectedTab.Controls)
{
if (clSon is CustomDataGridView)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, (DataGridView)clSon);
}
}
}
else if (cl is CustomDataGridView)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, (DataGridView)cl);
}
}
}
private void 综合查询toolStripButton3_Click(object sender, EventArgs e)
{
IAuthorization authorization = PlatformFactory.GetObject <IAuthorization>();
string businessID = "查看储备人才库";
IQueryResult qr = authorization.Query(businessID, null, null, 0);
List <string> lstFindField = new List <string>();
DataColumnCollection columns = qr.DataCollection.Tables[0].Columns;
if (qr.Succeeded && columns.Count > 0)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1);
for (int i = 0; i < columns.Count; i++)
{
lstFindField.Add(columns[i].ColumnName);
}
}
FormConditionFind formFindCondition = new FormConditionFind(this, lstFindField.ToArray(), businessID, labelTitle.Text);
formFindCondition.ShowDialog();
}
private void 导出toolStripButton_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1);
}
private void btnOutExcel_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dgv_InvoiceShow);
}
private void 导出本身_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog2, dgvSelfReject);
}
private void 导出Bom_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dgvBomReject);
}
private void btnExport_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dgv_Show);
}
private void btn_logistics_Output_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dgvlogistics);
}
private void btnOutput_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, customDataGridView1);
}
private void btnPrint_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dgvStatistical);
}
private void 导出EXCELToolStripMenuItem_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1);
}
private void btnOutput_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, (DataGridView)dgv_BusDetail);
}
private void btnExportExcel_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1);
}
private void btnOutput_BOM_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dgvbom);
}