コード例 #1
0
        public string GetDepartment(int level, string id1, string id2, string id3, string id4, string dname)
        {
            string department = "";

            T_HR_Department1 dep1 = entities.T_HR_Department1.Find(id1);
            T_HR_Department2 dep2 = entities.T_HR_Department2.Find(id2);
            T_HR_Department3 dep3 = entities.T_HR_Department3.Find(id3);
            T_HR_Department4 dep4 = entities.T_HR_Department4.Find(id4);

            if (level == 1)
            {
                department = dname;
            }
            if (level == 2)
            {
                department = dep1.Department1Name + dname;
            }
            if (level == 3)
            {
                department = dep1.Department1Name + dep2.Department2Name + dname;
            }
            if (level == 4)
            {
                department = dep1.Department1Name + dep2.Department2Name + dep3.Department3Name + dname;
            }
            if (level == 5)
            {
                department = dep1.Department1Name + dep2.Department2Name + dep3.Department3Name + dep4.Department4Name + dname;
            }
            return(department);
        }
コード例 #2
0
        public T_HR_Department2 ToDB2(int flag)
        {
            T_HR_Department2 dep = new T_HR_Department2();

            dep.ID2             = ID;
            dep.ID1             = PreID;
            dep.Department2No   = No;
            dep.Department2Name = Name;
            dep.Remark          = Remark;
            dep.CreaterName     = CreaterName;
            dep.CreateTime      = CreateTime;
            if (flag == 2)
            {
                dep.EditorName = EditorName;
                dep.EditeTime  = EditeTime;
            }
            dep.DOrder = DOrder;
            dep.Valid  = Valid;

            return(dep);
        }
コード例 #3
0
        public ActionResult JSDeleteDepartment(SubmitHandler handler)//删除响应
        {
            var    s = X.GetCmp <Store>("DepartmentStore");
            string id;

            Dictionary <string, string>[] values = JSON.Deserialize <Dictionary <string, string>[]>(handler.Json.ToString());

            if (values.Length > 0)//js代码已经处理过,此处判断无用,可删
            {
                if (IsDelete(values))
                {
                    foreach (Dictionary <string, string> row in values)
                    {
                        id = row["ID"];
                        var dep = (from o in entities.V_HR_Dep
                                   where o.ID == id
                                   select o).First();

                        #region
                        if (dep.Level == "1")
                        {
                            T_HR_Department1 dep1 = entities.T_HR_Department1.Find(id);
                            if (dep1 != null)
                            {
                                //entities.T_HR_Contract.Remove(de);
                                dep1.Valid = false;
                            }
                        }
                        if (dep.Level == "2")
                        {
                            T_HR_Department2 dep2 = entities.T_HR_Department2.Find(id);
                            if (dep2 != null)
                            {
                                //entities.T_HR_Contract.Remove(de);
                                dep2.Valid = false;
                            }
                        }
                        if (dep.Level == "3")
                        {
                            T_HR_Department3 dep3 = entities.T_HR_Department3.Find(id);
                            if (dep3 != null)
                            {
                                //entities.T_HR_Contract.Remove(de);
                                dep3.Valid = false;
                            }
                        }
                        if (dep.Level == "4")
                        {
                            T_HR_Department4 dep4 = entities.T_HR_Department4.Find(id);
                            if (dep4 != null)
                            {
                                //entities.T_HR_Contract.Remove(de);
                                dep4.Valid = false;
                            }
                        }
                        if (dep.Level == "5")
                        {
                            T_HR_Department5 dep5 = entities.T_HR_Department5.Find(id);
                            if (dep5 != null)
                            {
                                //entities.T_HR_Contract.Remove(de);
                                dep5.Valid = false;
                            }
                        }
                        #endregion

                        var staffs = from o in entities.T_HR_Staff
                                     where o.ID1 == id || o.ID2 == id || o.ID3 == id || o.ID4 == id || o.ID5 == id
                                     select o;
                        foreach (var item in staffs)
                        {
                            T_HR_Staff staff = entities.T_HR_Staff.Find(item.StaffID);
                            staff.ID1        = null;
                            staff.ID2        = null;
                            staff.ID3        = null;
                            staff.ID4        = null;
                            staff.ID5        = null;
                            staff.Department = null;
                        }

                        try
                        {
                            entities.SaveChanges();
                            s.Remove(id);
                        }
                        catch (Exception e)
                        {
                            X.Msg.Alert("警告", "数据删除失败!<br /> note:" + e.Message).Show();
                        }
                    }
                }
                else
                {
                    X.Msg.Alert("警告", "不可删除存在下级部门的部门!").Show();
                }
            }
            else
            {
                X.Msg.Alert("提示", "未选择任何列!").Show();
            }

            return(this.Direct());
        }
コード例 #4
0
        public ActionResult AddOrEditDepartment(Department dep)//AddContract保存相应
        {
            V_HR_Dep testdep = entities.V_HR_Dep.Find(dep.ID);

            dep.Level = GetLevel(dep.ID1, dep.ID2, dep.ID3, dep.ID4);
            if (dep.Level != 0)
            {
                DirectResult r = new DirectResult();
                if (testdep == null)//为空为添加
                {
                    dep.ID          = Tool.ProduceSed64();;
                    dep.Valid       = true;
                    dep.CreaterName = new LoginUser().EmployeeId;
                    dep.CreateTime  = DateTime.Now;
                    dep.PreID       = GetPreID(dep.Level, dep.ID1, dep.ID2, dep.ID3, dep.ID4);

                    if (dep.Level == 1)
                    {
                        entities.T_HR_Department1.Add(dep.ToDB1(1));
                    }
                    if (dep.Level == 2)
                    {
                        entities.T_HR_Department2.Add(dep.ToDB2(1));
                    }
                    if (dep.Level == 3)
                    {
                        entities.T_HR_Department3.Add(dep.ToDB3(1));
                    }
                    if (dep.Level == 4)
                    {
                        entities.T_HR_Department4.Add(dep.ToDB4(1));
                    }
                    if (dep.Level == 5)
                    {
                        entities.T_HR_Department5.Add(dep.ToDB5(1));
                    }

                    try
                    {
                        entities.SaveChanges();
                        r.Success = true;
                        X.Msg.Alert("提示", "保存成功!", new JFunction {
                            Fn = "closewindow"
                        }).Show();
                    }
                    catch (Exception e)
                    {
                        X.Msg.Alert("警告", "数据保存失败!<br /> note:" + e.Message, new JFunction {
                            Fn = "closewindow"
                        }).Show();
                        r.Success = false;
                    }
                }
                else//否则为修改
                {
                    dep.EditorName = new LoginUser().EmployeeId;
                    dep.EditeTime  = DateTime.Now;
                    dep.PreID      = GetPreID(dep.Level, dep.ID1, dep.ID2, dep.ID3, dep.ID4);

                    #region
                    if (testdep.Level == "1")
                    {
                        T_HR_Department1 dep1 = entities.T_HR_Department1.Find(dep.ID);
                        dep1.Department1No   = dep.No;
                        dep1.Department1Name = dep.Name;
                        dep1.Remark          = dep.Remark;
                        dep1.EditorName      = dep.EditorName;
                        dep1.EditeTime       = dep.EditeTime;
                        dep1.DOrder          = dep.DOrder;
                    }
                    if (testdep.Level == "2")
                    {
                        T_HR_Department2 dep2 = entities.T_HR_Department2.Find(dep.ID);
                        dep2.Department2No   = dep.No;
                        dep2.Department2Name = dep.Name;
                        dep2.Remark          = dep.Remark;
                        dep2.EditorName      = dep.EditorName;
                        dep2.EditeTime       = dep.EditeTime;
                        dep2.DOrder          = dep.DOrder;
                    }
                    if (testdep.Level == "3")
                    {
                        T_HR_Department3 dep3 = entities.T_HR_Department3.Find(dep.ID);
                        dep3.Department3No   = dep.No;
                        dep3.Department3Name = dep.Name;
                        dep3.Remark          = dep.Remark;
                        dep3.EditorName      = dep.EditorName;
                        dep3.EditeTime       = dep.EditeTime;
                        dep3.DOrder          = dep.DOrder;
                    }
                    if (testdep.Level == "4")
                    {
                        T_HR_Department4 dep4 = entities.T_HR_Department4.Find(dep.ID);
                        dep4.Department4No   = dep.No;
                        dep4.Department4Name = dep.Name;
                        dep4.Remark          = dep.Remark;
                        dep4.EditorName      = dep.EditorName;
                        dep4.EditeTime       = dep.EditeTime;
                        dep4.DOrder          = dep.DOrder;
                    }
                    if (testdep.Level == "5")
                    {
                        T_HR_Department5 dep5 = entities.T_HR_Department5.Find(dep.ID);
                        dep5.Department5No   = dep.No;
                        dep5.Department5Name = dep.Name;
                        dep5.Remark          = dep.Remark;
                        dep5.EditorName      = dep.EditorName;
                        dep5.EditeTime       = dep.EditeTime;
                        dep5.DOrder          = dep.DOrder;
                    }
                    #endregion

                    string depname = GetDepartment(dep.Level, dep.ID1, dep.ID2, dep.ID3, dep.ID4, dep.Name);
                    var    staffs  = from o in entities.T_HR_Staff
                                     where o.ID1 == dep.ID || o.ID2 == dep.ID || o.ID3 == dep.ID || o.ID4 == dep.ID || o.ID5 == dep.ID
                                     select o;
                    foreach (var item in staffs)
                    {
                        T_HR_Staff staff = entities.T_HR_Staff.Find(item.StaffID);
                        staff.Department = depname;
                    }

                    try
                    {
                        entities.SaveChanges();
                        r.Success = true;
                        X.Msg.Alert("提示", "修改成功!", new JFunction {
                            Fn = "closewindow"
                        }).Show();
                    }
                    catch (Exception e)
                    {
                        X.Msg.Alert("警告", "数据修改失败!<br /> note:" + e.Message, new JFunction {
                            Fn = "closewindow"
                        }).Show();
                        r.Success = false;
                    }
                }
                return(r);
            }
            else
            {
                X.Msg.Alert("警告", "上级部门不能跳过为空!").Show();
                return(this.Direct());
            }
        }
コード例 #5
0
        public ActionResult AddDepartment(string id) //在修改时传递的为contractid
        {
            if (id == "-1")                          //-1为添加
            {
                return(View(new Department()));
            }
            else//否则为修改
            {
                V_HR_Dep item = (from o in entities.V_HR_Dep
                                 where o.ID == id
                                 select o).First();

                Department de = new Department();

                de.ID          = item.ID;
                de.PreID       = item.PreID;
                de.No          = item.No;
                de.Name        = item.Name;
                de.Level       = Convert.ToInt32(item.Level);
                de.DOrder      = Convert.ToInt32(item.DOrder);
                de.Remark      = item.Remark;
                de.CreaterName = item.CreaterName;
                de.CreateTime  = Convert.ToDateTime(item.CreateTime);
                de.EditorName  = item.EditorName;
                de.EditeTime   = Convert.ToDateTime(item.EditeTime);
                de.Valid       = Convert.ToBoolean(item.Valid);

                if (de.Level == 2)
                {
                    T_HR_Department1 d1 = (from o in entities.T_HR_Department1
                                           where o.ID1 == de.PreID
                                           select o).First();
                    de.ID1 = d1.ID1;
                }

                if (de.Level == 3)
                {
                    T_HR_Department2 d2 = (from o in entities.T_HR_Department2
                                           where o.ID2 == de.PreID
                                           select o).First();
                    de.ID2 = d2.ID2;
                    de.ID1 = d2.ID1;
                }

                if (de.Level == 4)
                {
                    T_HR_Department3 d3 = (from o in entities.T_HR_Department3
                                           where o.ID3 == de.PreID
                                           select o).First();
                    de.ID3 = d3.ID3;
                    de.ID2 = d3.ID2;

                    T_HR_Department2 d2 = (from o in entities.T_HR_Department2
                                           where o.ID2 == de.ID2
                                           select o).First();
                    de.ID1 = d2.ID1;
                }

                if (de.Level == 5)
                {
                    T_HR_Department4 d4 = (from o in entities.T_HR_Department4
                                           where o.ID4 == de.PreID
                                           select o).First();
                    de.ID4 = d4.ID4;
                    de.ID3 = d4.ID3;

                    T_HR_Department3 d3 = (from o in entities.T_HR_Department3
                                           where o.ID3 == de.ID3
                                           select o).First();
                    de.ID2 = d3.ID2;

                    T_HR_Department2 d2 = (from o in entities.T_HR_Department2
                                           where o.ID2 == de.ID2
                                           select o).First();
                    de.ID1 = d2.ID1;
                }

                var x = X.GetCmp <FieldSet>("BaseList");
                x.Hidden = true;

                return(View(de));
            }
        }