获取GridView的选择行的对应的某单元的值

获取GridView的选择行的对应的某单元的值:GetGridControlSelectValue#region 获取GridView的选择行的对应的某单元的值:GetGridControlSelectValue

        /** <summary>
        /// 获取GridView的选择行的对应的某单元的值:GetGridControlSelectValue
        /// </summary>
        /// <param name="gridView"></param>
        /// <param name="dataColumnName"></param>
        /// <returns></returns>
        public object GetGridControlSelectValue(DevExpress.XtraGrid.Views.Grid.GridView gridView,string dataColumnName)
        {
            if (gridView.SelectedRowsCount > 0)
            {
                return gridView.GetDataRow(gridView.GetSelectedRows()[0])[dataColumnName];
            }
            else
                return null;
        }

        #endregion

        打开文件#region 打开文件

        /** <summary>
        /// 打开文件
        /// </summary>
        /// <param name="fileName">文件名</param>
        public 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(this, "您的系统不能打开该类型的文件!.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }

        #endregion

        把GridControl的数据输出#region 把GridControl的数据输出

        /** <summary>
        /// 把GridControl的数据输出
        /// </summary>
        /// <param name="provider">输出提供者</param>
        /// <param name="gridView1">DevExpress GridView</param>
        public 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;
        }

        /** <summary>
        /// 把GridControl的数据输出输出成Html
        /// </summary>
        /// <param name="provider"></param>
        /// <param name="gridView1"></param>
        public void ExportToHtml(GridView gridView1)
        {
            string fileName = ShowSaveFileDialog("HTML 文档", "HTML 文档|*.html");
            if(fileName != "")
            {
                ExportTo(new ExportHtmlProvider(fileName),gridView1);
                OpenFile(fileName);
            }   
        }

        /** <summary>
        /// 把GridControl的数据输出输出成Xml
        /// </summary>
        /// <param name="gridView1"></param>
        public void ExportToXml(GridView gridView1)
        {
            string fileName = ShowSaveFileDialog("Xml 文档", "Xml 文档|*.xml");
            if(fileName != "")
            {
                ExportTo(new ExportXmlProvider(fileName),gridView1);
                OpenFile(fileName);
            }   
        }

        /** <summary>
        /// 把GridControl的数据输出输出成Excel
        /// </summary>
        /// <param name="gridView1"></param>
        public void ExportToExcel(GridView gridView1)
        {
            string fileName = ShowSaveFileDialog("Excel 文档", "Excel 文档|*.xls");
            if(fileName != "")
            {
                ExportTo(new ExportXlsProvider(fileName),gridView1);
                OpenFile(fileName);
            }   
        }

        /** <summary>
        /// 把GridControl的数据输出输出成Text文本
        /// </summary>
        /// <param name="gridView1"></param>
        public void ExportToText(GridView gridView1)
        {
            string fileName = ShowSaveFileDialog("Text 文档", "Text 文档|*.txt");
            if(fileName != "")
            {
                ExportTo(new ExportTxtProvider(fileName),gridView1);
                OpenFile(fileName);
            }   
        }
        #endregion

        提示保存窗口#region 提示保存窗口

        /** <summary>
        /// 提示保存窗口
        /// </summary>
        /// <param name="title"></param>
        /// <param name="filter"></param>
        /// <returns></returns>
        public string ShowSaveFileDialog(string title, string filter)
        {
            SaveFileDialog dlg = new SaveFileDialog();
            string name = Application.ProductName;
            int n = name.LastIndexOf(".") + 1;
            if(n > 0) name = name.Substring(n, name.Length - n);
            dlg.Title = "Export To " + title;
            dlg.FileName = name;
            dlg.Filter = filter;
            if(dlg.ShowDialog() == DialogResult.OK) return dlg.FileName;
            return "";
        }

        #endregion

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值