/// <summary>
/// 导出
/// </summary>
private void MasterToolBar_DoExport_Click(object sender, EventArgs e)
{
_currentDt = bSafetyStock.GetList(GetConduction()).Tables[0];
if (isSearch && _currentDt != null)
{
foreach (DataRow row in _currentDt.Rows)
{
try
{
if (row["CREATE_USER"] != null && bCommon.GetBaseMaster("USER", CConvert.ToString(row["CREATE_USER"])) != null)
{
row["CREATE_USER"] = bCommon.GetBaseMaster("USER", CConvert.ToString(row["CREATE_USER"])).Name;
}
if (row["LAST_UPDATE_USER"] != null && bCommon.GetBaseMaster("USER", CConvert.ToString(row["LAST_UPDATE_USER"])) != null)
{
row["LAST_UPDATE_USER"] = bCommon.GetBaseMaster("USER", CConvert.ToString(row["LAST_UPDATE_USER"])).Name;
}
}
catch { }
}
int result = CommonExport.DataTableToExcel(_currentDt, CConstant.SAFETY_STOCK_HEADER, CConstant.SAFETY_STOCK_COLUMNS, "SAFETY_STOCK", "SAFETY_STOCK");
if (result == CConstant.EXPORT_SUCCESS)
{
MessageBox.Show("数据已经成功导出!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (result == CConstant.EXPORT_FAILURE)
{
MessageBox.Show("数据导出失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("没有可以导出的数据。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 导出
/// </summary>
private void MasterToolBar_DoExport_Click(object sender, EventArgs e)
{
_currentDt = bSafetyStock.GetList(GetConduction()).Tables[0];
if (isSearch && _currentDt != null)
{
foreach (DataRow row in _currentDt.Rows)
{
try
{
if (row["CREATE_USER"] != null && bCommon.GetBaseMaster("USER", CConvert.ToString(row["CREATE_USER"])) != null)
{
row["CREATE_USER"] = bCommon.GetBaseMaster("USER", CConvert.ToString(row["CREATE_USER"])).Name;
}
if (row["LAST_UPDATE_USER"] != null && bCommon.GetBaseMaster("USER", CConvert.ToString(row["LAST_UPDATE_USER"])) != null)
{
row["LAST_UPDATE_USER"] = bCommon.GetBaseMaster("USER", CConvert.ToString(row["LAST_UPDATE_USER"])).Name;
}
}
catch { }
}
SaveFileDialog sf = new SaveFileDialog();
sf.FileName = "LZ_SAFETY_STOCK_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
sf.Filter = "(文件)|*.xls;*.xlsx";
string header = "仓库编号\t仓库名称\t商品编号\t商品名称\t单位编号\t单位名称\t安全在库数\t最大在库数\t最小采购数\t状态\t创建人员\t创建时间\t最后更新人\t最后更新时间\t\n";
if (sf.ShowDialog(this) == DialogResult.OK)
{
int result = CExport.DataTableToCsv(_currentDt, header, sf.FileName);
if (result == 0)
{
MessageBox.Show("导出成功!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}