/**/
/// <summary>
/// 打开文件
/// </summary>
/// <param name="fileName">文件名</param>
private static void OpenFile(string fileName)
{
if (MessageBox.Show("是否想要打开这个文件?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
Process process = new Process();
process.StartInfo.FileName = fileName;
process.StartInfo.Verb = "Open";
process.StartInfo.WindowStyle = ProcessWindowStyle.Normal;
process.Start();
}
catch
{
MessageBox.Show("您的系统不能打开该类型的文件！.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
#endregion
#region 把GridControl的数据输出
/**/
/// <summary>
/// 把GridControl的数据输出
/// </summary>
/// <param name="provider">输出提供者</param>
/// <param name="gridView1">DevExpress GridView</param>
public static void ExportTo(IExportProvider provider, GridView gridView1)
{
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
BaseExportLink link = gridView1.CreateExportLink(provider);
(link as GridViewExportLink).ExpandAll = false;
link.ExportTo(true);
Cursor.Current = currentCursor;
}
private void ExportTo(DevExpress.XtraGrid.GridControl pDg, IExportProvider provider)
{
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
BaseExportLink link = pDg.MainView.CreateExportLink(provider);
(link as GridViewExportLink).ExpandAll = false;
link.ExportTo(true);
provider.Dispose();
Cursor.Current = currentCursor;
}
/// <summary>
/// 把XtraGrid中的数据倒出到Excel 中
/// </summary>
/// <param name="pGridView"></param>
/// <param name="pExportFullName"></param>
public void ExportToExcel(DevExpress.XtraGrid.GridControl pDg, string pExportFullName)
{
if (pDg.MainView != null)
{
try {
ExportXlsProvider ex = new ExportXlsProvider(pExportFullName);
BaseExportLink link = pDg.MainView.CreateExportLink(ex);
((GridViewExportLink)link).ExpandAll = false;
link.ExportTo(true);
}
catch (Exception e) {
throw e;
}
}
}
private void ExportTo(IExportProvider provider)
{
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
this.FindForm().Refresh();
BaseExportLink link = gridView1.CreateExportLink(provider);
(link as GridViewExportLink).ExpandAll = false;
link.ExportTo(true);
provider.Dispose();
Cursor.Current = currentCursor;
}
private void toolExport_Click(object sender, EventArgs e)
{
IEnumerator enumGridControl = _componentContainer.GetEnumerator();
while (enumGridControl.MoveNext())
{
GridControl grd = enumGridControl.Current as GridControl;
if (grd != null)
{
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
IExportProvider provider = new ExportXlsProvider(saveFileDialog1.FileName);
BaseExportLink link = grd.MainView.CreateExportLink(provider);
link.ExportTo(true);
}
}
}
}
