public void AddSeat()
{
BLL.Dealseat_empty dealseat_empty = new BLL.Dealseat_empty();
if (H_name == "3号影厅")
{
row = 8;
column = 10;
chang = kuan = 35;
jiege = 50;
}
else
{
row = 6;
column = 10;
chang = kuan = 45;
jiege = 60;
}
for (int i = 0; i < row; i++)
{
for (int j = 0; j < column; j++)
{
pb[i, j] = new SeatKJ.UserControl1();
pb[i, j].Seat_id = (i * 10 + j + 1).ToString();
if (dealseat_empty.SeatIs_empty(Schedule_id, pb[i, j].Seat_id)) //判断座位是否为空
{
pb[i, j].BackColor = Color.Yellow; //可选设为黄色
pb[i, j].IsSelected = "0";
pb[i, j].Click += new System.EventHandler(pb_Yellow_Click); //为可选座位绑定到一个单击事件
}
else
{
pb[i, j].BackColor = Color.Red; //不可选设为红色
}
pb[i, j].BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
pb[i, j].Location = new System.Drawing.Point(70 + j * jiege, 90 + i * jiege);
pb[i, j].Name = (i * 10 + j + 1).ToString();
pb[i, j].Size = new System.Drawing.Size(chang, kuan);
pb[i, j].TabStop = false;
pb[i, j].label1.Text = (i * 10 + j + 1).ToString();
pb[i, j].label1.ForeColor = Color.Black;
pb[i, j].label1.Location = new System.Drawing.Point(5, 5);
this.panel1.Controls.Add(pb[i, j]);
}
}
}
private void button8_Click(object sender, EventArgs e)
{
if (comboBox3.SelectedIndex < 0 || comboBox6.SelectedIndex < 0 || comboBox7.SelectedIndex < 0)
{
MessageBox.Show("请填写完整排期信息!");
}
else
{
string newhall_id = comboBox3.Text;
DateTime date = Convert.ToDateTime(DatePicker2.Value.ToShortDateString());
model.Date = date;
string hour = comboBox6.Text;
string minute = comboBox7.Text;
model.Time = hour + ":" + minute;
BLL.Dealseat_empty dealseat_empty = new BLL.Dealseat_empty();
Model.seat_empty emptymodel = new Model.seat_empty();
if (model.H_id != newhall_id)
{
if (model.H_id != "003" && newhall_id != "003")
{
model.H_id = newhall_id;
}
else if (model.H_id != "003" && newhall_id == "003")
{
model.H_id = newhall_id;
emptymodel.Schedule_id = Schedule_id;
emptymodel.Is_empty = 1;
for (int i = 61; i <= 80; i++)
{
emptymodel.Seat_id = i.ToString();
dealseat_empty.Add(emptymodel);
}
}
else
{
model.H_id = newhall_id;
for (int i = 61; i <= 80; i++)
{
dealseat_empty.Deleteseat_empty(Schedule_id, i.ToString());
}
}
}
dealschedule.Updatefilm_schedule(model);
}
Fill();
MessageBox.Show("修改成功!");
}
private void DelButton_Click(object sender, EventArgs e) //选择该行，才能进行删除操作， MessageBox.Show("确定删除？");
{
int delSchedule_id;
try
{
f_id = (int)dataGridView1.CurrentRow.Cells[0].Value;
datetime = (DateTime)dataGridView1.CurrentRow.Cells[2].Value;
time = (String)dataGridView1.CurrentRow.Cells[3].Value;
switch ((String)dataGridView1.CurrentRow.Cells[4].Value)
{
case "1号影厅": h_id = "001"; break;
case "2号影厅": h_id = "002"; break;
case "3号影厅": h_id = "003"; break;
}
}
catch (System.Exception ex)
{
MessageBox.Show("请选择有效数据行！");
return;
}
if (MessageBox.Show(" 确定删除？", "询问", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) != DialogResult.Yes)
{
return;
}
delSchedule_id = dealschedule.Getfilm_scheduleid(f_id, datetime, time, h_id); //读取排期原来值显示在修改panel中
BLL.Dealseat_empty dealseat_empty = new BLL.Dealseat_empty();
if (dealseat_empty.Deleteseat_emptyall(delSchedule_id) && dealschedule.Deletefilm_schedule(delSchedule_id)) //删除排期对应的座位信息以及删除排期
{
Fill();
MessageBox.Show("删除成功！");
}
else
{
Fill();
MessageBox.Show("删除失败！");
}
}
private void button6_Click(object sender, EventArgs e)
{
if (comboBox8.SelectedIndex < 0 || comboBox2.SelectedIndex < 0 || comboBox1.SelectedIndex < 0)
{
MessageBox.Show("请填写完整排期信息!");
}
else
{
model.F_id = f_id;
model.H_id = comboBox8.Text;
string hour = comboBox2.Text;
string minute = comboBox1.Text;
DateTime date = Convert.ToDateTime(DatePicker3.Value.ToShortDateString()); //获取datatime并使时间部分为0
model.Date = date;
model.Time = hour + ":" + minute;
BLL.Dealseat_empty dealseat_empty = new BLL.Dealseat_empty();
Model.seat_empty emptymodel = new Model.seat_empty();
emptymodel.Is_empty = 1;
emptymodel.Schedule_id = dealschedule.Addfilm_schedule2(model); //插入film_schedule表并获得schedule_id
if (model.H_id == "001" || model.H_id == "002") //根据schedule_id和h_id生成seat_empty表的座位数据 Is_empty的值为1
{
for (int i = 1; i <= 60; i++)
{
emptymodel.Seat_id = i.ToString();
dealseat_empty.Add(emptymodel);
}
}
else
{
for (int i = 1; i <= 80; i++)
{
emptymodel.Seat_id = i.ToString();
dealseat_empty.Add(emptymodel);
}
}
MessageBox.Show("添加排期成功!");
Fill();
}
}
private void button2_Click(object sender, EventArgs e)
{
foreach (Control con in panel1.Controls)
{
if (con is SeatKJ.UserControl1)
{
SeatKJ.UserControl1 pb = (SeatKJ.UserControl1)con;
if (pb.IsSelected == "1") //确认选座
{
Model.seat_empty model = new Model.seat_empty();
model.Schedule_id = Schedule_id;
model.Seat_id = pb.Seat_id;
BLL.Dealseat_empty dealseat_empty = new BLL.Dealseat_empty();
if (dealseat_empty.Updateseat_empty(model))
{
pb.Click -= new System.EventHandler(pb_Yellow_Click);
pb.BackColor = Color.Red;
pb.IsSelected = "0";
}
ticketmodel.F_id = this.F_id; //购票成功 打印ticket信息，录入数据库
ticketmodel.Schedule_id = this.Schedule_id;
ticketmodel.Deal_time = Convert.ToDateTime(DateTime.Now.ToShortDateString());
ticketmodel.Seat_id = pb.Seat_id;
if (MemberHelper.Use == true)
{
ticketmodel.Customer_id = MemberHelper.Name; //若通过会员验证，则Costomer_id =会员卡号
}
else
{
ticketmodel.Customer_id = "000000"; //不是会员则Costomer_id = 000000(非会员)
}
ticketmodel.Price = Convert.ToInt32(Convert.ToDouble(textBox5.Text) / Convert.ToDouble(textBox9.Text));
dealticket.Addticket(ticketmodel);
}
}
}
groupBox3.Hide();
}
