//load room
 private void LoadRoomByDelFlag(int p)
 {
     RoomInfoBLL bll = new RoomInfoBLL();
     dgvRoomInfo.AutoGenerateColumns = false; ;
     dgvRoomInfo.DataSource = bll.GetAllRoomInfoByDelFlag(p);
     dgvRoomInfo.SelectedRows[0].Selected = false;
 }
        private void LoadRoomInfoByDelFlag(int p)
        {
            RoomInfoBLL bll = new RoomInfoBLL();
            List<RoomInfo> listRoom = bll.GetAllRoomInfoByDelFlag(p);
            for(int i=0; i<listRoom.Count; i++)
            {
                // tab object
                TabPage tp = new TabPage();
                // display room name
                tp.Text = listRoom[i].RoomName;
                // roomInfo object store in tag property
                tp.Tag = listRoom[i];

                // listview object
                ListView lv = new ListView();
                // bind image
                lv.LargeImageList = imageList1;
                // picture show style
                lv.View = View.LargeIcon;
                // fill to listview
                lv.Dock = DockStyle.Fill;
                // listview background color
                lv.BackColor = Color.Green;
                // multiselect 
                lv.MultiSelect = false;

                tp.Controls.Add(lv);
                tabControl1.TabPages.Add(tp);
            }
        }
 //update
 private void button2_Click(object sender, EventArgs e)
 {
     if(dgvRoomInfo.SelectedRows.Count>0)
     {
         int id = Convert.ToInt32(dgvRoomInfo.SelectedRows[0].Cells[0].Value.ToString());
         RoomInfoBLL bll = new RoomInfoBLL();
         meaRoom.Obj = bll.GetRoomInfoByRoomId(id);
         LoadFrmChangeRoom(4);
     }
     else
     {
         MessageBox.Show("请选择要修改房间的行数");
     }
 }
 /// <summary>
 /// delete room
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnDeleteRoom_Click(object sender, EventArgs e)
 {
     //RoomInfoBLL bll = new RoomInfoBLL();
     if(dgvRoomInfo.SelectedRows.Count > 0)
     {
         int id = Convert.ToInt32(dgvRoomInfo.SelectedRows[0].Cells[0].Value.ToString());
         DeskInfoBLL dbll = new DeskInfoBLL();
         if(dbll.GetDeskCountByRoomId(id))
         {
             MessageBox.Show("房间有桌子不能删除");
         }
         else
         {
             RoomInfoBLL rbll = new RoomInfoBLL();
             if(rbll.SoftDeleteRoomInfoByRoomId(id))
             {
                 MessageBox.Show("操作成功");
                 LoadRoomByDelFlag(0);
             }
             else
             {
                 MessageBox.Show("操作失败");
             }
         }
     }
     else
     {
         MessageBox.Show("请选择要删除的房间");
     }
 }
 private void btnOk_Click(object sender, EventArgs e)
 {
     RoomInfo r = new RoomInfo();
     
     if(txtRName.Text=="")
     {
         MessageBox.Show("请添加房间名");
         return;
     }
     if(txtRType.Text == "")
     {
         MessageBox.Show("请添加房间类型");
         return;
     }
     if(txtRMinMoney.Text=="")
     {
         MessageBox.Show("请添加房间的最低消费");
         return;
     }
     if(txtRPerNum.Text == "")
     {
         MessageBox.Show("请添加房间人数");
         return;
     }
     if (txtIsDeflaut.Text == "")
     {
         MessageBox.Show("请添加默认编号");
         return;
     }
     if (txtRName.Text != "" && txtRType.Text != "" && txtRMinMoney.Text!="" && txtRPerNum.Text!="" && txtIsDeflaut.Text!="")
     {
         r.IsDefault = Convert.ToInt32(txtIsDeflaut.Text);
         //r.RoomId = Convert.ToInt32(txtRType.Text);
         r.RoomMaxConsumer = Convert.ToInt32(txtRPerNum.Text);
         r.RoomMinimunConsume = Convert.ToDecimal(txtRMinMoney.Text);
         r.RoomName = txtRName.Text;
         r.RoomType = Convert.ToInt32(txtRType.Text);
         if(this.TP == 3)
         {
             r.SubBy = 1;
             r.SubTime = System.DateTime.Now;
             r.DelFlag = 0;
         }
         else if(this.TP == 4)
         {
             r.RoomId = Convert.ToInt32(labId.Text);
         }
         RoomInfoBLL bll = new RoomInfoBLL();
         string msg = bll.AddOrUpdate(r,this.TP) ? "操作成功" : "操作失败";
         MessageBox.Show(msg);
     }
     
     
 }