| | |
| | | } |
| | | } |
| | | |
| | | updatepltRole.Islock = "Q"; |
| | | updatepltRole.Islock = "H"; |
| | | updatepltRole.Modifier = dto.Modifier; |
| | | updatepltRole.Modifytime =DateTime.Now; |
| | | var count= _context.SaveChanges(); |
| | |
| | | var entity = (from a in _context.HrSalaries |
| | | join b in _context.PltUsers on a.Userid equals b.Id |
| | | join c in _context.HrDepts on b.DeptId equals c.Id |
| | | where a.RecStatus=="A" && a.Userid == userid && a.Year == year && a.Month==month |
| | | where a.RecStatus=="A" && a.Islock!="D" && a.Userid == userid && a.Year == year && a.Month==month |
| | | select new HrSalaryDTO() |
| | | { |
| | | Id = a.Id, |
| | |
| | | data.LoadData(searchEntity, rolelist); |
| | | return data; |
| | | } |
| | | |
| | | public void AutoCheck() |
| | | { |
| | | try |
| | | { |
| | | var salary = _context.Database.ExecuteSqlRaw("update [hr_salary] set islock='Q',[modifier]='e4c93811-b9b1-4998-89f5-c416ebab0c07',modifytime=getdate() where islock = 'H' and DATEDIFF(hh,[modifytime], getdate()) > 72"); |
| | | } |
| | | catch (Exception) |
| | | { |
| | | throw; |
| | | } |
| | | } |
| | | } |
| | | } |