/// <summary>
/// 获取当前处理人集合
/// </summary>
/// <param name="wfaID">WF_APP表主键,工作流实例的主键</param>
/// <returns></returns>
public IList <EAS_ACCOUNTS> GETCurrentStepHandleUser(string wfaID)
{
IList <EAS_ACCOUNTS> list = null;
EAS_ACCOUNTS acc = null;
StringBuilder stb = new StringBuilder();
stb.Append("WHERE LOGINID IN (");
stb.Append(" SELECT OBJECTVALUE");
stb.Append(" FROM WF_APP_HANDLE");
stb.Append(" WHERE WFA_ID='" + wfaID + "'");
stb.Append(" AND OBJECTTYPE='SingleUser'");
stb.Append(" AND Current_STEP_ID=");
stb.Append(" (");
stb.Append(" SELECT Current_STEP_ID");
stb.Append(" FROM WF_DETAIL");
stb.Append(" WHERE WFA_ID='" + wfaID + "'");
stb.Append(" AND (COMPLEMENTDATE='' or COMPLEMENTDATE is null)");
stb.Append(" AND IS_Through<>'Y'");
stb.Append(" )");
stb.Append(" )");
DataTable dt = CommonFuns.getDataTableBySql("LOGINID,NAME", stb.ToString(), "EAS_ACCOUNTS");
if (dt == null && dt.Rows.Count == 0)
{
return(null);
}
else
{
list = new List <EAS_ACCOUNTS>();
foreach (DataRow dr in dt.Rows)
{
acc = new EAS_ACCOUNTS();
acc.LOGINID = dr["LOGINID"].ToString();
acc.NAME = dr["NAME"].ToString();
list.Add(acc);
}
return(list);
}
}
/// <summary>
/// 获取当前处理人集合
/// </summary>
/// <param name="wfaID">WF_APP表主键,工作流实例的主键</param>
/// <returns></returns>
public IList<EAS_ACCOUNTS> GETCurrentStepHandleUser(string wfaID)
{
IList<EAS_ACCOUNTS> list = null;
EAS_ACCOUNTS acc = null;
StringBuilder stb = new StringBuilder();
stb.Append("WHERE LOGINID IN (");
stb.Append(" SELECT OBJECTVALUE");
stb.Append(" FROM WF_APP_HANDLE");
stb.Append(" WHERE WFA_ID='" + wfaID + "'");
stb.Append(" AND OBJECTTYPE='SingleUser'");
stb.Append(" AND Current_STEP_ID=");
stb.Append(" (");
stb.Append(" SELECT Current_STEP_ID");
stb.Append(" FROM WF_DETAIL");
stb.Append(" WHERE WFA_ID='" + wfaID + "'");
stb.Append(" AND (COMPLEMENTDATE='' or COMPLEMENTDATE is null)");
stb.Append(" AND IS_Through<>'Y'");
stb.Append(" )");
stb.Append(" )");
DataTable dt = CommonFuns.getDataTableBySql("LOGINID,NAME", stb.ToString(), "EAS_ACCOUNTS");
if (dt == null && dt.Rows.Count == 0)
{
return null;
}
else
{
list = new List<EAS_ACCOUNTS>();
foreach (DataRow dr in dt.Rows)
{
acc = new EAS_ACCOUNTS();
acc.LOGINID = dr["LOGINID"].ToString();
acc.NAME = dr["NAME"].ToString();
list.Add(acc);
}
return list;
}
}
