Beispiel #1
0
        //--------------
        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));
        }