class1.cs

客房预定系统

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;
using System.Data;
using System.Data .SqlClient ;

/// <summary>
/// 封装网上订房系统的主要数据库操作函数
/// </summary>
public class Class1
{
	public Class1()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public SqlConnection con()
    {
        SqlConnection conn = new SqlConnection ("Server=.;database=hotel;uid=sa;pwd=");
        return conn;
    }

//会员表相关操作

/// <summary>
/// 根据会员代码，返回会员实例。
/// </summary>
/// <param name="mem_id">会员代码</param>
    public member ReMem(string mem_id)
    {
        member mem = new member();
        SqlConnection conn = con();
        conn.Open();
        string sqlstr = "select * from webmem where Mem_cd='" + mem_id + "'";
        SqlCommand cmd = new SqlCommand(sqlstr,conn );
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable tmp = new DataTable();
        sda.Fill(tmp);
        DataRowView drv = tmp.DefaultView[0];
        mem.id = Convert .ToInt32 ( drv["Mem_id"].ToString());
        mem.nm = drv["Mem_nm"].ToString();
        mem.cd = drv["Mem_cd"].ToString();
        mem.sex  = drv["Mem_sex"].ToString();
        mem.pwd  = drv["Mem_pwd"].ToString();
        conn.Close();
        return mem ;
    }
///<summary>
/// 判断会员代码是否存在。
///</summary>
///<param name="mem_id">会员代码</param>
    public bool ExistMem(string mem_id)
    {
        SqlConnection conn = con();
        conn.Open();
        string sqlstr = "select count(*) from webmem where Mem_cd='" + mem_id + "'";
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        int i = Convert .ToInt32 ( cmd.ExecuteScalar());
        conn.Close();
        if (i == 0)
        {
            return false;
        }
        else
        {
            return true;
        }

    }
///<summary>
/// 向会员信息表中插入信息。
///</summary>
///<param name="mem_id">会员代码</param>
///<param name="mem_nm">会员姓名</param>
///<param name="mem_sex">会员性别</param>
///<param name="mem_pwd">会员密码</param>
    public void InsertMem(member mem)
    {
        string mem_cd = mem.cd;
        string mem_nm = mem.nm;
        string mem_sex = mem.sex;
        string mem_pwd = mem.pwd;
        SqlConnection conn = con();
        conn.Open ();
        string sqlstr = "insert into webmem(Mem_cd,Mem_nm,Mem_sex,Mem_pwd) values('" + mem_cd + "','" + mem_nm + "','" + mem_sex + "','" + mem_pwd + "')";
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        cmd.ExecuteNonQuery();
        conn.Close();
    }

//酒店表相关操作

///<summary>
/// 根据 名称 所属城市 星级 模糊查找，返回相应酒店列表。
///</summary>
///<param name="htl_nm">酒店名称</param>
///<param name="htl_cty">所属城市</param>
///<param name="htl_cls">酒店星级</param>
    public DataTable HtlList(string htl_nm, string htl_cty, string htl_cls)
    {
        SqlConnection conn = con();
        conn.Open();
        string sqlstr = "select * from webhotel where Htl_nm like '%" + htl_nm + "%' and Htl_cty like '%" + htl_cty + "%' and Htl_cls like '%" + htl_cls + "%'";
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable tmp = new DataTable();
        sda.Fill(tmp);
        conn.Close();
        return tmp;
    }
///<summary>
/// 根据酒店代码，返回相应酒店名称。
///</summary>
///<param name="htl_cd">酒店代码</param>

    public string HtlNm (string htl_cd)
    {
        SqlConnection conn = con();
        conn.Open();
        string sqlstr = "select * from webhotel where Htl_cd='" + htl_cd + "'";
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable tmp = new DataTable();
        sda.Fill(tmp);
        DataRowView drv = tmp.DefaultView[0];
        string htl_nm = drv["Htl_nm"].ToString();
        conn.Close();
        return htl_nm ;
    }

//客房表相关操作

///<summary>
/// 根据酒店代码，返回酒店客房信息列表。
///</summary>
///<param name="htl_cd">酒店代码</param>
    public DataTable RoomList(string htl_cd)
    {
        SqlConnection conn = con();
        conn.Open();
        string sqlstr = "select * from webrmtyp where Htl_cd = '" + htl_cd + "'";
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable tmp = new DataTable();
        sda.Fill(tmp);
        conn.Close();
        return tmp;
    }

///<summary>
/// 根据 酒店代码 房间名称，返回 房间类型代码。
///</summary>
///<param name="htl_cd">酒店代码</param>
///<param name="rm_nm">房间名称</param>
    public string ReRmcd(string htl_cd, string rm_nm)
    {
        SqlConnection conn = con();
        conn.Open();
        string sqlstr = "select * from webrmtyp where Htl_cd = '" + htl_cd + "' and Rmtyp_nm='" + rm_nm + "'";
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable tmp = new DataTable();
        sda.Fill(tmp);
        DataRowView drv = tmp.DefaultView[0];
        string rm_cd = drv["Rmtyp_cd"].ToString();
        return rm_cd;
    }

//订单列表相关操作

///<summary>
/// 根据会员代码，返回最新的订单实例。
///</summary>
///<param name="mem_cd">会员代码</param>
    public acct ReAcct(string mem_cd)
    {
        acct acc = new acct();
        SqlConnection conn = con();
        conn.Open();
        string sqlstr = "select top 1 * from webacct where Mem_cd = '" + mem_cd + "' order by Acct_id Desc";
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable tmp = new DataTable();
        sda.Fill(tmp);
        DataRowView drv = tmp.DefaultView[0];
        acc.id = Convert.ToInt32(drv["Acct_id"].ToString());
        acc.htl_cd = drv["Htl_id"].ToString();
        acc.rmtyp_cd = drv["Rmtyp_cd"].ToString();
        acc.rmtyp_amt = Convert.ToDecimal(drv["Rmtyp_amt"].ToString());
        acc.arr_dt  = Convert .ToDateTime ( drv["Arr_dt"].ToString());
        acc.dpt_dt = Convert .ToDateTime ( drv["Dpt_dt"].ToString());
        acc.gst_nums = Convert.ToInt32(drv["Gst_nums"].ToString());
        acc.rm_nums = Convert.ToInt32(drv["Rm_nums"].ToString());
        acc.mem_cd  = drv["Mem_cd"].ToString();
        acc.acct_nm  = drv["Acct_nm"].ToString();
        acc.acct_sex = drv["Acct_sex"].ToString();
        acc.acct_tel  = drv["Acct_tel"].ToString();
        acc.notice  = drv["Notice"].ToString();
        return acc;
    }
///<summary>
/// 根据会员代码，返回所属的订单信息列表。
///</summary>
///<param name="mem_cd">会员代码</param>
    public DataTable ReAcctList(string mem_cd)
    {
        SqlConnection conn = con();
        conn.Open();
        string sqlstr = "select * from webacct where Mem_cd = '" + mem_cd + "'";
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable tmp = new DataTable();
        sda.Fill(tmp);
        return tmp;
    }
///<summary>
/// 向订单表中插入信息。
///</summary>
///<param name="acc">订单实例</param>

    public void InsertAcct (acct acc)
    {
        SqlConnection conn = con();
        conn.Open();
        string sqlstr = "insert into webacct(Htl_cd,Rmtyp_cd,Rmtyp_amt,Arr_dt,Dpt_dt,Gst_nums,Rm_nums,Mem_cd,Acct_nm,Acct_sex,Acct_tel,Notice) values('" + acc.htl_cd + "','" + acc.rmtyp_cd + "','" + acc.rmtyp_amt + "','" + acc.arr_dt + "','" + acc.dpt_dt + "','" + acc.gst_nums + "','" + acc.rm_nums + "','" + acc.mem_cd + "','" + acc.acct_nm + "','" + acc.acct_sex + "','" + acc.acct_tel + "','" + acc.notice + "')";
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        cmd.ExecuteNonQuery();
        conn.Close();
    }

}