/// <summary> /// 修改项目 /// </summary> /// <param name="project">需修改项目</param> public int UpdateProject(Business_Project project) { Business_Project old = context.Business_Projects.Find(project.ProjectID); context.Entry <Business_Project>(old).CurrentValues.SetValues(project); return(context.SaveChanges()); }
private void lbProjects_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (e.AddedItems.Count != 0) { tbEditZone.SelectedIndex = 1; updateProject = (e.AddedItems[0] as Business_Project).Clone(); (tbEditZone.Items[tbEditZone.Items.Count - 1] as TabItem).DataContext = updateProject; } }
protected override void Seed(EasySystemDBContext context) { Random r = new Random(); #region 部门数据 Common_Department[] departments = new Common_Department[] { new Common_Department() { DepartmentName = "市政分院" }, new Common_Department() { DepartmentName = "建筑分院" }, new Common_Department() { DepartmentName = "景观分院" } }; context.Common_Departments.AddRange(departments); context.SaveChanges(); #endregion #region 项目数据 for (int i = 1; i < 31; i++) { Business_Project project = new Business_Project() { ProjectName = "项目" + i, ProjectLeader = "某某某", Company = "建设单位" + i, DesignNo = "2017S0" + i.ToString().PadLeft(2, '0') }; context.Business_Projects.Add(project); } for (int i = 1; i < 31; i++) { Business_Project project = new Business_Project() { ProjectName = "项目" + (i + 30), ProjectLeader = "某某某", Company = "建设单位" + (i + 30), DesignNo = "2017J0" + i.ToString().PadLeft(2, '0') }; context.Business_Projects.Add(project); } context.SaveChanges(); #endregion #region 业务类型 List <Business_ServiceType> serviceTypes = new List <Business_ServiceType>(); #endregion #region 任务数据 List <Business_Task> tasks = new List <Business_Task>(); for (int i = 1; i < 31; i++) { tasks.Add(new Business_Task() { ProjectID = i, DepartmentID = 1, BusinessType = Common_BusinessType.Inside, Contact = "某某某" }); } for (int i = 31; i < 61; i++) { tasks.Add(new Business_Task() { ProjectID = i, DepartmentID = 2, BusinessType = Common_BusinessType.Inside, Contact = "某某某" }); } context.Business_Tasks.AddRange(tasks); context.SaveChanges(); List <Business_TaskItem> taskItems = new List <Business_TaskItem>(); for (int i = 1; i < 31; i++) { taskItems.Add(new Business_TaskItem() { TaskID = i, ItemName = "第一册", Subject = "道路、景观、照明", A1 = r.Next(1, 6), A2 = r.Next(1, 21), A3 = r.Next(80, 200), Copies = 9 }); taskItems.Add(new Business_TaskItem() { TaskID = i, ItemName = "第二册", Subject = "排水", A1 = r.Next(1, 6), A2 = r.Next(1, 11), A3 = r.Next(50, 100), Copies = 9 }); taskItems.Add(new Business_TaskItem() { TaskID = i, ItemName = "第三册", Subject = "桥梁", A2 = r.Next(1, 6), A3 = r.Next(30, 70), Copies = 9 }); } for (int i = 31; i < 61; i++) { for (int j = 1; j < 6; j++) { taskItems.Add(new Business_TaskItem() { TaskID = i, ItemName = j + "#栋", Subject = "建筑", A0 = r.Next(1, 6), A1 = r.Next(10, 20), Copies = 8 }); taskItems.Add(new Business_TaskItem() { TaskID = i, ItemName = j + "#栋", Subject = "结构", A0 = r.Next(1, 6), A1 = r.Next(10, 20), Copies = 8 }); taskItems.Add(new Business_TaskItem() { TaskID = i, ItemName = j + "#栋", Subject = "给排水", A0 = r.Next(1, 6), A1 = r.Next(10, 20), Copies = 8 }); taskItems.Add(new Business_TaskItem() { TaskID = i, ItemName = j + "#栋", Subject = "电气", A0 = r.Next(1, 6), A1 = r.Next(10, 20), Copies = 8 }); taskItems.Add(new Business_TaskItem() { TaskID = i, ItemName = j + "#栋", Subject = "暖通", A0 = r.Next(1, 6), A1 = r.Next(10, 20), Copies = 8 }); } } context.Business_TaskItems.AddRange(taskItems); context.SaveChanges(); #endregion base.Seed(context); }
/// <summary> /// 新增项目 /// </summary> /// <param name="project">待新增项目</param> public int AddProject(Business_Project project) { context.Business_Projects.Add(project); return(context.SaveChanges()); }