frmsystemset.cs

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

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Hotel.Operation;
using Hotel.Entity;
using System.Data.SqlClient;

namespace Hotel.UI
{
    public partial class frmSystemSet : Form
    {
        GuestRoomAccess objGuestRoomAccess = null;
        RoomTypeAccess objRoomTypeAccess = null;
        ItemsPriceAccess objItemsPriceAccess = null;
        ItemsTypeAccess objItemsTypeAccess = null;
        GuestRoom guestRoomEntity = null;
        AssociatorAccess objAssociatorAccess = null;

        public frmSystemSet()
        {
            InitializeComponent();
        }
        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void frmSystemSet_Load(object sender, EventArgs e)
        {
            //显示所有房间
            objGuestRoomAccess = new GuestRoomAccess();
            objGuestRoomAccess.GetAllRoom(lsvAllRoom, "TypeNum");
            //显示房间各种类型
            objRoomTypeAccess = new RoomTypeAccess();
            objRoomTypeAccess.GetAllType(lsvRoomType);
            //所有商品
            objItemsPriceAccess = new ItemsPriceAccess();
            objItemsPriceAccess.GetItems(lsvItems, "ItemsTypeID");
            //添加商品类型到cboItemType
            objItemsTypeAccess = new ItemsTypeAccess();
            ArrayList arr = new ArrayList();
            arr=objItemsTypeAccess.GetItemType();
            foreach (string str in arr)
            {
                cboItemType.Items.Add(str);
            }
            //商品类型
            objItemsTypeAccess.GetTypeInfo(lsvItemsType);

            //添加会员卡类型信息到表
            objAssociatorAccess = new AssociatorAccess();
            objAssociatorAccess.GetAssociatorInfo(lsvCar);

        }
        //通过类型分类显示
        private void cboChangeType_SelectedIndexChanged(object sender, EventArgs e)
        {
            int k = cboChangeType.SelectedIndex;
            if (k == 0)
            {
                objGuestRoomAccess.GetAllRoom(lsvAllRoom, "TypeNum");
                return;
            }
            objGuestRoomAccess = new GuestRoomAccess();
            objGuestRoomAccess.GetAllRoom(lsvAllRoom, k.ToString());
        }
        //用于传递参数到修改窗口
        public static int roomType =0;
        public static string roomNum= "";
        public static string area = "";
        public static int phone = 0;
        public static string state = "";
        public static string remark = "";
        private void btnModifi_Click(object sender, EventArgs e)
        {
            string str = "";
            try
            {
                str=lsvAllRoom.SelectedItems[0].Text.ToString();
            }
            catch
            { 
            }
            if (str == "")
            {
                MessageBox.Show("您还没有选中要修改的房间!", "提示");
                return;
            }
            //用于传递参数到修改窗口
            roomNum = str;
            guestRoomEntity = new GuestRoom();
            guestRoomEntity=objGuestRoomAccess.GetRoomInfo(roomNum);
            roomType = guestRoomEntity.TypeNum;
            area = guestRoomEntity.Area;
            phone = guestRoomEntity.RoomPhone;
            state = guestRoomEntity.State;
            remark = guestRoomEntity.Remark;

            //修改房间
            frmModifiRoom frm = new frmModifiRoom();
            frm.ShowDialog();
            //刷新
            objGuestRoomAccess = new GuestRoomAccess();
            objGuestRoomAccess.GetAllRoom(lsvAllRoom, "TypeNum");
        }
        //删除房间
        private void btnDelete_Click(object sender, EventArgs e)
        {
            string str = "";
            int k = 0;
            try
            {
                str = lsvAllRoom.SelectedItems[0].Text.ToString();
            }
            catch
            {
            }
            if (str == "")
            {
                MessageBox.Show("您还没有选中要删除的房间!", "提示");
                return;
            }
            DialogResult en = MessageBox.Show("您确定要删除" + str + " 房间吗?", "确认",
                MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (en == DialogResult.Yes)
            {
                objGuestRoomAccess = new GuestRoomAccess();
                k=objGuestRoomAccess.DeleteRoom(str);
                if (k > 0)
                {
                    //刷新
                    objGuestRoomAccess = new GuestRoomAccess();
                    objGuestRoomAccess.GetAllRoom(lsvAllRoom, "TypeNum");
                    MessageBox.Show("房间 " + str + " 已被成功删除!", "提示");
                }
                else
                {
                    MessageBox.Show("删除失败!","提示");
                }
            }
        }

        private void btnAddRoom_Click(object sender, EventArgs e)
        {
            frmAddRoom frm = new frmAddRoom();
            frm.ShowDialog();
            //刷新
            objGuestRoomAccess = new GuestRoomAccess();
            objGuestRoomAccess.GetAllRoom(lsvAllRoom, "TypeNum");
        }
        //按商品类型过滤
        private void cboItemType_SelectedIndexChanged(object sender, EventArgs e)
        {
            objItemsPriceAccess = new ItemsPriceAccess();
            int k = cboItemType.SelectedIndex;
            //显示所有
            if (k == 0)
            {
                objItemsPriceAccess.GetItems(lsvItems, "ItemsTypeID");
                return;
            }
            objItemsPriceAccess.GetItems(lsvItems, k.ToString());
            

        }
        //添加商品
        private void btnAddItem_Click(object sender, EventArgs e)
        {
            frmAddTtem frm = new frmAddTtem();
            frm.ShowDialog();
            //所有商品
            objItemsPriceAccess = new ItemsPriceAccess();
            objItemsPriceAccess.GetItems(lsvItems, "ItemsTypeID");
        }
        //修改房价
        public static int RType=0;
        private void btnModifiType_Click(object sender, EventArgs e)
        {
            
            try
            {
                RType = int.Parse(lsvRoomType.SelectedItems[0].Text.ToString());
            }
            catch
            {
            }
            if (RType ==0)
            {
                MessageBox.Show("未选中要修改的房间类型!", "提示");
            }
            else
            {
                frmModifiRoomType frm = new frmModifiRoomType();
                frm.ShowDialog();
                //刷新
                objRoomTypeAccess = new RoomTypeAccess();
                objRoomTypeAccess.GetAllType(lsvRoomType);
            }
        }
        //删除商品
        private void btnDeleteItem_Click(object sender, EventArgs e)
        {
            int str = 0;
            try
            {
                str = int.Parse(lsvItems.SelectedItems[0].Text.ToString());
            }
            catch
            {
            }
            if (str ==0)
            {
                MessageBox.Show("您还没有选中要删除的商品!", "提示");
                return;
            }
            DialogResult en = MessageBox.Show("您确定要删除" + str + " 商品吗?", "确认",
                MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (en == DialogResult.Yes)
            {
                objItemsPriceAccess = new ItemsPriceAccess();
                int k = 0;
                k = objItemsPriceAccess.DeleteItem(str);
                if (k > 0)
                {
                    //刷新
                    //所有商品
                    objItemsPriceAccess = new ItemsPriceAccess();
                    objItemsPriceAccess.GetItems(lsvItems, "ItemsTypeID");
                    MessageBox.Show("商品 " + str + " 已被成功删除!", "提示");
                }
                else
                {
                    MessageBox.Show("删除失败!", "提示");
                }
            }

        }
        //修改商品
        public static int ItemNum = 0;
        private void btnModifiItem_Click(object sender, EventArgs e)
        {
            try
            {
                ItemNum =int.Parse( lsvItems.SelectedItems[0].Text.ToString());
            }
            catch
            {
            }
            if (ItemNum == 0)
            {
                MessageBox.Show("您还没有选中要修改的商品!", "提示");
                return;
            }
            frmModifiItem frm = new frmModifiItem();
            frm.ShowDialog();
            //刷新
            //所有商品
            objItemsPriceAccess = new ItemsPriceAccess();
            objItemsPriceAccess.GetItems(lsvItems, "ItemsTypeID");
        }
        //当选中时添加到文本框
        private void lsvItemsType_SelectedIndexChanged(object sender, EventArgs e)
        {
            int num=0;
            try
            {
                num =int.Parse( lsvItemsType.SelectedItems[0].Text.ToString());
                
            }
            catch
            { 
            }
            txtTypeNum.Text = num.ToString();
            objItemsTypeAccess = new ItemsTypeAccess();
            txtName.Text=objItemsTypeAccess.GetTypeName(num);
        }

        private void btnAddItemType_Click(object sender, EventArgs e)
        {
            if (txtName.Text.Trim().Equals(""))
            {
                MessageBox.Show("请输入商品类型!","提示");
                return;
            }
            objItemsTypeAccess = new ItemsTypeAccess();
            int k=objItemsTypeAccess.AddType(txtName.Text.Trim());
            if (k != 0)
            {
                //刷新房间各种类型
                objItemsTypeAccess = new ItemsTypeAccess();
                objItemsTypeAccess.GetTypeInfo(lsvItemsType);
                //提示成功
                MessageBox.Show("添加成功!", "提示");
                //更新cboItemType
                ArrayList arr = new ArrayList();
                arr = objItemsTypeAccess.GetItemType();
                cboItemType.Items.Clear();
                cboItemType.Items.Add("所有商品");
                foreach (string str in arr)
                {
                    cboItemType.Items.Add(str);
                }
                //清空文本框