/// <summary>
/// 清除输出表格数据
/// </summary>
public void ClearOutputDataTableData()
{
var tableVariables = this.OfType <ActionTableVariable>();
foreach (var v in tableVariables)
{
if (v.Direction == Models.VariableDirection.Output)
{
ActionTableVariable t = v as ActionTableVariable;
DataTable dt = t.Data as DataTable;
if (dt != null)
{
dt.Clear();
}
}
}
}
/// <summary>
/// 导入数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataSourceBtn_Click(object sender, EventArgs e)
{
DTSWizardBook wizard = new DTSWizardBook();
DataTable dt = wizard.Import();
if (dt != null)
{
if (Action is ActionTableVariable)
{
ActionTableVariable tableVariable = Action as ActionTableVariable;
tableVariable.Data = dt;
}
else if (Action is ActionArrayVariable)
{
ActionArrayVariable arr = Action as ActionArrayVariable;
arr.Data = TableToList(dt);
}
}
}
private void CustomBind()
{
ActionTableVariable variable = Context.ActionModel.VariableActionModel.OfType <ActionTableVariable>().FirstOrDefault(c => c.Name == toolStripComboBox1.Text);
DataTable sourceTable = variable.Data as DataTable;
if (sourceTable == null)
{
return;
}
listView1.Clear();
foreach (DataColumn c in sourceTable.Columns)
{
listView1.Columns.Add(c.ColumnName);
}
int maxRow = sourceTable.Rows.Count > 30 ? 30 : sourceTable.Rows.Count;
for (int i = 0; i < maxRow; i++)
{
listView1.Items.Add(new ListViewItem(sourceTable.Rows[i].ItemArray.Select(c => c == null ? "" : c.ToString()).ToArray()));
}
}
