/// <summary>
/// 创建WorkID
/// </summary>
/// <param name="flowNo">流程编号</param>
/// <param name="ht">表单参数，可以为null。</param>
/// <param name="workDtls">明细表参数，可以为null。</param>
/// <param name="starter">流程的发起人</param>
/// <param name="title">创建工作时的标题，如果为null，就按设置的规则生成。</param>
/// <param name="parentWorkID">父流程的WorkID,如果没有父流程就传入为0.</param>
/// <param name="parentFlowNo">父流程的流程编号,如果没有父流程就传入为null.</param>
/// <returns>为开始节点创建工作后产生的WorkID.</returns>
public static Int64 Node_CreateBlankWork(string flowNo, Hashtable ht, DataSet workDtls,
string guestNo, string title, Int64 parentWorkID, string parentFlowNo, int parentNodeID, string parentEmp)
{
//if (BP.Web.WebUser.No != "Guest")
// throw new Exception("@必须是Guest登陆才能发起.");
string dbstr = SystemConfig.AppCenterDBVarStr;
Flow fl = new Flow(flowNo);
Node nd = new Node(fl.StartNodeID);
//把一些其他的参数也增加里面去,传递给ccflow.
Hashtable htPara = new Hashtable();
if (parentWorkID != 0)
{
htPara.Add(StartFlowParaNameList.PWorkID, parentWorkID);
}
if (parentFlowNo != null)
{
htPara.Add(StartFlowParaNameList.PFlowNo, parentFlowNo);
}
if (parentNodeID != 0)
{
htPara.Add(StartFlowParaNameList.PNodeID, parentNodeID);
}
if (parentEmp != null)
{
htPara.Add(StartFlowParaNameList.PEmp, parentEmp);
}
Emp empStarter = new Emp(BP.Web.WebUser.No);
Work wk = fl.NewWork(empStarter, htPara);
Int64 workID = wk.OID;
#region 给各个属性-赋值
if (ht != null)
{
foreach (string str in ht.Keys)
{
wk.SetValByKey(str, ht[str]);
}
}
wk.OID = workID;
if (workDtls != null)
{
//保存从表
foreach (DataTable dt in workDtls.Tables)
{
foreach (MapDtl dtl in wk.HisMapDtls)
{
if (dt.TableName != dtl.No)
{
continue;
}
//获取dtls
GEDtls daDtls = new GEDtls(dtl.No);
daDtls.Delete(GEDtlAttr.RefPK, wk.OID); // 清除现有的数据.
GEDtl daDtl = daDtls.GetNewEntity as GEDtl;
daDtl.RefPK = wk.OID.ToString();
// 为从表复制数据.
foreach (DataRow dr in dt.Rows)
{
daDtl.ResetDefaultVal();
daDtl.RefPK = wk.OID.ToString();
//明细列.
foreach (DataColumn dc in dt.Columns)
{
//设置属性.
daDtl.SetValByKey(dc.ColumnName, dr[dc.ColumnName]);
}
daDtl.InsertAsOID(DBAccess.GenerOID("Dtl")); //插入数据.
}
}
}
}
#endregion 赋值
Paras ps = new Paras();
// 执行对报表的数据表WFState状态的更新,让它为runing的状态.
if (DataType.IsNullOrEmpty(title) == false)
{
ps = new Paras();
ps.SQL = "UPDATE " + fl.PTable + " SET WFState=" + dbstr + "WFState,Title=" + dbstr + "Title WHERE OID=" + dbstr + "OID";
ps.Add(GERptAttr.WFState, (int)WFState.Blank);
ps.Add(GERptAttr.Title, title);
ps.Add(GERptAttr.OID, wk.OID);
DBAccess.RunSQL(ps);
}
else
{
ps = new Paras();
ps.SQL = "UPDATE " + fl.PTable + " SET WFState=" + dbstr + "WFState,FK_Dept=" + dbstr + "FK_Dept,Title=" + dbstr + "Title WHERE OID=" + dbstr + "OID";
ps.Add(GERptAttr.WFState, (int)WFState.Blank);
ps.Add(GERptAttr.FK_Dept, empStarter.FK_Dept);
ps.Add(GERptAttr.Title, BP.WF.WorkFlowBuessRole.GenerTitle(fl, wk));
ps.Add(GERptAttr.OID, wk.OID);
DBAccess.RunSQL(ps);
}
// 删除有可能产生的垃圾数据,比如上一次没有发送成功，导致数据没有清除.
ps = new Paras();
ps.SQL = "DELETE FROM WF_GenerWorkFlow WHERE WorkID=" + dbstr + "WorkID1 OR FID=" + dbstr + "WorkID2";
ps.Add("WorkID1", wk.OID);
ps.Add("WorkID2", wk.OID);
DBAccess.RunSQL(ps);
ps = new Paras();
ps.SQL = "DELETE FROM WF_GenerWorkerList WHERE WorkID=" + dbstr + "WorkID1 OR FID=" + dbstr + "WorkID2";
ps.Add("WorkID1", wk.OID);
ps.Add("WorkID2", wk.OID);
DBAccess.RunSQL(ps);
// 设置流程信息
if (parentWorkID != 0)
{
BP.WF.Dev2Interface.SetParentInfo(flowNo, workID, parentWorkID);
}
#region 处理generworkid
// 设置父流程信息.
GenerWorkFlow gwf = new GenerWorkFlow();
gwf.WorkID = wk.OID;
int i = gwf.RetrieveFromDBSources();
//将流程信息提前写入wf_GenerWorkFlow,避免查询不到
gwf.FlowName = fl.Name;
gwf.FK_Flow = flowNo;
gwf.FK_FlowSort = fl.FK_FlowSort;
gwf.SysType = fl.SysType;
gwf.FK_Dept = WebUser.FK_Dept;
gwf.DeptName = WebUser.FK_DeptName;
gwf.FK_Node = fl.StartNodeID;
gwf.NodeName = nd.Name;
gwf.WFState = WFState.Runing;
if (DataType.IsNullOrEmpty(title))
{
gwf.Title = BP.WF.WorkFlowBuessRole.GenerTitle(fl, wk);
}
else
{
gwf.Title = title;
}
gwf.Starter = WebUser.No;
gwf.StarterName = WebUser.Name;
gwf.RDT = DataType.CurrentDataTimess;
gwf.PWorkID = parentWorkID;
// gwf.PFID = parentFID;
gwf.PFlowNo = parentFlowNo;
gwf.PNodeID = parentNodeID;
if (i == 0)
{
gwf.Insert();
}
else
{
gwf.Update();
}
//插入待办.
GenerWorkerList gwl = new GenerWorkerList();
gwl.WorkID = wk.OID;
gwl.FK_Node = nd.NodeID;
gwl.FK_Emp = WebUser.No;
i = gwl.RetrieveFromDBSources();
gwl.FK_EmpText = WebUser.Name;
gwl.FK_NodeText = nd.Name;
gwl.FID = 0;
gwl.FK_Flow = fl.No;
gwl.FK_Dept = WebUser.FK_Dept;
gwl.FK_DeptT = WebUser.FK_DeptName;
gwl.SDT = "无";
gwl.DTOfWarning = DataType.CurrentDataTime;
gwl.IsEnable = true;
gwl.IsPass = false;
gwl.PRI = gwf.PRI;
if (i == 0)
{
gwl.Insert();
}
else
{
gwl.Update();
}
#endregion
return(wk.OID);
}
