frmmain.cs

酒店管理系统,您酒店物业管理的好帮手

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;


using Hotel.UI;
using Hotel.Operation;
using Hotel.Entity;

namespace Hotel
{
    public partial class frmMain : Form
    {
        GuestRoomAccess objGuestRoomAccess = null;
        GuestRoom guestRoomEntity = null;
        RoomUseAccess objRoomUseAccess = null;
        BuyerAccess objBuyerAccess = null;
        DataSet ds = null;
        RoomTypeAccess objRoomTypeAccess = null;
        AccountAccess objAccountAccess = null;
        RemindAccess objRemindAccess = null;
        private string strPath = Application.StartupPath;

        public frmMain()
        {
            InitializeComponent();
        }

        private void mnuExit_Click(object sender, EventArgs e)
        {
            DialogResult obj=MessageBox.Show("是否退出？","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
            if (obj == DialogResult.Yes)
            {
                Application.Exit();
            }
        }
        //帮助--ud
        private void mnuAboutWe_Click(object sender, EventArgs e)
        {
            frmAbout obj = new frmAbout();
            obj.ShowDialog();
        }

        private void mnuNew_Click(object sender, EventArgs e)
        {
            
        }

        private void frmMain_Load(object sender, EventArgs e)
        {
            tsslUername.Text = "当前用户: "+Program.strName;
            showRoom();
            ShowRemind();//显示提醒的列表
        }
        public void ShowRemind()
        {
             //显示提醒的列表
            objRemindAccess = new RemindAccess();
            ds = new DataSet();
            ds=objRemindAccess.GetStardRemind();
            //建表头
            ColumnHeader ch = null;
            lsvRemind.Columns.Clear();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                if (i == 0)
                {
                    ch = new ColumnHeader();
                    ch.Text = "*";
                    ch.Width = 20;
                    lsvRemind.Columns.Add(ch);
                    continue;
                }
                ch = new ColumnHeader();
                ch.Text = ds.Tables[0].Columns[i].ToString();
                lsvRemind.Columns.Add(ch);
            }

            lsvRemind.Items.Clear();
            ListViewItem lsvItem = null;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                lsvItem = new ListViewItem((i+1).ToString());
                for (int j = 1; j < ds.Tables[0].Columns.Count; j++)
                {
                    lsvItem.SubItems.Add(ds.Tables[0].Rows[i][j].ToString());
                }
                lsvRemind.Items.Add(lsvItem);
            }  
        }
        public void showRoom()
        {
            objGuestRoomAccess = new GuestRoomAccess();
            objGuestRoomAccess.GetRoom(lsvA,1);
            objGuestRoomAccess.GetRoom(lsvB, 2);
            objGuestRoomAccess.GetRoom(lsvC, 3);
            objGuestRoomAccess.GetRoom(lsvD, 4);
            objGuestRoomAccess.GetRoom(lsvE, 5);
            objGuestRoomAccess.GetRoom(lsvF, 6);
            
        }

        private void mnuBig_Click(object sender, EventArgs e)
        {
            lsvA.View = View.LargeIcon;
            objGuestRoomAccess.GetRoom(lsvA, 1);
            objGuestRoomAccess.GetRoom(lsvB, 2);
            objGuestRoomAccess.GetRoom(lsvC, 3);
            objGuestRoomAccess.GetRoom(lsvD, 4);
            objGuestRoomAccess.GetRoom(lsvE, 5);
            objGuestRoomAccess.GetRoom(lsvF, 6);
            
            
            imglist.ImageSize = new Size(48,48);
        }

        private void mnuMiddle_Click(object sender, EventArgs e)
        {

            imglist.ImageSize = new Size(32, 32);
            objGuestRoomAccess.GetRoom(lsvA, 1);
            objGuestRoomAccess.GetRoom(lsvB, 2);
            objGuestRoomAccess.GetRoom(lsvC, 3);
            objGuestRoomAccess.GetRoom(lsvD, 4);
            objGuestRoomAccess.GetRoom(lsvE, 5);
            objGuestRoomAccess.GetRoom(lsvF, 6);
        }

        private void mnuSmill_Click(object sender, EventArgs e)
        {
            imglist.ImageSize = new Size(24, 24);
            
        }

        private void mnuList_Click(object sender, EventArgs e)
        {
            lsvA.View = View.List;
        }

        private void tsbParticular_Click(object sender, EventArgs e)
        {
            lsvA.View = View.Details;
        }
        //刷新
        private void mnuRefurbish_Click(object sender, EventArgs e)
        {
            showRoom();
        }
        //显示时间
        private void timShow_Tick(object sender, EventArgs e)
        {
           string str = DateTime.Now.Date.ToString();

           lblYear.Text = str.Substring(0, 10);
           lblWeeb.Text = DateTime.Now.DayOfWeek.ToString();
           lblDateTime.Text = DateTime.Now.TimeOfDay.ToString().Substring(0,8);
        }

        private void mnuMo_Click(object sender, EventArgs e)
        {
            frmModifiPwd frm = new frmModifiPwd();
            frm.ShowDialog();
        }

        private void mnuScreen_Click(object sender, EventArgs e)
        {
            frmLock frm = new frmLock();
            frm.ShowDialog();
        }

        private void mnuPopedom_Click(object sender, EventArgs e)
        {
            frmPopedom frm = new frmPopedom();
            frm.ShowDialog();
        }

        private void mnuUnit_Click(object sender, EventArgs e)
        {
            frmUnitOpen frm = new frmUnitOpen();
            frm.ShowDialog();
        }
        public static string room = "";
        public static string type = "";
        private void tsbOne_Click(object sender, EventArgs e)
        {
            ListView lsvName =new ListView();
            if (tbcMain.SelectedIndex == 0)
            {
                lsvName = lsvA;
            }
            else if (tbcMain.SelectedIndex == 1)
            {
                lsvName = lsvB;
            }
            else if (tbcMain.SelectedIndex == 2)
            {
                lsvName = lsvC;
            }
            else if (tbcMain.SelectedIndex == 3)
            {
                lsvName = lsvD;
            }
            else if (tbcMain.SelectedIndex == 4)
            {
                lsvName = lsvE;
            }
            else
            {
                lsvName = lsvF;
            }
            //判断是否选中了房间
            if (lsvName.SelectedItems.Count == 0)
            {
                MessageBox.Show("请选择房间!", "提示");
                return;
            }
            if (!lsvName.SelectedItems[0].SubItems[4].Text.Trim().Equals("可供"))
            {
                MessageBox.Show("该房间非可供状态!","提示");
                return;
            }
            room = lsvName.SelectedItems[0].SubItems[0].Text.ToString();
            type = lsvName.SelectedItems[0].SubItems[1].Text.ToString();
            frmUnitOpen frm = new frmUnitOpen();//宾客开单
            frm.ShowDialog();
            showRoom();//刷新
        }

        private void mnuDataBack_Click(object sender, EventArgs e)
        {
            frmBackup frm = new frmBackup();//备份
            frm.ShowDialog();
        }

        private void mnuComeback_Click(object sender, EventArgs e)
        {
            frmBackup frm = new frmBackup();//恢复
            frm.ShowDialog();
        }

        private void tsbIn_Click(object sender, EventArgs e)
        {

        }

        private void tsbDestine_Click(object sender, EventArgs e)
        {
            frmDestine frm = new frmDestine();
            frm.ShowDialog();
        }

        private void tsbSystem_Click(object sender, EventArgs e)
        {
            frmSystemSet frm = new frmSystemSet();
            frm.ShowDialog();
            showRoom();
        }
        //当选中房间时加载房间信息和消费清单
        private void lsvA_SelectedIndexChanged(object sender, EventArgs e)
        {
            //显示预设房价
            showlist(lsvA,1);
        }

        private void lsvB_SelectedIndexChanged(object sender, EventArgs e)
        {
            showlist(lsvC,3);
        }

        private void lsvC_SelectedIndexChanged(object sender, EventArgs e)
        {
            showlist(lsvB,2);
        }

        private void lsvD_SelectedIndexChanged(object sender, EventArgs e)
        {
            showlist(lsvD,4);
        }
        private void lsvE_SelectedIndexChanged(object sender, EventArgs e)
        {
            showlist(lsvE,5);
        }
        private void lsvF_SelectedIndexChanged(object sender, EventArgs e)
        {
            showlist(lsvF, 6);
        }
        //公共方法,显示信息
        public void showlist(ListView lv, int v)
        {
            objRoomTypeAccess = new RoomTypeAccess();
            lblRoomPrice.Text = objRoomTypeAccess.GetRoomPrice(v).ToString() + " 元/天";

            string roomID = "";
            try
            {
                roomID = lv.SelectedItems[0].Text.ToString().Trim();
            }
            catch
            {
                //MessageBox.Show(ex.Message);
            }
            guestRoomEntity = new GuestRoom();
            guestRoomEntity = objGuestRoomAccess.GetRoomInfo(roomID);
            lblRoomPhone.Text = guestRoomEntity.RoomPhone.ToString();
            lblAddress.Text = guestRoomEntity.Area.ToString();
            //判断房间是否正在使用
            if (guestRoomEntity.State.Trim().Equals("使用"))
            {
                //通过房间号获得帐单里的客间信息
                objRoomUseAccess = new RoomUseAccess();
                ds = new DataSet();
                //获得正在使用的房间的信息
                ds = objRoomUseAccess.GetRoomInfo(roomID);
                //从数据集获得宾客ID

                if (ds.Tables[0].Rows.Count != 0)
                {
                    int byID;
                    byID = Convert.ToInt32(ds.Tables[0].Rows[0][1].ToString());

                    //通过宾客ID取得姓名
                    objBuyerAccess = new BuyerAccess();
                    lblShowName.Text = objBuyerAccess.GetBuyerInfo(byID).ToString();
                    //入住时间
                    lblInTime.Text = ds.Tables[0].Rows[0][4].ToString().Substring(0, 10);
                    lblInUse.Text = ds.Tables[0].Rows[0][8].ToString();
                    //计算天数价格
                    lblSumMoney.Text = "0";
                }
                else
                {
                    lblShowName.Text = "无";
                    lblInTime.Text = "0";
                    lblInUse.Text = "0";
                }
                //获得帐号


                objRoomUseAccess = new RoomUseAccess();
                int num = objRoomUseAccess.GetRoomUseID(roomID);
                objAccountAccess = new AccountAccess();
                ds = new DataSet();
                ds = objAccountAccess.GetAccount(num);
                lsvAccount.Items.Clear();
                ListViewItem lstItem = null;
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    lstItem = new ListViewItem(ds.Tables[0].Rows[i][0].ToString());
                    for (int j = 1; j < ds.Tables[0].Columns.Count; j++)
                    {
                        lstItem.SubItems.Add(ds.Tables[0].Rows[i][j].ToString());
                    }
                    lsvAccount.Items.Add(lstItem);
                }
                
            }
        }
        //客户信息查询
        private void mnuInRoom_Click(object sender, EventArgs e)
        {
            frmInfoFind frm = new frmInfoFind();
            frm.ShowDialog();
        }

        private void mnuAccount_Click(object sender, EventArgs e)
        {
            frmReckoning frm = new frmReckoning();
            frm.ShowDialog();
        }

        private void tsbFind_Click(object sender, EventArgs e)
        {
            frmInfoFind frm = new frmInfoFind();
            frm.ShowDialog();
        }

        private void tsbManager_Click(object sender, EventArgs e)
        {
            frmInsideManage frm = new frmInsideManage();
            frm.ShowDialog();
        }

        private void lsvAccount_SelectedIndexChanged(object sender, EventArgs e)
        {

        }
        //更换皮肤