/// <summary>
/// 我可以处理当前的工作吗？
/// </summary>
/// <returns></returns>
public bool Can_I_Do_It()
{
/* 判断我是否可以处理当前点数据？ */
switch (this.HisDeliveryWay)
{
case DeliveryWay.ByPreviousNodeFormEmpsField:
NodeEmps ndemps = new NodeEmps(this.NodeID);
if (ndemps.Contains(NodeEmpAttr.FK_Emp, WebUser.No) == false)
{
return(false);
}
else
{
return(true);
}
case DeliveryWay.ByStation:
Stations sts = WebUser.HisStations;
string myStaStrs = "@";
foreach (Station st in sts)
{
myStaStrs += "@" + st.No;
}
myStaStrs = myStaStrs + "@";
NodeStations ndeStas = new NodeStations(this.NodeID);
bool isHave = false;
foreach (NodeStation ndS in ndeStas)
{
if (myStaStrs.Contains("@" + ndS.FK_Station + "@") == true)
{
isHave = true;
break;
}
}
if (isHave == false)
{
return(false);
}
return(true);
default: /* 其它的情况则不与判断。*/
// jc.Delete(); // 设置是非法的，直接删除。
return(false);
break;
}
}
/// <summary>
/// 自动计算未来处理人（该方法在发送成功后执行.）
/// </summary>
/// <param name="CurrWorkNode">当前的节点</param>
/// <param name="nd"></param>
/// <param name="toND"></param>
public FullSA(WorkNode currWorkNode)
{
//如果当前不需要计算未来处理人.
if (currWorkNode.HisFlow.IsFullSA == false &&
currWorkNode.IsSkip == false)
{
return;
}
//如果到达最后一个节点，就不处理了。
if (currWorkNode.HisNode.IsEndNode)
{
return;
}
//初始化一些变量.
this.HisCurrWorkNode = currWorkNode;
Node currND = currWorkNode.HisNode;
Int64 workid = currWorkNode.HisWork.OID;
//查询出来所有的节点.
Nodes nds = new Nodes(this.HisCurrWorkNode.HisFlow.No);
// 开始节点需要特殊处理》
/* 如果启用了要计算未来的处理人 */
SelectAccper sa = new SelectAccper();
//首先要清除以前的计算，重新计算。
sa.Delete(SelectAccperAttr.WorkID, workid);
//求出已经路过的节点.
DataTable dt = DBAccess.RunSQLReturnTable("SELECT FK_Node FROM WF_GenerWorkerList WHERE WorkID=" + BP.Sys.SystemConfig.AppCenterDBVarStr + "WorkID", "WorkID", workid);
string passedNodeIDs = "";
foreach (DataRow item in dt.Rows)
{
passedNodeIDs += item[0].ToString() + ",";
}
//遍历当前的节点。
foreach (Node item in nds)
{
if (item.IsStartNode == true)
{
continue;
}
//如果已经包含了，就说明该节点已经经过了，就不处理了。
if (passedNodeIDs.Contains(item.NodeID + ",") == true)
{
continue;
}
//如果按照岗位计算（默认的第一个规则.）
if (item.HisDeliveryWay == DeliveryWay.ByStation)
{
string sql = "SELECT No, Name FROM Port_Emp WHERE No IN (SELECT A.FK_Emp FROM " + BP.WF.Glo.EmpStation + " A, WF_NodeStation B WHERE A.FK_Station=B.FK_Station AND B.FK_Node=" + item.NodeID + ")";
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
if (dt.Rows.Count != 1)
{
continue;
}
string no = dt.Rows[0][0].ToString();
string name = dt.Rows[0][1].ToString();
// sa.Delete(SelectAccperAttr.FK_Node,item.NodeID, SelectAccperAttr.WorkID, workid); //删除已经存在的数据.
sa.FK_Emp = no;
sa.EmpName = name;
sa.FK_Node = item.NodeID;
sa.WorkID = workid;
sa.Info = "无";
sa.AccType = 0;
sa.ResetPK();
if (sa.IsExits)
{
continue;
}
//计算接受任务时间与应该完成任务时间.
InitDT(sa, item);
sa.Insert();
continue;
}
//处理与指定节点相同的人员.
if (item.HisDeliveryWay == DeliveryWay.BySpecNodeEmp &&
item.DeliveryParas == currND.NodeID.ToString())
{
sa.FK_Emp = WebUser.No;
sa.FK_Node = item.NodeID;
sa.WorkID = workid;
sa.Info = "无";
sa.AccType = 0;
sa.EmpName = WebUser.Name;
sa.ResetPK();
if (sa.IsExits)
{
continue;
}
//计算接受任务时间与应该完成任务时间.
InitDT(sa, item);
sa.Insert();
continue;
}
//处理绑定的节点人员..
if (item.HisDeliveryWay == DeliveryWay.ByBindEmp)
{
NodeEmps nes = new NodeEmps();
nes.Retrieve(NodeEmpAttr.FK_Node, item.NodeID);
foreach (NodeEmp ne in nes)
{
sa.FK_Emp = ne.FK_Emp;
sa.FK_Node = item.NodeID;
sa.WorkID = workid;
sa.Info = "无";
sa.AccType = 0;
sa.EmpName = ne.FK_EmpT;
sa.ResetPK();
if (sa.IsExits)
{
continue;
}
//计算接受任务时间与应该完成任务时间.
InitDT(sa, item);
sa.Insert();
}
}
//按照节点的 岗位与部门的交集计算.
#region 部门与岗位的交集计算.
if (item.HisDeliveryWay == DeliveryWay.ByDeptAndStation)
{
string dbStr = BP.Sys.SystemConfig.AppCenterDBVarStr;
string sql = string.Empty;
//added by liuxc,2015.6.30.
//区别集成与BPM模式
if (BP.WF.Glo.OSModel == BP.Sys.OSModel.OneOne)
{
sql = "SELECT No FROM Port_Emp WHERE No IN ";
sql += "(SELECT No as FK_Emp FROM Port_Emp WHERE FK_Dept IN ";
sql += "( SELECT FK_Dept FROM WF_NodeDept WHERE FK_Node=" + dbStr + "FK_Node1)";
sql += ")";
sql += "AND No IN ";
sql += "(";
sql += "SELECT FK_Emp FROM " + BP.WF.Glo.EmpStation + " WHERE FK_Station IN ";
sql += "( SELECT FK_Station FROM WF_NodeStation WHERE FK_Node=" + dbStr + "FK_Node1 )";
sql += ") ORDER BY No ";
Paras ps = new Paras();
ps.Add("FK_Node1", item.NodeID);
ps.Add("FK_Node2", item.NodeID);
ps.SQL = sql;
dt = DBAccess.RunSQLReturnTable(ps);
}
else
{
sql = "SELECT pdes.FK_Emp AS No"
+ " FROM Port_DeptEmpStation pdes"
+ " INNER JOIN WF_NodeDept wnd"
+ " ON wnd.FK_Dept = pdes.FK_Dept"
+ " AND wnd.FK_Node = " + item.NodeID
+ " INNER JOIN WF_NodeStation wns"
+ " ON wns.FK_Station = pdes.FK_Station"
+ " AND wnd.FK_Node =" + item.NodeID
+ " ORDER BY"
+ " pdes.FK_Emp";
dt = DBAccess.RunSQLReturnTable(sql);
}
foreach (DataRow dr in dt.Rows)
{
Emp emp = new Emp(dr[0].ToString());
sa.FK_Emp = emp.No;
sa.FK_Node = item.NodeID;
sa.DeptName = emp.FK_DeptText;
sa.WorkID = workid;
sa.Info = "无";
sa.AccType = 0;
sa.EmpName = emp.Name;
sa.ResetPK();
if (sa.IsExits)
{
continue;
}
//计算接受任务时间与应该完成任务时间.
InitDT(sa, item);
sa.Insert();
}
}
#endregion 部门与岗位的交集计算.
}
//预制当前节点到达节点的数据。
Nodes toNDs = currND.HisToNodes;
foreach (Node item in toNDs)
{
if (item.HisDeliveryWay == DeliveryWay.ByStation || item.HisDeliveryWay == DeliveryWay.FindSpecDeptEmpsInStationlist)
{
/*如果按照岗位访问*/
#region 最后判断 - 按照岗位来执行。
string dbStr = BP.Sys.SystemConfig.AppCenterDBVarStr;
string sql = "";
Paras ps = new Paras();
/* 如果执行节点 与 接受节点岗位集合不一致 */
/* 没有查询到的情况下, 先按照本部门计算。*/
if (this.HisCurrWorkNode.HisFlow.FlowAppType == FlowAppType.Normal)
{
switch (BP.Sys.SystemConfig.AppCenterDBType)
{
case DBType.MySQL:
case DBType.MSSQL:
if (Glo.OSModel == Sys.OSModel.OneOne)
{
sql = "select x.No from Port_Emp x inner join (select FK_Emp from " + BP.WF.Glo.EmpStation + " a inner join WF_NodeStation b ";
sql += " on a.FK_Station=b.FK_Station where FK_Node=" + dbStr + "FK_Node) as y on x.No=y.FK_Emp inner join Port_Emp z on";
sql += " x.No=z.No where z.FK_Dept =" + dbStr + "FK_Dept order by x.No";
}
else
{
sql = "select x.No from Port_Emp x inner join (select FK_Emp from " + BP.WF.Glo.EmpStation + " a inner join WF_NodeStation b ";
sql += " on a.FK_Station=b.FK_Station where FK_Node=" + dbStr + "FK_Node) as y on x.No=y.FK_Emp inner join Port_DeptEmp z on";
sql += " x.No=z.FK_Emp where z.FK_Dept =" + dbStr + "FK_Dept order by x.No";
}
break;
default:
if (Glo.OSModel == Sys.OSModel.OneOne)
{
sql = "SELECT No FROM Port_Emp WHERE NO IN "
+ "(SELECT FK_Emp FROM " + BP.WF.Glo.EmpStation + " WHERE FK_Station IN (SELECT FK_Station FROM WF_NodeStation WHERE FK_Node=" + dbStr + "FK_Node) )"
+ " AND NO IN "
+ "(SELECT No as FK_Emp FROM Port_Emp WHERE FK_Dept =" + dbStr + "FK_Dept)";
sql += " ORDER BY No ";
}
else
{
sql = "SELECT No FROM Port_Emp WHERE NO IN "
+ "(SELECT FK_Emp FROM " + BP.WF.Glo.EmpStation + " WHERE FK_Station IN (SELECT FK_Station FROM WF_NodeStation WHERE FK_Node=" + dbStr + "FK_Node) )"
+ " AND NO IN "
+ "(SELECT FK_Emp FROM Port_DeptEmp WHERE FK_Dept =" + dbStr + "FK_Dept)";
sql += " ORDER BY No ";
}
break;
}
ps = new Paras();
ps.SQL = sql;
ps.Add("FK_Node", item.NodeID);
ps.Add("FK_Dept", WebUser.FK_Dept);
}
dt = DBAccess.RunSQLReturnTable(ps);
foreach (DataRow dr in dt.Rows)
{
Emp emp = new Emp(dr[0].ToString());
sa.FK_Emp = emp.No;
sa.FK_Node = item.NodeID;
sa.DeptName = emp.FK_DeptText;
sa.WorkID = workid;
sa.Info = "无";
sa.AccType = 0;
sa.EmpName = emp.Name;
sa.ResetPK();
if (sa.IsExits)
{
continue;
}
//计算接受任务时间与应该完成任务时间.
InitDT(sa, item);
sa.Insert();
}
#endregion 照岗位来执行。
}
}
}