Esempio n. 1
0
        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();
            }
        }
Esempio n. 2
0
        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("修改成功!");
        }