//导出
private void tsbExport_Click(object sender, EventArgs e)
{
if (BackDataSet.Tables.Count > 0)
{
Export FormE = new Export(BackDataSet);
FormE.ShowDialog(this);
}
//Apq.Windows.Forms.Wizard w = new Apq.Windows.Forms.Wizard();
//w.StepIndex = 0;
//w.btnBack.Click += new EventHandler(btnBack_Click);
//w.btnNext.Click += new EventHandler(btnNext_Click);
//w.btnFinish.Click += new EventHandler(btnFinish_Click);
//w.btnCancel.Click += new EventHandler(btnCancel_Click);
//ShowExportForm(w, 0, 1);
}
private void tsbExport_Click(object sender, EventArgs e)
{
if (lstds.Count > 0)
{
DataSet ds = lstds[0].Copy();
// 增加服务器名列
foreach (DataTable dt in ds.Tables)
{
dt.Columns.Add("__DBIName");
// 设置第一个数据集的服务器名
// 设置服务器名
foreach (DataRow dr in dt.Rows)
{
dr["__DBIName"] = ds.DataSetName;
}
}
for (int i = 1; i < lstds.Count; i++)
{
ds.Merge(lstds[i]);
// 设置服务器名
foreach (DataTable dt in ds.Tables)
{
foreach (DataRow dr in dt.Rows)
{
if (Apq.Convert.LikeDBNull(dr["__DBIName"]))
{
dr["__DBIName"] = lstds[i].DataSetName;
}
}
}
}
Export FormE = new Export(ds);
FormE.ShowDialog(this);
}
}