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);
}
}
