public bool SendWeekPlanMail(string office) { WeekPlanApplication weekPlanApplication = new WeekPlanApplication(); UserApplication userApp = new UserApplication(); List <UsersEntity> usersHavenotSubmitWeekPlan = new List <UsersEntity>(); List <UsersEntity> allUsers = userApp.GetActiveUserList().FindAll(u => u.Role != RolesEnum.CLIENT && u.IsNotice); List <UsersEntity> currentUsers = allUsers.FindAll(u => u.Office.ToUpper() == office.ToUpper()); DateTime weekDay = DateTime.Now; if (weekDay.DayOfWeek != DayOfWeek.Sunday) { weekDay = weekDay.AddDays(-(int)DateTime.Now.DayOfWeek).AddDays(7); } foreach (UsersEntity user in currentUsers) { WeekPlanEntity weekPlanEntity = weekPlanApplication.GetInfo(user.UserID, weekDay); if (weekPlanEntity == null) { usersHavenotSubmitWeekPlan.Add(user); } } SendWeekPlanMail(usersHavenotSubmitWeekPlan, weekDay.Date); return(true); }
protected void Page_Load(object sender, EventArgs e) { planApp = new WeekPlanApplication(); if (!IsPostBack) { BindEstimate(); int id = QS("id", 0); //修改 plan int oldplan = QS("oldplan", 0); //追加本周的计划 int isEdit = QS("isEdit", 0); WeekPlanEntity weekPlanEntity; DateTime weekDay = DateTime.Now.AddDays(7); int weekOfDay = (int)weekDay.DayOfWeek; weekOfDay = weekOfDay == 0 ? 7 : weekOfDay; weekDay = weekDay.AddDays(-weekOfDay); if (id == 0 && oldplan == 0) //添加下周计划 { weekPlanEntity = planApp.GetInfo(UserInfo.UserID, weekDay.AddDays(7)); if (weekPlanEntity == null) { lblTitle.InnerText = "Add Week Plan"; IsEdit = false; } else { BindData(weekPlanEntity); SetSelectedEstimate(weekPlanEntity); } lblNextWeek.InnerHtml = weekDay.AddDays(1).ToString("MM/dd/yyyy") + " ------ " + weekDay.AddDays(7).ToString("MM/dd/yyyy"); WeekPlanEntity old_weekPlanEntity = planApp.GetInfo(UserInfo.UserID, weekDay); if (old_weekPlanEntity == null) //本周计划没有写 { lblFrontWeek.InnerHtml = string.Format("<a href='WeekPlanEdit.aspx?oldplan=1'>{0} ------ {1}</a>" , weekDay.AddDays(-6).ToString("MM/dd/yyyy"), weekDay.ToString("MM/dd/yyyy")); } else {//有写本周计划 lblFrontWeek.InnerHtml = string.Format("<a href='WeekPlanEdit.aspx?id={2}'>{0} ------ {1}</a>" , weekDay.AddDays(-6).ToString("MM/dd/yyyy"), weekDay.ToString("MM/dd/yyyy"), old_weekPlanEntity.ID); } BindImport(); } else if (id == 0 && oldplan == 1) //追加本周计划 { lblTitle.InnerText = "Add Week Plan"; lblFrontWeek.InnerHtml = weekDay.AddDays(-6).ToString("MM/dd/yyyy") + " ------ " + weekDay.ToString("MM/dd/yyyy"); lblNextWeek.InnerHtml = string.Format("<a href='WeekPlanEdit.aspx'>{0} ------ {1}</a>" , weekDay.AddDays(1).ToString("MM/dd/yyyy"), weekDay.AddDays(7).ToString("MM/dd/yyyy")); IsEdit = false; BindImport(); } else if (id > 0 && oldplan == 0) //编辑周计划 { if (UserInfo.Role == RolesEnum.ADMIN || UserInfo.Role == RolesEnum.PM || UserInfo.Role == RolesEnum.Sales) { weekPlanEntity = planApp.GetInfo(id); } else { weekPlanEntity = planApp.GetInfo(id, UserInfo.UserID); } if (weekPlanEntity == null) { lblTitle.InnerText = "Add Week Plan"; lblFrontWeek.InnerHtml = weekDay.AddDays(-6).ToString("MM/dd/yyyy") + " ------ " + weekDay.ToString("MM/dd/yyyy"); IsEdit = false; BindImport(); } else { BindData(weekPlanEntity); SetSelectedEstimate(weekPlanEntity); } if (isEdit == 0) { lblNextWeek.InnerHtml = string.Format("<a href='WeekPlanEdit.aspx'>{0} ------ {1}</a>" , weekDay.AddDays(1).ToString("MM/dd/yyyy"), weekDay.AddDays(7).ToString("MM/dd/yyyy")); } } else { lblNextWeek.InnerHtml = "<span style='color: Red;'>unauthorized access</span>"; btnSave.Visible = false; } } int result; int.TryParse(ddlImport.SelectedValue, out result); if (result > 0) { IsEdit = false; } }
public bool SyncWeekPlan(TimeSheetsEntity model) { WeekPlanApplication planApp = new WeekPlanApplication(); DateTime weekDay = model.SheetDate; //DateTime weekDay = DateTime.Now.AddDays(7); int weekOfDay = (int)weekDay.DayOfWeek; weekOfDay = weekOfDay == 0 ? 7 : weekOfDay; weekDay = weekDay.AddDays(-weekOfDay).AddDays(7); List <TimeSheetTicket> listTimeSheetTicket = GetTimesheetTicket(0, model.SheetDate, model.SheetDate, false, UserID, 0); string description = ""; string tickets = ""; decimal hours = 0; foreach (var timeSheet in listTimeSheetTicket) { description += timeSheet.TicketID + ": " + timeSheet.TicketTitle + "\r\n"; tickets += timeSheet.TicketID + "_"; hours += timeSheet.Hours; } WeekPlanEntity entity = planApp.GetInfo(UserID, weekDay); if (entity == null) { entity = new WeekPlanEntity(); entity.WeekDay = weekDay.Date; entity.UserID = UserInfo.UserID; entity.CreateDate = DateTime.Now; entity.UpdateDate = DateTime.Now; entity.UpdateUserID = UserInfo.UserID; entity.IsDeleted = false; entity.Monday = ""; entity.MondayTickets = ""; entity.MondayEstimate = 0; entity.Tuesday = ""; entity.TuesdayTickets = ""; entity.TuesdayEstimate = 0; entity.Wednesday = ""; entity.WednesdayTickets = ""; entity.WednesdayEstimate = 0; entity.Thursday = ""; entity.ThursdayTickets = ""; entity.ThursdayEstimate = 0; entity.Friday = ""; entity.FridayTickets = ""; entity.FridayEstimate = 0; entity.Saturday = ""; entity.SaturdayTickets = ""; entity.SaturdayEstimate = 0; entity.Sunday = ""; entity.SundayTickets = ""; entity.SundayEstimate = 0; } switch (weekOfDay) { case 1: entity.Monday = description; entity.MondayTickets = tickets; entity.MondayEstimate = (int)hours; break; case 2: entity.Tuesday = description; entity.TuesdayTickets = tickets; entity.TuesdayEstimate = (int)hours; break; case 3: entity.Wednesday = description; entity.WednesdayTickets = tickets; entity.WednesdayEstimate = (int)hours; break; case 4: entity.Thursday = description; entity.ThursdayTickets = tickets; entity.ThursdayEstimate = (int)hours; break; case 5: entity.Friday = description; entity.FridayTickets = tickets; entity.FridayEstimate = (int)hours; break; case 6: entity.Saturday = description; entity.SaturdayTickets = tickets; entity.SaturdayEstimate = (int)hours; break; case 7: entity.Sunday = description; entity.SundayTickets = tickets; entity.SundayEstimate = (int)hours; break; } if (entity.ID > 0) { return(planApp.Update(entity, true)); } else { return(planApp.Add(entity) > 0); } }
protected void Page_Load(object sender, EventArgs e) { planApp = new WeekPlanApplication(); if (!IsPostBack) { BindEstimate(); int id = QS("id", 0); //修改 plan int oldplan = QS("oldplan", 0); //追加本周的计划 WeekPlanEntity weekPlanEntity; DateTime weekDay = DateTime.Now; if (weekDay.DayOfWeek != DayOfWeek.Sunday) { weekDay = weekDay.AddDays(-(int)DateTime.Now.DayOfWeek).AddDays(7); } if (id == 0 && oldplan == 0) //添加下周计划 { weekPlanEntity = planApp.GetInfo(UserInfo.UserID, weekDay); if (weekPlanEntity == null) { lblTitle.InnerText = "Add Week Plan"; lblStart.InnerText = weekDay.ToString("MM/dd/yyyy"); lblEnd.InnerText = weekDay.AddDays(6).ToString("MM/dd/yyyy"); IsEdit = false; WeekPlanEntity old_weekPlanEntity = planApp.GetInfo(UserInfo.UserID, weekDay.AddDays(-7)); if (old_weekPlanEntity == null) //本周计划没有写 { lblAddPlan.InnerHtml = string.Format("<a href='weekplanEdit.aspx?oldplan=1'>{0} ------ {1}</a>" , weekDay.AddDays(-7).ToString("MM/dd/yyyy"), weekDay.AddDays(-1).ToString("MM/dd/yyyy")); } else {//有写本周计划 lblAddPlan.InnerHtml = string.Format("<a href='weekplanEdit.aspx?id={2}'>{0} ------ {1}</a>" , weekDay.AddDays(-7).ToString("MM/dd/yyyy"), weekDay.AddDays(-1).ToString("MM/dd/yyyy"), old_weekPlanEntity.ID); } BindImport(); } else { BindData(weekPlanEntity); SetSelectedEstimate(weekPlanEntity); } } else if (id == 0 && oldplan == 1) //追加本周计划 { weekDay = weekDay.AddDays(-7); lblTitle.InnerText = "Add Week Plan"; lblStart.InnerText = weekDay.ToString("MM/dd/yyyy"); lblEnd.InnerText = weekDay.AddDays(6).ToString("MM/dd/yyyy"); } else if (id > 0 && oldplan == 0) //编辑周计划 { if (UserInfo.Role == RolesEnum.ADMIN || UserInfo.Role == RolesEnum.PM || UserInfo.Role == RolesEnum.Sales) { weekPlanEntity = planApp.GetInfo(id); } else { weekPlanEntity = planApp.GetInfo(id, UserInfo.UserID); } if (weekPlanEntity == null) { lblTitle.InnerText = "Add Week Plan"; lblStart.InnerText = weekDay.ToString("MM/dd/yyyy"); lblEnd.InnerText = weekDay.AddDays(6).ToString("MM/dd/yyyy"); IsEdit = false; BindImport(); } else { BindData(weekPlanEntity); SetSelectedEstimate(weekPlanEntity); } } else { lblAddPlan.InnerHtml = "<span style='color: Red;'>unauthorized access</span>"; btnOK.Visible = false; btnSave.Visible = false; } } }