private void btnExportExcel_Click(object sender, EventArgs e)
{
try
{
this.btnExportExcel.Enabled = false;
if (this.myDataGridView1.DataSource == null)
{
SysMessage.InformationMsg("没有数据可导出！");
return;
}
DataTable dtData = (DataTable)this.myDataGridView1.DataSource;
if (dtData.Rows.Count == 0)
{
SysMessage.InformationMsg("没有数据可导出！");
return;
}
ExcelCommonMethod.ExportIntoExcel(dtData, this.Text);
}
catch (Exception ex)
{
SysMessage.ErrorMsg(ex.Message);
}
finally
{
this.btnExportExcel.Enabled = true;
}
}
private void tool_ExportExcel_Click(object sender, EventArgs e)
{
DataTable dtData = (DataTable)this.myDataGridView1.DataSource;
if (dtData.Rows.Count > 0)
{
ExcelCommonMethod.ExportIntoExcel(dtData, "");
}
}
public override void tool1_PrintView_Click(object sender, EventArgs e)
{
base.tool1_PrintView_Click(sender, e);
if (this.myDataGridViewHead.CurrentRow == null)
{
return;
}
if (SysMessage.YesNoMsg("数据是否导入EXCEL文件？") == System.Windows.Forms.DialogResult.No)
{
return;
}
ExcelCommonMethod.ExportIntoExcel((DataTable)this.myDataGridViewDetails.DataSource, string.Empty);
}
public override void btnExportDetails_Click(object sender, EventArgs e)
{
base.btnExportDetails_Click(sender, e);
if (this.dataGridViewHead.CurrentRow == null)
{
return;
}
if (this.tabControl1.SelectedIndex == 0)
{
return;
}
try
{
string strSQL = string.Empty;
string strExcelTitle = string.Empty;
int iOrderID = (int)this.dataGridViewHead.Rows[this.dataGridViewHead.CurrentRow.Index].Cells["订单id"].Value;
string strBooksNo = this.dataGridViewHead.CurrentRow.Cells["手册编号"].Value.ToString();
switch (this.tabControl1.SelectedIndex)
{
case 1:
strSQL = string.Format("exec 预先订单用量明细 {0},{1}", iOrderID, strBooksNo);
strExcelTitle = "归并后材料总单";
break;
case 2:
strSQL = string.Format("exec 预先订单归并前用量明细 {0},{1}", iOrderID, strBooksNo);
strExcelTitle = "归并前材料总单";
break;
case 3:
strSQL = string.Format("exec 预先订单归并前明细用量明细 {0},{1}", iOrderID, strBooksNo);
strExcelTitle = "归并前材料明细总单";
break;
}
IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture);
dataAccess.Open();
DataTable dtExcel = dataAccess.GetTable(strSQL, null);
dataAccess.Close();
ExcelCommonMethod.ExportIntoExcel(dtExcel, strExcelTitle);
}
catch (Exception ex)
{
SysMessage.ErrorMsg(string.Format("【{0}】出错，错误信息如下：{1}{2}", btnExportDetails.Text, Environment.NewLine, ex.Message));
}
}
private void myButton3_Click(object sender, EventArgs e)
{
ExcelCommonMethod.proba(this);
}
public virtual void tool_ExportExcel_Click(object sender, EventArgs e)
{
ExcelCommonMethod.ExportIntoExcel((DataTable)this.myDataGridView1.DataSource, " ");
}
private void tool1_ExportExcel_Click(object sender, EventArgs e)
{
ExcelCommonMethod.ExportIntoExcel((DataTable)this.myDataGridView1.DataSource, "归并后料件清单");
ExcelCommonMethod.ExportIntoExcel((DataTable)this.myDataGridView2.DataSource, "归并前料件清单");
ExcelCommonMethod.ExportIntoExcel((DataTable)this.myDataGridView3.DataSource, "归并前料件明细清单");
}
private void tool1_ExportExcel_Click(object sender, EventArgs e)
{
ExcelCommonMethod.ExportIntoExcel(dtData, "出库料件统计");
}
