首页 > 编程开发 > Objective-C编程 >
-
WF动态挂单
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();
}
运行说明
在文本框中输入表明,用[,]分开,每多一个表,流程就会多一个逻辑结点
注意修改一下连接字串,以指定数据库
数据类型验证没有写,但类型分析已写完,只接加上就可以了
本文示例源代码或素材下载
工作流代码
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();
}
运行说明
在文本框中输入表明,用[,]分开,每多一个表,流程就会多一个逻辑结点
注意修改一下连接字串,以指定数据库
数据类型验证没有写,但类型分析已写完,只接加上就可以了
本文示例源代码或素材下载
