//public static ObjectBE GetBEFromTable(DataTable dt)
//{
// return (ObjectBE)dt.ExtendedProperties["BE"];
//}
/// <summary>
/// Initializes all event handlers for datatable events
/// </summary>
/// <param name="pDT">The datatable being managed</param>
private void Init()
{
if (myMngr.RuleHandler != null)
{
myDefinition = myMngr.RuleHandler.GetMyDefinition(myEntityName);
}
if (myDefinition != null)
{
foreach (lmDatasets.appDB.ddFieldRow dfr in myDefinition.GetddFieldRows())
{
columnMap.Add(dfr.FieldName, dfr);
if (dfr.FieldName != dfr.DBFieldName)
{
columnMap.Add(dfr.DBFieldName, dfr);
//the extended property is used by the template writerows function
myDT.Columns[dfr.DBFieldName].ExtendedProperties.Add("FieldName", dfr.FieldName);
}
}
}
//set reference so that BE objects can be pulled off datatables
myDT.ExtendedProperties.Add("BE", this);
//hook up events for data validation and business logic
myDT.RowChanging += new DataRowChangeEventHandler(RowChangingEventHandler);
myDT.RowChanged += new DataRowChangeEventHandler(RowChangedEventHandler);
myDT.RowDeleting += new DataRowChangeEventHandler(RowChangingEventHandler);
myDT.RowDeleted += new DataRowChangeEventHandler(RowChangedEventHandler);
if (this.IsColumnChangeMode)
{
myDT.ColumnChanging += new DataColumnChangeEventHandler(ColumnChangingEventHandler);
myDT.ColumnChanged += new DataColumnChangeEventHandler(ColumnChangedEventHandler);
}
}
private void uiCommandManager1_CommandClick(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e)
{
try
{
switch (e.Command.Key)
{
case "cmdCreateView":
string sql = AtMng.GetddTable().CreateSQLView(CurrentRowTable());
Clipboard.SetText(sql);
MessageBox.Show("SQL statement placed on clipboard");
break;
case "cmdRefreshReferences":
RefreshReferences();
break;
case "cmdPopulate":
Populate();
break;
case "cmdCancel":
Cancel();
break;
case "cmdSave":
Save();
break;
case "cmdExportToXML":
ExportToXml();
break;
case "cmdNewTable":
lmDatasets.appDB.ddTableRow dtr = (lmDatasets.appDB.ddTableRow)AtMng.GetddTable().Add(null);
ddTableGridEX.Find(ddTableGridEX.RootTable.Columns["TableName"], Janus.Windows.GridEX.ConditionOperator.Equal, "New Table", 0, 1);
ddTableGridEX.CurrentColumn = ddTableGridEX.RootTable.Columns["TableName"];
ddTableGridEX.EditMode = Janus.Windows.GridEX.EditMode.EditOn;
break;
case "cmdNewField":
if (CurrentRowTable() != null)
{
lmDatasets.appDB.ddFieldRow dfr = (lmDatasets.appDB.ddFieldRow)AtMng.GetddField().Add(CurrentRowTable());
ddFieldGridEX.Find(ddFieldGridEX.RootTable.Columns["FieldId"], Janus.Windows.GridEX.ConditionOperator.Equal, dfr.FieldId, 0, 1);
//ddFieldGridEX.CurrentColumn = ddFieldGridEX.RootTable.Columns["FieldName"];
//ddFieldGridEX.EditMode = Janus.Windows.GridEX.EditMode.EditOn;
}
else
{
MessageBox.Show("Please select a Table row before choosing to create a new field", "No Table Selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
private void CalculateRelatedFieldReferences(lmDatasets.appDB.ddTableRow ddtable)
{
if (!loadedReferences.ContainsKey(ddtable.TableId))
{
lmDatasets.appDB.ddFieldRow[] flds = (lmDatasets.appDB.ddFieldRow[])AtMng.DB.ddField.Select("TableId=" + ddtable.TableId);
foreach (lmDatasets.appDB.ddFieldRow ddfield in flds)
{
lmDatasets.ActivityConfig.ActivityFieldRow[] afrs = (lmDatasets.ActivityConfig.ActivityFieldRow[])AtMng.acMng.DB.ActivityField.Select("ObjectName='" + ddtable.TableName + "' and FieldName='" + ddfield.FieldName + "'");
foreach (lmDatasets.ActivityConfig.ActivityFieldRow afr in afrs)
{
lmDatasets.ActivityConfig.ACSeriesRow acr = AtMng.acMng.DB.ACSeries.FindByACSeriesId(afr.ACSeriesId);
string df = "";
if (!afr.IsDefaultValueNull())
{
df = afr.DefaultValue;
}
dtReferencedInSteps.Rows.Add(ddfield.FieldId, acr.StepCode, afr.TaskType, afr.ObjectAlias, afr.Step, afr.ActivityFieldID, acr.ActivityNameEng, acr.SeriesRow.SeriesCode, acr.SeriesRow.SeriesDescEng, acr.ACSeriesId, acr.SeriesId, df);
}
}
loadedReferences.Add(ddtable.TableId, ddtable);
}
}
private void uiCommandManager1_CommandClick(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e)
{
try
{
switch (e.Command.Key)
{
case "cmdPopulate":
Populate();
break;
case "cmdCancel":
Cancel();
break;
case "cmdSave":
Save();
break;
case "cmdExportToXML":
ExportToXml();
break;
case "cmdNew":
cmdNew1.Expand();
break;
case "cmdNewTable":
lmDatasets.appDB.ddTableRow dtr = (lmDatasets.appDB.ddTableRow)AtMng.GetddTable().Add(null);
ddTableGridEX.Find(ddTableGridEX.RootTable.Columns["TableName"], Janus.Windows.GridEX.ConditionOperator.Equal, "New Table", 0, 1);
ddTableGridEX.CurrentColumn = ddTableGridEX.RootTable.Columns["TableName"];
ddTableGridEX.EditMode = Janus.Windows.GridEX.EditMode.EditOn;
break;
case "cmdNewField":
if (CurrentRowTable() != null)
{
foreach (Janus.Windows.GridEX.GridEXRow gr in ddTableGridEX.GetRows())
{
if ((int)gr.Cells["TableId"].Value == CurrentRowTable().TableId)
{
ddTableGridEX.Row = gr.Position;
}
}
ddTableGridEX.CurrentRow.Expanded = true;
lmDatasets.appDB.ddFieldRow dfr = (lmDatasets.appDB.ddFieldRow)AtMng.GetddField().Add(CurrentRowTable());
foreach (Janus.Windows.GridEX.GridEXRow gr in ddTableGridEX.CurrentRow.GetChildRecords())
{
if ((int)gr.Cells["FieldId"].Value == dfr.FieldId)
{
ddTableGridEX.Row = gr.Position;
ddTableGridEX.CurrentColumn = ddTableGridEX.RootTable.ChildTables[0].Columns["FieldName"];
ddTableGridEX.EditMode = Janus.Windows.GridEX.EditMode.EditOn;
}
}
}
else
{
MessageBox.Show("Please select a Table row before choosing to create a new field", "No Table Selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
