From 8db98fe1142211c9941d9c7d944394c5d7a33159 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 21 六月 2021 09:17:53 +0800
Subject: [PATCH] 提交
---
zhengcaioa/Services/HrSalaryService.cs | 277 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 277 insertions(+), 0 deletions(-)
diff --git a/zhengcaioa/Services/HrSalaryService.cs b/zhengcaioa/Services/HrSalaryService.cs
new file mode 100644
index 0000000..b9bbfec
--- /dev/null
+++ b/zhengcaioa/Services/HrSalaryService.cs
@@ -0,0 +1,277 @@
+锘縰sing AutoMapper;
+using DTO;
+using IServices;
+using Microsoft.EntityFrameworkCore;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using zhengcaioa.Models;
+
+
+namespace Services
+{
+ public class HrSalaryService: IHrSalaryService
+ {
+ private readonly zhengcaioaContext _context;
+ private readonly IMapper _mapper;
+ public HrSalaryService(zhengcaioaContext context, IMapper mapper)
+ {
+ _context = context;
+ _mapper = mapper;
+ }
+
+ public ResultEntity save(HrSalaryDTO dto)
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ try
+ {
+ var model = _mapper.Map<HrSalary>(dto);
+ if (String.IsNullOrEmpty(model.Id))
+ {
+ model.Id = Guid.NewGuid().ToString();
+
+
+ _context.HrSalaries.Add(model);
+ }
+ else
+ {
+ var updatepltRole = _context.HrSalaries.Find(model.Id);
+ updatepltRole.Userid = model.Userid;
+ updatepltRole.Year = model.Year;
+ updatepltRole.Month = model.Month;
+ updatepltRole.Jibengongzi = model.Jibengongzi;
+ updatepltRole.Baomifei = model.Baomifei;
+ updatepltRole.Gongzuobutie = model.Gongzuobutie;
+ updatepltRole.Jiabangongzi = model.Jiabangongzi;
+
+ updatepltRole.Shebao = model.Shebao;
+
+
+ updatepltRole.Dianhuabutie = model.Dianhuabutie;
+
+ updatepltRole.Quanqinjiang = model.Quanqinjiang;
+ updatepltRole.Jiaotngbutie = model.Jiaotngbutie;
+ updatepltRole.Jixiaoticheng = model.Jixiaoticheng;
+ updatepltRole.Jiangjin = model.Jiangjin;
+ updatepltRole.Bufagongzi = model.Bufagongzi;
+ updatepltRole.Shebaokou = model.Shebaokou;
+ updatepltRole.Geshui = model.Geshui;
+ updatepltRole.Dianhuafei = model.Dianhuafei;
+ updatepltRole.Queqin = model.Queqin;
+ updatepltRole.Fakuan = model.Fakuan;
+ updatepltRole.Peichang = model.Peichang;
+ updatepltRole.Jiucuo = model.Jiucuo;
+ updatepltRole.Daozhanggongzi = model.Daozhanggongzi;
+ updatepltRole.Yufagongzi = model.Yufagongzi;
+ updatepltRole.Yufagongziheji = model.Yufagongziheji;
+
+ updatepltRole.Islock = model.Islock;
+
+
+
+
+
+ updatepltRole.RecStatus = model.RecStatus;
+ // updatepltRole.Creater = pltRole.Creater;
+ //updatepltRole.Createtime = pltRole.Createtime;
+ updatepltRole.Modifier = model.Modifier;
+ updatepltRole.Modifytime = model.Modifytime;
+
+ }
+
+ _context.SaveChanges();
+ resultEntity.ReturnID = model.Id;
+ resultEntity.Result = true;
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "淇濆瓨澶辫触锛岃鑱旂郴绠＄悊鍛�";
+
+ }
+ return resultEntity;
+ }
+
+ public HrSalaryDTO Get(string id)
+ {
+ var entity = _context.HrSalaries.Find(id);
+
+ if (entity.RecStatus != "A")
+ {
+ entity = new HrSalary();
+ }
+ var HrSalaryDTO = _mapper.Map<HrSalaryDTO>(entity);
+ return HrSalaryDTO;
+ }
+
+ public ResultDataEntity<HrSalaryDTO> SearchByPaging(HrSalaryDTOSearch searchEntity)
+ {
+ ResultDataEntity<HrSalaryDTO> data = new ResultDataEntity<HrSalaryDTO>();
+
+ //var listCode = (from a in _context.SysCodeDtls
+ // join b in _context.SysCodes
+ // on a.CodeId equals b.Id
+ // where a.RecStatus == "A"
+ // && b.RecStatus == "A"
+ // select new CodeDataEntity()
+ // {
+ // CodeId = b.Id,
+ // CodeTable = b.CodeTable,
+ // CodeField = b.CodeField,
+ // CodeSn = a.CodeSn,
+ // Comments = a.Comments,
+ // Contents = a.Contents,
+ // RecStatus = a.RecStatus,
+ // Sort = a.Sort
+ // }
+ // );
+
+ int year = 0;
+ int month = 0;
+ if (string.IsNullOrWhiteSpace(searchEntity.YearMonth))
+ {
+ DateTime yearMonth = DateTime.Parse(searchEntity.YearMonth + "-01");
+ year = yearMonth.Year;
+ month = yearMonth.Month;
+ }
+ var query = (from a in _context.HrSalaries//.Where(x => x.RecStatus == "A")
+ // join b in listCode.Where(x => x.CodeTable == "hr_jibengongzi" && x.CodeField == "dianhuabutie")
+ //on a.Dianhuabutie equals b.CodeSn
+ // into bsssss
+ // from bbb in bsssss.DefaultIfEmpty()
+
+ join f in _context.PltUsers
+ on a.Userid equals f.Id
+ // into fsssss
+ //from fff in fsssss.DefaultIfEmpty()
+
+ join g in _context.HrDepts
+ on f.DeptId equals g.Id
+ // into gsssss
+ //from ggg in gsssss.DefaultIfEmpty()
+
+ where a.RecStatus == "A"
+ && (string.IsNullOrWhiteSpace(searchEntity.Usernumber) || f.Usernumber == searchEntity.Usernumber.Trim())
+ && (string.IsNullOrWhiteSpace(searchEntity.DeptId) || f.DeptId == searchEntity.DeptId.Trim())
+ && (string.IsNullOrWhiteSpace(searchEntity.UserName) || f.UserName.Contains(searchEntity.UserName.Trim()))
+ && (string.IsNullOrWhiteSpace(searchEntity.YearMonth) || ( a.Year == year && a.Month == month ))
+ select new HrSalaryDTO
+ {
+ Id = a.Id,
+
+ Userid = a.Userid,
+ Usernumber = f.Usernumber,
+ UserName = f.UserName,
+ DeptName = g.DeptName,
+ Year = a.Year,
+ Month = a.Month,
+ Jibengongzi = a.Jibengongzi,
+ Baomifei = a.Baomifei,
+ Gongzuobutie = a.Gongzuobutie,
+ Jiabangongzi = a.Jiabangongzi,
+
+ Shebao = a.Shebao,
+
+
+ Dianhuabutie = a.Dianhuabutie,
+
+ Quanqinjiang = a.Quanqinjiang,
+ Jiaotngbutie = a.Jiaotngbutie,
+ Jixiaoticheng = a.Jixiaoticheng,
+ Jiangjin = a.Jiangjin,
+ Bufagongzi = a.Bufagongzi,
+ Shebaokou = a.Shebaokou,
+ Geshui = a.Geshui,
+ Dianhuafei = a.Dianhuafei,
+ Queqin = a.Queqin,
+ Fakuan = a.Fakuan,
+ Peichang = a.Peichang,
+ Jiucuo = a.Jiucuo,
+ Daozhanggongzi = a.Daozhanggongzi,
+ Yufagongzi = a.Yufagongzi,
+ Yufagongziheji = a.Yufagongziheji,
+
+
+ JibengongziName = a.Jibengongzi.HasValue ? a.Jibengongzi.Value.ToString("F2") : "",
+ BaomifeiName = a.Baomifei.HasValue ? a.Baomifei.Value.ToString("F2") : "",
+ GongzuobutieName = a.Gongzuobutie.HasValue ? a.Gongzuobutie.Value.ToString("F2") : "",
+ JiabangongziName = a.Jiabangongzi.HasValue ? a.Jiabangongzi.Value.ToString("F2") : "",
+ ShebaoName = a.Shebao.HasValue ? a.Shebao.Value.ToString("F2") : "",
+
+ DianhuabutieName = a.Dianhuabutie.HasValue ? a.Dianhuabutie.Value.ToString("F2") : "",
+ QuanqinjiangName = a.Quanqinjiang.HasValue ? a.Quanqinjiang.Value.ToString("F2") : "",
+ JiaotngbutieName = a.Jiaotngbutie.HasValue ? a.Jiaotngbutie.Value.ToString("F2") : "",
+ JixiaotichengName = a.Jixiaoticheng.HasValue ? a.Jixiaoticheng.Value.ToString("F2") : "",
+ JiangjinName = a.Jiangjin.HasValue ? a.Jiangjin.Value.ToString("F2") : "",
+ BufagongziName = a.Bufagongzi.HasValue ? a.Bufagongzi.Value.ToString("F2") : "",
+ ShebaokouName = a.Shebaokou.HasValue ? a.Shebaokou.Value.ToString("F2") : "",
+ GeshuiName = a.Geshui.HasValue ? a.Geshui.Value.ToString("F2") : "",
+ DianhuafeiName = a.Dianhuafei.HasValue ? a.Dianhuafei.Value.ToString("F2") : "",
+ QueqinName = a.Queqin.HasValue ? a.Queqin.Value.ToString("F2") : "",
+ FakuanName = a.Fakuan.HasValue ? a.Fakuan.Value.ToString("F2") : "",
+ PeichangName = a.Peichang.HasValue ? a.Peichang.Value.ToString("F2") : "",
+ JiucuoName = a.Jiucuo.HasValue ? a.Jiucuo.Value.ToString("F2") : "",
+ DaozhanggongziName = a.Daozhanggongzi.HasValue ? a.Daozhanggongzi.Value.ToString("F2") : "",
+ YufagongziName = a.Yufagongzi.HasValue ? a.Yufagongzi.Value.ToString("F2") : "",
+ YufagongzihejiName = a.Yufagongziheji.HasValue ? a.Yufagongziheji.Value.ToString("F2") : "",
+
+
+
+ Islock =a.Islock,
+ RecStatus = a.RecStatus,
+ Creater = a.Creater,
+ Createtime = a.Createtime,
+ Modifier = a.Modifier,
+ Modifytime = a.Modifytime,
+
+ }).OrderByDescending(x => x.Modifytime).ToList();
+
+
+
+
+
+
+
+ if (searchEntity.totalrows == 0)
+ searchEntity.totalrows = query.Count();
+ var rolelist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
+
+ data.LoadData(searchEntity, rolelist);
+ return data;
+ }
+
+ public ResultEntity ModifyStatus(string id, string userid)
+ {
+
+ ResultEntity result = new ResultEntity();
+ result.Result = true;
+
+ var model = _context.HrSalaries.Find(id);
+ if (model != null)
+ {
+ model.RecStatus = "D";
+ model.Modifier = userid;
+ model.Modifytime = DateTime.Now;
+ _context.SaveChanges();
+ }
+
+ return result;
+ }
+
+
+ /// <summary>
+ /// 鑾峰彇鎵�鏈夋湁鏁堣鑹�
+ /// </summary>
+ /// <returns></returns>
+ public List<HrSalaryDTO> GetList()
+ {
+
+
+ var listPosition = _context.HrSalaries.Where(r => r.RecStatus == "A").ToList();
+
+ var list = _mapper.Map<List<HrSalaryDTO>>(listPosition);
+ return list;
+ }
+ }
+}
--
Gitblit v1.9.1