From 0e5c4a8e17dcefcc10b2507da61b099be12451d8 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 12 一月 2024 12:52:52 +0800
Subject: [PATCH] 代理合作功能
---
zhengcaioa/Services/ExpertService.cs | 299 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 280 insertions(+), 19 deletions(-)
diff --git a/zhengcaioa/Services/ExpertService.cs b/zhengcaioa/Services/ExpertService.cs
index b1fb522..440a386 100644
--- a/zhengcaioa/Services/ExpertService.cs
+++ b/zhengcaioa/Services/ExpertService.cs
@@ -25,13 +25,42 @@
ResultEntity resultEntity = new ResultEntity();
try
{
- var list = _context.Experts.Where(e => e.IdCard == expertDTO.IdCard && e.RecStatus == "A" && e.Id != expertDTO.Id).ToList();
- if (list.Count > 0 )
+ if (!string.IsNullOrEmpty(expertDTO.IdCard))
{
- resultEntity.Result = false;
- resultEntity.Message = "璇ヤ笓瀹朵俊鎭凡缁忓瓨鍦�";
- return resultEntity;
+ var list = _context.Experts.Where(e => e.IdCard == expertDTO.IdCard && e.RecStatus == "A" && e.Id != expertDTO.Id).ToList();
+ if (list.Count > 0)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "璇ヤ笓瀹惰韩浠借瘉淇℃伅宸茬粡瀛樺湪";
+ return resultEntity;
+ }
}
+
+ if (!string.IsNullOrEmpty(expertDTO.Phone1))
+ {
+ var list = _context.Experts.Where(e => e.Phone1 == expertDTO.Phone1 && e.RecStatus == "A" && e.Id != expertDTO.Id).ToList();
+ if (list.Count > 0)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "璇ヤ笓瀹惰仈绯荤數璇濅俊鎭凡缁忓瓨鍦�";
+ return resultEntity;
+ }
+ }
+
+ if (!string.IsNullOrEmpty(expertDTO.CertiNumber))
+ {
+ var list = _context.Experts.Where(e => e.CertiNumber == expertDTO.CertiNumber && e.RecStatus == "A" && e.Id != expertDTO.Id).ToList();
+ if (list.Count > 0)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "璇ヤ笓瀹朵笓瀹惰瘉鍙蜂俊鎭凡缁忓瓨鍦�";
+ return resultEntity;
+ }
+ }
+
+
+
+
Expert expert = _mapper.Map<Expert>(expertDTO);
if (string.IsNullOrEmpty(expert.Id))
{
@@ -41,6 +70,11 @@
else
{
var updateplExpert = _context.Experts.Find(expert.Id);
+ if(updateplExpert.Creater == "1")
+ {
+ updateplExpert.Creater = expert.Modifier;
+ updateplExpert.Createtime = expert.Modifytime;
+ }
updateplExpert.Name = expert.Name;
updateplExpert.Sex = expert.Sex;
updateplExpert.InfoSource = expert.InfoSource;
@@ -73,6 +107,9 @@
updateplExpert.TitileCerti9 = expert.TitileCerti9;
updateplExpert.TitileCerti10 = expert.TitileCerti10;
updateplExpert.ShenheStatus = expert.ShenheStatus;
+ updateplExpert.Modifier = expert.Modifier;
+ updateplExpert.Modifytime = expert.Modifytime;
+ updateplExpert.YearJiou = expert.YearJiou;
}
_context.SaveChanges();
@@ -142,6 +179,28 @@
into csss
from ccc in csss.DefaultIfEmpty()
+ join m in _context.PltUsers
+ on a.Creater equals m.Id
+ into msssss
+ from mmm in msssss.DefaultIfEmpty()
+
+
+ join n in _context.Areas
+ on a.Province equals n.CodeId
+ into nsssss
+ from nnn in nsssss.DefaultIfEmpty()
+
+ join o in _context.Areas
+ on a.City equals o.CodeId
+ into osssss
+ from ooo in osssss.DefaultIfEmpty()
+
+
+ join p in listCode.Where(x => x.CodeTable == "experts" && x.CodeField == "year_jiou")
+ on a.YearJiou equals p.CodeSn
+ into psss
+ from ppp in psss.DefaultIfEmpty()
+
where a.RecStatus == "A"
&& (searchEntity.JoinCount<=0 || hhh.JoinCount >= searchEntity.JoinCount)
@@ -169,8 +228,9 @@
Remark = a.Remark,
Creater = a.Creater,
+ CreaterName = mmm.UserName,
Createtime = a.Createtime,
-
+ CreatetimeName = a.Createtime.ToString("yyyy-MM-dd"),
RecStatus = a.RecStatus,
Modifier = a.Modifier,
Modifytime = a.Modifytime,
@@ -184,8 +244,11 @@
Sort = a.Sort,
ShenheStatus = a.ShenheStatus,
-
-
+
+ AreaName = nnn.Name + "-" + ooo.Name,
+ YearJiou = a.YearJiou,
+ YearJiouName = ppp.Comments,
+
}).ToList();
if (!string.IsNullOrEmpty(searchEntity.Name))
@@ -212,7 +275,7 @@
if (!string.IsNullOrEmpty(searchEntity.Province))
{
- query = query.Where(m => m.Province == searchEntity.Province).ToList();
+ query = query.Where(m => m.Province.Contains(searchEntity.Province)).ToList();
}
if (!string.IsNullOrEmpty(searchEntity.City))
@@ -230,16 +293,23 @@
}
if (!string.IsNullOrEmpty(searchEntity.CertiNumber))
{
- query = query.Where(m => m.CertiNumber.Contains(searchEntity.CertiNumber)).ToList();
+ query = query.Where(m => m.CertiNumber != null && m.CertiNumber.Contains(searchEntity.CertiNumber)).ToList();
}
if (!string.IsNullOrEmpty(searchEntity.Phone1))
{
- query = query.Where(m => m.Phone1.Contains(searchEntity.Phone1)).ToList();
+ query = query.Where(m => m.Phone1 != null && m.Phone1.Contains(searchEntity.Phone1)).ToList();
+ }
+ if (!string.IsNullOrEmpty(searchEntity.Creater))
+ {
+ query = query.Where(m => m.Creater == searchEntity.Creater).ToList();
+ }
+ if (!string.IsNullOrEmpty(searchEntity.YearJiou))
+ {
+ query = query.Where(m => m.YearJiou == searchEntity.YearJiou).ToList();
}
-
- query = query.OrderByDescending(x => x.Modifytime).ToList();
- if (searchEntity.totalrows == 0)
+ query = query.OrderByDescending(x => x.Modifytime).ToList();
+ //if (searchEntity.totalrows == 0)
searchEntity.totalrows = query.Count();
var expertlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
//list = _mapper.Map<List<ExpertDTO>>(expertlist);
@@ -266,9 +336,17 @@
return result;
}
- public List<ExpertDTO> GetList()
+ public List<ExpertDTO> GetList(string[] id = null)
{
- var listExperts = _context.Experts.Where(e => e.RecStatus == "A").ToList();
+ var listExperts = _context.Experts.Where(e => e.RecStatus == "A" && e.ShenheStatus == "A").ToList();
+
+ if (id != null)
+ {
+
+ listExperts = listExperts.Where(r => id.Contains(r.Id)).ToList();
+ }
+
+
var list = _mapper.Map<List<ExpertDTO>>(listExperts);
return list;
}
@@ -325,7 +403,7 @@
query = query.Where(m => m.Creater.Contains(searchEntity.Creater)).ToList();
}
query = query.OrderByDescending(x => x.Modifytime).ToList();
- if (searchEntity.totalrows == 0)
+ //if (searchEntity.totalrows == 0)
searchEntity.totalrows = query.Count();
var expertlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
list = _mapper.Map<List<ExpertPromoteDTO>>(expertlist);
@@ -455,7 +533,7 @@
- if (searchEntity.totalrows == 0)
+ //if (searchEntity.totalrows == 0)
searchEntity.totalrows = query.Count();
var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
data.LoadData(searchEntity, lianlist);
@@ -618,7 +696,7 @@
- if (searchEntity.totalrows == 0)
+ //if (searchEntity.totalrows == 0)
searchEntity.totalrows = query.Count();
var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
data.LoadData(searchEntity, lianlist);
@@ -639,5 +717,188 @@
var exDTO = _mapper.Map<ExpertOrderDipatchDTO>(entity);
return exDTO;
}
+
+
+ public ResultEntity IdCardChongfu(string IdCard = "", string Id = "")
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ resultEntity.Result = true;
+ try
+ {
+ if (!string.IsNullOrEmpty(IdCard))
+ {
+ var list = _context.Experts.Where(e => e.IdCard == IdCard && e.RecStatus == "A" && e.Id != Id).ToList();
+ if (list.Count > 0)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "璇ヤ笓瀹惰韩浠借瘉淇℃伅宸茬粡瀛樺湪";
+ return resultEntity;
+ }
+ }
+
+
+
+
+
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "鏌ヨ澶辫触锛岃鑱旂郴绠＄悊鍛�";
+ ex.Message.ToString();
+ }
+ return resultEntity;
+ }
+
+ public ResultEntity CertiNumberChongfu(string CertiNumber = "", string Id = "")
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ resultEntity.Result = true;
+ try
+ {
+
+
+
+
+ if (!string.IsNullOrEmpty(CertiNumber))
+ {
+ var list = _context.Experts.Where(e => e.CertiNumber == CertiNumber && e.RecStatus == "A" && e.Id != Id).ToList();
+ if (list.Count > 0)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "璇ヤ笓瀹朵笓瀹惰瘉鍙蜂俊鎭凡缁忓瓨鍦�";
+ return resultEntity;
+ }
+ }
+
+
+
+
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "鏌ヨ澶辫触锛岃鑱旂郴绠＄悊鍛�";
+ ex.Message.ToString();
+ }
+ return resultEntity;
+ }
+
+
+ public ResultEntity Phone1Chongfu(string Phone1 = "", string Id = "")
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ resultEntity.Result = true;
+ try
+ {
+
+
+ if (!string.IsNullOrEmpty(Phone1))
+ {
+ var list = _context.Experts.Where(e => e.Phone1 == Phone1 && e.RecStatus == "A" && e.Id != Id).ToList();
+ if (list.Count > 0)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "璇ヤ笓瀹惰仈绯荤數璇濅俊鎭凡缁忓瓨鍦�";
+ return resultEntity;
+ }
+ }
+
+
+
+
+
+
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "鏌ヨ澶辫触锛岃鑱旂郴绠＄悊鍛�";
+ ex.Message.ToString();
+ }
+ return resultEntity;
+ }
+
+
+ public List<ExpertDTO> GetListsalary(string userid, DateTime datemin, DateTime datemax)
+ {
+
+
+ var listPosition = _context.Experts.Where(r => r.RecStatus == "A"&& r.ShenheStatus=="A"&& r.Creater == userid && r.Createtime >= datemin && r.Createtime < datemax).ToList();
+
+ var list = _mapper.Map<List<ExpertDTO>>(listPosition);
+ return list;
+ }
+
+
+ public ResultEntity savehezuo(ExpertDTO expertDTO)
+ {
+ ResultEntity resultEntity = new ResultEntity();
+ try
+ {
+
+ Expert expert = _mapper.Map<Expert>(expertDTO);
+ if (string.IsNullOrEmpty(expert.Id))
+ {
+ expert.Id = Guid.NewGuid().ToString();
+ _context.Experts.Add(expert);
+ }
+ else
+ {
+ var updateplExpert = _context.Experts.Find(expert.Id);
+ if (updateplExpert.Creater == "1")
+ {
+ updateplExpert.Creater = expert.Modifier;
+ updateplExpert.Createtime = expert.Modifytime;
+ }
+ updateplExpert.Name = expert.Name;
+ updateplExpert.Sex = expert.Sex;
+ updateplExpert.InfoSource = expert.InfoSource;
+ updateplExpert.IdCard = expert.IdCard;
+ updateplExpert.Province = expert.Province;
+ updateplExpert.AreaId = expert.AreaId;
+ updateplExpert.City = expert.City;
+ updateplExpert.Address = expert.Address;
+ updateplExpert.Postal = expert.Postal;
+ updateplExpert.ExpertType = expert.ExpertType;
+ updateplExpert.Level = expert.Level;
+ updateplExpert.Phone1 = expert.Phone1;
+ updateplExpert.Phone2 = expert.Phone2;
+ updateplExpert.Qq = expert.Qq;
+ updateplExpert.Wechat = expert.Wechat;
+ updateplExpert.ReviewItem = expert.ReviewItem;
+ updateplExpert.CertiNumber = expert.CertiNumber;
+ updateplExpert.CertiFont = expert.CertiFont;
+ updateplExpert.CertiBack = expert.CertiBack;
+ updateplExpert.TitileCerti = expert.TitileCerti;
+ updateplExpert.Remark = expert.Remark;
+ updateplExpert.TitileCerti1 = expert.TitileCerti1;
+ updateplExpert.TitileCerti2 = expert.TitileCerti2;
+ updateplExpert.TitileCerti3 = expert.TitileCerti3;
+ updateplExpert.TitileCerti4 = expert.TitileCerti4;
+ updateplExpert.TitileCerti5 = expert.TitileCerti5;
+ updateplExpert.TitileCerti6 = expert.TitileCerti6;
+ updateplExpert.TitileCerti7 = expert.TitileCerti7;
+ updateplExpert.TitileCerti8 = expert.TitileCerti8;
+ updateplExpert.TitileCerti9 = expert.TitileCerti9;
+ updateplExpert.TitileCerti10 = expert.TitileCerti10;
+ updateplExpert.ShenheStatus = expert.ShenheStatus;
+ updateplExpert.Modifier = expert.Modifier;
+ updateplExpert.Modifytime = expert.Modifytime;
+ updateplExpert.YearJiou = expert.YearJiou;
+ }
+
+ _context.SaveChanges();
+ resultEntity.ReturnID = expert.Id;
+ resultEntity.Result = true;
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "淇濆瓨澶辫触锛岃鑱旂郴绠＄悊鍛�";
+ ex.Message.ToString();
+ }
+ return resultEntity;
+ }
}
}
--
Gitblit v1.9.1