コード例 #1
0
        public ActionResult Create(Department department)
        {
            //模型状态错误(为空)
            if (ModelState.IsValid)
            {
                /*选出ReserveFields中部门相关的记录*/
                var recordList = (from p in db.ReserveFields where p.TableName == "Departments" select p).ToList();
                ViewBag.recordList = recordList;
                /*生成部门编号*/
                department.Number = (new Random().Next(1111, 9999)).ToString();
                /*遍历*/
                foreach (var temp in recordList)
                {
                    DepartmentReserve dr = new DepartmentReserve();
                    dr.Number = department.Number;
                    dr.FieldId = temp.Id;
                    dr.Value = Request[temp.FieldName];
                    db.DepartmentReserves.Add(dr);
                    /*把这行去掉之后即可运行*/
                    //db.SaveChanges();
                }
                db.Departments.Add(department);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            return View(department);
        }
コード例 #2
0
        public ActionResult Create(Department department)
        {
            if (ModelState.IsValid)
            {
                /*Step1:如果上级部门为空则上级部门编号为公司Id*/
                if (department.ParentDepartmentId == null) { department.ParentDepartmentId = this.CompanyId; }

                /*Step2:部门编号唯一,应该用Ajax??*/
                //var find = (from p in db.Departments where p.DepartmentId == department.DepartmentId select p).FirstOrDefault();
                //if (find != null) { ModelState.AddModelError("","部门编号已存在!" );}

                /*Step3:保存固定字段(为了生成主键Id)*/
                db.Departments.Add(department);
                db.SaveChanges();

                /*Step4:显示预留字段名称*/
                var recordList = (from p in db.ReserveFields where p.TableName == "Departments" select p).ToList();
                ViewBag.recordList = recordList;

                /*Step5:保存预留字段的值*/
                foreach (var temp in recordList)
                {
                    DepartmentReserve dr = new DepartmentReserve();
                    dr.Number = department.Id;
                    dr.FieldId = temp.Id;
                    dr.Value = Request[temp.FieldName];
                    /*占位,为了在Index中显示整齐的格式*/
                    if (dr.Value == null) dr.Value = " ";
                    db.DepartmentReserves.Add(dr);
                    db.SaveChanges();
                }

                return RedirectToAction("Index");
            }

            return View(department);
        }
コード例 #3
0
        public ActionResult Create([Bind(Include = "Id,TableName,FieldName,Description,Status")] ReserveField reserveField)
        {
            List<SelectListItem> items = new List<SelectListItem>();
            items.Add(new SelectListItem { Text = "部门信息表", Value = "Departments" });
            items.Add(new SelectListItem { Text = "员工档案表", Value = "Staffs" });
            items.Add(new SelectListItem { Text = "员工技能表", Value = "StaffSkills" });
            //items.Add(new SelectListItem { Text = "员工技能表", Value = "StaffSkills" });
            items.Add(new SelectListItem { Text = "人事变更申请表", Value = "StaffChanges" });
            items.Add(new SelectListItem { Text = "离职申请表", Value = "StaffApplications" });
            items.Add(new SelectListItem { Text = "离职档案表", Value = "StaffArchives" });
            items.Add(new SelectListItem { Text = "合同管理表", Value = "Contracts" });
            ViewBag.List = items;

            if (ModelState.IsValid)
            {

                var number = db.ReserveFields.Select(rf=>rf.Id).Max();
                reserveField.Id = number+1;
                db.ReserveFields.Add(reserveField);
                /*状态设置为有效*/
                reserveField.Status = "true";
                db.SaveChanges();
                //if (reserveField.TableName == "Contracts")
                //{
                //    StaffApplicationReserve sar = new ContractReserve();
                //    var staffApplication = db.StaffApplications.ToList();
                //    foreach (var temp in staffApplication)
                //    {
                //        sar.FieldId = reserveField.Id;
                //        sar.Number = temp.Id;
                //        sar.Value = " ";
                //        db.StaffApplicationReserves.Add(sar);
                //        db.SaveChanges();
                //    }
                //}

                //确保固定字段表、变化字段表和变化字段存储表的数据一致性。
                if (reserveField.TableName == "StaffApplications")
                {
                    StaffApplicationReserve sar = new StaffApplicationReserve();
                    var staffApplication = db.StaffApplications.ToList();
                    foreach (var temp in staffApplication)
                    {
                        sar.FieldId = reserveField.Id;
                        sar.Number = temp.Id;
                        sar.Value = " ";
                        db.StaffApplicationReserves.Add(sar);
                        db.SaveChanges();
                    }
                }
                if (reserveField.TableName == "StaffChanges")
                {
                    StaffChangeReserve scr = new StaffChangeReserve();
                    var staffchange = db.StaffChanges.ToList();
                    foreach (var temp in staffchange)
                    {
                        scr.FieldId = reserveField.Id;
                        scr.Number = temp.Id;
                        scr.Value = " ";
                        db.StaffChangeReserves.Add(scr);
                        db.SaveChanges();
                    }
                }
                if (reserveField.TableName == "StaffSkills")
                {
                    StaffSkillReserve ssr = new StaffSkillReserve();
                    var staffskill = db.StaffSkills.ToList();
                    foreach (var temp in staffskill)
                    {
                        ssr.FieldId = reserveField.Id;
                        ssr.Number = temp.Id;
                        ssr.Value = " ";
                        db.StaffSkillReserves.Add(ssr);
                        db.SaveChanges();
                    }
                }
                if (reserveField.TableName == "Staffs")
                {
                    StaffReserve sr = new StaffReserve();
                    var staff = db.Staffs.ToList();
                    foreach (var temp in staff)
                    {
                        sr.FieldId = reserveField.Id;
                        sr.Number = temp.Number;
                        sr.Value = " ";
                        db.StaffReserves.Add(sr);
                        db.SaveChanges();
                    }
                }
                if (reserveField.TableName == "Departments")
                {
                    DepartmentReserve dr = new DepartmentReserve();
                    var department = db.Departments.ToList();
                    foreach(var temp in department)
                    {
                        dr.FieldId=reserveField.Id;
                        dr.Number = temp.Id;
                        dr.Value = " ";
                        db.DepartmentReserves.Add(dr);
                        db.SaveChanges();
                    }
                }
                if (reserveField.TableName == "StaffArchives")
                {
                    StaffArchiveReserve sar = new StaffArchiveReserve();
                    var staffarchive = db.StaffArchives.ToList();
                    foreach (var temp in staffarchive)
                    {
                        sar.FieldId = reserveField.Id;
                        sar.Number = temp.Id;
                        sar.Value = " ";
                        db.StaffArchiveReserves.Add(sar);
                        db.SaveChanges();
                    }
                }

                return RedirectToAction("IndexInfo", new { table = reserveField.TableName });
            }

            return View(reserveField);
        }