/// <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())); } }