private void AddExtensionToFileFormatTable(string ext, docDB.FileFormatDataTable ffTable)
{
if (obe == null)
{
obe = AtMng.GetCodeTableBE("FileFormat");
obe.Load();
}
CodesDB.FileFormatRow ffRow = (CodesDB.FileFormatRow)obe.Add(null);
ffRow.AllowEdit = false;
ffRow.AllowPreview = false;
ffRow.AllowSearch = true;
ffRow.AllowUpload = true;
ffRow.FileDescEng = "Lotus Notes Import";
ffRow.FileDescFre = "Lotus Notes Import";
ffRow.FileFormat = ext;
ffRow.IsBinary = false;
ffRow.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(obe);
bp.Update();
ffTable.ImportRow(ffRow);
}
private void gridEX1_RowDoubleClick(object sender, RowActionEventArgs e)
{
try
{
uiPanel2.Closed = true;
if (gridEX1.GetRow().RowType == RowType.Record)
{
string TblName;
DataRow dr = (DataRow)((DataRowView)gridEX1.GetRow().DataRow).Row;
TblName = (string)dr["TableName"];
uiPanel1.Text = TblName;
for (int i = cGridEX.RootTable.Columns.Count - 1; i >= 0; i--)
{
cGridEX.RootTable.Columns.Remove(cGridEX.RootTable.Columns[i]);
}
obe = AtMng.GetCodeTableBE(TblName);
obe.Load();
cGridEX.DataSource = obe.myDT;
int y = 0;
for (int i = 0; obe.myDT.Columns.Count > i; i++)
{
if ((obe.myDT.Columns[i].ColumnName == "entryUser") ||
(obe.myDT.Columns[i].ColumnName == "entryDate") ||
(obe.myDT.Columns[i].ColumnName == "updateUser") ||
(obe.myDT.Columns[i].ColumnName == "updateDate") ||
(obe.myDT.Columns[i].ColumnName == "ts"))
{
}
else
{
if (cGridEX.RootTable.Columns.Count > i)
{
}
else
{
cGridEX.RootTable.Columns.Add();
}
cGridEX.RootTable.Columns[y].DataMember = obe.myDT.Columns[i].ColumnName;
cGridEX.RootTable.Columns[y].Key = obe.myDT.Columns[i].ColumnName;
cGridEX.RootTable.Columns[y].AutoSizeMode = ColumnAutoSizeMode.AllCellsAndHeader;
if (obe.myDT.Columns[i].DataType == System.Type.GetType("System.Boolean"))
{
cGridEX.RootTable.Columns[y].ColumnType = ColumnType.CheckBox;
cGridEX.RootTable.Columns[y].EditType = EditType.CheckBox;
}
if (TblName == "AccountType")
{
switch (i)
{
case 1:
cGridEX.RootTable.Columns[y].Caption = "Code";
break;
case 2:
cGridEX.RootTable.Columns[y].Caption = "Desc Eng";
break;
case 3:
cGridEX.RootTable.Columns[y].Caption = "Desc Fre";
break;
default:
cGridEX.RootTable.Columns[y].Caption = obe.myDT.Columns[i].ColumnName;
break;
}
}
else
{
cGridEX.RootTable.Columns[y].Caption = obe.myDT.Columns[i].ColumnName;
if (obe.myDT.Columns[i].ColumnName == "WFBGColor")
{
cGridEX.RootTable.Columns[y].Selectable = false;
uiPanel2.Closed = false;
cGridEX.RootTable.Columns.Add("BGColor");
}
}
y++;
}
}
cGridEX.RootTable.SortKeys.Add(cGridEX.RootTable.Columns[0], Janus.Windows.GridEX.SortOrder.Ascending);
if (cGridEX.RootTable.Columns.Contains("Obsolete"))
{
Janus.Windows.GridEX.GridEXFormatCondition gfc2 = new GridEXFormatCondition(cGridEX.RootTable.Columns["Obsolete"], ConditionOperator.Equal, true);
Janus.Windows.GridEX.GridEXFormatStyle gfs2 = new GridEXFormatStyle();
gfs2.FontStrikeout = TriState.True;
gfc2.FormatStyle = gfs2;
cGridEX.RootTable.FormatConditions.Add(gfc2);
}
if (cGridEX.RootTable.Columns.Contains("ReadOnly"))
{
Janus.Windows.GridEX.GridEXFormatCondition gfc = new GridEXFormatCondition(cGridEX.RootTable.Columns["ReadOnly"], ConditionOperator.Equal, true);
Janus.Windows.GridEX.GridEXFormatStyle gfs = new GridEXFormatStyle();
gfs.BackColor = Color.Gainsboro;
gfs.ForeColor = SystemColors.ControlDarkDark;
gfc.FormatStyle = gfs;
cGridEX.RootTable.FormatConditions.Add(gfc);
}
cGridEX.AutoSizeColumns();
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
