resvacct.aspx.cs

客房预定系统

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

public partial class ResvAcct : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            InitCtrl();
        }
    }
    protected void InitCtrl()
    {
        string htl_cd = Request.QueryString ["htl_cd"];
        Class1 db = new Class1();
        //返回酒店名称；
        lb_Htlnm.Text = db.HtlNm(htl_cd);
        lb_Htlcd.Text = htl_cd;
        //按照酒店代码绑定房间下拉列表
        ddl_RmTyp.DataSource = db.RoomList(htl_cd);
        ddl_RmTyp.DataTextField  = "Rmtyp_nm";
        ddl_RmTyp.DataValueField = "Rmtyp_amt";
        ddl_RmTyp.DataBind();
        //为房间价格赋值
        lb_RmAmt.Text = ddl_RmTyp.SelectedValue.ToString();
        //根据会员代码，绑定会员名称
        member mem = new member();
        string mem_cd = Session["mem_cd"].ToString();
        mem = db.ReMem(mem_cd);
        lb_MemNm.Text = mem.nm;
    }
    protected void ddl_RmTyp_SelectedIndexChanged(object sender, EventArgs e)
    {
        //为房间价格赋值
        lb_RmAmt.Text = ddl_RmTyp.SelectedValue.ToString();
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        string htl_cd = Request.QueryString ["htl_cd"];
        Class1 db =new Class1 ();
        acct acc = new acct();
        acc.htl_cd = lb_Htlcd.Text;//酒店代码
        acc.rmtyp_cd = db.ReRmcd(htl_cd, ddl_RmTyp.SelectedItem.Text);//房间代码
        acc.arr_dt = Convert .ToDateTime ( tbx_arrdt.Text);//到店日期
        acc.dpt_dt = Convert .ToDateTime ( tbx_dptdt.Text);//离店日期
        acc.gst_nums = Convert .ToInt32 ( tbx_GstNums.Text);//到店人数
        acc.rm_nums = Convert .ToInt32 ( tbx_RmNums.Text);//订房数目
        acc.rmtyp_amt = Convert .ToDecimal ( lb_RmAmt.Text);//房间价格
        acc.mem_cd = Session["mem_cd"].ToString();//预定会员代码
        acc.acct_nm = tbx_AcctNm.Text;//联系人姓名
        acc.acct_sex = ddl_AcctSex.SelectedItem.Text;//联系人性别
        acc.acct_tel = tbx_AcctTel.Text;//联系人电话
        acc.notice = tbx_Notice.Text;//备注
        db.InsertAcct(acc);
        Session["acc"] = acc; 
        Response.Redirect("~/ResvSave.aspx");
    }
}