/// <summary>
/// 添加排好的影片信息
/// </summary>
public int AddFilmSchedule(CommonFilmSchedule cfilmSchedule)
{
string sql = " insert into dbo.FilmSchedule " +
" values(@FilmId,@FilmName,@VideoHallId,@FilmBeginTime,@FilmEndTime,@FilmBeginId,@FilmEndId,@ReleaseDates,@TicketPrice,@PreferentialPrice,@SellTickets) ";
SqlParameter[] paras = {
new SqlParameter("@FilmId",SqlDbType.Int,4),
new SqlParameter("@FilmName",SqlDbType.VarChar,50),
new SqlParameter("@VideoHallId",SqlDbType.Int,4),
new SqlParameter("@FilmBeginTime",SqlDbType.VarChar,50),
new SqlParameter("@FilmEndTime",SqlDbType.VarChar,50),
new SqlParameter("@FilmBeginId",SqlDbType.Int,4),
new SqlParameter("@FilmEndId",SqlDbType.Int,4),
new SqlParameter("@ReleaseDates",SqlDbType.Date),
new SqlParameter("@TicketPrice",SqlDbType.Int,4),
new SqlParameter("@PreferentialPrice",SqlDbType.Int,4),
new SqlParameter("@SellTickets",SqlDbType.Int,4)
};
paras[0].Value = cfilmSchedule.FilmId;
paras[1].Value = cfilmSchedule.FilmName;
paras[2].Value = cfilmSchedule.VideoHallId;
paras[3].Value = cfilmSchedule.FilmBeginTime;
paras[4].Value = cfilmSchedule.FilmEndTime;
paras[5].Value = cfilmSchedule.FilmBeginId;
paras[6].Value = cfilmSchedule.FilmEndId;
paras[7].Value = cfilmSchedule.ReleaseDates;
paras[8].Value = cfilmSchedule.TicketPrice;
paras[9].Value = cfilmSchedule.PreferentialPrice;
//电影票刚开始默认为0
paras[10].Value = 0;
return SQLHelper.ExecuteNonQuery(sql, paras);
}
/// <summary>
/// 添加排好的影片信息
/// </summary>
public bool AddFilmSchedule(CommonFilmSchedule cfilmSchedule)
{
if (filmSchedule.AddFilmSchedule(cfilmSchedule) > 0)
{
return true;
}
return false;
}
/// <summary>
/// 保存排好的影片信息
/// </summary>
private void AddFilmSchedule(int filmId, CommonFilmSchedule cfilmSchedule)
{
//保存排好的影片信息
bool rAdd = filmSchedule.AddFilmSchedule(cfilmSchedule);
//记录排片次数
bool rTime = filmMsg.AddScheduleTime(filmId);
if (rAdd && rTime)
{
//刷新dgv控件
GetNoScheduleFilm();
MessageBox.Show("影片已排好");
}
}
/// <summary>
/// 修改排好的片信息
/// </summary>
/// <param name="cfilmSchedule"></param>
/// <returns></returns>
public int ModifyScheduledFilm(int scheduleId, CommonFilmSchedule cfilmSchedule)
{
string sql = " update dbo.FilmSchedule " +
" set VideoHallId=@VideoHallId, FilmBeginTime=@FilmBeginTime," +
" FilmEndTime=@FilmEndTime,FilmBeginId=@FilmBeginId,FilmEndId=@FilmEndId, " +
" ReleaseDates=@ReleaseDates,TicketPrice=@TicketPrice, " +
" PreferentialPrice=@PreferentialPrice " +
" where ScheduleId=@scheduleId ";
SqlParameter[] paras = {
new SqlParameter("@VideoHallId",SqlDbType.Int,4),
new SqlParameter("@FilmBeginTime",SqlDbType.VarChar,50),
new SqlParameter("@FilmEndTime",SqlDbType.VarChar,50),
new SqlParameter("@FilmBeginId",SqlDbType.Int,4),
new SqlParameter("@FilmEndId",SqlDbType.Int,4),
new SqlParameter("@ReleaseDates",SqlDbType.Date),
new SqlParameter("@scheduleId",SqlDbType.Int,4),
new SqlParameter("@TicketPrice",SqlDbType.Int,4),
new SqlParameter("@PreferentialPrice",SqlDbType.Int,4)
};
paras[0].Value = cfilmSchedule.VideoHallId;
paras[1].Value = cfilmSchedule.FilmBeginTime;
paras[2].Value = cfilmSchedule.FilmEndTime;
paras[3].Value = cfilmSchedule.FilmBeginId;
paras[4].Value = cfilmSchedule.FilmEndId;
paras[5].Value = cfilmSchedule.ReleaseDates;
paras[6].Value = scheduleId;
paras[7].Value = cfilmSchedule.TicketPrice;
paras[8].Value = cfilmSchedule.PreferentialPrice;
return SQLHelper.ExecuteNonQuery(sql, paras);
}
/// <summary>
/// 点击确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_confirm_Click(object sender, EventArgs e)
{
int filmId = 0;
int scheduleId = 0;
try
{
filmId = Convert.ToInt32(lbl_filmId.Text);//电影Id
if (grp_schedule.Text.Contains("已排"))
{
scheduleId = Convert.ToInt32(lbl_scheduleId.Text);//排片Id
}
}
catch (FormatException)
{
MessageBox.Show("请选择影片!");
return;
}
CommonFilmSchedule cfilmSchedule = new CommonFilmSchedule();
//将控件数据存入CommonFilmSchedule类
if (!ControlsToCommon(filmId, cfilmSchedule))
{
return;
}
//已排情况下,点击下架
if (rdo_unshelve.Checked)
{
Unshelve(filmId, scheduleId);
}
//检查排片是否重复
if (filmSchedule.IsScheduleTimeRepeat(scheduleId, cfilmSchedule))
{
MessageBox.Show("不要重复排片");
return;
}
//保存信息
if (grp_schedule.Text.Contains("待排"))
{
AddFilmSchedule(filmId, cfilmSchedule);
}
if (grp_schedule.Text.Contains("已排"))
{
ModifyScheduledFilm(scheduleId, cfilmSchedule);
}
}
/// <summary>
/// 修改排好的影片信息
/// </summary>
/// <param name="scheduleId"></param>
/// <param name="cfilmSchedule"></param>
private void ModifyScheduledFilm(int scheduleId, CommonFilmSchedule cfilmSchedule)
{
//修改排好的影片信息
bool re = filmSchedule.ModifyScheduledFilm(scheduleId, cfilmSchedule);
if (re)
{
//刷新dgv控件
GetScheduledFilm();
}
}
/// <summary>
/// 将控件数据存入CommonFilmSchedule类
/// </summary>
private bool ControlsToCommon(int filmId, CommonFilmSchedule cfilmSchedule)
{
//将控件数据存入CommonFilmSchedule类
cfilmSchedule.FilmId = filmId;
cfilmSchedule.FilmName = txt_filmName.Text;
if (cbo_videoHallNO.Text.Contains("请选择"))
{
MessageBox.Show("请选择放映厅");
return false;
}
cfilmSchedule.VideoHallId = Convert.ToInt32(cbo_videoHallNO.SelectedValue);
CommonSchedule schedule = (CommonSchedule)cbo_filmBeginTime.SelectedItem;
if (schedule.Time.Contains("请选择"))
{
MessageBox.Show("请选择影片开始时间");
return false;
}
cfilmSchedule.FilmBeginTime = schedule.Time;
cfilmSchedule.FilmEndTime = txt_filmEndTime.Text;
cfilmSchedule.FilmBeginId = schedule.Id;
cfilmSchedule.FilmEndId = schedule.Id + 5;
cfilmSchedule.TicketPrice = Convert.ToInt32(txt_ticketPrice.Text.Trim());
cfilmSchedule.PreferentialPrice = Convert.ToInt32(txt_preferentialPrice.Text.Trim());
//转换为yyyy/mm/dd
string releaseDates = Convert.ToString(dtp_ReleaseDates.Value.Date);
cfilmSchedule.ReleaseDates = releaseDates.Substring(0, releaseDates.LastIndexOf('/'));
return true;
}
/// <summary>
/// 检查排片时间段是否重合
/// </summary>
/// <param name="cfilmSchedule"></param>
/// <param name="op"></param>
/// <returns></returns>
public bool IsScheduleTimeRepeat(int scheduleId, CommonFilmSchedule cfilmSchedule)
{
int obj = (int)filmSchedule.IsScheduleTimeRepeat(scheduleId, cfilmSchedule.VideoHallId,
cfilmSchedule.ReleaseDates, cfilmSchedule.FilmBeginId, cfilmSchedule.FilmEndId);
if (obj > 0)
{
return true;
}
return false;
}
/// <summary>
/// 修改排好的片信息
/// </summary>
/// <param name="cfilmSchedule"></param>
/// <returns></returns>
public bool ModifyScheduledFilm(int scheduleId, CommonFilmSchedule cfilmSchedule)
{
if (filmSchedule.ModifyScheduledFilm(scheduleId, cfilmSchedule) > 0)
{
return true;
}
return false;
}
