private void CreateRelations(IEnumerable newItems)
{
var items = _designer.Blocks;
foreach (ConnectionElement conEl in newItems)
{
//一些多余的连接，需要去除。
if (string.IsNullOrEmpty(conEl.From) || string.IsNullOrEmpty(conEl.To))
{
continue;
}
if (items.Find(conEl.From) == null || items.Find(conEl.To) == null)
{
continue;
}
var connection = new BlockRelation();
connection.DataContext = conEl;
SetBinding(connection, BlockRelation.FromBlockProperty, "From");
SetBinding(connection, BlockRelation.ToBlockProperty, "To");
SetBinding(connection, BlockRelation.LabelProperty, "Label");
SetBinding(connection, BlockRelation.ConnectionTypeProperty, "ConnectionType");
SetBinding(connection, BlockRelation.FromPointPosProperty, "FromPointPos");
SetBinding(connection, BlockRelation.ToPointPosProperty, "ToPointPos");
SetBinding(connection, BlockRelation.HiddenProperty, "Hidden");
SetBinding(connection, BlockRelation.LabelVisibilityProperty, "LabelVisible", _btvConverter);
_designer.Relations.Add(connection);
}
}
public RelationAddedEventArgs(BlockRelation relation)
{
this.Relation = relation;
}
private void _canvas_DragLineCompleted(object sender, CanvasDragLineCompletedEventArgs e)
{
var source = BlockControl.GetBlockControl(e.Source);
var sink = BlockControl.GetBlockControl(e.Sink);
var relation = new BlockRelation
{
FromBlock = source.TypeFullName,
ToBlock = sink.TypeFullName
};
this.Relations.Insert(0, relation);
this.OnRelationAdded(relation);
}
private void RemoveConnectionFromCanvas(BlockRelation con)
{
_canvas.Children.Remove(con.EngineControl);
}
private void AddConnectionIntoCanvas(BlockRelation relation)
{
var con = relation.CreateConnection();
ModelingDesigner.SetComponent(con, relation);
//从 0 开始添加，可以保证连接显示在元素之后。
_canvas.Children.Insert(0, con);
}
protected virtual void OnRelationAdded(BlockRelation relation)
{
var handler = this.RelationAdded;
if (handler != null) handler(this, new RelationAddedEventArgs(relation));
}
private void CreateRelations(IEnumerable newItems)
{
var items = _designer.Blocks;
foreach (ConnectionElement conEl in newItems)
{
//一些多余的连接，需要去除。
if (string.IsNullOrEmpty(conEl.From) || string.IsNullOrEmpty(conEl.To)) { continue; }
if (items.Find(conEl.From) == null || items.Find(conEl.To) == null) { continue; }
var connection = new BlockRelation();
connection.DataContext = conEl;
SetBinding(connection, BlockRelation.FromBlockProperty, "From");
SetBinding(connection, BlockRelation.ToBlockProperty, "To");
SetBinding(connection, BlockRelation.LabelProperty, "Label");
SetBinding(connection, BlockRelation.ConnectionTypeProperty, "ConnectionType");
SetBinding(connection, BlockRelation.FromPointPosProperty, "FromPointPos");
SetBinding(connection, BlockRelation.ToPointPosProperty, "ToPointPos");
SetBinding(connection, BlockRelation.HiddenProperty, "Hidden");
SetBinding(connection, BlockRelation.LabelVisibilityProperty, "LabelVisible", _btvConverter);
_designer.Relations.Add(connection);
}
}
static void Main(string[] args)
{
/*
* This example creates a master-detail form based on the dept and emp database tables owned by the user scott.
* The master contains the following fields: empno, ename, job, sal, and deptno.
* The detail contains the following fields deptno, dname, and loc.
* The join condition is deptno.
*/
// Create the form
var module = new FormModule("empdept");
// Create a window
var mywin = new Window(module, "MYWIN");
// Create a canvas and set canvas-related properties
var mycanvas = new Canvas(module, "MYCANVAS")
{
ViewportWidth = 512,
ViewportHeight = 403,
ViewportXPosition = 0,
ViewportYPosition = 0,
Width = 538,
Height = 403,
Window = mywin,
};
// Create Emp block and set block-related properties
var emp = new Block(module, "EMP")
{
IsDatabaseBlock = true,
QueryDataSourceType = QueryDataSourceType.Table,
QueryDataSourceName = "EMP",
DMLDataTargetType = DMLDataTargetType.Table,
DMLDataTargetName = "EMP"
};
// Create Dept block and set block-related properties
var dept = new Block(module, "DEPT")
{
IsDatabaseBlock = true,
QueryDataSourceType = QueryDataSourceType.Table,
QueryDataSourceName = "DEPT",
DMLDataTargetType = DMLDataTargetType.Table,
DMLDataTargetName = "DEPT"
};
// Create empno item and item-related properties
var empno = new Item(emp, "EMPNO")
{
ItemType = ItemType.TextItem,
IsEnabled = true,
IsKeyboardNavigable = true,
DataType = ItemDataType.Number,
MaximumLength = 6,
IsRequired = true,
DistanceBetweenRecords = 0,
IsDatabaseItem = true,
IsQueryAllowed = true,
QueryLength = 6,
IsUpdateAllowed = true,
IsVisible = true,
Canvas = mycanvas,
XPosition = 32,
YPosition = 50,
Width = 51,
Height = 17,
Bevel = Bevel.Lowered,
Hint = "Enter value for :EMPNO"
};
// Create Ename item and item-related properties
var ename = new Item(emp, "ENAME")
{
ItemType = ItemType.TextItem,
IsEnabled = true,
IsKeyboardNavigable = true,
DataType = ItemDataType.Char,
MaximumLength = 10,
DistanceBetweenRecords = 0,
IsDatabaseItem = true,
IsQueryAllowed = true,
QueryLength = 10,
IsUpdateAllowed = true,
IsVisible = true,
Canvas = mycanvas,
XPosition = 83,
YPosition = 50,
Width = 77,
Height = 17,
Bevel = Bevel.Lowered,
Hint = "Enter value for :ENAME"
};
// Create JOB item and item-related properties
var job = new Item(emp, "JOB")
{
ItemType = ItemType.TextItem,
IsEnabled = true,
IsKeyboardNavigable = true,
DataType = ItemDataType.Char,
MaximumLength = 9,
DistanceBetweenRecords = 0,
IsDatabaseItem = true,
IsQueryAllowed = true,
QueryLength = 9,
IsUpdateAllowed = true,
IsVisible = true,
Canvas = mycanvas,
XPosition = 160,
YPosition = 50,
Width = 70,
Height = 17,
Bevel = Bevel.Lowered,
Hint = "Enter value for :JOB"
};
// Create SALARY item and item-related properties
var sal = new Item(emp, "SAL")
{
ItemType = ItemType.TextItem,
IsEnabled = true,
IsKeyboardNavigable = true,
DataType = ItemDataType.Number,
MaximumLength = 9,
DistanceBetweenRecords = 0,
IsDatabaseItem = true,
IsQueryAllowed = true,
QueryLength = 9,
IsUpdateAllowed = true,
IsVisible = true,
Canvas = mycanvas,
XPosition = 352,
YPosition = 50,
Width = 70,
Height = 17,
Bevel = Bevel.Lowered,
Hint = "Enter value for :SAL"
};
// Create DEPTNO item and item-related properties
var deptnoEmp = new Item(emp, "DEPTNO")
{
ItemType = ItemType.TextItem,
IsEnabled = true,
IsKeyboardNavigable = true,
DataType = ItemDataType.Number,
MaximumLength = 4,
DistanceBetweenRecords = 0,
IsDatabaseItem = true,
IsQueryAllowed = true,
QueryLength = 4,
IsUpdateAllowed = true,
IsVisible = true,
Canvas = mycanvas,
XPosition = 493,
YPosition = 50,
Width = 30,
Height = 17,
Bevel = Bevel.Lowered,
Hint = "Enter value for :DEPTNO"
};
// Create DEPTNO item and item-related properties
var deptnoDept = new Item(dept, "DEPTNO")
{
ItemType = ItemType.TextItem,
IsEnabled = true,
IsKeyboardNavigable = true,
DataType = ItemDataType.Number,
MaximumLength = 4,
DistanceBetweenRecords = 0,
IsDatabaseItem = true,
IsQueryAllowed = true,
QueryLength = 4,
IsUpdateAllowed = true,
IsVisible = true,
Canvas = mycanvas,
XPosition = 32,
YPosition = 151,
Width = 38,
Height = 17,
Bevel = Bevel.Lowered,
Hint = "Enter value for :DEPTNO"
};
// Create DNAME item and item-related properties
var dname = new Item(dept, "DNAME")
{
ItemType = ItemType.TextItem,
IsEnabled = true,
IsKeyboardNavigable = true,
DataType = ItemDataType.Char,
MaximumLength = 14,
DistanceBetweenRecords = 0,
IsDatabaseItem = true,
IsQueryAllowed = true,
QueryLength = 14,
IsUpdateAllowed = true,
IsVisible = true,
Canvas = mycanvas,
XPosition = 70,
YPosition = 151,
Width = 102,
Height = 17,
Bevel = Bevel.Lowered,
Hint = "Enter value for :DNAME"
};
// Create LOC item and item-related properties
var loc = new Item(dept, "LOC")
{
ItemType = ItemType.TextItem,
IsEnabled = true,
IsKeyboardNavigable = true,
DataType = ItemDataType.Char,
MaximumLength = 13,
DistanceBetweenRecords = 0,
IsDatabaseItem = true,
IsQueryAllowed = true,
QueryLength = 14,
IsUpdateAllowed = true,
IsVisible = true,
Canvas = mycanvas,
XPosition = 173,
YPosition = 151,
Width = 96,
Height = 17,
Bevel = Bevel.Lowered,
Hint = "Enter value for :LOC"
};
// Create Relations and relations-related properties
var relation = new BlockRelation(dept, "DEPT_EMP")
{
DetailBlock = "EMP",
DeleteRecordBehavior = DeleteRecordBehavior.NonIsolated,
IsDeferred = false,
AutomaticQuery = false,
PreventMasterlessOperations = false,
JoinCondition = "DEPTNO"
};
relation.Generate();
module.Save();
}
