public fDocView(DocManager dm, lmDatasets.docDB.DocumentRow dr) { InitializeComponent(); if (dr == null) { Close(); return; } this.Text = String.Format(Properties.Resources.AppDocViewer, dm.AtMng.AppMan.AppName); ucDocView1.Init(dm); ucDocView1.ActionToolbarView = UserControls.DocCommandBar.Hide; ucDocView1.Datasource = new DataView(dr.Table, "Docid=" + dr.DocId.ToString(), "", DataViewRowState.CurrentRows); }
public fDoc(DocManager dm, lmDatasets.docDB.DocumentRow dr) { InitializeComponent(); if (dr == null) { Close(); return; } this.Text = String.Format(Properties.Resources.AppDocViewer, dm.AtMng.AppMan.AppName); ucDoc1.Init(dm); ucDoc1.AllowActionToolbar = false; //ucDoc1.AllowUserCompose = false; //ucDoc1.ReadOnly(true); ucDoc1.Datasource = new DataView(dr.Table, "Docid=" + dr.DocId.ToString(), "", DataViewRowState.CurrentRows); }
private void uiCommandManager1_CommandClick(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e) { try { switch (e.Command.Key) { case "cmdSave": if (this.folderBrowserDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string path = this.folderBrowserDialog1.SelectedPath; DataSet ds = (DataSet)bindingSource1.DataSource; atriumBE.DocManager dm = this.AtMng.GetFile().GetDocMng(); foreach (DataRow dr in ds.Tables[0].Rows) { int docrefid = (int)dr["DocRefId"]; int docid = (int)dr["DocId"]; string version = (string)dr["CurrentVersion"]; lmDatasets.docDB.DocumentRow docr = dm.GetDocument().Load(docid); docr.efSubject = dr["FullFileNumber"].ToString() + " " + docr.efSubject; dm.GetDocContent().Load(docrefid, version); dm.GetDocument().Export(docr, false, path); dm.DB.DocContent.Clear(); dm.DB.DocContent.AcceptChanges(); } } break; case "cmdExecute": try { ebMessage.Text = "Executing...Please Wait"; ebCount.Text = ""; string sSQL = ebSQL.Text; if (ebSQL.SelectedText.Length > 0) { sSQL = ebSQL.SelectedText; } if (sSQL == "") { ebMessage.Text = "No query to execute"; ebCount.Text = ""; return; } DataSet ds = AtMng.AppMan.ExecuteDatasetSQL(sSQL); bindingSource1.DataSource = ds; gridEX1.DataSource = ds; gridEX1.RetrieveStructure(true); foreach (Janus.Windows.GridEX.GridEXColumn gc in gridEX1.Tables[1].Columns) { gc.EditType = Janus.Windows.GridEX.EditType.NoEdit; if (gc.DataTypeCode == TypeCode.DateTime) { gc.FormatString = "g"; } } ebMessage.Text = "Done"; if (ds.Tables.Count > 0) { ebCount.Text = ds.Tables[0].Rows.Count.ToString(); gridEX1.ExpandRecords(); } } catch (Exception x) { ebMessage.Text = "Error: " + x.Message; ebCount.Text = ""; UIHelper.HandleUIException(x); } break; case "cmdSaveExcel": this.saveFileDialog1.ShowDialog(); string file3 = this.saveFileDialog1.FileName; if (file3 == "") { return; } Janus.Windows.GridEX.Export.GridEXExporter oExport = new Janus.Windows.GridEX.Export.GridEXExporter(); oExport.GridEX = gridEX1; oExport.ExportMode = Janus.Windows.GridEX.ExportMode.AllRows; oExport.IncludeChildTables = true; oExport.IncludeCollapsedRows = true; oExport.IncludeExcelProcessingInstruction = true; oExport.IncludeFormatStyle = true; oExport.IncludeHeaders = true; System.IO.FileStream LayoutStream = new System.IO.FileStream(file3, System.IO.FileMode.Create, System.IO.FileAccess.ReadWrite, System.IO.FileShare.ReadWrite); oExport.Export(LayoutStream); LayoutStream.Close(); break; } } catch (Exception x) { UIHelper.HandleUIException(x); } }