//删除房间的时候
private void button3_Click(object sender, EventArgs e)
{
//选中
if (dgvRoomInfo.SelectedRows.Count > 0)
{
if (DialogResult.OK == MessageBox.Show("是否删除", "删除", MessageBoxButtons.OKCancel))
{
//开始删除
int id = Convert.ToInt32(dgvRoomInfo.SelectedRows[0].Cells[0].Value);
DeskInfoBLL bll = new DeskInfoBLL();
//有正在使用的餐桌
if (Convert.ToInt32(bll.GetDeskState(id)) > 0)
{
MessageBox.Show("有餐桌正在使用不能删除");
}
else
{
//删除房间,删除该房间下的餐桌
RoomInfoBLL rbll = new RoomInfoBLL();
//判断一个该房间下是否有餐桌,有就删,没有就直接删房间
if (bll.DeleteDesk(id) && rbll.DeleteRoomById(id))
{
MessageBox.Show("操作成功");
LoadRoomInfoByDelFlag(0);
LoadDeskInfoByDelFlag(0);
}
else
{
MessageBox.Show("操作失败");
}
}
}
}
}
private void btnDRoom_Click(object sender, EventArgs e)
{
if (dgvRoom.SelectedRows.Count <= 0)
{
md.MsgDivShow("请选中要删除的房间", 1);
return;
}
if (MessageBox.Show("确认删除该房间吗?", "删除房间", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
int id = ((RoomInfo)dgvRoom.SelectedRows[0].DataBoundItem).RoomId;
//判断该房间下是否有餐桌,有餐桌就不删除该房间
DeskInfoBLL dkBll = new DeskInfoBLL();
if (dkBll.GetDeskInfoCountByRoomId(id) > 0)
{
md.MsgDivShow("对不起,该房间下有餐桌", 1);
return;
}
//该房间下没有餐桌--可以删除选中的房间
RoomInfoBLL rBll = new RoomInfoBLL();
md.MsgDivShow(rBll.SoftDeleteRoomInfoByRoomId(id) ? "操作成功" : "操作失败", 1);
LoadAllRoomInfoByDelFlag(0);//刷新
return;
}
md.MsgDivShow("您已经取消了删除该房间");
}
private void btnOk_Click(object sender, EventArgs e)
{
//判断每个文本框不能为空
if (CheckEmpty())
{
RoomInfo room = new RoomInfo();
room.IsDefault = Convert.ToInt32(txtIsDeflaut.Text);
room.RoomMaxConsumer = Convert.ToInt32(txtRPerNum.Text);
room.RoomMinimunConsume = Convert.ToDecimal(txtRMinMoney.Text);
room.RoomName = txtRName.Text;
room.RoomType = Convert.ToInt32(txtRType.Text);
if (this.Tp == 1) //新增
{
room.DelFlag = 0;
room.SubBy = 1;
room.SubTime = System.DateTime.Now;
}
else if (this.Tp == 2) //修改
{
room.RoomId = Convert.ToInt32(labId.Text);
}
RoomInfoBLL bll = new RoomInfoBLL();
string msg = bll.SaveRoom(room, this.Tp) ? "操作成功" : "操作失败";
MessageBox.Show(msg);
this.Close();
}
}
private void btnDRoom_Click(object sender, EventArgs e)
{
//判断是否选择了删除的对象
if (dgvRoom.SelectedRows.Count <= 0)
{
md.MsgDivShow("请选择要注销的房间", 1);
return;
}
//提示用户是否真的删除
if (MessageBox.Show("亲，真的要注销这个房间吗？", "注销提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
RoomInfoBLL roomBll = new RoomInfoBLL();
RoomInfo room = (RoomInfo)dgvRoom.SelectedRows[0].DataBoundItem;
DeskInfoBLL deskBll = new DeskInfoBLL();
if (deskBll.GetAliveDeskCountByRoomId((int)room.RoomId) > 0)
{
md.MsgDivShow("对不起，该房间内有餐桌，请先注销该房间内的餐桌哦~", 1);
return;
}
//删除
string msg = roomBll.SoftDelete((int)room.RoomId) > 0 ? "操作成功" : "操作失败";
md.MsgDivShow(msg, 1);
//刷新
LoadRoomByDelFlag(0);
LoadRoomEvent();
LoadDeskEvent(GetTabPage());
return;
}
//提示取消删除
md.MsgDivShow("您已经取消了注销", 1);
}
//房间的删除
private void button3_Click(object sender, EventArgs e)
{
if (dgvRoomInfo.SelectedRows.Count > 0)
{
if (DialogResult.OK == MessageBox.Show("您确定删除吗？", "删除", MessageBoxButtons.OKCancel))
{
DeskInfoBLL bll = new DeskInfoBLL();
int roomId = Convert.ToInt32(dgvRoomInfo.SelectedRows[0].Cells[0].Value);
//可以删除了，这个房间是否有餐桌，这个房间餐桌是否在被使用
if (bll.GetDeskInfoStateByRoomId(roomId))
{
MessageBox.Show("房间下还有正在使用的餐桌，不能删除");
}
else
{
//先删除餐桌，再删除房间
RoomInfoBLL rbll = new RoomInfoBLL();
if (bll.DeleteDeskInfoByRoomId(roomId) && rbll.DeleteRoomInfoByRoomId(roomId))
{
MessageBox.Show("操作成功！");
LoadDeskInfoByDelFlag(0);
LoadRoomInfoByDelFlag(0);
}
else
{
MessageBox.Show("操作失败！");
}
}
}
}
else
{
MessageBox.Show("请选中删除的行");
}
}
private void btnOk_Click(object sender, EventArgs e)
{
//获取文本框的内容 .判断不能为空,我的要求每个文本框都不能为空
if (IsCheck())
{
RoomInfo r = new RoomInfo();
//文本框的内容是否能转换我这忽略了
r.IsDefault = Convert.ToInt32(txtIsDeflaut.Text);
r.RoomMaxConsumer = Convert.ToDecimal(txtRPerNum.Text);
r.RoomMinimunConsume = Convert.ToDecimal(txtRMinMoney.Text);
r.RoomName = txtRName.Text;
r.RoomType = Convert.ToInt32(txtRType.Text);
//判断是新增还是修改
if (this.Tp == 1)//新增
{
r.DelFlag = 0;
r.SubBy = 1;
r.SubTime = DateTime.Now;
}
else if (this.Tp == 2)//修改
{
r.RoomId = Convert.ToInt32(labId.Text);
}
RoomInfoBLL bll = new RoomInfoBLL();
string msg = bll.SaveRoom(r, this.Tp)?"操作成功":"操作失败";
MessageBox.Show(msg);
this.Close();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (CheckEmpty())
{
RoomInfo r = new RoomInfo();
r.IsDefault = txtIsDefault.Text; //默认的编号
r.RoomMaxNum = Convert.ToInt32(txtRPerNum.Text); //容纳人数
r.RoomMinMoney = Convert.ToDouble(txtRMinMoney.Text); //最低消费
r.RoomName = txtRName.Text; //名字
r.RoomType = Convert.ToInt32(txtRType.Text);
//增加或者修改
if (Temp == 1)//新增
{
r.DelFlag = 0;
r.SubBy = 1;
r.SubTime = System.DateTime.Now; //当前的时间
}
else if (Temp == 2) //修改
{
r.RoomId = Convert.ToInt32(labId.Text);
}
RoomInfoBLL rBll = new RoomInfoBLL();
string msg = rBll.AddOrUpdateRoomInfo(r, Temp) ? "操作成功" : "操作失败";
md.MsgDivShow(msg, 1, Bind);
}
}
//加载房间
private void LoadRoomInfoByDelFlag(int delFlag)
{
RoomInfoBLL bll = new RoomInfoBLL();//创建一个实例
//获取所有的房间集合
List <RoomInfo> listRoom = bll.GetAllRoomInfoByDelFlag(delFlag);
//反循环
for (int i = listRoom.Count - 1; i >= 0; i--)
{
//创建tabpage(控件)选项卡,创建一个listview(东西)
//tabpage添加到tcinfo中,listview添加到tabpage中
TabPage tp = new TabPage();
tp.Tag = listRoom[i];//把房间的对象存到"控件"的tag属性中
tp.Text = listRoom[i].RoomName;
ListView lv = new ListView(); //创建一个显示餐桌的"东西"
lv.Dock = DockStyle.Fill; //这个控件在父容器中填满
lv.View = View.LargeIcon; //图片的显示方式
lv.BackColor = Color.White; //背景颜色
lv.LargeImageList = imageList1;
lv.MultiSelect = false; //禁止多选
//为lv添加一个事件,当里面的选中项发生改变时做什么事情
lv.ItemSelectionChanged += new ListViewItemSelectionChangedEventHandler(lv_ItemSelectionChanged);
tp.Controls.Add(lv);//把lv这个东西添加到tabpage控件中
tcInFo.TabPages.Add(tp);
}
}
//加载房间
private void LoadAllRoomInfoByDelFlag(int p)
{
RoomInfoBLL rBll = new RoomInfoBLL();
dgvRoom.AutoGenerateColumns = false; //禁止自动生成列
dgvRoom.DataSource = rBll.GetAllRoomInfoByDelFlag(p);
dgvRoom.ClearSelection(); //清楚默认选中的行
}
private void LoadRoomInfoByDelFlag(int p)
{
RoomInfoBLL bll = new RoomInfoBLL();
dgvRoomInfo.AutoGenerateColumns = false;
dgvRoomInfo.DataSource = bll.GetAllRoomInfoByDelFlag(p);
dgvRoomInfo.SelectedRows[0].Selected = false;
}
private void LoadCmbRoom()
{
RoomInfoBLL rBll = new RoomInfoBLL();
List <RoomInfo> rooms = rBll.GetAllRoomInfoByDelFlag(0);
rooms.Insert(0, new RoomInfo {
RoomName = "请选择", RoomId = -1
});
cmbRoom.DataSource = rooms;
cmbRoom.DisplayMember = "RoomName";
cmbRoom.ValueMember = "RoomId";
}
private void LoadRoomInfoByDelFlag(int p)
{
RoomInfoBLL rBll = new RoomInfoBLL();
List <RoomInfo> list = rBll.GetAllRoomInfoByDelFlag(p);
list.Insert(0, new RoomInfo()
{
RoomName = "请选择", RoomId = -1
});
cmbRoom.DataSource = list;
cmbRoom.DisplayMember = "RoomName";
cmbRoom.ValueMember = "RoomId";
}
private void LoadRoomType()
{
RoomInfoBLL bll = new RoomInfoBLL();
List <RoomInfo> list = bll.GetAllRoomInfoByDelFlag(0);
list.Insert(0, new RoomInfo()
{
RoomId = -1, RoomName = "请选择"
});
cmdRoom.DataSource = list;
cmdRoom.DisplayMember = "RoomName";
cmdRoom.ValueMember = "RoomId";
}
private int Tp;//标识3- 增加-4--修改
public void LoadRoomNameAndRoomId(int p)
{
//显示房间的名字
RoomInfoBLL bll = new RoomInfoBLL();
List <RoomInfo> list = bll.GetRoomNameAndId(0);
list.Insert(0, new RoomInfo()
{
RoomName = "请选择", RoomId = -1
});
cmdRoom.DataSource = list;
cmdRoom.DisplayMember = "RoomName";
cmdRoom.ValueMember = "RoomId";
}
//修改房间
private void button2_Click(object sender, EventArgs e)
{
if (dgvRoomInfo.SelectedRows.Count > 0)
{
//获取id
int id = Convert.ToInt32(dgvRoomInfo.SelectedRows[0].Cells[0].Value);
//根据这个id查询数据库这个id对应的所有的数据
RoomInfoBLL bll = new RoomInfoBLL();
RoomInfo room = bll.GetRoomInfoByRoomId(id);
if (room != null)
{
fea.obj = room;
ShowFrmChangeRoom(2);
}
}
}
//修改
private void button2_Click(object sender, EventArgs e)
{
if (dgvRoomInfo.SelectedRows.Count > 0)
{
//获取id
string id = dgvRoomInfo.SelectedRows[0].Cells[0].Value.ToString();
//根据id获取这一行的内容赋值给一个对象
RoomInfoBLL bll = new RoomInfoBLL();
//根据id查询房间信息
RoomInfo room = bll.GetRoomInfoByRoomId(Convert.ToInt32(id));
room.RoomId = Convert.ToInt32(id);
fea.Obj = room; //把对象传到事件中去
ShowRoomChange(2); //2表示修改
}
else
{
MessageBox.Show("请选中行");
}
}
//修改房间
private void btnUpdateRoom_Click(object sender, EventArgs e)
{
if (dgvRoomInfo.SelectedRows.Count > 0)
{
int id = Convert.ToInt32(dgvRoomInfo.SelectedRows[0].Cells[0].Value);
//根据Id查询数据库这个Id对应的所有值
RoomInfoBLL bll = new RoomInfoBLL();
RoomInfo room = bll.GetRoomInfoByRoomId(id);
if (room != null)
{
fea.obj = room;
room.RoomId = id;
ShowFrmChangeRoom(2);
}
}
else
{
MessageBox.Show("请选择要操作的行");
}
}
//加载房间
private void LoadRoomInfoByDelFlag(int p)
{
RoomInfoBLL bll = new RoomInfoBLL();
List <RoomInfo> listRoom = bll.GetAllRoomInfoByDelFlag(0);
for (int i = listRoom.Count - 1; i >= 0; i--)
{
TabPage tp = new TabPage();
tp.Tag = listRoom[i]; //存房间的对象
tp.Text = listRoom[i].RoomName; //存房间的名字
ListView lv = new ListView();
lv.LargeImageList = imageList1; //给listView控件绑定图片集合
lv.BackColor = Color.White;
lv.Dock = DockStyle.Fill; //让listview控件在父容器中
lv.MultiSelect = false; //只能选一个
lv.View = View.LargeIcon;
tp.Controls.Add(lv);
tcin.TabPages.Add(tp);
}
}
//加载所有房间
private void LoadRoomInfoByDelFlag(int p)
{
var bll = new RoomInfoBLL();
var listRoom = bll.GetAllRoomInfoByDelFlag(p);
foreach (var room in listRoom)
{
var tp = new TabPage();
tp.Text = room.RoomName;
tp.Tag = room;//将房间对象储存到tag属性中
var lv = new ListView();
lv.LargeImageList = imageList1; //绑定图片
lv.View = View.LargeIcon; //图片显示的方式
lv.Dock = DockStyle.Fill; //设置填充方式
lv.MultiSelect = false; //禁止多选
lv.BackColor = Color.Tan;
tp.Controls.Add(lv); //将lv添加到tabPage中
tabc.TabPages.Add(tp); //将tp添加到tabControl中
}
}
//动态加载所有的房间
private void LoadRoomInfoByDelFlag(int p)
{
//坑==========================================
//加载所有的房间
RoomInfoBLL rBll = new RoomInfoBLL();
List <RoomInfo> listRoom = rBll.GetAllRoomInfoByDelFlag(p);
for (int i = listRoom.Count - 1; i >= 0; i--)
{
TabPage tp = new TabPage();
tp.Text = listRoom[i].RoomName; //显示房间的名字
tp.Tag = listRoom[i]; //把房间对象存储到每个tabpage控件的tag属性
ListView lv = new ListView(); //餐桌 listview这个控件可以放图片也可以放文字 lv.LargeImageList = imageList1;//设置该控件中显示图片控件
lv.LargeImageList = imageList1; //设置该控件中显示图片控件
lv.View = View.LargeIcon; //设置控件中的图片显示的方式
lv.Dock = DockStyle.Fill; //设置该控件的显示方式
lv.BackColor = Color.SeaGreen; //设置该控件的背景颜色
lv.MultiSelect = false; //禁止多选
//把lv添加到tabpage控件中
tp.Controls.Add(lv);
tabMain.TabPages.Add(tp);
}
}
private void LoadRoomByDelFlag(int p)
{
RoomInfoBLL rBll = new RoomInfoBLL();
List <RoomInfo> rooms = rBll.GetAllRoomInfoByDelFlag(p);
for (int i = rooms.Count - 1; i >= 0; i--)
{
//page
TabPage page = new TabPage();
page.Text = rooms[i].RoomName;
page.Tag = rooms[i];
//listview
ListView lv = new ListView();
lv.View = View.LargeIcon;
lv.LargeImageList = imageList1;
lv.Dock = DockStyle.Fill;
lv.BackColor = Color.SeaGreen;
lv.MultiSelect = false;
//page添加listview
page.Controls.Add(lv);
//tabmain添加page
tabMain.TabPages.Add(page);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (!IsNotEmpty())
{
return;
}
RoomInfoBLL rBll = new RoomInfoBLL();
RoomInfo r = new RoomInfo();
int i = 0;
r.IsDefault = txtIsDefault.Text; //默认的编号
r.RoomMaxNum = Convert.ToInt32(txtRPerNum.Text); //容纳人数
r.RoomMinMoney = Convert.ToDouble(txtRMinMoney.Text); //最低消费
r.RoomName = txtRName.Text; //名字
r.RoomType = Convert.ToInt32(txtRType.Text);
if (status == HandleStatus.Insert)
{
r.DelFlag = 0;
r.SubBy = 1;
r.SubTime = System.DateTime.Now;//当前时间
i = rBll.add(r);
}
if (status == HandleStatus.Update)
{
r.RoomId = oldRoom.RoomId;
r.DelFlag = oldRoom.DelFlag;
r.SubBy = oldRoom.SubBy;
r.SubTime = oldRoom.SubTime;
i = rBll.update(r);
}
string msg = i > 0 ? "操作成功" : "操作失败";
md.MsgDivShow(msg, 1, Bind);
}
