private void btnCreate_Click(object sender, EventArgs e)
{
mdc = new MDataColumn();
mdc.Add("ID", SqlDbType.Int, true, false, 11, true, null);
mdc.Add("Name");
mdc.ToTable().Bind(dgvData);
}
private void ViewColumns()
{
using (MAction action = new MAction("Users"))//实例后就可以拿到表的结构了。
{
mdc = action.Data.Columns;
}
mdc.ToTable().Bind(dgvData);
}
protected override void Show(IDialogVisualizerService windowService, IVisualizerObjectProvider objectProvider)
{
MDataColumn mdc = objectProvider.GetObject() as MDataColumn;
if (mdc != null)
{
MDataTable dt = mdc.ToTable();
string title = string.Format("TableName : {0} Columns£º {1}", dt.TableName, mdc.Count);
FormCreate.BindTable(windowService, dt, title);
}
}
private void btnSetOrdinal_Click(object sender, EventArgs e)
{
//把第二位的列移前
mdc.SetOrdinal(mdc[1].ColumnName, 0);
if (mdc.Table != null && mdc.Table.Rows.Count > 1)
{
new MDataTable().Bind(dgvData);
MDataTable dt = mdc.Table.Clone();
dt.Bind(dgvData);
}
else
{
mdc.ToTable().Bind(dgvData);
}
}
public override void GetData(object target, System.IO.Stream outgoingData)
{
MDataTable dt = null;
#region 类型判断
if (target is MDataTable)
{
dt = target as MDataTable;
}
else if (target is MDataRow)
{
dt = ((MDataRow)target).ToTable();
}
else if (target is MDataColumn)
{
dt = ((MDataColumn)target).ToTable();
}
else if (target is MDataRowCollection)
{
dt = target as MDataRowCollection;
}
else if (target is DataRow)
{
MDataRow row = target as DataRow;
dt = row.ToTable();
}
else if (target is DataColumnCollection)
{
MDataColumn mdc = target as DataColumnCollection;
dt = mdc.ToTable();
}
else if (target is DataRowCollection)
{
MDataRowCollection rows = target as DataRowCollection;
dt = rows;
}
else if (target is NameObjectCollectionBase)
{
dt = MDataTable.CreateFrom(target as NameObjectCollectionBase);
}
else if (target is IEnumerable)
{
dt = MDataTable.CreateFrom(target as IEnumerable);
}
else
{
dt = MDataTable.CreateFrom(target);
if (dt == null)
{
MDataRow row = MDataRow.CreateFrom(target);
if (row != null)
{
dt = row.ToTable();
}
}
}
#endregion
dt = Format(dt);
if (dt != null)
{
base.GetData(dt.ToDataTable(), outgoingData);
}
else
{
base.GetData(new DataTable("Empty Table"), outgoingData);
}
}
