//更新一条记录（当票售出后，可将is_empty更改为0）
public bool Updateseat_empty(Model.seat_empty model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update seat_empty set");
strSql.Append(" is_empty= 0");
strSql.Append(" where Schedule_id=@Schedule_id and Seat_id=@Seat_id");
SqlParameter[] parameters =
{
new SqlParameter("@Schedule_id", SqlDbType.Int),
new SqlParameter("@Seat_id", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.Schedule_id;
parameters[1].Value = model.Seat_id;
int rows = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//增加座位信息(当安排好场次的时候，就可以增加座位信息 is_empty=1)
public bool Add(Model.seat_empty model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into seat_empty(");
strSql.Append(" Schedule_id,Seat_id,Is_empty)");
strSql.Append(" values(");
strSql.Append(" @Schedule_id,@Seat_id,@Is_empty)");
SqlParameter[] parameters =
{
new SqlParameter("@Schedule_id", SqlDbType.Int),
new SqlParameter("@Seat_id", SqlDbType.VarChar,20),
new SqlParameter("@Is_empty", SqlDbType.Int)
};
parameters[0].Value = model.Schedule_id;
parameters[1].Value = model.Seat_id;
parameters[2].Value = model.Is_empty;
int rows = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
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 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();
}
//更新一条记录（当票售出后，可将is_empty更改为0）
public bool Updateseat_empty(Model.seat_empty model)
{
return(dealseat_empty.Updateseat_empty(model));
}
//增加座位信息(当安排好场次的时候，就可以增加座位信息 is_empty=1)
public bool Add(Model.seat_empty model)
{
return(dealseat_empty.Add(model));
}
