protected void Repeater_YbUser_ItemDataBound(object sender, RepeaterItemEventArgs e) { Score_Day_BLL bll = new Score_Day_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 List <Score_Day> mlist = bll.GetList(a => a.YBTime == "08时" && a.YBDate == next_date).OrderBy(a => a.YBUserName).OrderBy(a => a.YbUsers.Order).ToList(); Repeater_YbUser_Morning.DataSource = mlist; Repeater_YbUser_Morning.DataBind(); Repeater Repeater_YbUser_Night = (Repeater)e.Item.FindControl("Repeater_YbUser_Night"); //根据分类ID查询该分类下的产品,并绑定产品Repeater List <Score_Day> nlist = bll.GetList(a => a.YBTime == "20时" && a.YBDate == date).OrderBy(a => a.YBUserName).OrderBy(a => a.YbUsers.Order).ToList(); Repeater_YbUser_Night.DataSource = nlist; Repeater_YbUser_Night.DataBind(); } }
protected void Btn_DataCheck_BaoWen_Click(object sender, EventArgs e) { DateTime startTime = DateTime.Parse(DDL_Year_BaoWen.SelectedItem.Value + "-" + DDL_Month_BaoWen.SelectedItem.Value + "-01").AddDays(-1); DateTime endTime = startTime.AddMonths(1); //BaoWens_BLL bwBll = new BaoWens_BLL(); //List<BaoWens> bwList = bwBll.GetList(a => a.YBDateTime >= startTime && a.YBDateTime < endTime && // a.BWType == DDL_Type_BaoWen.SelectedItem.Value).ToList(); List <YBUsers_Date_ViewModel> list = new List <YBUsers_Date_ViewModel>(); TimeSpan ts = endTime - startTime; for (int i = 0; i < ts.Days; i++) { YBUsers_Date_ViewModel vm = new YBUsers_Date_ViewModel() { Date = startTime.AddDays(i), Next_Date = startTime.AddDays(i + 1), }; list.Add(vm); } Repeater_YbUser.DataSource = list; Repeater_YbUser.DataBind(); }
public void Query() { DateTime startTime = DateTime.Parse(DropDownList_Year.SelectedItem.Value + "-" + DropDownList_Month.SelectedItem.Value + "-01"); DateTime endTime = startTime.AddMonths(1).AddDays(-1); //YbUsers_BLL bll = new YbUsers_BLL(); Score_Day_BLL bll = new Score_Day_BLL(); //List<Score_Day> list = bll.GetList(a => a.YBTime == DropDownList_YBTime.SelectedItem.Value && a.YBDate >= startTime && a.YBDate < endTime).OrderBy(a=>a.YBDate).ToList(); //var List <YBUsers_Date_ViewModel> list = new List <YBUsers_Date_ViewModel>(); TimeSpan ts = endTime - startTime; for (int i = 0; i <= ts.Days; i++) { YBUsers_Date_ViewModel vm = new YBUsers_Date_ViewModel() { Date = startTime.AddDays(i), Next_Date = startTime.AddDays(i + 1), }; list.Add(vm); } Repeater_YbUser.DataSource = list; Repeater_YbUser.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(); } }