//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); } }