/// <summary> /// 根据职位ID获得用户 /// </summary> /// <param name="iPostID">职位ID</param> /// <returns></returns> public static ViewBase GetUserByPositionID(int iPostID) { ViewPostUser vwPostUser = new ViewPostUser(); vwPostUser.BaseCondition = iPostID > 0 ? "c.ID = " + iPostID.ToString() : "1<>1"; return vwPostUser; }
/// <summary> /// 根据职位找人,支持多个职位 /// </summary> /// <param name="sPostNames">职位名字 ","连接</param> /// <returns></returns> public static ViewBase GetUserByPosition(string sPostNames) { string[] strArray = sPostNames.Split(','); string strPosts = string.Empty; foreach (string str in strArray) { if (strPosts.Length > 0) { strPosts += ","; } strPosts += "'" + str + "'"; } ViewPostUser vwPostUser = new ViewPostUser(); vwPostUser.BaseCondition = sPostNames.Length > 0 ? "c.Name in (" + strPosts + ")" : "1<>1"; return vwPostUser; }