private void gv_Attachment_DoubleClick(object sender, EventArgs e) { try { if (gv_Attachment.FocusedRowHandle < 0) { return; } FileUtils.ClearDirectory(Application.StartupPath + "\\Temp"); var imageId = Convert.ToInt32(gv_Attachment.GetFocusedRowCellValue("Id")); var fileName = gv_Attachment.GetFocusedRowCellValue("Name").ToString(); var attachementBll = new EqptAttachment(); var attachementModel = attachementBll.GetModel(imageId); var fs = new FileStream(Application.StartupPath + "\\Temp\\" + fileName, FileMode.OpenOrCreate); var bw = new BinaryWriter(fs); bw.Write(attachementModel.Attachment, 0, attachementModel.Attachment.Length); bw.Close(); fs.Close(); Process.Start(Application.StartupPath + "\\Temp\\" + fileName); } catch (Exception ex) { XtraMessageBox.Show("打开出错!", "提示"); } }
private void btn_DownloadAttachment_Click(object sender, EventArgs e) { if (gv_Attachment.FocusedRowHandle < 0) { XtraMessageBox.Show("当前未选中任何附件!", "提示"); return; } var attachmentId = Convert.ToInt32(gv_Attachment.GetFocusedRowCellValue("Id")); var attachmentName = gv_Attachment.GetFocusedRowCellValue("Name").ToString(); var saveFileDialog = new SaveFileDialog() { Filter = string.Format("*.{0}|*.{0}", Path.GetExtension(attachmentName)), FileName = attachmentName }; if (saveFileDialog.ShowDialog() == DialogResult.OK) { var eqptAttachmentBll = new EqptAttachment(); var eqptAttachmentModel = eqptAttachmentBll.GetModel(attachmentId); var fs = new FileStream(saveFileDialog.FileName, FileMode.OpenOrCreate); var bw = new BinaryWriter(fs); bw.Write(eqptAttachmentModel.Attachment, 0, eqptAttachmentModel.Attachment.Length); bw.Close(); fs.Close(); XtraMessageBox.Show("下载成功!", "提示"); } }
private void btn_AddAttachment_Click(object sender, EventArgs e) { var openFileDialog = new OpenFileDialog(); if (openFileDialog.ShowDialog() == DialogResult.OK) { using (var fsRead = new FileStream(openFileDialog.FileName, FileMode.Open, FileAccess.Read, FileShare.ReadWrite)) { if (fsRead.CanRead) { var eqptAttachmentBll = new EqptAttachment(); var eqptAttachmentModel = new Model.EqptAttachment(); var fsSize = Convert.ToInt32(fsRead.Length); var btRead = new byte[fsSize]; fsRead.Read(btRead, 0, fsSize); fsRead.Close(); eqptAttachmentModel.Attachment = btRead; eqptAttachmentModel.LayerName = _layerInfo.LayerName; eqptAttachmentModel.Name = Path.GetFileName(openFileDialog.FileName); eqptAttachmentModel.SmId = _smId; XtraMessageBox.Show(eqptAttachmentBll.Add(eqptAttachmentModel) > 0 ? "添加成功!" : "添加失败!", "提示"); InitAttachmentGrid(); } } } }
private void btn_AddAttachment_Click(object sender, EventArgs e) { var openFileDialog = new OpenFileDialog(); if(openFileDialog.ShowDialog()==DialogResult.OK) { using (var fsRead = new FileStream(openFileDialog.FileName, FileMode.Open, FileAccess.Read, FileShare.ReadWrite)) { if (fsRead.CanRead) { var eqptAttachmentBll = new EqptAttachment(); var eqptAttachmentModel = new Model.EqptAttachment(); var fsSize = Convert.ToInt32(fsRead.Length); var btRead = new byte[fsSize]; fsRead.Read(btRead, 0, fsSize); fsRead.Close(); eqptAttachmentModel.Attachment = btRead; eqptAttachmentModel.LayerName = _layerInfo.LayerName; eqptAttachmentModel.Name = Path.GetFileName(openFileDialog.FileName); eqptAttachmentModel.SmId = _smId; XtraMessageBox.Show(eqptAttachmentBll.Add(eqptAttachmentModel) > 0 ? "添加成功!" : "添加失败!", "提示"); InitAttachmentGrid(); } } } }
private void gv_Attachment_DoubleClick(object sender, EventArgs e) { try { if (gv_Attachment.FocusedRowHandle < 0) return; FileUtils.ClearDirectory(Application.StartupPath + "\\Temp"); var imageId = Convert.ToInt32(gv_Attachment.GetFocusedRowCellValue("Id")); var fileName = gv_Attachment.GetFocusedRowCellValue("Name").ToString(); var attachementBll = new EqptAttachment(); var attachementModel = attachementBll.GetModel(imageId); var fs = new FileStream(Application.StartupPath + "\\Temp\\" + fileName, FileMode.OpenOrCreate); var bw = new BinaryWriter(fs); bw.Write(attachementModel.Attachment, 0, attachementModel.Attachment.Length); bw.Close(); fs.Close(); Process.Start(Application.StartupPath + "\\Temp\\" + fileName); } catch (Exception ex) { XtraMessageBox.Show("打开出错!", "提示"); } }
private void btn_DownloadAttachment_Click(object sender, EventArgs e) { if(gv_Attachment.FocusedRowHandle<0) { XtraMessageBox.Show("当前未选中任何附件!", "提示"); return; } var attachmentId = Convert.ToInt32(gv_Attachment.GetFocusedRowCellValue("Id")); var attachmentName = gv_Attachment.GetFocusedRowCellValue("Name").ToString(); var saveFileDialog = new SaveFileDialog() {Filter = string.Format("*.{0}|*.{0}", Path.GetExtension(attachmentName)),FileName = attachmentName}; if(saveFileDialog.ShowDialog()==DialogResult.OK) { var eqptAttachmentBll = new EqptAttachment(); var eqptAttachmentModel = eqptAttachmentBll.GetModel(attachmentId); var fs = new FileStream(saveFileDialog.FileName, FileMode.OpenOrCreate); var bw = new BinaryWriter(fs); bw.Write(eqptAttachmentModel.Attachment, 0, eqptAttachmentModel.Attachment.Length); bw.Close(); fs.Close(); XtraMessageBox.Show("下载成功!", "提示"); } }