public void update(List <string> timecells, DateTime fromDate, DateTime toDate)
{
convertToMap(timecells);// Key:date Value: timecells
ScheduleDAL dal = new ScheduleDAL();
SqlConnection conn = DBManager.getSqlConnection();
conn.Open();
// foreach (String dtStr in this.timeCellMap.Keys)
DateTime dateRange = fromDate;
while (dateRange <= toDate)
{
DateTime scheduleDate = dateRange;//Util.StringToDate(dtStr) ?? DateTime.MaxValue;
dal.delete(conn, this.userId, scheduleDate);
dateRange = dateRange.AddDays(1);
}
foreach (String dtStr in this.timeCellMap.Keys)
{
DateTime scheduleDate = Util.StringToDate(dtStr) ?? DateTime.MaxValue;
var fromToList = mergeCells(timeCellMap[dtStr]);
foreach (Dictionary <String, DateTime> fromTo in fromToList)
{
if (fromTo != null)
{
dal.insert(conn, this.userId, scheduleDate, fromTo["From"], fromTo["To"].AddMinutes(30), "Y");
}
}
}
conn.Close();
}
public void readGroupSchedule(DateTime?start, DateTime?end)
{
ScheduleDAL scheduleDAL = new ScheduleDAL();
scheduleDAL.userId = this.userId;
scheduleDAL.scheduleId = this.scheduleId;
scheduleDAL.freeSlot = this.freeSlot;
scheduleDAL.freeSlotTimeFrom = this.freeSlotTimeFrom;
scheduleDAL.freeSlotTimeTo = this.freeSlotTimeTo;
scheduleList = scheduleDAL.readSchedule(this.groupId, start, end);
}
private Schedules GetScheduleExecQuery(string query)
{
Schedules sche = new Schedules();
using (connection = DBHelper.OpenConnection()) {
MySqlCommand cmd = new MySqlCommand(query, connection);
using (reader = cmd.ExecuteReader()) {
if (reader.Read())
{
sche = ScheduleDAL.GetSchedule(reader);
}
}
}
return(sche);
}
public DataTable GetStartEndShift(string username)
{
try
{
ScheduleDAL objShift = new ScheduleDAL();
DataTable dt = new DataTable();
dt = objShift.ReadStartEndShift(username);
foreach (DataRow dr in dt.Rows)
{
startShift = dr["StartShift"].ToString();
endShift = dr["EndShift"].ToString();
}
return(dt);
}
catch { throw; }
}
public DataTable GetShiftDetails(string username)
{
try
{
ScheduleDAL objShift = new ScheduleDAL();
DataTable dt = new DataTable();
dt = objShift.ReadNextShiftByUsername(username);
foreach (DataRow dr in dt.Rows)
{
date = dr["Date"].ToString();
dateTime = DateTime.Parse(date);
startShift = dr["StartShift"].ToString();
endShift = dr["EndShift"].ToString();
nextShift = startShift + " - " + endShift;
}
return(dt);
}
catch { throw; }
}
/// <summary>
/// 初始化TreeView控件
/// </summary>
private void InitTreeView()
{
tvMovies.BeginUpdate();
tvMovies.Nodes.Clear();
TreeNode movieNode = null;
foreach (Movie m in MovieDAL.GetAllMovies())
{
movieNode = new TreeNode(m.MovieName);
tvMovies.Nodes.Add(movieNode);
foreach (Schedule s in ScheduleDAL.GetSchedulesByMovieID(m.MovieID))
{
TreeNode timeNode = new TreeNode(s.DateTime);
timeNode.Name = s.ScheduleID.ToString();
movieNode.Nodes.Add(timeNode);
}
}
tvMovies.EndUpdate();
}
public ScheduleBUS()
{
scheduleDAL = new ScheduleDAL();
}
private void tvMovies_AfterSelect(object sender, TreeViewEventArgs e)
{
/// <summary>
/// 选择一场电影事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
TreeNode node = tvMovies.SelectedNode;
if (node == null)
{
return;
}
if (node.Level != 1)
{
return;
}
int sID = int.Parse(node.Name);
Schedule s = null;
Movie m = null;
s = ScheduleDAL.GetScheduleByScheduleID(sID);
if (s == null)
{
MessageBox.Show("s should not be null");
return;
}
m = MovieDAL.GetMovieByMovieID(s.MovieID);
if (m == null)
{
MessageBox.Show("m should not be null");
return;
}
//将详细信息显示
this.lblMovieName.Text = m.MovieName;
this.lblDirector.Text = m.Director;
this.lblActor.Text = m.Actor;
this.lblPrice.Text = s.Price.ToString();
this.lblTime.Text = s.DateTime;
this.lblType.Text = m.MovieType;
this.picMovie.Image = Image.FromFile(m.Poster);
if (this.customerVIP != null)
{
this.lblCalcPrice.Text = (s.Price * 0.8).ToString();
}
else
{
this.lblCalcPrice.Text = lblPrice.Text;
}
otherHallIDs.Clear();
foreach (int hID in AllHallIDs)
{
if (hID == s.HallID)
{
continue;
}
otherHallIDs.Add(hID);
}
//清空座位
ReSetSeats(s.HallID);
//遍历该场电影的座位销售情况
foreach (Ticket t in TicketDAL.GetTicketsByScheduleID(sID))
{
foreach (Seat seat in seats[s.HallID].Values)
{
if (t.DetailSeat == seat.SeatNum)
{
seat.Color = Color.LightCoral;
}
}
}
UpdateSeats(s.HallID);
tbSeat.SelectedTab = tbSeat.TabPages[s.HallID - 1];
}
public ScheduleBLL()
{
data = new ScheduleDAL();
}
