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