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 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("修改成功!"); }