From 7b9e068cfe4e295f9ee960457d848c631f0136c7 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 27 八月 2021 16:09:56 +0800
Subject: [PATCH] 工作交接
---
zhengcaioa/Services/AskService.cs | 450 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 450 insertions(+), 0 deletions(-)
diff --git a/zhengcaioa/Services/AskService.cs b/zhengcaioa/Services/AskService.cs
index 2e45284..6d145f8 100644
--- a/zhengcaioa/Services/AskService.cs
+++ b/zhengcaioa/Services/AskService.cs
@@ -319,5 +319,455 @@
}
#endregion
+
+ #region 浼樻儬鐢宠
+ public ResultEntity SaveAskYouHui(AdmAskYouHuiDTO admAsk)
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ try
+ {
+ AdmAskYouHui ask = _mapper.Map<AdmAskYouHui>(admAsk);
+ if (string.IsNullOrEmpty(admAsk.Id))
+ {
+ ask.Id = Guid.NewGuid().ToString();
+ admAsk.Id = ask.Id;
+ _context.AdmAskYouHuis.Add(ask);
+ }
+ else
+ {
+ var entity = _context.AdmAskYouHuis.Find(admAsk.Id);
+
+ entity.CustomerId = admAsk.CustomerId;
+ entity.OrderType = admAsk.OrderType;
+ entity.Youhuistandard = admAsk.Youhuistandard;
+ entity.YouHui = admAsk.YouHui;
+ entity.Remark = admAsk.Remark;
+
+
+ entity.ShenpiStatus = admAsk.ShenpiStatus;
+ entity.CreaterName = admAsk.CreaterName;
+ entity.Tittle = admAsk.Tittle;
+
+
+
+ entity.Modifier = admAsk.Modifier;
+ entity.Modifytime = DateTime.Now;
+ }
+ _context.SaveChanges();
+ resultEntity.ReturnID = ask.Id;
+ resultEntity.Result = true;
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "淇濆瓨澶辫触锛岃鑱旂郴绠＄悊鍛�";
+ ex.Message.ToString();
+ }
+
+ return resultEntity;
+ }
+
+ public AdmAskYouHuiDTO GetAskYouHui(string Id)
+ {
+ var entity = _context.AdmAskYouHuis.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
+ if (entity == null)
+ {
+ entity = new AdmAskYouHui();
+ }
+ var leaveDTO = _mapper.Map<AdmAskYouHuiDTO>(entity);
+ return leaveDTO;
+
+ }
+
+ public List<AdmAskYouHuiDTO> GetAskYouHuiList(string CustomerId, string OrderType)
+ {
+ var entity = _context.AdmAskYouHuis.Where(e => e.RecStatus == "A" && e.ShenpiStatus == "A" && e.CustomerId == CustomerId && e.OrderType == OrderType && e.Createtime >= DateTime.Now.Date.AddDays(-8)).OrderByDescending(x=>x.Createtime).ToList();
+
+ var leaveDTO = _mapper.Map<List<AdmAskYouHuiDTO>>(entity);
+ return leaveDTO;
+
+ }
+ #endregion
+
+ #region 璁块棶璇风ず
+ public ResultEntity SaveAskBaiFang(AdmAskBaiFangDTO admAsk)
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ try
+ {
+ AdmAskBaiFang ask = _mapper.Map<AdmAskBaiFang>(admAsk);
+ if (string.IsNullOrEmpty(admAsk.Id))
+ {
+ ask.Id = Guid.NewGuid().ToString();
+ admAsk.Id = ask.Id;
+ _context.AdmAskBaiFangs.Add(ask);
+ }
+ else
+ {
+ var entity = _context.AdmAskBaiFangs.Find(admAsk.Id);
+
+ entity.CustomerId = admAsk.CustomerId;
+ entity.VisType = admAsk.VisType;
+ entity.Jtype = admAsk.Jtype;
+ entity.BaiFangtime = admAsk.BaiFangtime;
+ entity.Remark = admAsk.Remark;
+
+
+ entity.ShenpiStatus = admAsk.ShenpiStatus;
+ entity.CreaterName = admAsk.CreaterName;
+ entity.Tittle = admAsk.Tittle;
+
+
+
+ entity.Modifier = admAsk.Modifier;
+ entity.Modifytime = DateTime.Now;
+ }
+ _context.SaveChanges();
+ resultEntity.ReturnID = ask.Id;
+ resultEntity.Result = true;
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "淇濆瓨澶辫触锛岃鑱旂郴绠＄悊鍛�";
+ ex.Message.ToString();
+ }
+
+ return resultEntity;
+ }
+
+ public AdmAskBaiFangDTO GetAskBaiFang(string Id)
+ {
+ var entity = _context.AdmAskBaiFangs.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
+ if (entity == null)
+ {
+ entity = new AdmAskBaiFang();
+ }
+ var leaveDTO = _mapper.Map<AdmAskBaiFangDTO>(entity);
+ return leaveDTO;
+
+ }
+
+ #endregion
+
+ #region 浼氬憳鎻愮幇鐢宠
+ public ResultEntity SaveCustomerWithdrawal(AdmCustomerWithdrawalDTO admAsk)
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ try
+ {
+ AdmCustomerWithdrawal ask = _mapper.Map<AdmCustomerWithdrawal>(admAsk);
+ if (string.IsNullOrEmpty(admAsk.Id))
+ {
+ ask.Id = Guid.NewGuid().ToString();
+ admAsk.Id = ask.Id;
+ _context.AdmCustomerWithdrawals.Add(ask);
+ }
+ else
+ {
+ var entity = _context.AdmCustomerWithdrawals.Find(admAsk.Id);
+
+ entity.OrderNo = admAsk.OrderNo;
+ entity.Jine = admAsk.Jine;
+ entity.HuiyuanName = admAsk.HuiyuanName;
+ entity.HuiyuanId = admAsk.HuiyuanId;
+ entity.HuiyuanPhone = admAsk.HuiyuanPhone;
+ entity.Shenqingtime = admAsk.Shenqingtime;
+
+ entity.BankAcount = admAsk.BankAcount;
+ entity.BankName = admAsk.BankName;
+ entity.Username = admAsk.Username;
+
+
+ entity.ShenpiStatus = admAsk.ShenpiStatus;
+ entity.CreaterName = admAsk.CreaterName;
+ entity.Tittle = admAsk.Tittle;
+
+
+
+ entity.Modifier = admAsk.Modifier;
+ entity.Modifytime = DateTime.Now;
+ }
+ _context.SaveChanges();
+ resultEntity.ReturnID = ask.Id;
+ resultEntity.Result = true;
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "淇濆瓨澶辫触锛岃鑱旂郴绠＄悊鍛�";
+ ex.Message.ToString();
+ }
+
+ return resultEntity;
+ }
+
+ public AdmCustomerWithdrawalDTO GetCustomerWithdrawal(string Id)
+ {
+ var entity = _context.AdmCustomerWithdrawals.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
+ if (entity == null)
+ {
+ entity = new AdmCustomerWithdrawal();
+ }
+ var leaveDTO = _mapper.Map<AdmCustomerWithdrawalDTO>(entity);
+ return leaveDTO;
+
+ }
+
+ public List<AdmCustomerWithdrawalDTO> GetCustomerWithdrawalList(string OrderNo)
+ {
+ var entity = _context.AdmCustomerWithdrawals.Where(e => e.RecStatus == "A" && e.OrderNo == OrderNo).ToList();
+
+ var leaveDTO = _mapper.Map<List<AdmCustomerWithdrawalDTO>>(entity);
+ return leaveDTO;
+
+ }
+
+ #endregion
+
+
+ #region 杈炶亴鐢宠
+ public ResultEntity SaveAskCiZhi(AdmAskCiZhiDTO admAsk)
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ try
+ {
+ AdmAskCiZhi ask = _mapper.Map<AdmAskCiZhi>(admAsk);
+ if (string.IsNullOrEmpty(admAsk.Id))
+ {
+ ask.Id = Guid.NewGuid().ToString();
+ admAsk.Id = ask.Id;
+ _context.AdmAskCiZhis.Add(ask);
+ }
+ else
+ {
+ var entity = _context.AdmAskCiZhis.Find(admAsk.Id);
+
+ entity.Remark = admAsk.Remark;
+ entity.DeptName = admAsk.DeptName;
+ entity.PostName = admAsk.PostName;
+ entity.CreatetimeName = admAsk.CreatetimeName;
+ entity.RuzhitimeName = admAsk.RuzhitimeName;
+ entity.Outtime = admAsk.Outtime;
+
+
+
+
+ entity.ShenpiStatus = admAsk.ShenpiStatus;
+ entity.CreaterName = admAsk.CreaterName;
+ entity.Tittle = admAsk.Tittle;
+ entity.JiaojieUser = admAsk.JiaojieUser;
+
+
+ entity.Modifier = admAsk.Modifier;
+ entity.Modifytime = DateTime.Now;
+ }
+ _context.SaveChanges();
+ resultEntity.ReturnID = ask.Id;
+ resultEntity.Result = true;
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "淇濆瓨澶辫触锛岃鑱旂郴绠＄悊鍛�";
+ ex.Message.ToString();
+ }
+
+ return resultEntity;
+ }
+
+ public AdmAskCiZhiDTO GetAskCiZhi(string Id)
+ {
+ var entity = _context.AdmAskCiZhis.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
+ if (entity == null)
+ {
+ entity = new AdmAskCiZhi();
+ }
+ var leaveDTO = _mapper.Map<AdmAskCiZhiDTO>(entity);
+ return leaveDTO;
+
+ }
+
+
+
+ #endregion
+
+
+ #region 宸ヤ綔浜ゆ帴
+ public ResultEntity SaveAskJiaojie(AdmAskJiaojieDTO admAsk)
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ try
+ {
+ AdmAskJiaojie ask = _mapper.Map<AdmAskJiaojie>(admAsk);
+ if (string.IsNullOrEmpty(admAsk.Id))
+ {
+ ask.Id = Guid.NewGuid().ToString();
+ admAsk.Id = ask.Id;
+ _context.AdmAskJiaojies.Add(ask);
+ }
+ else
+ {
+ var entity = _context.AdmAskJiaojies.Find(admAsk.Id);
+
+ entity.Remark = admAsk.Remark;
+ entity.CiZhiId = admAsk.CiZhiId;
+
+
+
+
+
+ entity.ShenpiStatus = admAsk.ShenpiStatus;
+ entity.CreaterName = admAsk.CreaterName;
+ entity.Tittle = admAsk.Tittle;
+
+
+
+ entity.Modifier = admAsk.Modifier;
+ entity.Modifytime = DateTime.Now;
+ }
+ _context.SaveChanges();
+ resultEntity.ReturnID = admAsk.Id;
+ resultEntity.Result = true;
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "淇濆瓨澶辫触锛岃鑱旂郴绠＄悊鍛�";
+ ex.Message.ToString();
+ }
+
+ return resultEntity;
+ }
+
+ public AdmAskJiaojieDTO GetAskJiaojie(string Id)
+ {
+ var entity = _context.AdmAskJiaojies.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
+ if (entity == null)
+ {
+ entity = new AdmAskJiaojie();
+ }
+ var leaveDTO = _mapper.Map<AdmAskJiaojieDTO>(entity);
+ return leaveDTO;
+
+ }
+
+ public ResultEntity SaveAskJiaojieDtl(AdmAskJiaojieDtlDTO admAsk)
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ try
+ {
+ AdmAskJiaojieDtl ask = _mapper.Map<AdmAskJiaojieDtl>(admAsk);
+ if (string.IsNullOrEmpty(admAsk.Id))
+ {
+ ask.Id = Guid.NewGuid().ToString();
+ admAsk.Id = ask.Id;
+ _context.AdmAskJiaojieDtls.Add(ask);
+ }
+ else
+ {
+ var entity = _context.AdmAskJiaojieDtls.Find(admAsk.Id);
+
+ entity.JiaojieId = admAsk.JiaojieId;
+ entity.Jiaojietime = admAsk.Jiaojietime;
+
+
+
+
+
+ entity.JiaojieType = admAsk.JiaojieType;
+ entity.Kehudanwei = admAsk.Kehudanwei;
+ entity.JiaojieNeirong = admAsk.JiaojieNeirong;
+ entity.JiaojieUserId = admAsk.JiaojieUserId;
+ entity.JieShoutime = admAsk.JieShoutime;
+ entity.JiaojieStatus = admAsk.JiaojieStatus;
+
+
+ entity.Modifier = admAsk.Modifier;
+ entity.Modifytime = DateTime.Now;
+ }
+ _context.SaveChanges();
+ resultEntity.ReturnID = ask.Id;
+ resultEntity.Result = true;
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "淇濆瓨澶辫触锛岃鑱旂郴绠＄悊鍛�";
+ ex.Message.ToString();
+ }
+
+ return resultEntity;
+ }
+
+ public List<AdmAskJiaojieDtlDTO> GetAskJiaojieDtls(string JiaojieId)
+ {
+ var entity = _context.AdmAskJiaojieDtls.Where(e => e.RecStatus == "A" && e.JiaojieId == JiaojieId).OrderBy(x=>x.JiaojieType).ToList();
+
+ var leaveDTOs = _mapper.Map<List<AdmAskJiaojieDtlDTO>>(entity);
+
+ 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"
+ && b.CodeTable == "ADM_AskJiaojieDtl"
+ && b.CodeField == "JiaojieType"
+ 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
+ }
+ ).ToList();
+ var pltUsers = _context.PltUsers.Where(e => e.RecStatus == "A" && e.Zhiwustatus == "A").ToList();
+
+
+ foreach (var leaveDTO in leaveDTOs)
+ {
+ leaveDTO.JiaojietimeName = leaveDTO.Jiaojietime.HasValue ? leaveDTO.Jiaojietime.Value.ToString("yyyy-MM-dd") : "";
+ leaveDTO.JieShoutimeName = leaveDTO.JieShoutime.HasValue ? leaveDTO.JieShoutime.Value.ToString("yyyy-MM-dd") : "";
+
+ var codeDataEntity = listCode.Where(x => x.CodeSn == leaveDTO.JiaojieType).FirstOrDefault();
+ if (codeDataEntity != null)
+ {
+ leaveDTO.JiaojieTypeName = codeDataEntity.Comments;
+ }
+
+ var pltUser = pltUsers.Where(x => x.Id == leaveDTO.JiaojieUserId).FirstOrDefault();
+ if (pltUser != null)
+ {
+ leaveDTO.JiaojieUserName = pltUser.UserName;
+ }
+
+
+ }
+
+
+ return leaveDTOs;
+
+ }
+
+
+ public AdmAskJiaojieDtlDTO GetAskJiaojieDtl(string Id)
+ {
+ var entity = _context.AdmAskJiaojieDtls.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
+ if (entity == null)
+ {
+ entity = new AdmAskJiaojieDtl();
+ }
+ var leaveDTO = _mapper.Map<AdmAskJiaojieDtlDTO>(entity);
+ return leaveDTO;
+
+ }
+
+
+ #endregion
+
}
}
--
Gitblit v1.9.1