From 15eb82df2d6ec539e9d4245bfe08d531e8eb6379 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期日, 27 四月 2025 14:33:26 +0800
Subject: [PATCH] 修改培训订单占多个座位
---
zhengcaioa/Services/ProjectService.cs | 59 ++++++++++++++++++++++++++++++++++++-----------------------
1 files changed, 36 insertions(+), 23 deletions(-)
diff --git a/zhengcaioa/Services/ProjectService.cs b/zhengcaioa/Services/ProjectService.cs
index 089febc..24c5958 100644
--- a/zhengcaioa/Services/ProjectService.cs
+++ b/zhengcaioa/Services/ProjectService.cs
@@ -231,7 +231,7 @@
}
}
}
- CacheHelperNetCore.CacheNull("Projects");
+ //CacheHelperNetCore.CacheNull("Projects");
_context.SaveChanges();
@@ -348,21 +348,7 @@
}
- if (!string.IsNullOrWhiteSpace(searchEntity.NamesToubiao))
- {
- sql.Append(" and ( exists (select b.[ProjectId] from [Projectzhongbiao] b where a.[Id]=b.[ProjectId] and b.[names] like '%" + searchEntity.NamesToubiao + "%') ");
-
- sql.Append(" or exists (select c.[ProjectId] from [Projectreason] c where a.[Id]=c.[ProjectId] and c.[reasonname] like '%" + searchEntity.NamesToubiao + "%') ");
-
- sql.Append(" or exists (select d.[ProjectId] from [Projectyouxiao] d where a.[Id]=d.[ProjectId] and d.[namesyouxiao] like '%" + searchEntity.NamesToubiao + "%') ");
-
- sql.Append(" or a.[drhx] like '%" + searchEntity.NamesToubiao + "%' ");
-
- sql.Append(" or a.[dshx] like '%" + searchEntity.NamesToubiao + "%' ");
-
- sql.Append(" )");
-
- }
+
if (!string.IsNullOrWhiteSpace(searchEntity.Fencha))
{
decimal aaaa = 0;
@@ -653,7 +639,28 @@
- var query = _context.Projects
+ if (!string.IsNullOrWhiteSpace(searchEntity.NamesToubiao))
+ {
+ var sqlsss = sql.ToString();
+ sql.Append(" and ( exists (select b.[ProjectId] from [Projectzhongbiao] b where a.[Id]=b.[ProjectId] and b.[names] like '%" + searchEntity.NamesToubiao + "%') ");
+
+ sql.Append(" or exists (select c.[ProjectId] from [Projectreason] c where a.[Id]=c.[ProjectId] and c.[reasonname] like '%" + searchEntity.NamesToubiao + "%') ");
+
+ sql.Append(" or exists (select d.[ProjectId] from [Projectyouxiao] d where a.[Id]=d.[ProjectId] and d.[namesyouxiao] like '%" + searchEntity.NamesToubiao + "%') ");
+ sql.Append(" )");
+ sql.Append(" union "+ sqlsss + " and ( a.[drhx] like '%" + searchEntity.NamesToubiao + "%' ");
+
+ sql.Append(" or a.[dshx] like '%" + searchEntity.NamesToubiao + "%' ");
+ sql.Append(" )");
+
+
+ }
+
+
+
+
+
+ var query = _context.Projects
.FromSqlRaw(sql.ToString());
@@ -860,16 +867,12 @@
/// <returns></returns>
public List<ProjectDTO> GetList()
{
- List<ProjectDTO> projectDTOs = (List<ProjectDTO>)CacheHelperNetCore.CacheValue("Projects");
- if (projectDTOs!=null&& projectDTOs.Count > 0)
- {
- return projectDTOs;
- }
+
var listPosition = _context.Projects.Where(r => r.RecStatus == "A").ToList();
var list = _mapper.Map<List<ProjectDTO>>(listPosition);
- CacheHelperNetCore.CacheInsert("Projects", list);
+
return list;
}
@@ -884,6 +887,16 @@
return list;
}
+ public List<ZhengfuProjectDTO> GetListsalaryzhengfu(string userid, DateTime datemin, DateTime datemax)
+ {
+
+
+ var listPosition = _webcontext.ZhengfuProjects.Where(r => r.RecStatus == "A" && r.Creater == userid && r.Createtime >= datemin && r.Createtime < datemax).ToList();
+
+ var list = _mapper.Map<List<ZhengfuProjectDTO>>(listPosition);
+ return list;
+ }
+
public List<ZhengfuProjectDTO> GetcaigougonggaoListsalary(string userid, DateTime datemin, DateTime datemax)
{
--
Gitblit v1.9.1