public void InitTodayScheduling() { Scheduling_BLL bll = new Scheduling_BLL(); DateTime today = DateTime.Parse(DateTime.Now.ToShortDateString()); string xingqi = GetWeekNumberZh(today.DayOfWeek.ToString()); Label_Today_Date.Text = today.ToString("yyyy年MM月dd日"); Label_Today_Week.Text = xingqi; Label_Today_day.Text = today.Day.ToString(); List <PF.Models.SQL.Scheduling> list = bll.GetList(a => a.Date == today).ToList(); PF.Models.SQL.Scheduling shouxi = list.Where(a => a.Work == "首席").FirstOrDefault(); if (shouxi != null) { Label_ShouXi_Today.Text = shouxi.YBUserName; } else { Label_ShouXi_Today.Text = string.Empty; } PF.Models.SQL.Scheduling lingban = list.Where(a => a.Work == "领班").FirstOrDefault(); if (lingban != null) { Label_LingBan_Today.Text = lingban.YBUserName; } else { Label_LingBan_Today.Text = string.Empty; } PF.Models.SQL.Scheduling zhiban = list.Where(a => a.Work == "值班").FirstOrDefault(); if (zhiban != null) { Label_ZhiBan_Today.Text = zhiban.YBUserName; } else { Label_ZhiBan_Today.Text = string.Empty; } PF.Models.SQL.Scheduling lianxian = list.Where(a => a.Work == "连线").FirstOrDefault(); if (lianxian != null) { Label_LianXian_Today.Text = lianxian.YBUserName; } else { Label_LianXian_Today.Text = string.Empty; } }
public void InitDay() { DateTime firstDay = DateTime.Parse(DropDownList_Year.SelectedItem.Value + "-" + DropDownList_Month.SelectedItem.Value + "-01"); DateTime endDay = firstDay.AddMonths(1); TimeSpan ts = endDay - firstDay; PF.BLL.SQL.Scheduling_BLL scbll = new Scheduling_BLL(); sclist = scbll.GetList(a => a.Date >= firstDay && a.Date < endDay).ToList(); List <Day_Scheduling_ViewModel> list = new List <Day_Scheduling_ViewModel>(); for (int i = 0; i < ts.Days; i++) { // DateTime dt = firstDay.AddDays(i); Day_Scheduling_ViewModel ds = new Day_Scheduling_ViewModel() { DayTime = firstDay.AddDays(i), DayTimeString = firstDay.AddDays(i).ToString("yyyy-MM-dd"), //Week = firstDay.AddDays(i).DayOfWeek.ToString("d"), Week = GetWeekNumber(firstDay.AddDays(i).DayOfWeek.ToString()), IsCurrentMonth = true }; list.Add(ds); } Day_Scheduling_ViewModel firstDayScheduling = list.FirstOrDefault(); int needDay = firstDayScheduling.Week - 1; for (int i = 1; i <= needDay; i++) { Day_Scheduling_ViewModel ds = new Day_Scheduling_ViewModel() { DayTime = firstDayScheduling.DayTime.AddDays(-i), DayTimeString = firstDayScheduling.DayTime.AddDays(-i).ToString("yyyy-MM-dd"), //Week = firstDay.AddDays(i).DayOfWeek.ToString("d"), Week = GetWeekNumber(firstDayScheduling.DayTime.AddDays(-i).DayOfWeek.ToString()), IsCurrentMonth = false }; list.Add(ds); } list = list.OrderBy(a => a.DayTime).ToList(); RepeaterScheduling.DataSource = list; RepeaterScheduling.DataBind(); }
protected void Repeater_YbUser_ItemDataBound(object sender, RepeaterItemEventArgs e) { BwYbs_BLL bll = new BwYbs_BLL(); Scheduling_BLL sbll = new Scheduling_BLL(); if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { Repeater Repeater_YbUser_Morning = (Repeater)e.Item.FindControl("Repeater_YbUser_Morning"); //找到分类Repeater关联的数据项 YBUsers_Date_ViewModel drv = (YBUsers_Date_ViewModel)e.Item.DataItem; //提取分类ID DateTime date = (DateTime)drv.Date; DateTime next_date = (DateTime)drv.Next_Date; //根据分类ID查询该分类下的产品,并绑定产品Repeater DateTime dateNight = date.AddMinutes(990); DateTime next_dateMorning = next_date.AddMinutes(405); List <BwYbs> mlist = bll.GetList(a => a.YBType == "早间报文" && a.YBDateTime == next_dateMorning).OrderBy(a => a.YBUserName).OrderBy(a => a.YbUsers.Order).ToList(); //List<YBUsers_ViewModel> userListM = mlist.GroupBy(a => new { a.YBUserName }).Select(a => new YBUsers_ViewModel { YBUserName = a.Key.YBUserName }).ToList(); List <Scheduling> schListMorning = sbll.GetList(a => a.Date == date && a.Work == "领班").ToList(); List <BaoWen_Check_ViewModel> bcvListMorning = new List <BaoWen_Check_ViewModel>(); BaoWen_Check_ViewModel bcv_group_morning = new BaoWen_Check_ViewModel(); bcv_group_morning.YbUserName = "******"; bcv_group_morning.Work = "集体";; bcv_group_morning.Date = date; BwYbs bwyb_group_morning = mlist.Where(a => a.YBUserName == "集体").FirstOrDefault(); if (bwyb_group_morning != null) { bcv_group_morning.IsMiss = false; bcv_group_morning.Message = ""; } else { bcv_group_morning.IsMiss = true; bcv_group_morning.Message = "(缺报)"; } bcvListMorning.Add(bcv_group_morning); foreach (Scheduling scheduling in schListMorning) { BaoWen_Check_ViewModel bcv = new BaoWen_Check_ViewModel(); bcv.Work = scheduling.Work; bcv.Date = (DateTime)scheduling.Date; bcv.YbUserName = scheduling.YBUserName; BwYbs bwyb = mlist.Where(a => a.YBUserName == scheduling.YBUserName).FirstOrDefault(); if (bwyb != null) { bcv.IsMiss = false; bcv.Message = ""; } else { bcv.IsMiss = true; bcv.Message = "(缺报)"; } bcvListMorning.Add(bcv); } Repeater_YbUser_Morning.DataSource = bcvListMorning; Repeater_YbUser_Morning.DataBind(); Repeater Repeater_YbUser_Night = (Repeater)e.Item.FindControl("Repeater_YbUser_Night"); //根据分类ID查询该分类下的产品,并绑定产品Repeater List <BwYbs> nlist = bll.GetList(a => a.YBType == "晚间报文" && a.YBDateTime == dateNight).OrderBy(a => a.YBUserName).OrderBy(a => a.YbUsers.Order).ToList(); //List<YBUsers_ViewModel> userListN = nlist.GroupBy(a => new { a.YBUserName }).Select(a => new YBUsers_ViewModel { YBUserName = a.Key.YBUserName }).ToList(); List <Scheduling> schListNight = sbll.GetList(a => a.Date == date && a.Work != "连线").OrderBy(a => a.Order).ToList(); List <BaoWen_Check_ViewModel> bcvListNight = new List <BaoWen_Check_ViewModel>(); BaoWen_Check_ViewModel bcv_group_night = new BaoWen_Check_ViewModel(); bcv_group_night.YbUserName = "******"; bcv_group_night.Work = "集体"; bcv_group_night.Date = date; BwYbs bwyb_group_night = nlist.Where(a => a.YBUserName == "集体").FirstOrDefault(); if (bwyb_group_night != null) { bcv_group_night.IsMiss = false; bcv_group_night.Message = ""; } else { bcv_group_night.IsMiss = true; bcv_group_night.Message = "(缺报)"; } bcvListNight.Add(bcv_group_night); foreach (Scheduling scheduling in schListNight) { BaoWen_Check_ViewModel bcv = new BaoWen_Check_ViewModel(); bcv.Work = scheduling.Work; bcv.Date = (DateTime)scheduling.Date; bcv.YbUserName = scheduling.YBUserName; BwYbs bwyb = nlist.Where(a => a.YBUserName == scheduling.YBUserName).FirstOrDefault(); if (bwyb != null) { bcv.IsMiss = false; bcv.Message = ""; } else { bcv.IsMiss = true; bcv.Message = "(缺报)"; } bcvListNight.Add(bcv); } Repeater_YbUser_Night.DataSource = bcvListNight; Repeater_YbUser_Night.DataBind(); } }