| | |
|---|
| | | updateproject.Dailicontact = project.Dailicontact; |
|---|
| | | updateproject.Dailiaddress = project.Dailiaddress; |
|---|
| | | updateproject.Fencha = project.Fencha; |
|---|
| | | updateproject.Shuliang = updateproject.Shuliang; |
|---|
| | | updateproject.Shuliang = project.Shuliang; |
|---|
| | | updateproject.Caigouyusuan = project.Caigouyusuan; |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | var projectDTO = _mapper.Map<ProjectDTO>(entity); |
|---|
| | | projectDTO.DrhxDefenName = projectDTO.DrhxDefen.HasValue ? projectDTO.DrhxDefen.Value.ToString("F2") : ""; |
|---|
| | | projectDTO.DshxDefenName = projectDTO.DshxDefen.HasValue ? projectDTO.DshxDefen.Value.ToString("F2") : ""; |
|---|
| | | projectDTO.CaigouyusuanName = projectDTO.Caigouyusuan.HasValue ? projectDTO.Caigouyusuan.Value.ToString() : ""; |
|---|
| | | if (projectreasons!=null && projectreasons.Count>0) |
|---|
| | | { |
|---|
| | | projectDTO.projectreasons = projectreasons; |
|---|
| | |
|---|
| | | List<ProjectDTO> list = new List<ProjectDTO>(); |
|---|
| | | //筛选 |
|---|
| | | StringBuilder sql = new StringBuilder(); |
|---|
| | | sql.Append("SELECT distinct a.[Id],a.[start_time],a.[drhx_defen],a.[dshx_defen] ,b.[name] +'-'+c.[name]+'-'+d.[name] Sheng ,a.city ,a.[area_id],a.cgfs, a.[name] ,a.[number],a.creater,a.createtime,a.modifier,a.modifytime ,a.[drhx],a.[drhx_price],a.[dshx],a.[dshx_price],a.[Fencha],a.[Shuliang],a.[remark],a.[rec_status] ,a.[question] ,a.[zhongbiaocishu],a.[feibiaocishu],a.[zhongbiaojine],a.[Fblx],a.[Fbyy] , a.[zhuanjia] , a.[caigourenname], a.[caigourenaddress], a.[caigourencontact], a.[dailiname], a.[dailiaddress], a.[dailicontact] ,toubiaocishu = stuff((select '、'+ f.[names] from [Projectzhongbiao] f where f.[ProjectId] = a.[Id] for xml path('')), 1,1, '') "); //zhuanjia = stuff((select ','+name from [Zhuanjia] f where CHARINDEX(f.id,a.[zhuanjia]) >0 for xml path('')), 1,1, '') |
|---|
| | | sql.Append("SELECT distinct a.[Id],a.[start_time],a.[drhx_defen],a.[caigouyusuan],a.[dshx_defen] ,b.[name] +'-'+c.[name]+'-'+d.[name] Sheng ,a.city ,a.[area_id],a.cgfs, a.[name] ,a.[number],a.creater,a.createtime,a.modifier,a.modifytime ,a.[drhx],a.[drhx_price],a.[dshx],a.[dshx_price],a.[Fencha],a.[Shuliang],a.[remark],a.[rec_status] ,a.[question] ,a.[zhongbiaocishu],a.[feibiaocishu],a.[zhongbiaojine],a.[Fblx],a.[Fbyy] , a.[zhuanjia] , a.[caigourenname], a.[caigourenaddress], a.[caigourencontact], a.[dailiname], a.[dailiaddress], a.[dailicontact] ,toubiaocishu = stuff((select '、'+ f.[names] from [Projectzhongbiao] f where f.[ProjectId] = a.[Id] for xml path('')), 1,1, '') "); //zhuanjia = stuff((select ','+name from [Zhuanjia] f where CHARINDEX(f.id,a.[zhuanjia]) >0 for xml path('')), 1,1, '') |
|---|
| | | sql.Append("FROM [Project] a "); |
|---|
| | | sql.Append("left join [Area] b on a.[sheng] = b.[codeID] "); |
|---|
| | | sql.Append("left join [Area] c on a.[city] = c.[codeID] "); |
|---|
| | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | 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(); |
|---|
| | | list = _mapper.Map<List<ProjectDTO>>(lianlist); |
|---|
| | |
|---|
| | | CacheHelperNetCore.CacheInsert("Projects", list); |
|---|
| | | return list; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | public List<ProjectDTO> GetListsalary(string userid, DateTime datemin, DateTime datemax) |
|---|
| | | { |
|---|
| | | |
|---|
| | | |
|---|
| | | var listPosition = _context.Projects.Where(r => r.RecStatus == "A" && r.Creater == userid && r.Createtime >= datemin && r.Createtime < datemax).ToList(); |
|---|
| | | |
|---|
| | | var list = _mapper.Map<List<ProjectDTO>>(listPosition); |
|---|
| | | return list; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
