From 4d539b4a5941bbbb12271dc500f8f09a66812905 Mon Sep 17 00:00:00 2001
From: LR-20210131IOQH\Administrator <jackcold@163.com>
Date: 星期五, 25 六月 2021 10:39:55 +0800
Subject: [PATCH] 工资核对，工资核准，工资查询
---
zhengcaioa/Services/SimService.cs | 24 +++++++++++++++---------
1 files changed, 15 insertions(+), 9 deletions(-)
diff --git a/zhengcaioa/Services/SimService.cs b/zhengcaioa/Services/SimService.cs
index 5278ed0..dd6b26d 100644
--- a/zhengcaioa/Services/SimService.cs
+++ b/zhengcaioa/Services/SimService.cs
@@ -289,19 +289,25 @@
ResultDataEntity<SimCostView> data = new ResultDataEntity<SimCostView>();
try
{
- var codedata = (from e in _context.SysCodes
- join c in _context.SysCodeDtls
- on e.Id equals c.CodeId
- where e.RecStatus == "A"
- && c.RecStatus == "A"
- && e.CodeTable == "t_sim_bind"
- && e.CodeField == "cardpro"
- select c).OrderBy(x => x.Sort).ToList();
+ //var codedata = (from e in _context.SysCodes
+ // join c in _context.SysCodeDtls
+ // on e.Id equals c.CodeId
+ // where e.RecStatus == "A"
+ // && c.RecStatus == "A"
+ // && e.CodeTable == "t_sim_bind"
+ // && e.CodeField == "cardpro"
+ // select c).OrderBy(x => x.Sort).ToList();
var dt = _context.SimCostView.OrderByDescending(c => c.accounted_time).ToList();
if (!string.IsNullOrEmpty(searchEntity.searchtime))
{
- //dt = dt.Where(c => c.simcard.Contains(searchEntity.simcard)).ToList();
+ var times = searchEntity.searchtime.Split('|');
+ if(times.Length==2)
+ {
+ DateTime d1 = DateTime.Parse(times[0]);
+ DateTime d2 = DateTime.Parse(times[1]);
+ dt = dt.Where(c => c.accounted_time > d1 && c.accounted_time < d2).ToList();
+ }
}
if (!string.IsNullOrEmpty(searchEntity.searchsim))
{
--
Gitblit v1.9.1