WF动态挂单(1)
WF与其他工作流框架不同，由于WF做为NET3.0的一部份发部，
这样使我们在设计WF应用时有更多的方案：
常用的有
1.使用服务器单一引擎处理所有客户端流程
2.每个客户端启动自己的业引擎，服务器从事数据保存与消息中转的工作
这些具体的应用，其他文章已经描述过，这里就不多说了；
本例的应用场景是第二种，
当然也可以很容易的改成第一种方式，数据交换用WebService,技巧就用[由一个WF项目说起]中我贴出的那段代码为基础。
要实现该例，要在数据库中建一些表，每张表代表一个具体的业务表单，表的个数、名称、结构任意，例子就是要动态挂单。
挂单类代码
using System;using System.Collections.Generic;using System.Text;namespace WFDataForm
{
class DynamicDataForm : System.Windows.Forms.Form
{
public string conString = ""; public string tabName; public DynamicDataForm(string db, string tabName) { this.conString = string.Format("data source=.;initial catalog={0};integrated security=true", db); this.tabName = tabName; InitializeComponent(); OperateData(); GetTabStruct(); ShowTabStruct(tabRow); ;
} private System.Windows.Forms.Panel dataPanel; private System.Windows.Forms.Button okButton; private System.Data.SqlClient.SqlConnection con; private System.Data.SqlClient.SqlCommand cmd_Select; private System.Data.SqlClient.SqlCommand cmd_Insert; System.Collections.Generic.List<TabField> tabRow = new List<TabField>(); private void InitializeComponent() { okButton = new System.Windows.Forms.Button(); okButton.Text = "完成"; okButton.Click += new EventHandler(okButton_Click); dataPanel = new System.Windows.Forms.Panel(); dataPanel.AutoScroll = true; dataPanel.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; dataPanel.Width = 400; dataPanel.Height = 200; dataPanel.Top = 30; this.Width = 410; this.Controls.Add(okButton); this.Controls.Add(dataPanel); } void okButton_Click(object sender, EventArgs e) { con.Open(); string s = GetInsetrString(tabRow); System.Console.WriteLine(s); cmd_Insert.CommandText = s; cmd_Insert.ExecuteNonQuery(); con.Close(); this.Close(); } private void OperateData() { con = new System.Data.SqlClient.SqlConnection(this.conString); cmd_Select = con.CreateCommand(); cmd_Select.CommandText = string.Format("select * from {0} where 1> 2", this.tabName); cmd_Insert = con.CreateCommand(); } private void GetTabStruct() { con.Open(); System.Data.SqlClient.SqlDataReader rd = cmd_Select.ExecuteReader(); for (int i = 0; i < rd.FieldCount; i++) { TabField f = new TabField(); f.fieldType = rd.GetFieldType(i); f.fieldName = rd.GetName(i); tabRow.Add(f); } rd.Close(); con.Close(); } private void ShowTabStruct(List<TabField> o) { int x = 120; int y = 30; int i = 0; foreach (TabField temp in o) { System.Windows.Forms.Label l = new System.Windows.Forms.Label(); l.Text = temp.fieldName; l.Top = y * i; System.Windows.Forms.TextBox t = new System.Windows.Forms.TextBox(); t.Left = x; t.Top = y * i; t.Tag = temp.fieldType; i = i + 1; this.dataPanel.Controls.Add(l); this.dataPanel.Controls.Add(t); } } private void GetData(List<TabField> o) { int i = 0; foreach (System.Windows.Forms.Control temp in this.dataPanel.Controls) { if (temp is System.Windows.Forms.TextBox) { tabRow[i].fieldValue = temp.Text; i = i + 1; } } } private string GetInsetrString(List<TabField> o) { GetData(o); string f = ""; string v = ""; foreach (TabField temp in o) { f = f + temp.fieldName + ","; if (temp.fieldType.ToString() == "System.Int32") { v = v + temp.fieldValue + ","; } else { v = v + "'" + temp.fieldValue + "'" + ","; } } f = DeleteRearwardSymbol(f); v = DeleteRearwardSymbol(v); string s = string.Format("insert into {0} ({1}) values ({2})", tabName, f, v); return s; } private string DeleteRearwardSymbol(string s) { string temp = s.Remove(s.Length - 1); return temp; } class TabField { public System.Type fieldType = null; public string fieldName = ""; public object fieldValue = null; } }
}工作流代码
namespace WFDataForm{ public sealed partial class Workflow1: SequentialWorkflowActivity { public Workflow1() { InitializeComponent(); } private string[] tab; private string tabs=""; public string Tabs { get { return tabs; } set { tabs = value; } } private bool whileTag=false; private int sp = 0; private void codeActivity1_ExecuteCode(object sender, EventArgs e) { if (sp < tab.Length) { new DynamicDataForm("a",tab[sp]).ShowDialog(); sp = sp + 1; } else { whileTag = true; } } private void codeActivity2_ExecuteCode(object sender, EventArgs e) { tab = tabs.Split(new char[] { ',' }); } }}引擎代码
private System.Workflow.Runtime.WorkflowRuntime wr; System.Workflow.Runtime.WorkflowInstance instance; private void button1_Click(object sender, EventArgs e) { Dictionary<string, object> parameters = new Dictionary<string, object>(); parameters.Add("Tabs",textBox1.Text); instance = wr.CreateWorkflow(typeof(WFDataForm.Workflow1), parameters); instance.Start(); } private void Form1_Load(object sender, EventArgs e) { wr = new System.Workflow.Runtime.WorkflowRuntime(); wr.StartRuntime(); wr.WorkflowCompleted += new EventHandler<System.Workflow.Runtime.WorkflowCompletedEventArgs>(wr_WorkflowCompleted); } void wr_WorkflowCompleted(object sender, System.Workflow.Runtime.WorkflowCompletedEventArgs e) { MessageBox.Show("完成"); } private void Form1_FormClosing(object sender, FormClosingEventArgs e) { wr.StopRuntime(); } private void button2_Click(object sender, EventArgs e) { instance.Resume(); }运行说明
在文本框中输入表明,用[,]分开,每多一个表,流程就会多一个逻辑结点
注意修改一下连接字串,以指定数据库
数据类型验证没有写,但类型分析已写完,只接加上就可以了
更多的扩展应用,在后面的文章中会展开了谈,本文全当热身
本例来自于[资料(2).rar]内容
本例代码https://files.cnblogs.com/foundation/WFDataForm.rar
