private void btnOutput_Click(object sender, EventArgs e)
{
string dtp = dateTimePicker1.Value.ToString("yyyyMM");
Excel excel = new Excel();
Excel.Excel_Base excelObj = new Excel.Excel_Base();
DataSet ds = new DataSet();
GetData(ds, dtp);
excelObj.dataSet = ds;
excelObj.defauleFileName = "成本异常" + dateTimePicker1.Value.ToString("yyyy-MM");
excelObj.isWrite = true;
if (excel.ExcelOpt(excelObj))
{
if (excelObj.status)
{
Msg.Show("Excel导出成功！");
}
else
{
Msg.Show(excelObj.msg, "错误");
}
}
}
private void btnOutput_Click(object sender, EventArgs e)
{
Excel excel = new Excel();
Excel.Excel_Base excelObj = new Excel.Excel_Base();
DataSet ds = new DataSet();
GetData(ds);
excelObj.dataSet = ds;
excelObj.defauleFileName = "领退料明细(生产)导出" + DateTime.Now.ToString("yyyy-MM-dd");
excelObj.isWrite = true;
if (excel.ExcelOpt(excelObj))
{
if (excelObj.status)
{
Msg.Show("Excel导出成功！");
}
else
{
Msg.Show(excelObj.msg, "错误");
}
}
}
private DataTable ReadExcel()
{
Excel excel = new Excel();
Excel.Excel_Base excelObj = new Excel.Excel_Base();
excelObj.isTitleRow = true;
if (excel.ExcelOpt(excelObj))
{
if (excelObj.status == true)
{
DataTable dt = excelObj.dataDt;
return(dt);
}
else
{
Msg.Show(excelObj.msg);
return(null);
}
}
else
{
Msg.Show(excelObj.msg);
return(null);
}
}
private void btnLayoutDefault_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.TableName = "Excel导入-模板";
dt.Columns.Add("品号", Type.GetType("System.String"));
dt.Columns.Add("品名", Type.GetType("System.String"));
dt.Columns.Add("规格", Type.GetType("System.String"));
dt.Columns.Add("数量", Type.GetType("System.String"));
DataRow dr = dt.NewRow();
dr["品号"] = "";
dt.Rows.Add(dr);
Excel excel = new Excel();
Excel.Excel_Base excelObj = new Excel.Excel_Base();
excelObj.isWrite = true;
excelObj.defauleFileName = "录入进货单-Excel导入-模板";
excelObj.dataSet.Tables.Add(dt);
if (excel.ExcelOpt(excelObj))
{
if (excelObj.status)
{
Msg.Show("已保存模板");
}
else
{
Msg.ShowErr(excelObj.msg);
}
}
}
private void BtnOutput_Click(object sender, EventArgs e)
{
Excel excel = new Excel();
Excel.Excel_Base excelObj = new Excel.Excel_Base();
excelObj.dataDt = (DataTable)DgvMain.DataSource;
excelObj.defauleFileName = "订单信息导出_" + CmBoxType.Text + "_" + DateTime.Now.ToString("yyyy-MM-dd");
excelObj.isWrite = true;
if (excel.ExcelOpt(excelObj))
{
if (excelObj.status)
{
Msg.Show("Excel导出成功！");
}
else
{
Msg.ShowErr(excelObj.msg);
}
}
}
private void btnOutput_Click(object sender, EventArgs e)
{
Excel excel = new Excel();
Excel.Excel_Base excelObj = new Excel.Excel_Base();
excelObj.dataSet.Tables.Add((DataTable)DgvMain.DataSource);
excelObj.dataSet.Tables[0].TableName = "批量采购数量汇总";
excelObj.defauleFileName = "批量采购数量汇总_" + DateTime.Now.ToString("yyyy-MM-dd");
excelObj.isWrite = true;
if (excel.ExcelOpt(excelObj))
{
if (excelObj.status)
{
Msg.Show("Excel导出成功！");
}
else
{
Msg.Show(excelObj.msg, "错误");
}
}
}
