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