private void btnExport_Click(object sender, EventArgs e)
 {
     //VietBaIT.LABLink.Reports.ExcelReport.ExportGridEx(grdPatient);
     Stream sw = null;
     try
     {
         var sd = new SaveFileDialog {Filter = "Excel File (*.xls)|*.xls|All Files (*.*)|*.*"};
         if (sd.ShowDialog() == DialogResult.OK)
         {
             //sw = new FileStream(sd.FileName, FileMode.OpenOrCreate, FileAccess.ReadWrite);
             sw = new FileStream(sd.FileName, FileMode.Create);
             var grdListExporter = new GridEXExporter();
             grdListExporter.IncludeExcelProcessingInstruction = true;
             grdListExporter.IncludeFormatStyle = true;
             grdListExporter.IncludeHeaders = true;
             grdListExporter.GridEX = grdPatient;
             grdListExporter.Export(sw);
             Utility.ShowMsg("Xuất dữ liệu thành công");
         }
     }
     catch (Exception ex)
     {
         Utility.ShowMsg(ex.Message);
     }
     finally
     {
         if (sw != null)
         {
             sw.Flush();
             sw.Close();
             sw.Dispose();
         }
     }
 }
Esempio n. 2
0
 public static void ExportGridEx(Janus.Windows.GridEX.GridEX gridEx )
 {
     Stream sw = null;
     try
     {
         var sd = new SaveFileDialog { Filter = "Excel File (*.xml)|*.xml" };
         if (sd.ShowDialog() == DialogResult.OK)
         {
             //sw = new FileStream(sd.FileName, FileMode.OpenOrCreate, FileAccess.ReadWrite);
             sw = new FileStream(sd.FileName, FileMode.Create);
             GridEXExporter grdListExporter = new GridEXExporter();
             grdListExporter.IncludeExcelProcessingInstruction = true;
             grdListExporter.IncludeFormatStyle = true;
             grdListExporter.IncludeHeaders = true;
             grdListExporter.GridEX = gridEx;
             grdListExporter.Export(sw);
             Utility.ShowMsg("Xuất dữ liệu thành công");
         }
     }
     catch (Exception ex)
     {
         Utility.ShowMsg(ex.Message);
     }
     finally
     {
         if (sw != null)
         {
             sw.Flush();
             sw.Close();
             sw.Dispose();
         }
     }
 }
Esempio n. 3
0
        protected void CreateXLSFile(string XLSFileName, GridEX gridEX, ExportMode exportMode)
        {
            try
            {
                SaveFileDialog saveFileDialog1 = new SaveFileDialog();
                saveFileDialog1.Filter           = "Excel files (*.xls)|*.xls";
                saveFileDialog1.InitialDirectory = Application.StartupPath + "\\Excels";
                saveFileDialog1.FileName         = XLSFileName;
                saveFileDialog1.FilterIndex      = 2;
                saveFileDialog1.RestoreDirectory = true;
                DialogResult dr = saveFileDialog1.ShowDialog();
                if (dr == DialogResult.Cancel)
                {
                    return;
                }
                if (File.Exists(saveFileDialog1.FileName))
                {
                    File.Delete(saveFileDialog1.FileName);
                }
                GridEXExporter gridEXExporter1 = new GridEXExporter();
                gridEXExporter1.GridEX     = gridEX;
                gridEXExporter1.ExportMode = exportMode;
                gridEXExporter1.Export(saveFileDialog1.OpenFile());

                Process process1 = new Process();
                process1.StartInfo.FileName = saveFileDialog1.FileName;
                process1.Start();
            }
            catch (Exception exp)
            {
                EMessage.Show("خطا در ایجاد فایل اکسل\r\n" + exp.Message, "خطا در ایجاد فایل اکسل", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Esempio n. 4
0
        private void btnExport_Click(object sender, EventArgs e)
        {
            //VietBaIT.LABLink.Reports.ExcelReport.ExportGridEx(grdPatient);
            Stream sw = null;

            try
            {
                var sd = new SaveFileDialog {
                    Filter = "Excel File (*.xls)|*.xls|All Files (*.*)|*.*"
                };
                if (sd.ShowDialog() == DialogResult.OK)
                {
                    //sw = new FileStream(sd.FileName, FileMode.OpenOrCreate, FileAccess.ReadWrite);
                    sw = new FileStream(sd.FileName, FileMode.Create);
                    var grdListExporter = new GridEXExporter();
                    grdListExporter.IncludeExcelProcessingInstruction = true;
                    grdListExporter.IncludeFormatStyle = true;
                    grdListExporter.IncludeHeaders     = true;
                    grdListExporter.GridEX             = grdPatient;
                    grdListExporter.Export(sw);
                    Utility.ShowMsg("Xuất dữ liệu thành công");
                }
            }
            catch (Exception ex)
            {
                Utility.ShowMsg(ex.Message);
            }
            finally
            {
                if (sw != null)
                {
                    sw.Flush();
                    sw.Close();
                    sw.Dispose();
                }
            }
        }
Esempio n. 5
0
        public static void ExportGridEx(GridEX gridEx)
        {
            Stream streamWrite = null;

            try
            {
                var saveDialog = new SaveFileDialog {
                    Filter = "Xml File (*.xml)|*.xml|All Files (*.*)|*.*"
                };

                if (saveDialog.ShowDialog() == DialogResult.OK)
                {
                    streamWrite = new FileStream(saveDialog.FileName, FileMode.Create);
                    var gridExporter = new GridEXExporter();
                    gridExporter.IncludeExcelProcessingInstruction = true;
                    gridExporter.IncludeFormatStyle = true;
                    gridExporter.IncludeHeaders     = true;
                    gridExporter.GridEX             = gridEx;

                    gridExporter.Export(streamWrite);

                    MessageBox.Show("Eksport danych do pliku został zakończony.", "Eksport do pliku", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (streamWrite != null)
                {
                    streamWrite.Flush();
                    streamWrite.Close();
                    streamWrite.Dispose();
                }
            }
        }
Esempio n. 6
0
        public static void ExportGridEx(GridEX gridEx, string name)
        {
            Stream sw = null;

            try
            {
                var sd = new SaveFileDialog {
                    Filter = @"Excel File (*.xls)|*.xls|All Files (*.*)|*.*"
                };
                if (sd.ShowDialog() == DialogResult.OK)
                {
                    //sw = new FileStream(sd.FileName, FileMode.OpenOrCreate, FileAccess.ReadWrite);
                    sw = new FileStream(sd.FileName, FileMode.Create);
                    var grdListExporter = new GridEXExporter();
                    grdListExporter.SheetName = name;
                    grdListExporter.IncludeExcelProcessingInstruction = true;
                    grdListExporter.IncludeFormatStyle = true;
                    grdListExporter.IncludeHeaders     = true;
                    grdListExporter.GridEX             = gridEx;
                    grdListExporter.Export(sw);
                    MessageBox.Show(@"تهیه فایل با موفقیت انجام شد");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                if (sw != null)
                {
                    sw.Flush();
                    sw.Close();
                    sw.Dispose();
                }
            }
        }
Esempio n. 7
0
        public static void ExportGridEx(Janus.Windows.GridEX.GridEX gridEx)
        {
            Stream sw = null;

            try
            {
                var sd = new SaveFileDialog {
                    Filter = "Excel File (*.xml)|*.xml"
                };
                if (sd.ShowDialog() == DialogResult.OK)
                {
                    //sw = new FileStream(sd.FileName, FileMode.OpenOrCreate, FileAccess.ReadWrite);
                    sw = new FileStream(sd.FileName, FileMode.Create);
                    GridEXExporter grdListExporter = new GridEXExporter();
                    grdListExporter.IncludeExcelProcessingInstruction = true;
                    grdListExporter.IncludeFormatStyle = true;
                    grdListExporter.IncludeHeaders     = true;
                    grdListExporter.GridEX             = gridEx;
                    grdListExporter.Export(sw);
                    Utility.ShowMsg("Xuất dữ liệu thành công");
                }
            }
            catch (Exception ex)
            {
                Utility.ShowMsg(ex.Message);
            }
            finally
            {
                if (sw != null)
                {
                    sw.Flush();
                    sw.Close();
                    sw.Dispose();
                }
            }
        }