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 DropDownList_ShouXi_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList drd = sender as DropDownList;
Repeater rps = drd.Parent.Parent as Repeater;
int n = ((RepeaterItem)drd.Parent).ItemIndex;
HiddenField hid = (HiddenField)(rps.Items[n].FindControl("HiddenField_DayTime"));
string daystring = hid.Value;
DateTime dt = DateTime.Parse(daystring);
//已经拿到了id，可以进行操作
DropDownList ddl = (DropDownList)(rps.Items[n].FindControl("DropDownList_ShouXi"));
PF.BLL.SQL.Scheduling_BLL scbll = new Scheduling_BLL();
if (ddl.SelectedItem.Value == "未选择")
{
scbll.Delete(a => a.Date == dt && a.Work == "首席");
}
else
{
PF.Models.SQL.Scheduling sc = scbll.Get(a => a.Date == dt && a.Work == "首席");
if (sc == null)
{
sc = new Models.SQL.Scheduling()
{
SchedulingID = Guid.NewGuid(),
CreateTime = DateTime.Now,
Date = dt,
Work = "首席",
YBUserID = Guid.Parse(ddl.SelectedItem.Value),
YBUserName = ddl.SelectedItem.Text,
Order = 1
};
scbll.Add(sc);
}
else
{
sc.YBUserID = Guid.Parse(ddl.SelectedItem.Value);
sc.YBUserName = ddl.SelectedItem.Text;
sc.CreateTime = DateTime.Now;
scbll.Update(sc);
}
}
}
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();
}
}
