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;
}
}
}
