示例#1
0
        public OperateResult Add(AssessmentInfo model)
        {
            using (SystemDB db = new SystemDB())
            {
                try
                {
                    var match = from m in db.assessmentInfoList
                                where m.employeeId == model.employeeId && m.month == model.month
                                select m;
                    if (match.Count() > 0)
                    {
                        return(new OperateResult
                        {
                            content = "数据已经存在",
                        });
                    }
                    model.inputDate = DateTime.Now;

                    db.assessmentInfoList.Add(model);
                    db.SaveChanges();

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                    });
                }
                catch (Exception ex)
                {
                    return(new OperateResult
                    {
                        content = ex.Message,
                    });
                }
            }
        }
示例#2
0
        public static OperateResult Add(LogRecord model)
        {
            using (SystemDB db = new SystemDB())
            {
                try
                {
                    var match = from m in db.logRecordList
                                select m;
                    if (match.Count() > 0)
                    {
                        return(new OperateResult
                        {
                            content = "用户已经存在",
                        });
                    }

                    db.logRecordList.Add(model);
                    db.SaveChanges();

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                    });
                }
                catch (Exception ex)
                {
                    return(new OperateResult
                    {
                        content = ex.Message,
                    });
                }
            }
        }
示例#3
0
        public static OperateResult  GetByCode(string code)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var element = (from m in db.companyList
                                   where code == m.code
                                   select m
                                   ).FirstOrDefault();

                    if (element == null)
                    {
                        return(new OperateResult
                        {
                            content = "不存在该公司",
                        });
                    }

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = element,
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#4
0
        public OperateResult Update(AssessmentInfo model)
        {
            using (SystemDB db = new SystemDB())
            {
                try
                {
                    db.Entry(model).State = System.Data.Entity.EntityState.Modified;

                    db.SaveChanges();

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        content = "更新成功"
                    });
                }
                catch (Exception ex)
                {
                    return(new OperateResult
                    {
                        content = ex.Message,
                    });
                }
            }
        }
示例#5
0
        public static OperateResult  Add(Company model)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var match = from m in db.companyList
                                where m.name.Equals(model.name) || m.code.Equals(model.code)
                                select m;
                    if (match.Count() > 0)
                    {
                        return(new OperateResult
                        {
                            content = "该公司已经存在",
                        });
                    }

                    db.companyList.Add(model);
                    db.SaveChanges();

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#6
0
        public static OperateResult  GetById(long id)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var element = (from m in db.postInfoList
                                   where id == m.id
                                   select m
                                   ).FirstOrDefault();

                    if (element == null)
                    {
                        return(new OperateResult
                        {
                            content = "访问错误",
                        });
                    }

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = element,
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#7
0
        private long GetPersons(long departmentId)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    long p = db.employeeList.Count(x => x.departmentId == departmentId);

                    var sons = from e in db.departmentList
                               where e.parentId == departmentId
                               select e;
                    foreach (var d in sons)
                    {
                        p += GetPersons(d.id);
                    }

                    return(p);
                }
            }
            catch (Exception ex)
            {
                return(0);

                throw;
            }
        }
示例#8
0
        /// <summary>
        /// 当月低于该部门该岗位平均实发工资
        /// </summary>
        /// <param name="employee"></param>
        /// <returns></returns>
        private static OperateResult CalSalaryInDepInPost(Employee employee)
        {
            if (employee.postInfo == null)
            {
                return(new OperateResult
                {
                    content = "无岗位信息",
                });
            }

            try
            {
                var db = new SystemDB();

                //得到最近一次该员工的工资数据
                var record = db.salaryRecordList.Where(m => m.assessmentInfo.employeeId == employee.id)
                             .OrderByDescending(m => m.assessmentInfo.month)
                             .Select(m => m).FirstOrDefault();

                if (record == null)
                {
                    return(new OperateResult
                    {
                        content = "还未存在工资数据,无法就行分析",
                    });
                }

                //得到最近一月部门内该岗位平均工资
                var ave = db.salaryRecordList.Where(m => m.assessmentInfo.month == record.assessmentInfo.month &&
                                                    m.assessmentInfo.employee.departmentId ==
                                                    record.assessmentInfo.employee.departmentId &&
                                                    m.assessmentInfo.employee.postId ==
                                                    record.assessmentInfo.employee.postId)
                          .Average(m => m.actualTotal);

                if (record.actualTotal < ave)
                {
                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = true
                    });
                }
                else
                {
                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = false
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#9
0
        public static OperateResult GetAll(QueryParam param = null)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var elements = (from e in db.logRecordList.Include("user")
                                    select new
                    {
                        e.id,
                        e.time,
                        e.content,
                        e.type,
                        e.user.name
                    }
                                    ).ToList();

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = elements,
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#10
0
        public OperateResult GetById(long id)
        {
            using (SystemDB db = new SystemDB())
            {
                try
                {
                    var element = (from m in db.userList
                                   where id == m.id
                                   select m
                                   ).FirstOrDefault();

                    if (element == null)
                    {
                        return(new OperateResult
                        {
                            content = "访问错误",
                        });
                    }

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = element,
                    });
                }
                catch (Exception ex)
                {
                    return(new OperateResult
                    {
                        content = ex.Message,
                    });
                }
            }
        }
示例#11
0
        public static OperateResult  GetAll(QueryParam param = null)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var elements = (from e in db.postInfoList
                                    select e
                                    ).ToList();

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = elements,
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#12
0
        public static OperateResult  GetAll(QueryParam param = null)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var elements = (from e in db.departmentList
                                    let persons = db.employeeList.Count(x => x.departmentId == e.id)
                                                  select new
                    {
                        e.id,
                        e.name,
                        e.code,
                        _parentId = e.parentId,
                        parentName = e.parent.name,
                        persons = persons
                    }
                                    ).ToList();

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = elements,
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#13
0
        public OperateResult GetAll(QueryParam param = null)
        {
            using (SystemDB db = new SystemDB())
            {
                try
                {
                    var elements = (from e in db.userList
                                    select new
                    {
                        e.id,
                        e.name,
                    }
                                    ).ToList();

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = elements,
                    });
                }
                catch (Exception ex)
                {
                    return(new OperateResult
                    {
                        content = ex.Message,
                    });
                }
            }
        }
示例#14
0
        public OperateResult Add(Module model)
        {
            using (SystemDB db = new SystemDB())
            {
                try
                {
                    var match = from m in db.moduleList
                                where m.name.Equals(model.name)
                                select m;
                    if (match.Count() > 0)
                    {
                        return(new OperateResult
                        {
                            content = "该模块已经存在",
                        });
                    }

                    db.moduleList.Add(model);
                    db.SaveChanges();

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                    });
                }
                catch (Exception ex)
                {
                    return(new OperateResult
                    {
                        content = ex.Message,
                    });
                }
            }
        }
示例#15
0
        public static OperateResult RemoveAll()
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    db.postInfoList.RemoveRange(db.postInfoList.ToList());

                    db.SaveChanges();

                    LogManager.Add(new LogRecord
                    {
                        userId  = SessionHelper.GetUserId(),
                        time    = DateTime.Now,
                        type    = "Info",
                        content = "删除所有岗位信息"
                    });

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        content = "删除成功"
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#16
0
        public static OperateResult  GetAll(QueryParam param = null)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var elements = (from e in db.moduleList
                                    orderby e.showIndex ascending
                                    select new
                    {
                        e.id,
                        e.name,
                        _parentId = e.parentId,
                        parentName = e.parent.name
                    }
                                    ).ToList();

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = elements,
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#17
0
        public static OperateResult Update(AssessmentInfo model)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    model.inputDate       = DateTime.Now;
                    db.Entry(model).State = System.Data.Entity.EntityState.Modified;

                    db.SaveChanges();

                    LogManager.Add(new LogRecord
                    {
                        userId  = SessionHelper.GetUserId(),
                        time    = DateTime.Now,
                        type    = "Info",
                        content = "修改考核:" + model.billSerial
                    });

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        content = "更新成功"
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#18
0
        public static OperateResult Add(AssessmentInfo model)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var match = from m in db.assessmentInfoList
                                where m.employeeId == model.employeeId && m.month == model.month
                                select m;
                    if (match.Count() > 0)
                    {
                        return(new OperateResult
                        {
                            content = "单号为(" + model.billSerial + ")的员工数据已经存在;",
                        });
                    }

                    var salary = (from s in db.employeeList
                                  where s.id == model.employeeId &&
                                  s.salaryInfoId != null
                                  select s).FirstOrDefault();
                    if (salary == null)
                    {
                        return(new OperateResult
                        {
                            content = "单号为(" + model.billSerial + ")的员工还未设定薪酬;",
                        });
                    }


                    model.inputDate = DateTime.Now;
                    model.status    = "未审核";

                    db.assessmentInfoList.Add(model);
                    db.SaveChanges();

                    LogManager.Add(new LogRecord
                    {
                        userId  = SessionHelper.GetUserId(),
                        time    = DateTime.Now,
                        type    = "Info",
                        content = "添加考核:" + model.billSerial
                    });

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = "单号为(" + model.billSerial + ")的员工,保存发生错误:"
                              + Model.Utility.Utility.GetExceptionMsg(ex) + ";",
                });
            }
        }
示例#19
0
        public OperateResult GetByPager(QueryParam param = null)
        {
            using (SystemDB db = new SystemDB())
            {
                try
                {
                    var elements = from e in db.moduleList
                                   select new
                    {
                        e.id,
                        e.name,
                        _parentId = e.parentId
                    };

                    int total = elements.Count();

                    /*
                     * int pages = 0;
                     * Pager pager = param.pager;
                     * if (pager == null || pager.rows == 0)
                     * {
                     *  pages = total > 0 ? 1 : 0;
                     * }
                     * else
                     * {
                     *  pages = total / (pager.rows == 0 ? 10 : pager.rows);
                     *  pages = total % pager.rows == 0 ? pages : pages + 1;
                     *  if (pager.page <= 1)
                     *  {
                     *      elements = elements.Take(pager.rows);
                     *  }
                     *  else
                     *  {
                     *      elements = elements.Skip((pager.page - 1) * pager.rows).Take(pager.rows);
                     *  }
                     * }
                     */
                    var data = new
                    {
                        pages = 1,
                        total,
                        rows = elements.ToList()
                    };

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = data,
                    });
                }
                catch (Exception ex)
                {
                    return(new OperateResult
                    {
                        content = ex.Message,
                    });
                }
            }
        }
示例#20
0
        public OperateResult GetByPager(QueryParam param = null)
        {
            using (SystemDB db = new SystemDB())
            {
                try
                {
                    var elements = from e in db.userList.Include("role")
                                   select new
                    {
                        e.id,
                        e.name,
                        roleName = e.role.name,
                        e.status,
                        e.lastLogin
                    };

                    int   total = elements.Count();
                    int   pages = 0;
                    Pager pager = param.pager;
                    if (pager == null || pager.rows == 0)
                    {
                        pages = total > 0 ? 1 : 0;
                    }
                    else
                    {
                        pages = total / (pager.rows == 0 ? 10 : pager.rows);
                        pages = total % pager.rows == 0 ? pages : pages + 1;
                        if (pager.page <= 1)
                        {
                            elements = elements.Take(pager.rows);
                        }
                        else
                        {
                            elements = elements.Skip((pager.page - 1) * pager.rows).Take(pager.rows);
                        }
                    }

                    var data = new
                    {
                        pages,
                        total,
                        rows = elements.ToList()
                    };

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = data,
                    });
                }
                catch (Exception ex)
                {
                    return(new OperateResult
                    {
                        content = ex.Message,
                    });
                }
            }
        }
示例#21
0
        public static OperateResult  ModifyPasswd(long id, string pwdOld, string pwd)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var element = (from m in db.userList
                                   where id == m.id
                                   select m
                                   ).FirstOrDefault();

                    if (element == null)
                    {
                        return(new OperateResult
                        {
                            content = "访问错误",
                        });
                    }

                    if (element.passwd != MD5Encode.Encode16(pwdOld))
                    {
                        return(new OperateResult
                        {
                            content = "原密码错误",
                        });
                    }


                    element.passwd = MD5Encode.Encode16(pwd);

                    db.Entry(element).State = System.Data.Entity.EntityState.Modified;

                    db.SaveChanges();

                    LogManager.Add(new LogRecord
                    {
                        userId  = SessionHelper.GetUserId(),
                        time    = DateTime.Now,
                        type    = "Info",
                        content = "重置密码:" + element.name
                    });


                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        content = "更新成功"
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#22
0
        public static OperateResult  GetByPager(QueryParam param = null)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var elements = from e in db.performanceInfoList
                                   orderby e.id
                                   select new
                    {
                        e.id,
                        e.code,
                        e.performanceRewards,
                    };

                    int   total = elements.Count();
                    int   pages = 0;
                    Pager pager = param.pager;
                    if (pager == null || pager.rows == 0)
                    {
                        pages = total > 0 ? 1 : 0;
                    }
                    else
                    {
                        pages = total / (pager.rows == 0 ? 20 : pager.rows);
                        pages = total % pager.rows == 0 ? pages : pages + 1;
                        if (pager.page <= 1)
                        {
                            elements = elements.Take(pager.rows);
                        }
                        else
                        {
                            elements = elements.Skip((pager.page - 1) * pager.rows).Take(pager.rows);
                        }
                    }

                    var data = new
                    {
                        pages,
                        total,
                        rows = elements.ToList()
                    };

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = data,
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#23
0
        public static OperateResult  Update(Department model)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var elements = (from e in db.departmentList
                                    where e.id != model.id && e.name == model.name
                                    select e
                                    ).ToList();
                    if (elements.Count() >= 1)
                    {
                        return(new OperateResult
                        {
                            content = "已经存在同名的部门",
                        });
                    }


                    var matchs = (from e in db.departmentList
                                  where e.id == model.parentId && e.parentId == model.id
                                  select e
                                  ).ToList();
                    if (matchs.Count() >= 1)
                    {
                        return(new OperateResult
                        {
                            content = "该部门与其上级部门互为上下部门",
                        });
                    }
                    db.Entry(model).State = EntityState.Modified;

                    db.SaveChanges();

                    LogManager.Add(new LogRecord
                    {
                        userId  = SessionHelper.GetUserId(),
                        time    = DateTime.Now,
                        type    = "Info",
                        content = "修改部门:" + model.name
                    });

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        content = "更新成功"
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#24
0
        /// <summary>
        /// 当月实发工资小于或等于该岗位已离职员工平均工资
        /// </summary>
        /// <param name="employee"></param>
        /// <returns></returns>
        private static OperateResult CalSalaryInHistoryPost(Employee employee)
        {
            if (employee.postInfo == null)
            {
                return(new OperateResult
                {
                    content = "无岗位信息",
                });
            }

            try
            {
                var db = new SystemDB();

                //得到最近一次该员工的工资数据
                var record = db.salaryRecordList.Where(m => m.assessmentInfo.employeeId == employee.id)
                             .OrderByDescending(m => m.assessmentInfo.month)
                             .Select(m => m).FirstOrDefault();

                if (record == null)
                {
                    return(new OperateResult
                    {
                        content = "还未存在工资数据,无法就行分析",
                    });
                }

                var ave = (from s in db.salaryRecordList
                           join e in db.EmployeeLeaveList on s.assessmentInfo.employeeId equals e.employeeId
                           where e.postId == employee.postId
                           select s.actualTotal).Average();

                if (record.actualTotal < ave)
                {
                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = true
                    });
                }
                else
                {
                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = false
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#25
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="employee">实发工资</param>
        /// <returns>计算成功返回status返回success,如果成立则data返回true,否则返回false</returns>
        private static OperateResult CalSalaryActualTotal(Employee employee)
        {
            try
            {
                var db = new SystemDB();

                var total = db.EmployeeLeaveList.Count();
                var count = 0;

                var salaryInfo = db.salaryInfoList.Where(m => m.id == employee.salaryInfoId)
                                 .Select(m => m).FirstOrDefault();
                if (salaryInfo == null)
                {
                    return(new OperateResult
                    {
                        content = "无薪酬信息",
                    });
                }

                var actualTotal = salaryInfo.GetSalaryTotal();

                var dimensionGroup = db.EmployeeLeaveList.GroupBy(g => g.salary)
                                     .Select(m => new { salary = m.Key, count = m.Count() })
                                     .OrderByDescending(m => m.count)
                                     .ThenBy(m => m.salary);

                foreach (var item in dimensionGroup)
                {
                    count += item.count;
                    if (Math.Abs(item.salary - actualTotal) < 0.01)
                    {
                        double percent = count / (double)total;
                        if (percent < LeaveLimitPercent)
                        {
                            return(new OperateResult
                            {
                                status = OperateStatus.Success,
                                data = true,
                            });
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
            return(new OperateResult
            {
                status = OperateStatus.Success,
                data = false,
            });
        }
示例#26
0
        /// <summary>
        /// 先移除role所有的权限,然后重新加入
        /// </summary>
        /// <param name="roleId"></param>
        /// <param name="idList"></param>
        /// <returns></returns>
        public static OperateResult  AssignRight(long roleId, List <long> idList)
        {
            try
            {
                using (SystemDB db = new SystemDB())
                {
                    var role = (from e in db.roleList.Include("rightList")
                                where e.id == roleId
                                select e).FirstOrDefault();
                    if (role == null)
                    {
                        return(new OperateResult
                        {
                            content = "找不到角色"
                        });
                    }

                    role.rightList.Clear();

                    foreach (var rid in idList)
                    {
                        var model = db.rightList.Find(rid);
                        role.rightList.Add(model);
                    }

                    db.Entry(role).State = EntityState.Modified;

                    //db.Configuration.ValidateOnSaveEnabled = false;
                    db.SaveChanges();
                    //db.Configuration.ValidateOnSaveEnabled = true;

                    LogManager.Add(new LogRecord
                    {
                        userId  = SessionHelper.GetUserId(),
                        time    = DateTime.Now,
                        type    = "Info",
                        content = "分配权限:" + role.name
                    });


                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        content = "更新成功"
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#27
0
        public static OperateResult  GetModuleTree(QueryParam param = null)
        {
            if (param == null || param.filters == null ||
                !param.filters.Keys.Contains("roleId"))
            {
                return(new OperateResult
                {
                    content = "没有权限"
                });
            }

            var  p      = param.filters["roleId"];
            long roleId = Convert.ToInt64(p.value ?? "0");

            try
            {
                Dictionary <Module, IEnumerable <Module> > map = new Dictionary <Module, IEnumerable <Module> >();

                var or = GetModulesByRoleId(roleId);
                if (or.status != OperateStatus.Success)
                {
                    return(or);
                }

                IEnumerable <Module> elements = or.data as IEnumerable <Module>;

                using (SystemDB db = new SystemDB())
                {
                    var parents = from e in elements
                                  where e.parentId == null
                                  select e;
                    foreach (var m in parents)
                    {
                        var suns = from s in elements
                                   where s.parentId == m.id
                                   select s;

                        map.Add(m, suns);
                    }

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        data = map,
                    });
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
        }
示例#28
0
        public OperateResult Remove(long id)
        {
            using (SystemDB db = new SystemDB())
            {
                try
                {
                    var element  = db.departmentList.Find(id);
                    var elements = db.departmentList.ToList();

                    if (element == null)
                    {
                        return(new OperateResult
                        {
                            content = "不存在该部门",
                        });
                    }
                    var query = from e in elements
                                where e.parentId == element.id
                                select e;
                    if (query.Count() > 0)
                    {
                        return(new OperateResult
                        {
                            content = "该部门存在下级部门,不能删除",
                        });
                    }

                    db.departmentList.Remove(element);

                    db.Entry(element).State = System.Data.Entity.EntityState.Deleted;
                    db.SaveChanges();

                    LogManager.Add(new LogRecord
                    {
                        userId  = SessionHelper.GetUserId(),
                        time    = DateTime.Now,
                        type    = "Info",
                        content = "删除用户:" + element.name
                    });

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        content = "删除成功"
                    });
                }
                catch (Exception ex)
                {
                    return(new OperateResult
                    {
                        content = ex.Message,
                    });
                }
            }
        }
示例#29
0
        /// <summary>
        /// 司龄月数离职率占比相加达60%的司龄段
        /// 按照月为单元计算
        /// </summary>
        /// <param name="employee"></param>
        /// <returns>计算成功返回status返回success,如果成立则data返回true,否则返回false</returns>
        private static OperateResult CalWorkAge(Employee employee)
        {
            if (employee.entryDate == null)
            {
                return(new OperateResult()
                {
                    content = "入职日期有误"
                });
            }
            try
            {
                SystemDB dbLeave = new SystemDB();

                var total = dbLeave.EmployeeLeaveList.Count();
                var count = 0;

                //按照月计算
                int workAge = Model.Utility.Utility.CalMonths(employee.entryDate.Value, DateTime.Now);

                var dimensionGroup = dbLeave.EmployeeLeaveList.AsEnumerable().GroupBy(g => Model.Utility.Utility.CalMonths(g.entryDate.Value, g.leaveDate.Value))
                                     .Select(m => new { workAge = m.Key, count = m.Count() })
                                     .OrderBy(m => m.count);

                foreach (var item in dimensionGroup)
                {
                    count += item.count;
                    if (item.workAge == workAge)
                    {
                        double percent = count / (double)total;
                        if (percent < LeaveLimitPercent)
                        {
                            return(new OperateResult
                            {
                                status = OperateStatus.Success,
                                data = true,
                            });
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                return(new OperateResult
                {
                    content = Model.Utility.Utility.GetExceptionMsg(ex),
                });
            }
            return(new OperateResult
            {
                status = OperateStatus.Success,
                data = false,
            });
        }
示例#30
0
        public OperateResult Update(User model)
        {
            using (SystemDB db = new SystemDB())
            {
                try
                {
                    var element = (from e in db.userList
                                   where e.id != model.id && e.name == model.name
                                   select e
                                   ).FirstOrDefault();
                    if (element != null)
                    {
                        return(new OperateResult
                        {
                            content = "已经存在同名",
                        });
                    }
                    element = (from e in db.userList
                               where e.id == model.id
                               select e
                               ).AsNoTracking().FirstOrDefault();

                    model.passwd = element.passwd;

                    db.Configuration.ValidateOnSaveEnabled = false;
                    db.Entry(model).State = System.Data.Entity.EntityState.Modified;

                    db.SaveChanges();

                    LogManager.Add(new LogRecord
                    {
                        userId  = SessionHelper.GetUserId(),
                        time    = DateTime.Now,
                        type    = "Info",
                        content = "修改用户:" + model.name
                    });

                    return(new OperateResult
                    {
                        status = OperateStatus.Success,
                        content = "更新成功"
                    });
                }
                catch (Exception ex)
                {
                    return(new OperateResult
                    {
                        content = ex.Message,
                    });
                }
            }
        }