protected void Repeater2_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
Repeater repeater = e.Item.FindControl("Repeater3") as Repeater;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(e.Item.DataItem);
JToken token = JToken.Parse(json);
int planId = token.Value <int>("PlanID");
if (planId != 0)
{
var splitContent = new DepartmentMonthPlan();
using (WXOADataContext db = new WXOADataContext())
{
var appraises = db.PLAN_Appraises.Join(db.TU_Users, o => o.UserID, i => i.UserID, (o, i) => new
{
o.PlanID,
o.Appraise,
o.Content,
o.AddTime,
i.RealName
}).ToList().Where(pa => pa.PlanID == planId).Select(pa => new
{
pa.PlanID,
pa.Appraise,
Content = new DepartmentMonthPlan().SplitString(pa.Content, 4),
Content1 = pa.Content,
pa.RealName,
AddTime = pa.AddTime.Value.ToString("yyyy-MM-dd")
});
repeater.DataSource = appraises;
repeater.DataBind();
}
}
}
}
private void InitComponent()
{
string departmentId = Request.QueryString["DepartmentID"];
string month = Request.QueryString["Month"];
DateTime startTime = new DateTime(DateTime.Now.Year, int.Parse(month), 1);
DateTime stopTime = new DateTime(DateTime.Now.Year, int.Parse(month), DateTime.DaysInMonth(DateTime.Now.Year, int.Parse(month)));
using (WXOADataContext db = new WXOADataContext())
{
db.Log = new DebuggerWriter();
var entity = db.TE_Departments.FirstOrDefault(d => d.ID == int.Parse(departmentId));
if (entity != null)
{
this.ltlDepartmentName.Text = entity.Name;
this.ltlMonthFlag.Text = String.Format("{0}年{1}月", DateTime.Now.Year, Request.QueryString["Month"].ToString());
}
var plan = db.PLAN_Plans.FirstOrDefault(p => p.DepartmentID == int.Parse(departmentId) && p.Type == 3 && p.RangeType == 2 && p.Starttime == startTime && p.Stoptime == stopTime);
if (plan != null)
{
this.txtTitle.Value = plan.Title;
this.txtTotal.Value = plan.Total.ToString();
this.txtCurrent.Value = plan.Current.ToString();
this.txtContent.Value = plan.Content;
this.txtSummary.Value = plan.Summary;
var comments = db.PLAN_Appraises.Join(db.TU_Users, o => o.UserID, i => i.UserID, (o, i) => new
{
o.PlanID,
o.Appraise,
o.Content,
o.AddTime,
i.RealName
}).ToList().Where(a => a.PlanID == plan.id).Select(a => new
{
a.PlanID,
a.Appraise,
Content = a.Content,
Content1 = SplitString(a.Content.ToString(), 4),
AddTime = a.AddTime.Value.ToString("yyyy-MM-dd"),
a.RealName
});
this.Repeater2.DataSource = comments;
this.Repeater2.DataBind();
}
db.Log = new DebuggerWriter();
var users = db.TU_Users.Where(u => u.DepartmentID == int.Parse(departmentId) && u.State != 40).Select(u => new
{
u.RealName,
u.UserID,
MonthFlag = String.Format("{0}年{1}月", DateTime.Now.Year, Request.QueryString["Month"].ToString()),
title = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? "" : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).Title,
total = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? 0 : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).Total,
current = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? 0 : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).Current,
content = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? "" : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).Content,
summary = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? "" : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).Summary,
PlanID = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? 0 : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).id
});
this.Repeater3.DataSource = users;
this.Repeater3.DataBind();
}
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
string addDateTime = Convert.ToDateTime(Request.QueryString["Starttime"]).ToString("yyyy-MM-dd");
Repeater repeater = (Repeater)e.Item.FindControl("CommentRepeater");
string json = Newtonsoft.Json.JsonConvert.SerializeObject(e.Item.DataItem);
JToken token = JToken.Parse(json);
int planId = token["PlanID"].Value <int>();
if (planId != 0)
{
using (WXOADataContext db = new WXOADataContext())
{
var comments = db.PLAN_Appraises.Join(db.TU_Users, o => o.UserID, i => i.UserID, (o, i) => new
{
o.PlanID,
o.Appraise,
Content = new DepartmentMonthPlan().SplitString(o.Content, 4),
o.AddTime,
i.RealName
}).ToList().Where(pa => pa.PlanID == planId && pa.AddTime.Value.ToString("yyyy-MM-dd").Equals(addDateTime)).ToList();
repeater.DataSource = comments;
repeater.DataBind();
}
}
}
}
private void InitComponent()
{
string departmentId = Request.QueryString["DepartmentID"];
if (!string.IsNullOrEmpty(departmentId))
{
using (WXOADataContext db = new WXOADataContext())
{
this.ltlDepartmentName.Text = db.TE_Departments.FirstOrDefault(d => d.ID == int.Parse(departmentId)) == null ? "" : db.TE_Departments.FirstOrDefault(d => d.ID == int.Parse(departmentId)).Name;
var entity = db.PLAN_Plans.Where(pp => pp.Type == 1 && pp.RangeType == 2 && pp.DepartmentID == int.Parse(departmentId) && pp.Starttime == Convert.ToDateTime(Request.QueryString["Starttime"])).FirstOrDefault();
this.liDatetime.Text = String.Format("{0:yyyy-MM-dd dddd}", Convert.ToDateTime(Request.QueryString["Starttime"]));
if (entity != null)
{
this.txtTitle.Text = entity.Title;
this.txtTotal.Text = entity.Total.ToString();
this.txtCurrent.Text = entity.Current.ToString();
this.txtContent.Text = entity.Content;
this.txtSummary.Text = entity.Summary;
this.ltlComment.Text = db.PLAN_Appraises.FirstOrDefault(ap => ap.PlanID == entity.id) == null ? "" : db.PLAN_Appraises.FirstOrDefault(ap => ap.PlanID == entity.id).Content;
}
var users = db.TU_Users.Where(u => u.DepartmentID == int.Parse(departmentId) && u.State != 40).Select(u => new
{
u.RealName,
Title = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])) == null ? "" : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])).Title,
Total = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])) == null ? 0 : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])).Total,
Current = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])) == null ? 0 : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])).Current,
Content = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])) == null ? "" : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])).Content,
Summary = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])) == null ? "" : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])).Summary,
PlanID = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])) == null ? 0 : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Type == 1 && p.RangeType == 1 && p.Starttime == Convert.ToDateTime(Request.QueryString["StartTime"])).id,
});
this.Repeater1.DataSource = users;
this.Repeater1.DataBind();
}
}
}
private void InitComponent()
{
using (WXOADataContext db = new WXOADataContext())
{
string userId = Request.QueryString["UserID"];
if (!string.IsNullOrEmpty(userId))
{
var entity = db.TU_Users.FirstOrDefault(u => u.UserID == Guid.Parse(userId));
if (entity != null)
{
this.ltlName.Text = entity.RealName;
}
}
}
}
private void InitComponent()
{
weekIndex = ConvertDateTime.GetWeekIndex(DateTime.Now.ToString());
string departmentId = Request.QueryString["DepartmentID"];
using (WXOADataContext db = new WXOADataContext())
{
var entity = db.TE_Departments.FirstOrDefault(d => d.ID == int.Parse(departmentId));
if (entity != null)
{
departmentName = entity.Name;
content = entity.Content;
}
var query1 = db.TU_Users.Where(u => u.DepartmentID == int.Parse(departmentId)).OrderBy(u => u.State).Select(u => new
{
u.RealName,
PositionName = db.TE_DutyDetails.FirstOrDefault(d => d.ID == Convert.ToInt64(u.DutyId)).Name,
u.Grade
});
this.Repeater1.DataSource = query1;
this.Repeater1.DataBind();
}
}
private void InitComponent()
{
currentWeekIndex = ConvertDateTime.GetWeekIndex(DateTime.Now);
string departmentId = Request.QueryString["DepartmentID"];
string weekIndex = Request.QueryString["WeekIndex"];
using (WXOADataContext db = new WXOADataContext())
{
var entity = db.TE_Departments.FirstOrDefault(d => d.ID == int.Parse(departmentId));
if (entity != null)
{
this.ltlDepartmentName.Text = entity.Name;
this.ltlDateTime.Text = String.Format("第{0}周", weekIndex);
}
string dtStart = ConvertDateTime.GetWeekRange(int.Parse(weekIndex)).Split('～')[0];
string dtEnd = ConvertDateTime.GetWeekRange(int.Parse(weekIndex)).Split('～')[1];
DateTime startTime = Convert.ToDateTime(dtStart).AddDays(-1);
DateTime stopTime = Convert.ToDateTime(dtEnd).AddDays(-1);
var plan = db.PLAN_Plans.FirstOrDefault(pp => pp.DepartmentID == int.Parse(departmentId) && pp.Starttime == startTime && pp.Stoptime == stopTime && pp.Type == 2 && pp.RangeType == 2);
if (plan != null)
{
this.txtTitle.Text = plan.Title;
this.txtTotal.Text = plan.Total.ToString();
this.txtCurrent.Text = plan.Current.ToString();
this.txtContent.Value = plan.Content;
this.txtSummary.Value = plan.Summary;
var comments = db.PLAN_Appraises.Join(db.TU_Users, o => o.UserID, i => i.UserID, (o, i) => new
{
o.PlanID,
o.Appraise,
o.Content,
o.AddTime,
i.RealName
}).ToList().Where(a => a.PlanID == plan.id).Select(a => new
{
a.PlanID,
a.Appraise,
Content = new DepartmentMonthPlan().SplitString(a.Content, 4),
Content1 = a.Content,
AddTime = a.AddTime.Value.ToString("yyyy-MM-dd"),
a.RealName
});
this.Repeater1.DataSource = comments;
this.Repeater1.DataBind();
}
var users = db.TU_Users.Where(u => u.DepartmentID == int.Parse(departmentId) && u.State != 40).Select(u => new
{
u.RealName,
u.UserID,
WeekFlag = String.Format("{0}周({1})", weekIndex, ConvertDateTime.GetWeekRange(int.Parse(weekIndex))),
title = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? "" : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).Title,
total = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? 0 : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).Total,
current = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? 0 : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).Current,
content = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? "" : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).Content,
summary = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? "" : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).Summary,
PlanID = db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime) == null ? 0 : db.PLAN_Plans.FirstOrDefault(p => p.UserID == u.UserID && p.Starttime == startTime && p.Stoptime == stopTime).id
});
this.Repeater2.DataSource = users;
this.Repeater2.DataBind();
}
}
private void InitComponent()
{
string userId = Request.QueryString["UserID"];
string type = Request.QueryString["type"];
switch (type)
{
case "1":
string dateTime = Request.QueryString["DateTime"];
this.Calendar1.TodaysDate = DateTime.Parse(dateTime);
this.Image1.ImageUrl = "/images/rtype3.png";
this.Image2.ImageUrl = "/images/type1.png";
this.Image2.ToolTip = "日计划";
this.ltlPlanType.Text = "日计划";
using (WXOADataContext db = new WXOADataContext())
{
var entity = db.TU_Users.FirstOrDefault(U => U.UserID == Guid.Parse(userId));
if (entity != null)
{
this.ltlPersonName.Text = entity.RealName;
this.ltlDateTime.Text = dateTime;
var plan = db.PLAN_Plans.FirstOrDefault(p => p.UserID == Guid.Parse(userId) && p.Starttime == DateTime.Parse(dateTime) && p.Type == 1 && p.RangeType == 1);
if (plan != null)
{
this.txtTitle.Value = plan.Title;
this.txtTotal.Value = plan.Total.ToString();
this.txtCurrent.Value = plan.Current.ToString();
this.txtContent.Value = plan.Content;
this.txtSummary.Value = plan.Summary;
var appraises = db.PLAN_Appraises.Join(db.TU_Users, o => o.UserID, i => i.UserID, (o, i) => new
{
o.PlanID,
o.Appraise,
o.Content,
o.AddTime,
i.RealName
}).ToList().Where(pa => pa.PlanID == plan.id).Select(pa => new
{
pa.PlanID,
pa.Appraise,
Content = new DepartmentMonthPlan().SplitString(pa.Content, 4),
Content1 = pa.Content,
pa.RealName,
AddTime = pa.AddTime.Value.ToString("yyyy-MM-dd")
});
this.Repeater1.DataSource = appraises;
this.Repeater1.DataBind();
}
}
}
break;
case "3":
string year = Request.QueryString["Year"];
string month = Request.QueryString["Month"];
this.Image1.ImageUrl = "/images/rtype3.png";
this.Image2.ImageUrl = "/images/type3.png";
this.Image2.ToolTip = "月计划";
this.ltlPlanType.Text = "月计划";
using (WXOADataContext db = new WXOADataContext())
{
var entity = db.TU_Users.FirstOrDefault(U => U.UserID == Guid.Parse(userId));
if (entity != null)
{
this.ltlPersonName.Text = entity.RealName;
this.ltlDateTime.Text = String.Format("{0}年{1}月", year, month);
DateTime startTime = Convert.ToDateTime(String.Format("{0}-{1}-{2}", year, month, "01"));
DateTime stopTime = ConvertDateTime.GetLastDayOfMonth(startTime);
var plan = db.PLAN_Plans.FirstOrDefault(p => p.UserID == Guid.Parse(userId) && p.Starttime == startTime && p.Stoptime == stopTime);
if (plan != null)
{
this.txtTitle.Value = plan.Title;
this.txtTotal.Value = plan.Total.ToString();
this.txtCurrent.Value = plan.Current.ToString();
this.txtContent.Value = plan.Content;
this.txtSummary.Value = plan.Summary;
this.Calendar1.TodaysDate = plan.Addtime.Value;
var appraises = db.PLAN_Appraises.Join(db.TU_Users, o => o.UserID, i => i.UserID, (o, i) => new
{
o.PlanID,
o.Appraise,
o.Content,
o.AddTime,
i.RealName
}).ToList().Where(pa => pa.PlanID == plan.id).Select(pa => new
{
pa.PlanID,
pa.Appraise,
Content = new DepartmentMonthPlan().SplitString(pa.Content, 4),
Content1 = pa.Content,
pa.RealName,
AddTime = pa.AddTime.Value.ToString("yyyy-MM-dd")
});
this.Repeater1.DataSource = appraises;
this.Repeater1.DataBind();
}
}
}
break;
}
}
