private void ModefyButton_Click(object sender, EventArgs e) //选择该行,才能修改,然后 panel3.show(); { 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; } Schedule_id = dealschedule.Getfilm_scheduleid(f_id, datetime, time, h_id); //读取排期原来值显示在修改panel中 model = dealschedule.GetModel1(Schedule_id); comboBox3.Text = model.H_id; DatePicker2.Value = model.Date; string[] time1 = model.Time.Split(':'); comboBox6.Text = time1[0]; comboBox7.Text = time1[1]; panel3.Show(); }
//增加电影场次,返回schedule_id public int Addfilm_schedule2(Model.film_schedule model) { StringBuilder strSql = new StringBuilder(); strSql.Append(" insert into film_schedule("); strSql.Append(" F_id,Date,Time,H_id)"); strSql.Append(" values ("); strSql.Append(" @F_id,@Date,@Time,@H_id); select @Schedule_id=@@IDENTITY; "); SqlParameter[] parameters = { new SqlParameter("@F_id", SqlDbType.Int), new SqlParameter("@Date", SqlDbType.Date), new SqlParameter("@Time", SqlDbType.VarChar, 20), new SqlParameter("@H_id", SqlDbType.VarChar, 20), new SqlParameter("@Schedule_id", SqlDbType.Int) }; parameters[0].Value = model.F_id; parameters[1].Value = model.Date; parameters[2].Value = model.Time; parameters[3].Value = model.H_id; parameters[4].Direction = ParameterDirection.Output; int rows = Convert.ToInt32(SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters)); return(Convert.ToInt32(parameters[4].Value)); }
//根据电影场次号Schedule_id查询电影场次信息 public Model.film_schedule GetModel1(int Schedule_id) { StringBuilder strSql = new StringBuilder(); strSql.Append(" select top 1 Schedule_id,F_id,Date,Time,H_id"); strSql.Append(" from film_schedule where Schedule_id=@Schedule_id "); SqlParameter[] parameters = { new SqlParameter("@Schedule_id", SqlDbType.Int) }; parameters[0].Value = Schedule_id; Model.film_schedule model = new Model.film_schedule(); DataTable dt = SqlDbHelper.ExecuteDataTable(strSql.ToString(), CommandType.Text, parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["Schedule_id"] != null && dt.Rows[0]["Schedule_id"].ToString() != "") { model.Schedule_id = int.Parse(dt.Rows[0]["Schedule_id"].ToString()); } if (dt.Rows[0]["F_id"] != null && dt.Rows[0]["F_id"].ToString() != "") { model.F_id = int.Parse(dt.Rows[0]["F_id"].ToString()); } if (dt.Rows[0]["Date"] != null && dt.Rows[0]["Date"].ToString() != "") { model.Date = DateTime.Parse(dt.Rows[0]["Date"].ToString()); } if (dt.Rows[0]["Time"] != null && dt.Rows[0]["Time"].ToString() != "") { model.Time = dt.Rows[0]["Time"].ToString(); } if (dt.Rows[0]["H_id"] != null && dt.Rows[0]["H_id"].ToString() != "") { model.H_id = dt.Rows[0]["H_id"].ToString(); } return(model); } else { return(null); } }
//更新电影场次安排 public bool Updatefilm_schedule(Model.film_schedule model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update film_schedule set"); strSql.Append(" F_id=@F_id,"); strSql.Append(" Date=@Date,"); strSql.Append(" Time=@Time,"); strSql.Append(" H_id=@H_id"); strSql.Append(" where Schedule_id=@Schedule_id "); SqlParameter[] parameters = { new SqlParameter("@F_id", SqlDbType.Int), new SqlParameter("@Date", SqlDbType.Date), new SqlParameter("@Time", SqlDbType.VarChar, 20), new SqlParameter("@H_id", SqlDbType.VarChar, 20), new SqlParameter("@Schedule_id", SqlDbType.Int), }; parameters[0].Value = model.F_id; parameters[1].Value = model.Date; parameters[2].Value = model.Time; parameters[3].Value = model.H_id; parameters[4].Value = model.Schedule_id; int rows = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters); if (rows > 0) { return(true); } else { return(false); } }
//更新电影场次安排 public bool Updatefilm_schedule(Model.film_schedule model) { return(dealfilm_schedule.Updatefilm_schedule(model)); }
//增加电影场次,返回schedule_id public int Addfilm_schedule2(Model.film_schedule model) { return(dealfilm_schedule.Addfilm_schedule2(model)); }
//增加电影场次 public bool Addfilm_schedule(Model.film_schedule model) { return(dealfilm_schedule.Addfilm_schedule(model)); }