//-------------- public DataTable SelByRefer(int userID) { B_User userBll = new B_User(); M_UserInfo userModel = new M_UserInfo(); userModel = userBll.GetUserByUserID(userID); SqlParameter[] sp = new SqlParameter[] { new SqlParameter("UserID", "%," + userID + ",%"), new SqlParameter("GroupID", "%," + userModel.GroupID + ",%") }; return(SqlHelper.ExecuteTable(CommandType.Text, "Select * From " + strTableName + " Where ReferUser Like @UserID OR ReferGroup Like @GroupID", sp)); }