/// <summary> /// 添加放映厅 /// </summary> /// <param name="cvh"></param> /// <returns></returns> public bool AddVideoHall(CommonVideoHall cvh) { if (videoHall.AddVideoHall(cvh) > 0) { return true; } return false; }
/// <summary> /// 添加放映厅 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Add_Click(object sender, EventArgs e) { if (btn_Add.Text.Contains("要")) { CleanTxtControl(); btn_Cancel.Visible = true; btn_Modify.Enabled = false; btn_Delete.Enabled = false; lbl_ImportExport.Enabled = false; txt_VideoHallId.Enabled = true; txt_Seatings.Enabled = true; txt_Row.Enabled = true; txt_Col.Enabled = true; btn_Add.Text = "保存添加"; return; } CommonVideoHall cvh = new CommonVideoHall(); cvh.VideoHallId = 0; try { cvh.VideoHallId = Convert.ToInt32(txt_VideoHallId.Text); } catch { MessageBox.Show("请输入正确的放映厅ID"); return; } cvh.Seatings = Convert.ToInt32(txt_Seatings.Text); cvh.RowSeatNum = Convert.ToInt32(txt_Row.Text); cvh.ColumnSeatNum = Convert.ToInt32(txt_Col.Text); if (videoHall.AddVideoHall(cvh)) { GetVideoHall(); MessageBox.Show("添加成功"); } else { MessageBox.Show("添加失败"); } GetVideoHall(); btn_Cancel.Visible = false; btn_Add.Text = "要添加"; btn_Cancel_Click(sender, e); }
/// <summary> /// 获取放映厅的信息 /// </summary> /// <returns></returns> public List<CommonVideoHall> GetVideoHallMsg() { SqlDataReader sdr = videoHall.GetVideoHallMsg(); List<CommonVideoHall> list = new List<CommonVideoHall>(); if (sdr != null) { while (sdr.Read()) { CommonVideoHall v = new CommonVideoHall(); v.VideoHallId = (int)sdr[0];//Id v.RowSeatNum = (int)sdr[2]; v.ColumnSeatNum = (int)sdr[3]; list.Add(v); } sdr.Close(); } return list; }
/// <summary> /// 添加放映厅 /// </summary> /// <param name="cvh"></param> /// <returns></returns> public int AddVideoHall(CommonVideoHall cvh) { if (IsReapt(cvh.VideoHallId)) { return 0; } string sql = " insert into VideoHall(VideoHallId,Seatings,RowSeatNum,ColumnSeatNum) " + " values(@VideoHallId,@Seatings,@RowSeatNum,@ColumnSeatNum) "; SqlParameter[] paras = { new SqlParameter("@VideoHallId",SqlDbType.Int,4), new SqlParameter("@Seatings",SqlDbType.Int,4), new SqlParameter("@RowSeatNum",SqlDbType.Int,4), new SqlParameter("@ColumnSeatNum",SqlDbType.Int,4) }; paras[0].Value = cvh.VideoHallId; paras[1].Value = cvh.Seatings; paras[2].Value = cvh.RowSeatNum; paras[3].Value = cvh.ColumnSeatNum; return SQLHelper.ExecuteNonQuery(sql, paras); }
/// <summary> /// 修改放映厅信息 /// </summary> /// <param name="cvh"></param> /// <returns></returns> public int ModifyVideoHall(int oldHallId, CommonVideoHall cvh) { if (oldHallId != cvh.VideoHallId) { if (IsReapt(cvh.VideoHallId)) { return 0; } } string sql = " update VideoHall " + " set VideoHallId=@VideoHallId,Seatings=@Seatings, " + " RowSeatNum=@RowSeatNum,ColumnSeatNum=@ColumnSeatNum " + " where VideoHallId=@oldHallId "; SqlParameter[] paras = { new SqlParameter("@VideoHallId",SqlDbType.Int,4), new SqlParameter("@Seatings",SqlDbType.Int,4), new SqlParameter("@RowSeatNum",SqlDbType.Int,4), new SqlParameter("@ColumnSeatNum",SqlDbType.Int,4), new SqlParameter("@oldHallId",SqlDbType.Int,4) }; paras[0].Value = cvh.VideoHallId; paras[1].Value = cvh.Seatings; paras[2].Value = cvh.RowSeatNum; paras[3].Value = cvh.ColumnSeatNum; paras[4].Value = oldHallId; return SQLHelper.ExecuteNonQuery(sql, paras); }
/// <summary> /// 修改放映厅信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Modify_Click(object sender, EventArgs e) { try { oldHallId = Convert.ToInt32(lbl_OldHallId.Text); } catch { return; } if (videoHall.IsVideoHallUsing(oldHallId)) { MessageBox.Show("放映厅在使用,无法修改"); return; } if (btn_Modify.Text.Contains("要")) { btn_Cancel.Visible = true; btn_Add.Enabled = false; btn_Delete.Enabled = false; lbl_ImportExport.Enabled = false; txt_VideoHallId.Enabled = true; txt_Seatings.Enabled = true; txt_Row.Enabled = true; txt_Col.Enabled = true; btn_Modify.Text = "保存修改"; return; } CommonVideoHall cvh = new CommonVideoHall(); cvh.VideoHallId = Convert.ToInt32(txt_VideoHallId.Text); cvh.Seatings = Convert.ToInt32(txt_Seatings.Text); cvh.RowSeatNum = Convert.ToInt32(txt_Row.Text); cvh.ColumnSeatNum = Convert.ToInt32(txt_Col.Text); if (videoHall.ModifyVideoHall(oldHallId, cvh)) { MessageBox.Show("修改成功"); } else { MessageBox.Show("修改失败"); } btn_Modify.Text = "要修改"; btn_Cancel.Visible = false; GetVideoHall(); btn_Cancel_Click(sender, e); }
/// <summary> /// 获取放映厅号 /// </summary> /// <returns></returns> public List<CommonVideoHall> GetVideoHallNO() { SqlDataReader sdr = videoHall.GetVideoHallNO(); List<CommonVideoHall> list = new List<CommonVideoHall>(); if (sdr != null) { while (sdr.Read()) { CommonVideoHall v = new CommonVideoHall(); v.VideoHallId = (int)sdr[0];//Id list.Add(v); } sdr.Close(); } return list; }
/// <summary> /// 修改放映厅信息 /// </summary> /// <param name="cvh"></param> /// <returns></returns> public bool ModifyVideoHall(int oldHallId, CommonVideoHall cvh) { if (videoHall.ModifyVideoHall(oldHallId, cvh) > 0) { return true; } return false; }