using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using AutoMapper;
|
using DTO;
|
using IServices;
|
using Microsoft.AspNetCore.Mvc.Rendering;
|
using Microsoft.EntityFrameworkCore;
|
using zhengcaioa.Models;
|
|
namespace Services
|
{
|
public partial class ExpertService: IExpertService
|
{
|
private readonly zhengcaioaContext _context;
|
private readonly IMapper _mapper;
|
public ExpertService(zhengcaioaContext context, IMapper mapper)
|
{
|
_context = context;
|
_mapper = mapper;
|
}
|
public ResultEntity save(ExpertDTO expertDTO)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
if (!string.IsNullOrEmpty(expertDTO.IdCard))
|
{
|
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))
|
{
|
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;
|
}
|
|
public ExpertDTO Get(string id)
|
{
|
Expert entity = _context.Experts.Find(id);
|
if (entity.RecStatus != "A")
|
{
|
entity = new Expert();
|
}
|
ExpertDTO exDTO = _mapper.Map<ExpertDTO>(entity);
|
return exDTO;
|
}
|
|
public ResultDataEntity<ExpertDTO> SearchByPaging(ExpertDTOSearch searchEntity)
|
{
|
|
|
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
|
}
|
);
|
|
ResultDataEntity<ExpertDTO> data = new ResultDataEntity<ExpertDTO>();
|
List<ExpertDTO> list = new List<ExpertDTO>();
|
//筛选
|
var query = (from a in _context.Experts
|
join h in _context.ExpertOrderDispatches.Where(x => x.RecStatus == "A").GroupBy(q => new { q.ExpertId }).Select(q => new
|
{
|
ExpertId = q.Key.ExpertId,
|
JoinCount = q.Count(),
|
})
|
|
|
on a.Id equals h.ExpertId
|
into hsss
|
from hhh in hsss.DefaultIfEmpty()
|
|
|
join c in listCode.Where(x => x.CodeTable == "experts" && x.CodeField == "level")
|
on a.Level equals c.CodeSn
|
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)
|
select new ExpertDTO
|
{
|
Id = a.Id,
|
Name = a.Name,
|
Sex = a.Sex,
|
InfoSource = a.InfoSource,
|
IdCard = a.IdCard,
|
Province = a.Province,
|
AreaId = a.AreaId,
|
City = a.City,
|
|
Address = a.Address,
|
Postal = a.Postal,
|
ExpertType = a.ExpertType,
|
|
Level = a.Level,
|
LevelName = ccc.Comments,
|
Phone1 = a.Phone1,
|
Phone2 = a.Phone2,
|
Qq = a.Qq,
|
|
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,
|
|
Wechat = a.Wechat,
|
ReviewItem = a.ReviewItem,
|
CertiNumber = a.CertiNumber,
|
CertiFont = a.CertiFont,
|
CertiBack = a.CertiBack,
|
TitileCerti = a.TitileCerti,
|
|
Sort = a.Sort,
|
ShenheStatus = a.ShenheStatus,
|
|
AreaName = nnn.Name + "-" + ooo.Name,
|
YearJiou = a.YearJiou,
|
YearJiouName = ppp.Comments,
|
|
}).ToList();
|
|
if (!string.IsNullOrEmpty(searchEntity.Name))
|
{
|
query = query.Where(m => m.Name.Contains(searchEntity.Name)).ToList();
|
}
|
if (!string.IsNullOrEmpty(searchEntity.ShenheStatus))
|
{
|
query = query.Where(m => m.ShenheStatus == searchEntity.ShenheStatus).ToList();
|
}
|
if (!string.IsNullOrEmpty(searchEntity.ExpertType))
|
{
|
query = query.Where(m => m.ExpertType == searchEntity.ExpertType).ToList();
|
}
|
DateTime startDate = DateTime.Now;
|
DateTime endDate = DateTime.Now;
|
if (!string.IsNullOrEmpty(searchEntity.Createtime))
|
{
|
string[] arr = searchEntity.Createtime.Split("|");
|
startDate = Convert.ToDateTime(arr[0]);
|
endDate = Convert.ToDateTime(arr[1]).AddDays(1);
|
query = query.Where(m => m.Createtime >= startDate && m.Createtime < endDate).ToList();
|
}
|
|
if (!string.IsNullOrEmpty(searchEntity.Province))
|
{
|
query = query.Where(m => m.Province.Contains(searchEntity.Province)).ToList();
|
}
|
|
if (!string.IsNullOrEmpty(searchEntity.City))
|
{
|
query = query.Where(m => m.City == searchEntity.City).ToList();
|
}
|
if (!string.IsNullOrEmpty(searchEntity.ReviewItem))
|
{
|
query = query.Where(m => m.ReviewItem.Contains(searchEntity.ReviewItem)).ToList();
|
}
|
|
if (!string.IsNullOrEmpty(searchEntity.Level))
|
{
|
query = query.Where(m => m.Level == searchEntity.Level).ToList();
|
}
|
if (!string.IsNullOrEmpty(searchEntity.CertiNumber))
|
{
|
query = query.Where(m => m.CertiNumber != null && m.CertiNumber.Contains(searchEntity.CertiNumber)).ToList();
|
}
|
if (!string.IsNullOrEmpty(searchEntity.Phone1))
|
{
|
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)
|
searchEntity.totalrows = query.Count();
|
var expertlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
|
//list = _mapper.Map<List<ExpertDTO>>(expertlist);
|
|
data.LoadData(searchEntity, expertlist);
|
return data;
|
|
}
|
|
public ResultEntity ModifyStatus(string id, string userid)
|
{
|
ResultEntity result = new ResultEntity();
|
result.Result = true;
|
|
var model = _context.Experts.Find(id);
|
if (model != null)
|
{
|
model.RecStatus = "D";
|
model.Modifier = userid;
|
model.Modifytime = DateTime.Now;
|
_context.SaveChanges();
|
}
|
|
return result;
|
}
|
|
public List<ExpertDTO> GetList(string[] id = null)
|
{
|
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;
|
}
|
|
#region 保存专家推广记录
|
public ResultEntity SaveExpPromote(ExpertPromoteDTO expertPromoteDTO)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
ExpertPromote expPromote = _mapper.Map<ExpertPromote>(expertPromoteDTO);
|
if (string.IsNullOrEmpty(expPromote.Id))
|
{
|
expPromote.Id = Guid.NewGuid().ToString();
|
_context.ExpertPromotes.Add(expPromote);
|
}
|
_context.SaveChanges();
|
resultEntity.ReturnID = expPromote.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
ex.Message.ToString();
|
}
|
return resultEntity;
|
}
|
|
public ResultDataEntity<ExpertPromoteDTO> SearchExpPromote(ExpertPromoteDTOSearch searchEntity)
|
{
|
ResultDataEntity<ExpertPromoteDTO> data = new ResultDataEntity<ExpertPromoteDTO>();
|
List<ExpertPromoteDTO> list = new List<ExpertPromoteDTO>();
|
//筛选
|
var query = _context.ExpertPromotes
|
.Where(b => b.RecStatus == "A")
|
.ToList();
|
|
if (!string.IsNullOrEmpty(searchEntity.ExpertId))
|
{
|
query = query.Where(m => m.ExpertId.Contains(searchEntity.ExpertId)).ToList();
|
}
|
if (!string.IsNullOrEmpty(searchEntity.Createtime))
|
{
|
DateTime startDate = DateTime.Now;
|
DateTime endDate = DateTime.Now;
|
string[] arr = searchEntity.Createtime.Split("|");
|
startDate = Convert.ToDateTime(arr[0]);
|
endDate = Convert.ToDateTime(arr[1]).AddDays(1);
|
query = query.Where(m => m.Createtime >= startDate && m.Createtime < endDate).ToList();
|
}
|
if (!string.IsNullOrEmpty(searchEntity.Creater))
|
{
|
query = query.Where(m => m.Creater.Contains(searchEntity.Creater)).ToList();
|
}
|
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<ExpertPromoteDTO>>(expertlist);
|
|
data.LoadData(searchEntity, list);
|
return data;
|
|
|
}
|
#endregion
|
|
|
#region 订单派工
|
/// <summary>
|
/// 查询工单专家派工记录
|
/// </summary>
|
/// <param name="searchEntity"></param>
|
/// <returns></returns>
|
public ResultDataEntity<ExpertOrderDipatchDTO> SearchOrderDispatch(ExpertOrderDipatchDTOSearch searchEntity)
|
{
|
ResultDataEntity<ExpertOrderDipatchDTO> data = new ResultDataEntity<ExpertOrderDipatchDTO>();
|
List<ExpertOrderDipatchDTO> list = new List<ExpertOrderDipatchDTO>();
|
|
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
|
}
|
);
|
DateTime XdTimestart = DateTime.Now;
|
DateTime XdTimeend = DateTime.Now;
|
if (!string.IsNullOrWhiteSpace(searchEntity.XdTime))
|
{
|
string[] XdTimes = searchEntity.XdTime.Split("|");
|
DateTime.TryParse(XdTimes[0], out XdTimestart);
|
DateTime.TryParse(XdTimes[1], out XdTimeend);
|
//XdTimeend = XdTimeend.AddDays(1);
|
}
|
|
var query = (from a in _context.CooperOrders
|
|
join b in listCode.Where(x => x.CodeTable == "CooperOrder" && x.CodeField == "shouli_status")
|
on a.ShouliStatus equals b.CodeSn
|
into bsss
|
from bbb in bsss.DefaultIfEmpty()
|
|
join f in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "jtype")
|
on a.OrderType equals f.CodeSn
|
into fsssss
|
from fff in fsssss.DefaultIfEmpty()
|
|
|
join g in _context.CooperatecustomCustomers.Where(x => x.RecStatus == "A")
|
on a.Khdw equals g.Id
|
into gsss
|
from ggg in gsss.DefaultIfEmpty()
|
|
join h in _context.ExpertOrderDispatches.Where(x => x.RecStatus == "A")
|
on a.Id equals h.Orderid
|
into ho
|
from hod in ho.DefaultIfEmpty()
|
|
join j in _context.Experts.Where(x => x.RecStatus == "A")
|
on hod.ExpertId equals j.Id
|
into exp
|
from expt in exp.DefaultIfEmpty()
|
|
|
where a.RecStatus == "A"
|
&& (string.IsNullOrWhiteSpace(searchEntity.XdTime) || (a.XdTime >= XdTimestart && a.XdTime <= XdTimeend))
|
&& (string.IsNullOrWhiteSpace(searchEntity.Ywjl) || ggg.Ywjl == searchEntity.Ywjl.Trim())
|
&& (string.IsNullOrWhiteSpace(searchEntity.OrderType) || a.OrderType == searchEntity.OrderType.Trim())
|
&& (string.IsNullOrWhiteSpace(searchEntity.OrderNo) || a.OrderNo.Contains(searchEntity.OrderNo.Trim()))
|
&& (string.IsNullOrWhiteSpace(searchEntity.KhdwName) || ggg.Name.Contains(searchEntity.KhdwName.Trim()))
|
&& (string.IsNullOrWhiteSpace(searchEntity.Khlx) || ggg.Khlx == searchEntity.Khlx.Trim())
|
&& (string.IsNullOrWhiteSpace(searchEntity.isDispatch) || (searchEntity.isDispatch == "1" && hod.Id!=null) || (searchEntity.isDispatch == "0" && hod.Id == null) )
|
&& (string.IsNullOrWhiteSpace(searchEntity.ExpertId) || hod.ExpertId == searchEntity.ExpertId.Trim())
|
|
|
// && (string.IsNullOrWhiteSpace(searchEntity.HuifangStatus) || a.HuifangStatus.Contains(searchEntity.HuifangStatus.Trim()))
|
// && (string.IsNullOrWhiteSpace(searchEntity.PingjiaStatus) || a.PingjiaStatus.Contains(searchEntity.PingjiaStatus.Trim()))
|
|
|
|
select new ExpertOrderDipatchDTO
|
{
|
Id = a.Id,
|
XdTime = a.XdTime,
|
XdTimeName = a.XdTime.ToString("yyyy-MM-dd"),
|
OrderId = a.Id,
|
OrderNo = a.OrderNo,
|
Khdw = a.Khdw,
|
KhdwName = ggg.Name,
|
OrderType = a.OrderType,
|
OrderTypeName = fff.Comments,
|
|
//OrderPro = a.OrderPro,
|
//OrderProName = hhh.Name,
|
//OrderNum = a.OrderNum,
|
|
Shr = a.Shr,
|
ShrAddress = a.ShrAddress,
|
ShrTel = a.ShrTel,
|
Money = hod.Money,
|
Creater = hod.Creater,
|
Createtime = hod.Createtime,
|
ExpertId = hod.ExpertId,
|
ExpertName = expt.Name,
|
RecStatus = hod.RecStatus,
|
Modifier = hod.Modifier,
|
Modifytime = hod.Modifytime
|
|
|
}
|
).OrderByDescending(x => x.XdTime).ToList();
|
|
|
|
//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);
|
return data;
|
}
|
public ResultEntity SaveDispatch(ExpertOrderDipatchDTO dipatchDTO)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
ExpertOrderDispatch dispatch = _mapper.Map<ExpertOrderDispatch>(dipatchDTO);
|
if (string.IsNullOrEmpty(dispatch.Id))
|
{
|
dispatch.Id = Guid.NewGuid().ToString();
|
dipatchDTO.Id = dispatch.Id;
|
_context.ExpertOrderDispatches.Add(dispatch);
|
}
|
else
|
{
|
var model = _context.ExpertOrderDispatches.Find(dispatch.Id);
|
model.Orderid = dipatchDTO.OrderId;
|
model.ExpertId = dipatchDTO.ExpertId;
|
model.Money = dipatchDTO.Money;
|
model.RecStatus = dipatchDTO.RecStatus;
|
model.Modifier = dipatchDTO.Modifier;
|
model.Modifytime = dipatchDTO.Modifytime.Value;
|
model.Sort = dipatchDTO.sort;
|
}
|
_context.SaveChanges();
|
resultEntity.ReturnID = dispatch.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
ex.Message.ToString();
|
}
|
return resultEntity;
|
}
|
|
#endregion
|
|
#region 专家结算
|
/// <summary>
|
/// 查询专家结算
|
/// </summary>
|
/// <param name="searchEntity"></param>
|
/// <returns></returns>
|
public ResultDataEntity<ExpertOrderDipatchDTO> SearchJiesuan(ExpertOrderDipatchDTOSearch searchEntity)
|
{
|
ResultDataEntity<ExpertOrderDipatchDTO> data = new ResultDataEntity<ExpertOrderDipatchDTO>();
|
List<ExpertOrderDipatchDTO> list = new List<ExpertOrderDipatchDTO>();
|
|
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
|
}
|
);
|
DateTime PdTimestart = DateTime.Now;
|
DateTime PdTimeend = DateTime.Now;
|
if (!string.IsNullOrWhiteSpace(searchEntity.PdTime))
|
{
|
string[] PdTimes = searchEntity.PdTime.Split("|");
|
DateTime.TryParse(PdTimes[0], out PdTimestart);
|
DateTime.TryParse(PdTimes[1], out PdTimeend);
|
PdTimeend = PdTimeend.AddDays(1);
|
}
|
|
var query = (from hod in _context.ExpertOrderDispatches.Where(x => x.RecStatus == "A")
|
|
|
|
|
join a in _context.CooperOrders on hod.Orderid equals a.Id
|
|
join b in listCode.Where(x => x.CodeTable == "CooperOrder" && x.CodeField == "shouli_status")
|
on a.ShouliStatus equals b.CodeSn
|
into bsss
|
from bbb in bsss.DefaultIfEmpty()
|
|
join f in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "jtype")
|
on a.OrderType equals f.CodeSn
|
into fsssss
|
from fff in fsssss.DefaultIfEmpty()
|
|
|
join k in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou")
|
on hod.Sort equals k.CodeSn
|
into ksssss
|
from kkk in ksssss.DefaultIfEmpty()
|
|
|
join ggg in _context.CooperatecustomCustomers
|
on a.Khdw equals ggg.Id
|
|
|
|
|
join expt in _context.Experts
|
on hod.ExpertId equals expt.Id
|
|
|
|
where a.RecStatus == "A"
|
&& (string.IsNullOrWhiteSpace(searchEntity.PdTime) || (hod.Createtime >= PdTimestart && hod.Createtime <= PdTimeend))
|
&& (string.IsNullOrWhiteSpace(searchEntity.ExpertId) || hod.ExpertId == searchEntity.ExpertId.Trim())
|
&& (string.IsNullOrWhiteSpace(searchEntity.OrderNo) || a.OrderNo.Contains(searchEntity.OrderNo.Trim()))
|
|
&& (string.IsNullOrWhiteSpace(searchEntity.Sort) || hod.Sort == searchEntity.Sort.Trim())
|
|
|
|
|
|
select new ExpertOrderDipatchDTO
|
{
|
Id = hod.Id,
|
XdTime = a.XdTime,
|
XdTimeName = a.XdTime.ToString("yyyy-MM-dd"),
|
OrderId = a.Id,
|
OrderNo = a.OrderNo,
|
Khdw = a.Khdw,
|
KhdwName = ggg.Name,
|
OrderType = a.OrderType,
|
OrderTypeName = fff.Comments,
|
|
//OrderPro = a.OrderPro,
|
//OrderProName = hhh.Name,
|
//OrderNum = a.OrderNum,
|
|
Shr = a.Shr,
|
ShrAddress = a.ShrAddress,
|
ShrTel = a.ShrTel,
|
Money = hod.Money,
|
Creater = hod.Creater,
|
Createtime = hod.Createtime,
|
CreatetimeName = hod.Createtime.ToString("yyyy-MM-dd"),
|
ExpertId = hod.ExpertId,
|
ExpertName = expt.Name,
|
RecStatus = hod.RecStatus,
|
Modifier = hod.Modifier,
|
Modifytime = hod.Modifytime,
|
sort = kkk.Comments,
|
|
}
|
).OrderByDescending(x => x.XdTime).ToList();
|
|
|
|
//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);
|
return data;
|
}
|
#endregion
|
|
|
|
|
public ExpertOrderDipatchDTO GetDispatch(string id)
|
{
|
var entity = _context.ExpertOrderDispatches.Find(id);
|
if (entity.RecStatus != "A")
|
{
|
entity = new ExpertOrderDispatch();
|
}
|
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;
|
}
|
}
|
}
|
