예제 #1
0
        private void Lsv_LinkList_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            int index = lsv_LinkList.SelectedItems.Count;

            if (index > 0 && XtraMessageBox.Show("是否打开文件?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                ListViewItem item     = lsv_LinkList.SelectedItems[0];
                string       filePath = item.SubItems[1].Text;
                if (!string.IsNullOrEmpty(filePath) && File.Exists(filePath))
                {
                    WinFormOpenHelper.OpenWinForm(Handle.ToInt32(), "open", filePath, null, null, ShowWindowCommands.SW_NORMAL);
                }
            }
        }
예제 #2
0
        private void DownloadButton_MouseDown(object sender, MouseEventArgs e)
        {
            if (e.Button == MouseButtons.Left)
            {
                object viewRow = view.GetFocusedRow();
                if (viewRow != null)
                {
                    object type = ((DataRowView)viewRow).Row.ItemArray[0];
                    if ("项目/课题清单".Equals(type))
                    {
                        XtraMessageBox.Show("此类别文件不可下载", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        return;
                    }
                    folderBrowserDialog1.Description = "选择文件保存路径";
                    if (folderBrowserDialog1.ShowDialog() == DialogResult.OK)
                    {
                        string         savePath    = folderBrowserDialog1.SelectedPath;
                        object         id          = ((DataRowView)viewRow).Row.ItemArray[1];
                        object         name        = ((DataRowView)viewRow).Row.ItemArray[2];
                        SqlConnection  con         = SqlHelper.GetConnect();
                        string         querySQL    = $"SELECT at_entity FROM Attachment WHERE at_id='{id}'";
                        SqlDataAdapter dataAdapter = new SqlDataAdapter(querySQL, con);
                        DataSet        dataSet     = new DataSet();
                        dataAdapter.Fill(dataSet);

                        Byte[]       fileByte = (Byte[])dataSet.Tables[0].Rows[0]["at_entity"];
                        BinaryWriter bw       = new BinaryWriter(File.Open(savePath + "\\" + name, FileMode.OpenOrCreate, FileAccess.Write));
                        bw.Write(fileByte);
                        bw.Close();

                        if (XtraMessageBox.Show("文件下载成功。\r\n是否打开文件所在地址", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes)
                        {
                            WinFormOpenHelper.OpenWinForm(0, "open", null, null, savePath, ShowWindowCommands.SW_NORMAL);
                        }
                    }
                }
            }
        }