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/HrJibengongziService.cs | 202 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 202 insertions(+), 0 deletions(-)
diff --git a/zhengcaioa/Services/HrJibengongziService.cs b/zhengcaioa/Services/HrJibengongziService.cs
new file mode 100644
index 0000000..661461c
--- /dev/null
+++ b/zhengcaioa/Services/HrJibengongziService.cs
@@ -0,0 +1,202 @@
+锘縰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 HrJibengongziService: IHrJibengongziService
+ {
+ private readonly zhengcaioaContext _context;
+ private readonly IMapper _mapper;
+ public HrJibengongziService(zhengcaioaContext context, IMapper mapper)
+ {
+ _context = context;
+ _mapper = mapper;
+ }
+
+ public ResultEntity save(HrJibengongziDTO dto)
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ try
+ {
+ var model = _mapper.Map<HrJibengongzi>(dto);
+ if (String.IsNullOrEmpty(model.Id))
+ {
+ model.Id = Guid.NewGuid().ToString();
+
+
+ _context.HrJibengongzis.Add(model);
+ }
+ else
+ {
+ var updatepltRole = _context.HrJibengongzis.Find(model.Id);
+ updatepltRole.PostId = model.PostId;
+ updatepltRole.Jibengongzi = model.Jibengongzi;
+ updatepltRole.Baomifei = model.Baomifei;
+ updatepltRole.Shebaodanwei = model.Shebaodanwei;
+ updatepltRole.Shebaogeren = model.Shebaogeren;
+ updatepltRole.Quanqingjiang = model.Quanqingjiang;
+ updatepltRole.Dianhuabutie = model.Dianhuabutie;
+
+ updatepltRole.Jiaotongbutie = model.Jiaotongbutie;
+
+
+ updatepltRole.Effecttime = model.Effecttime;
+
+ 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 HrJibengongziDTO Get(string id)
+ {
+ var entity = _context.HrJibengongzis.Find(id);
+
+ if (entity.RecStatus != "A")
+ {
+ entity = new HrJibengongzi();
+ }
+ var HrJibengongziDTO = _mapper.Map<HrJibengongziDTO>(entity);
+ return HrJibengongziDTO;
+ }
+
+ public ResultDataEntity<HrJibengongziDTO> SearchByPaging(HrJibengongziDTOSearch searchEntity)
+ {
+ ResultDataEntity<HrJibengongziDTO> data = new ResultDataEntity<HrJibengongziDTO>();
+
+ 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
+ }
+ );
+
+ var query = (from a in _context.HrJibengongzis//.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.HrPositions
+ on a.PostId equals f.Id
+ into fsssss
+ from fff in fsssss.DefaultIfEmpty()
+
+ where a.RecStatus == "A"
+ && (string.IsNullOrWhiteSpace(searchEntity.PostId) || a.PostId == searchEntity.PostId.Trim())
+ select new HrJibengongziDTO
+ {
+ Id = a.Id,
+ PostId = a.PostId,
+ PostName = fff.PostName,
+ Jibengongzi = a.Jibengongzi,
+ Baomifei = a.Baomifei,
+ Shebaodanwei = a.Shebaodanwei,
+ Shebaogeren = a.Shebaogeren,
+ Dianhuabutie = a.Dianhuabutie,
+ Quanqingjiang = a.Quanqingjiang,
+ Jiaotongbutie = a.Jiaotongbutie,
+
+ JibengongziName = a.Jibengongzi.HasValue? a.Jibengongzi.Value.ToString("F2"):"",
+ BaomifeiName = a.Baomifei.HasValue ? a.Baomifei.Value.ToString("F2") : "",
+ ShebaodanweiName = a.Shebaodanwei.HasValue ? a.Shebaodanwei.Value.ToString("F2") : "",
+ ShebaogerenName = a.Shebaogeren.HasValue ? a.Shebaogeren.Value.ToString("F2") : "",
+ DianhuabutieName = bbb.Comments,
+ QuanqingjiangName = a.Quanqingjiang.HasValue ? a.Quanqingjiang.Value.ToString("F2") : "",
+ JiaotongbutieName = a.Jiaotongbutie.HasValue ? a.Jiaotongbutie.Value.ToString("F2") : "",
+ Effecttime = a.Effecttime,
+ EffecttimeName = a.Effecttime.HasValue ? a.Effecttime.Value.ToString("yyyy-MM-dd") : "",
+
+
+
+
+ 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.HrJibengongzis.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<HrJibengongziDTO> GetList()
+ {
+
+
+ var listPosition = _context.HrJibengongzis.Where(r => r.RecStatus == "A" ).ToList();
+
+ var list = _mapper.Map<List<HrJibengongziDTO>>(listPosition);
+ return list;
+ }
+ }
+}
--
Gitblit v1.9.1