everyone.cs

这个是个未完成品 演示地址：http://www.yyzyq.com 仅以此例给正在学习编程爱好.net的朋友 希望能给大家带来帮助

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Everyone 的摘要说明
/// </summary>
public class Everyone:SqlDataBase
{
	public Everyone()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    
    /// <summary>
    /// 返回游客视图
    /// </summary>
    /// <returns></returns>
    public DataView DvEveryone()
    {
        return GetDv("select * from everyone");
    }

    /// <summary>
    /// 添加游客用户
    /// </summary>
    /// <returns></returns>
    public bool AddEveryone(string strId,string strUrl)
    {
        string strSql = "insert into everyone (name,url)values('" + strId + "','"+strUrl+"')";
        string strSql2 = "select count(id) from everyone where name='" + strId + "'";
        try
        {
            if(RunSqlReturn(strSql2) == "0")
                RunSql(strSql);
            return true;
        }
        catch { return false; }
    }

    /// <summary>
    /// 更新登陆时间
    /// </summary>
    /// <param name="strId">SessionId</param>
    /// <returns></returns>
    public bool ChangeLoginDate(string strId,string strUrl)
    {
        string strSql = "update everyone set logindate ='" + DateTime.Now.ToString() + "',url='"+strUrl+"' where name='" + strId + "'";
        try
        {
            RunSql(strSql);
            return true;
        }
        catch { return false; }
    }

    /// <summary>
    /// 更新用户在线状态
    /// </summary>
    /// <returns></returns>
    public bool ChangeEveryoneOnline()
    {
        string strSql = "delete everyone where logindate < GetDate()-0.014";
        try
        {
            RunSql(strSql);
            return true;
        }
        catch { return false; }
    }
}