querydepositform.aspx.cs

一个关于宾馆酒店管理系统的源代码

//文件名:QueryDepositForm.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;

using System.Data.SqlClient;
public partial class QueryManage_QueryDepositForm : System.Web.UI.Page
{
    private static String MySQLConnectionString;
    private static System.Data.DataTable MyGuestTable = new System.Data.DataTable();
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Page.Title = "当前位置：查询管理->查询旅客押金";   
        string MyForbidString = Session["MyForbid"].ToString();
        if (MyForbidString.IndexOf("C5") > 1)
        {
            Server.Transfer("~/SystemManage/AllErrorHelp.aspx");
        }
        if (!IsPostBack)
        {
            //创建无连接的数据表
            DataColumn[] MyKey = new DataColumn[1];
            MyGuestTable = new DataTable("旅客押金");
            DataColumn MyColumn = new DataColumn();
            MyColumn.DataType = System.Type.GetType("System.String");
            MyColumn.ColumnName = "入住编号";
            MyGuestTable.Columns.Add(MyColumn);
            MyKey[0] = MyColumn;
            MyGuestTable.PrimaryKey = MyKey;
            MyGuestTable.Columns.Add("客人姓名", System.Type.GetType("System.String"));
            MyGuestTable.Columns.Add("入住房号", System.Type.GetType("System.String"));
            MyGuestTable.Columns.Add("预收押金", System.Type.GetType("System.String"));
            MyGuestTable.Columns.Add("费用总额", System.Type.GetType("System.String"));
            MyGuestTable.Columns.Add("应补金额", System.Type.GetType("System.String"));
            this.TextBox1.Text = DateTime.Now.Year.ToString();
            this.TextBox2.Text = DateTime.Now.Month.ToString();
            this.TextBox3.Text = DateTime.Now.Day.ToString();                
        }
        if (IsPostBack)
        {//查询酒店旅客押金信息       
            MyGuestTable.Rows.Clear();
            string MySQL = "Select 入住编号,客人姓名,入住房号,预收押金,折扣价格,入住日期,住宿人数 From 客房入住单 Where 入住编号 NOT IN (Select 入住编号 From 客房结账单)";
            MySQLConnectionString = ConfigurationManager.ConnectionStrings["MyHotelDBConnectionString"].ConnectionString;
            SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
            MyConnection.Open();
            System.Data.DataTable MyTable = new System.Data.DataTable();
            SqlDataAdapter MyAdapter = new SqlDataAdapter(MySQL, MyConnection);
            MyAdapter.Fill(MyTable);
            foreach (DataRow MyRow in MyTable.Rows)
            {
                string My入住编号 = MyRow[0].ToString();
                string My客人姓名 = MyRow[1].ToString();
                string My入住房号 = MyRow[2].ToString();
                string My预收押金 = MyRow[3].ToString();
                string My折扣价格 = MyRow[4].ToString();
                int My住宿人数 = Convert.ToInt16(MyRow[6].ToString());
                double MyD店内消费 = 0;
                double MyD电话费 = 0;
                double MyD用餐费 = 0;
                double MyD住宿费 = 0;

                DateTime My入住日期 = (DateTime)MyRow[5];
                int MyYear = Convert.ToInt16(this.TextBox1.Text);
                int MyMonth = Convert.ToInt16(this.TextBox2.Text);
                int MyDay = Convert.ToInt16(this.TextBox3.Text);
                DateTime My截止日期DateTimePicker = new DateTime(MyYear,MyMonth,MyDay);
                TimeSpan MySpan = My截止日期DateTimePicker.Subtract(My入住日期);
                MyD住宿费 = Convert.ToDouble(My折扣价格) * Math.Round(MySpan.TotalDays, 0) * My住宿人数;

                MySQL = "Select SUM(金额) From 话费入账 Where 入住编号='" + My入住编号 + "'";
                SqlCommand MyCommand = new SqlCommand(MySQL, MyConnection);
                string My电话费 = MyCommand.ExecuteScalar().ToString();
                if (My电话费.Length > 0)
                {
                    MyD电话费 = Convert.ToDouble(My电话费);
                }

                MySQL = "Select SUM(金额) From 餐费入账 Where 入住编号='" + My入住编号 + "'";
                MyCommand = new SqlCommand(MySQL, MyConnection);
                string My用餐费 = MyCommand.ExecuteScalar().ToString();
                if (My用餐费.Length > 0)
                {
                    MyD用餐费 = Convert.ToDouble(My用餐费);
                }

                MySQL = "Select SUM(消费数量*折扣价格) From 消费入账 Where 入住编号='" + My入住编号 + "'";
                MyCommand = new SqlCommand(MySQL, MyConnection);
                string My店内消费 = MyCommand.ExecuteScalar().ToString();
                if (My店内消费.Length > 0)
                {
                    MyD店内消费 = Convert.ToDouble(My店内消费);
                }

                double MyD费用总额 = MyD住宿费 + MyD电话费 + MyD用餐费 + MyD店内消费;

                double MyD应补金额 = MyD费用总额 - Convert.ToDouble(My预收押金);

                Object[] MyCells = { My入住编号, My客人姓名, My入住房号, MyD应补金额.ToString(),My预收押金, 
                MyD费用总额.ToString(),MyD住宿费.ToString(),My用餐费,My店内消费,My电话费};
                DataRow MyNewRow = MyGuestTable.NewRow();
                MyNewRow["入住编号"] = My入住编号;
                MyNewRow["客人姓名"] = My客人姓名;
                MyNewRow["入住房号"] = My入住房号;
                MyNewRow["预收押金"] = My预收押金;
                MyNewRow["费用总额"] = MyD费用总额;
                MyNewRow["应补金额"] = MyD应补金额;
                MyGuestTable.Rows.Add(MyNewRow);               
            }
            this.GridView1.DataSource = MyGuestTable;
            this.GridView1.DataBind();
        }
    }
    public DataTable MyPrintTable
    {//设置要传递到打印页的数据表
        get
        {
            return MyGuestTable;
        }
    }
    public String MyPrint截止日期
    {//设置要传递到打印页的截止日期
        get
        {
            return this.TextBox1.Text+"年"+this.TextBox2.Text+"月"+this.TextBox3.Text+"日";
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {//打印旅客押金信息
        Server.Transfer("~/QueryManage/QueryDepositPrint.aspx");
    }  
}