public int Insert(WeekPlanEntity weekPlanEntity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WeekPlan set IsDeleted=1 where UserID=@UserID and WeekDay=@WeekDay ;");
strSql.Append("insert into WeekPlan(");
strSql.Append("UserID,[WeekDay],CreateDate,UpdateDate,UpdateUserID,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,IsDeleted");
strSql.Append(",MondayEstimate,TuesdayEstimate,WednesdayEstimate,ThursdayEstimate,FridayEstimate,SaturdayEstimate,SundayEstimate " +
",[SundayTickets],[MondayTickets],[TuesdayTickets],[WednesdayTickets],[ThursdayTickets],[FridayTickets],[SaturdayTickets])");
strSql.Append(" values (");
strSql.Append("@UserID,@WeekDay,@CreateDate,@UpdateDate,@UpdateUserID,@Sunday,@Monday,@Tuesday,@Wednesday,@Thursday,@Friday,@Saturday,@IsDeleted");
strSql.Append(",@MondayEstimate,@TuesdayEstimate,@WednesdayEstimate,@ThursdayEstimate,@FridayEstimate,@SaturdayEstimate,@SundayEstimate" +
",@SundayTickets ,@MondayTickets ,@TuesdayTickets ,@WednesdayTickets ,@ThursdayTickets ,@FridayTickets ,@SaturdayTickets)");
strSql.Append(";select ISNULL( SCOPE_IDENTITY(),0);");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
db.AddInParameter(dbCommand, "UserID", DbType.Int32, weekPlanEntity.UserID);
db.AddInParameter(dbCommand, "WeekDay", DbType.DateTime, weekPlanEntity.WeekDay.Date);
db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, weekPlanEntity.CreateDate);
db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, weekPlanEntity.UpdateDate);
db.AddInParameter(dbCommand, "UpdateUserID", DbType.Int32, weekPlanEntity.UpdateUserID);
db.AddInParameter(dbCommand, "Sunday", DbType.String, weekPlanEntity.Sunday);
db.AddInParameter(dbCommand, "Monday", DbType.String, weekPlanEntity.Monday);
db.AddInParameter(dbCommand, "Tuesday", DbType.String, weekPlanEntity.Tuesday);
db.AddInParameter(dbCommand, "Wednesday", DbType.String, weekPlanEntity.Wednesday);
db.AddInParameter(dbCommand, "Thursday", DbType.String, weekPlanEntity.Thursday);
db.AddInParameter(dbCommand, "Friday", DbType.String, weekPlanEntity.Friday);
db.AddInParameter(dbCommand, "Saturday", DbType.String, weekPlanEntity.Saturday);
db.AddInParameter(dbCommand, "MondayEstimate", DbType.String, weekPlanEntity.MondayEstimate);
db.AddInParameter(dbCommand, "TuesdayEstimate", DbType.String, weekPlanEntity.TuesdayEstimate);
db.AddInParameter(dbCommand, "WednesdayEstimate", DbType.String, weekPlanEntity.WednesdayEstimate);
db.AddInParameter(dbCommand, "ThursdayEstimate", DbType.String, weekPlanEntity.ThursdayEstimate);
db.AddInParameter(dbCommand, "FridayEstimate", DbType.String, weekPlanEntity.FridayEstimate);
db.AddInParameter(dbCommand, "SaturdayEstimate", DbType.String, weekPlanEntity.SaturdayEstimate);
db.AddInParameter(dbCommand, "SundayEstimate", DbType.String, weekPlanEntity.SundayEstimate);
db.AddInParameter(dbCommand, "SundayTickets", DbType.String, weekPlanEntity.SundayTickets);
db.AddInParameter(dbCommand, "MondayTickets", DbType.String, weekPlanEntity.MondayTickets);
db.AddInParameter(dbCommand, "TuesdayTickets", DbType.String, weekPlanEntity.TuesdayTickets);
db.AddInParameter(dbCommand, "WednesdayTickets", DbType.String, weekPlanEntity.WednesdayTickets);
db.AddInParameter(dbCommand, "ThursdayTickets", DbType.String, weekPlanEntity.ThursdayTickets);
db.AddInParameter(dbCommand, "FridayTickets", DbType.String, weekPlanEntity.FridayTickets);
db.AddInParameter(dbCommand, "SaturdayTickets", DbType.String, weekPlanEntity.SaturdayTickets);
db.AddInParameter(dbCommand, "IsDeleted", DbType.String, weekPlanEntity.IsDeleted);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
}
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);
}
public bool Update(WeekPlanEntity entity, bool isVerify)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WeekPlan")
.Append(" set UpdateDate =@UpdateDate ,UpdateUserID=@UpdateUserID,Sunday=@Sunday,Monday=@Monday,Tuesday=@Tuesday")
.Append(",Wednesday=@Wednesday,Thursday=@Thursday,Friday=@Friday,Saturday=@Saturday,MondayEstimate=@MondayEstimate")
.Append(",TuesdayEstimate=@TuesdayEstimate,WednesdayEstimate=@WednesdayEstimate,ThursdayEstimate=@ThursdayEstimate")
.Append(",FridayEstimate=@FridayEstimate,SaturdayEstimate=@SaturdayEstimate,SundayEstimate=@SundayEstimate")
.Append(",SundayTickets=@SundayTickets,MondayTickets=@MondayTickets,TuesdayTickets=@TuesdayTickets,WednesdayTickets=@WednesdayTickets")
.Append(",ThursdayTickets=@ThursdayTickets,FridayTickets=@FridayTickets,SaturdayTickets=@SaturdayTickets")
;
if (isVerify)
{
strSql.Append(" where id=@id and UserId = @UpdateUserID");
}
else
{
strSql.Append(" where id=@id");
}
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
db.AddInParameter(dbCommand, "id", DbType.Int32, entity.ID);
db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, entity.UpdateDate);
db.AddInParameter(dbCommand, "UpdateUserID", DbType.Int32, entity.UpdateUserID);
db.AddInParameter(dbCommand, "Sunday", DbType.String, entity.Sunday);
db.AddInParameter(dbCommand, "Monday", DbType.String, entity.Monday);
db.AddInParameter(dbCommand, "Tuesday", DbType.String, entity.Tuesday);
db.AddInParameter(dbCommand, "Wednesday", DbType.String, entity.Wednesday);
db.AddInParameter(dbCommand, "Thursday", DbType.String, entity.Thursday);
db.AddInParameter(dbCommand, "Friday", DbType.String, entity.Friday);
db.AddInParameter(dbCommand, "Saturday", DbType.String, entity.Saturday);
db.AddInParameter(dbCommand, "MondayEstimate", DbType.String, entity.MondayEstimate);
db.AddInParameter(dbCommand, "TuesdayEstimate", DbType.String, entity.TuesdayEstimate);
db.AddInParameter(dbCommand, "WednesdayEstimate", DbType.String, entity.WednesdayEstimate);
db.AddInParameter(dbCommand, "ThursdayEstimate", DbType.String, entity.ThursdayEstimate);
db.AddInParameter(dbCommand, "FridayEstimate", DbType.String, entity.FridayEstimate);
db.AddInParameter(dbCommand, "SaturdayEstimate", DbType.String, entity.SaturdayEstimate);
db.AddInParameter(dbCommand, "SundayEstimate", DbType.String, entity.SundayEstimate);
db.AddInParameter(dbCommand, "SundayTickets", DbType.String, entity.SundayTickets);
db.AddInParameter(dbCommand, "MondayTickets", DbType.String, entity.MondayTickets);
db.AddInParameter(dbCommand, "TuesdayTickets", DbType.String, entity.TuesdayTickets);
db.AddInParameter(dbCommand, "WednesdayTickets", DbType.String, entity.WednesdayTickets);
db.AddInParameter(dbCommand, "ThursdayTickets", DbType.String, entity.ThursdayTickets);
db.AddInParameter(dbCommand, "FridayTickets", DbType.String, entity.FridayTickets);
db.AddInParameter(dbCommand, "SaturdayTickets", DbType.String, entity.SaturdayTickets);
return(db.ExecuteNonQuery(dbCommand) > 0);
}
}
private void SetSelectedEstimate(WeekPlanEntity weekPlanEntity)
{
ddlSundayEst.SelectedValue = weekPlanEntity.SundayEstimate.ToString();
ddlMondayEst.SelectedValue = weekPlanEntity.MondayEstimate.ToString();
ddlTuesdayEst.SelectedValue = weekPlanEntity.TuesdayEstimate.ToString();
ddlWednesdayEst.SelectedValue = weekPlanEntity.WednesdayEstimate.ToString();
ddlThursdayEst.SelectedValue = weekPlanEntity.ThursdayEstimate.ToString();
ddlFridayEst.SelectedValue = weekPlanEntity.FridayEstimate.ToString();
ddlSaturdayEst.SelectedValue = weekPlanEntity.SaturdayEstimate.ToString();
}
private void BindData(WeekPlanEntity entity)
{
hfID.Value = entity.ID.ToString();
lblTitle.InnerText = "Edit Week Plan";
lblStart.InnerText = entity.WeekDay.ToString("MM/dd/yyyy");
lblEnd.InnerText = entity.WeekDay.AddDays(6).ToString("MM/dd/yyyy");
txtSunday.Text = entity.Sunday.Replace("<br>", "\r\n");;
txtMonday.Text = entity.Monday.Replace("<br>", "\r\n");;
txtTuesday.Text = entity.Tuesday.Replace("<br>", "\r\n");;
txtWednesday.Text = entity.Wednesday.Replace("<br>", "\r\n");;
txtThursday.Text = entity.Thursday.Replace("<br>", "\r\n");;
txtFriday.Text = entity.Friday.Replace("<br>", "\r\n");;
txtSaturday.Text = entity.Saturday.Replace("<br>", "\r\n");;
}
private void SetSelectedEstimate(WeekPlanEntity weekPlanEntity)
{
ddlSundayEst.SelectedValue = weekPlanEntity.SundayEstimate.ToString();
ddlMondayEst.SelectedValue = weekPlanEntity.MondayEstimate.ToString();
ddlTuesdayEst.SelectedValue = weekPlanEntity.TuesdayEstimate.ToString();
ddlWednesdayEst.SelectedValue = weekPlanEntity.WednesdayEstimate.ToString();
ddlThursdayEst.SelectedValue = weekPlanEntity.ThursdayEstimate.ToString();
ddlFridayEst.SelectedValue = weekPlanEntity.FridayEstimate.ToString();
ddlSaturdayEst.SelectedValue = weekPlanEntity.SaturdayEstimate.ToString();
//set remaining hours
txtMondayRemaining.Value = (24 - weekPlanEntity.MondayEstimate).ToString();
txtTuesdayRemaining.Value = (24 - weekPlanEntity.TuesdayEstimate).ToString();
txtWednesdayRemaining.Value = (24 - weekPlanEntity.WednesdayEstimate).ToString();
txtThursdayRemaining.Value = (24 - weekPlanEntity.ThursdayEstimate).ToString();
txtFridayRemaining.Value = (24 - weekPlanEntity.FridayEstimate).ToString();
txtSaturdayRemaining.Value = (24 - weekPlanEntity.SaturdayEstimate).ToString();
txtSundayRemaining.Value = (24 - weekPlanEntity.SundayEstimate).ToString();
}
private void BindData(WeekPlanEntity entity)
{
hfID.Value = entity.ID.ToString();
lblTitle.InnerText = "Edit Week Plan";
lblFrontWeek.InnerHtml = entity.WeekDay.AddDays(-6).ToString("MM/dd/yyyy") + " ------ "
+ entity.WeekDay.ToString("MM/dd/yyyy");
txtSunday.Text = entity.Sunday.Replace("<br>", "\r\n");;
txtMonday.Text = entity.Monday.Replace("<br>", "\r\n");;
txtTuesday.Text = entity.Tuesday.Replace("<br>", "\r\n");;
txtWednesday.Text = entity.Wednesday.Replace("<br>", "\r\n");;
txtThursday.Text = entity.Thursday.Replace("<br>", "\r\n");;
txtFriday.Text = entity.Friday.Replace("<br>", "\r\n");;
txtSaturday.Text = entity.Saturday.Replace("<br>", "\r\n");;
mondayTicketIds.Value = entity.MondayTickets;
tuesdayTicketIds.Value = entity.TuesdayTickets;
wednesdayTicketIds.Value = entity.WednesdayTickets;
thursdayTicketIds.Value = entity.ThursdayTickets;
fridayTicketIds.Value = entity.FridayTickets;
saturdayTicketIds.Value = entity.SaturdayTickets;
sundayTicketIds.Value = entity.SundayTickets;
}
protected void ddlImport_SelectedIndexChanged(object sender, EventArgs e)
{
WeekPlanEntity weekPlan = planApp.GetInfo(int.Parse(ddlImport.SelectedValue));
if (weekPlan != null)
{
txtMonday.Text = weekPlan.Monday.Replace("<br>", "\r\n");;
ddlMondayEst.SelectedValue = weekPlan.MondayEstimate.ToString();
txtTuesday.Text = weekPlan.Tuesday.Replace("<br>", "\r\n");;
ddlTuesdayEst.SelectedValue = weekPlan.TuesdayEstimate.ToString();
txtWednesday.Text = weekPlan.Wednesday.Replace("<br>", "\r\n");;
ddlWednesdayEst.SelectedValue = weekPlan.WednesdayEstimate.ToString();
txtThursday.Text = weekPlan.Thursday.Replace("<br>", "\r\n");;
ddlThursdayEst.SelectedValue = weekPlan.ThursdayEstimate.ToString();
txtFriday.Text = weekPlan.Friday.Replace("<br>", "\r\n");;
ddlFridayEst.SelectedValue = weekPlan.FridayEstimate.ToString();
txtSaturday.Text = weekPlan.Saturday.Replace("<br>", "\r\n");;
ddlSaturdayEst.SelectedValue = weekPlan.SaturdayEstimate.ToString();
txtSunday.Text = weekPlan.Sunday.Replace("<br>", "\r\n");;
ddlSundayEst.SelectedValue = weekPlan.SundayEstimate.ToString();
//set remaining hours
txtMondayRemaining.Value = (8 - weekPlan.MondayEstimate).ToString();
txtTuesdayRemaining.Value = (8 - weekPlan.TuesdayEstimate).ToString();
txtWednesdayRemaining.Value = (8 - weekPlan.WednesdayEstimate).ToString();
txtThursdayRemaining.Value = (8 - weekPlan.ThursdayEstimate).ToString();
txtFridayRemaining.Value = (8 - weekPlan.FridayEstimate).ToString();
txtSaturdayRemaining.Value = (8 - weekPlan.SaturdayEstimate).ToString();
txtSundayRemaining.Value = (8 - weekPlan.SundayEstimate).ToString();
mondayTicketIds.Value = weekPlan.MondayTickets;
tuesdayTicketIds.Value = weekPlan.TuesdayTickets;
wednesdayTicketIds.Value = weekPlan.WednesdayTickets;
thursdayTicketIds.Value = weekPlan.ThursdayTickets;
fridayTicketIds.Value = weekPlan.FridayTickets;
saturdayTicketIds.Value = weekPlan.SaturdayTickets;
sundayTicketIds.Value = weekPlan.SundayTickets;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
WeekPlanEntity entity = new WeekPlanEntity();
int id;
if (int.TryParse(hfID.Value, out id))
{
//编辑
entity.ID = id;
entity.UpdateDate = DateTime.Now;
entity.UpdateUserID = UserInfo.UserID;
}
else //新建
{
DateTime weekDay = DateTime.Now.AddDays(7);
int weekOfDay = (int)weekDay.DayOfWeek;
weekOfDay = weekOfDay == 0 ? 7 : weekOfDay;
weekDay = weekDay.AddDays(-weekOfDay).AddDays(7);
if (QS("id", 0) == 0 && QS("oldplan", 0) == 1) // 追加本周计划
{
weekDay = weekDay.AddDays(-7);
}
entity.WeekDay = weekDay.Date;
entity.UserID = UserInfo.UserID;
entity.CreateDate = DateTime.Now;
entity.UpdateDate = DateTime.Now;
entity.UpdateUserID = UserInfo.UserID;
entity.IsDeleted = false;
}
entity.Sunday = (txtSunday.Text).Replace("\r\n", "<br>");
entity.SundayEstimate = txtSunday.Text == "" ? 0 : int.Parse(ddlSundayEst.SelectedValue);
entity.Monday = (txtMonday.Text).Replace("\r\n", "<br>");
entity.MondayEstimate = txtMonday.Text == "" ? 0 : int.Parse(ddlMondayEst.SelectedValue);
entity.Tuesday = (txtTuesday.Text).Replace("\r\n", "<br>");
entity.TuesdayEstimate = txtTuesday.Text == "" ? 0 : int.Parse(ddlTuesdayEst.SelectedValue);
entity.Wednesday = (txtWednesday.Text).Replace("\r\n", "<br>");
entity.WednesdayEstimate = txtWednesday.Text == "" ? 0 : int.Parse(ddlWednesdayEst.SelectedValue);
entity.Thursday = (txtThursday.Text).Replace("\r\n", "<br>");
entity.ThursdayEstimate = txtThursday.Text == "" ? 0 : int.Parse(ddlThursdayEst.SelectedValue);
entity.Friday = (txtFriday.Text).Replace("\r\n", "<br>");
entity.FridayEstimate = txtFriday.Text == "" ? 0 : int.Parse(ddlFridayEst.SelectedValue);
entity.Saturday = (txtSaturday.Text).Replace("\r\n", "<br>");
entity.SaturdayEstimate = txtSaturday.Text == "" ? 0 : int.Parse(ddlSaturdayEst.SelectedValue);
entity.MondayTickets = mondayTicketIds.Value;
entity.TuesdayTickets = tuesdayTicketIds.Value;
entity.WednesdayTickets = wednesdayTicketIds.Value;
entity.ThursdayTickets = thursdayTicketIds.Value;
entity.FridayTickets = fridayTicketIds.Value;
entity.SaturdayTickets = saturdayTicketIds.Value;
entity.SundayTickets = sundayTicketIds.Value;
if (id > 0)
{
bool result;
if (UserInfo.Role == RolesEnum.ADMIN || UserInfo.Role == RolesEnum.PM || UserInfo.Role == RolesEnum.Sales)
{
result = planApp.Update(entity, false);
}
else
{
result = planApp.Update(entity, true);
}
if (result)
{
RedirectBack("Index.aspx");
}
else
{
ShowFailMessageToClient(planApp.BrokenRuleMessages);
}
}
else
{
if (planApp.Add(entity) > 0)
{
Response.Redirect("Index.aspx?date=" + entity.WeekDay.ToString("MM/dd/yyyy"));
}
else
{
ShowFailMessageToClient(planApp.BrokenRuleMessages);
}
}
}
public bool Update(WeekPlanEntity entity)
{
throw new NotImplementedException();
}
public bool Update(WeekPlanEntity entity, bool isVerify)
{
return(mgr.Update(entity, isVerify));
}
public int Add(WeekPlanEntity entity)
{
return(repository.Insert(entity));
}
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 btnSave_Click(object sender, EventArgs e)
{
WeekPlanEntity entity = new WeekPlanEntity();
int id;
if (int.TryParse(hfID.Value, out id))
{
//编辑
entity.ID = id;
entity.UpdateDate = DateTime.Now;
entity.UpdateUserID = UserInfo.UserID;
}
else //新建
{
DateTime weekDay = DateTime.Now;
if (weekDay.DayOfWeek != DayOfWeek.Sunday)
{
weekDay = weekDay.AddDays(-(int)DateTime.Now.DayOfWeek).AddDays(7);
}
if (QS("id", 0) == 0 && QS("oldplan", 0) == 1) // 追加本周计划
{
weekDay = weekDay.AddDays(-7);
}
entity.WeekDay = weekDay.Date;
entity.UserID = UserInfo.UserID;
entity.CreateDate = DateTime.Now;
entity.UpdateDate = DateTime.Now;
entity.UpdateUserID = UserInfo.UserID;
entity.IsDeleted = false;
}
entity.Sunday = (txtSunday.Text).Replace("\r\n", "<br>");
entity.SundayEstimate = int.Parse(ddlSundayEst.SelectedValue);
entity.Monday = (txtMonday.Text).Replace("\r\n", "<br>");
entity.MondayEstimate = int.Parse(ddlMondayEst.SelectedValue);
entity.Tuesday = (txtTuesday.Text).Replace("\r\n", "<br>");
entity.TuesdayEstimate = int.Parse(ddlTuesdayEst.SelectedValue);
entity.Wednesday = (txtWednesday.Text).Replace("\r\n", "<br>");
entity.WednesdayEstimate = int.Parse(ddlWednesdayEst.SelectedValue);
entity.Thursday = (txtThursday.Text).Replace("\r\n", "<br>");
entity.ThursdayEstimate = int.Parse(ddlThursdayEst.SelectedValue);
entity.Friday = (txtFriday.Text).Replace("\r\n", "<br>");
entity.FridayEstimate = int.Parse(ddlFridayEst.SelectedValue);
entity.Saturday = (txtSaturday.Text).Replace("\r\n", "<br>");
entity.SaturdayEstimate = int.Parse(ddlSaturdayEst.SelectedValue);
if (id > 0)
{
bool result;
if (UserInfo.Role == RolesEnum.ADMIN || UserInfo.Role == RolesEnum.PM || UserInfo.Role == RolesEnum.Sales)
{
result = planApp.Update(entity, false);
}
else
{
result = planApp.Update(entity, true);
}
if (result)
{
ShowSuccessMessageToClient(true, true);
}
else
{
ShowFailMessageToClient(planApp.BrokenRuleMessages);
}
}
else
{
if (planApp.Add(entity) > 0)
{
ShowSuccessMessageToClient();
}
else
{
ShowFailMessageToClient(planApp.BrokenRuleMessages);
}
}
}
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;
}
}
}
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 Update(WeekPlanEntity entity, bool isVerify)
{
return(repository.Update(entity, isVerify));
}
public int Add(WeekPlanEntity entity)
{
return(mgr.Add(entity));
}
