userhomes.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>
/// UserHome 的摘要说明
/// </summary>
public class UserHomes:SqlDataBase
{
	public UserHomes()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    /// <summary>
    /// 返回用户别墅视图
    /// </summary>
    /// <returns></returns>
    public DataView DvUserHome()
    {
        return GetDv("SELECT * FROM V_Home ORDER BY id");
    }

    /// <summary>
    /// 获取房屋价格
    /// </summary>
    /// <param name="homeid"></param>
    /// <returns></returns>
    public int GetHomeMoney(string homeid)
    {
        return  int.Parse(RunSqlReturn("select money from users_home where id=" + homeid));
    }

    /// <summary>
    /// 添加房子用户
    /// </summary>
    /// <param name="homeid"></param>
    /// <param name="userid"></param>
    /// <returns></returns>
    public bool AddUserHome(string homeid,string userid)
    {
        string strSql = "update Users_Home set userid = " + userid + " where id=" + homeid;
        int money = GetHomeMoney(homeid);
        string strSql2 = "update Users_Info set money = money -"+money+" where userid =" + userid;
        try
        {
            RunSql(strSql);
            RunSql(strSql2);
            return true;
        }
        catch { return false; }            
    }

    /// <summary>
    /// 验证用户是否已经拥有房子
    /// </summary>
    /// <param name="userid">用户ID</param>
    /// <returns></returns>
    public int GetVldHome(string userid)
    {
        return int.Parse(RunSqlReturn("select count(id) from users_home where userid =" + userid));
    }

    /// <summary>
    /// 
    /// </summary>
    /// <param name="homeid"></param>
    /// <returns></returns>
    public int GetVldUser(string homeid)
    {
        return int.Parse(RunSqlReturn("select userid from users_home where id =" + homeid));
    }
}