Esempio n. 1
0
        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();
            }
        }
Esempio n. 2
0
        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();
        }
Esempio n. 3
0
        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();
        }
Esempio n. 4
0
        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();
            }
        }