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(); }