/// <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; } }