| | |
| | | // } |
| | | // ); |
| | | |
| | | //int year = 0; |
| | | //int month = 0; |
| | | //if (string.IsNullOrWhiteSpace(searchEntity.YearMonth)) |
| | | //{ |
| | | // DateTime yearMonth = DateTime.Now;//.Parse(searchEntity.YearMonth + "-01"); |
| | | // year = yearMonth.Year; |
| | | // month = yearMonth.Month; |
| | | //} |
| | | int year = 0; |
| | | int month = 0; |
| | | if (!string.IsNullOrWhiteSpace(searchEntity.YearMonth)) |
| | | { |
| | | DateTime yearMonth = DateTime.Parse(searchEntity.YearMonth + "-01"); |
| | | year = yearMonth.Year; |
| | | month = yearMonth.Month; |
| | | } |
| | | var query = (from a in _context.HrSalaries//.Where(x => x.RecStatus == "A") |
| | | // join b in listCode.Where(x => x.CodeTable == "hr_jibengongzi" && x.CodeField == "dianhuabutie") |
| | | //on a.Dianhuabutie equals b.CodeSn |
| | |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Usernumber) || f.Usernumber == searchEntity.Usernumber.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.DeptId) || f.DeptId == searchEntity.DeptId.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.UserName) || f.UserName.Contains(searchEntity.UserName.Trim())) |
| | | //&& (string.IsNullOrWhiteSpace(searchEntity.YearMonth) || ( a.Year == year && a.Month == month )) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.YearMonth) || ( a.Year == year && a.Month == month )) |
| | | select new HrSalaryDTO |
| | | { |
| | | Id = a.Id, |
| | |
| | | |
| | | |
| | | ViewBag.GoodsStatus = _liaotianService.GetSYScode("adm_goods_manage", "goods_status").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList(); |
| | | ViewBag.Goods = _admGoodsManageService.GetList().Select(x => new { code = x.Id, label = x.GoodsName }).ToList(); |
| | | ViewBag.Goods = _admGoodsManageService.GetList().Select(x => new { code = x.Id, label = (x.GoodsName.Length>15? x.GoodsName.Substring(0, 15) : x.GoodsName) }).ToList(); |
| | | |
| | | ViewBag.ClassifyId = _admGoodsClassifyService.GetList().Select(x => new { code = x.Id, label = x.ClassifyName }).ToList(); |
| | | |
| | |
| | | dataUrl = "/AdmGoodsManage/GetList"; |
| | | searchCol = [ |
| | | |
| | | { label: '物品类别', name: 'ClassifyId', labtype: 'combox', hidden: false, data: JSON.parse(ClassifyId), cwidth: '5%', cccwidth: '8%' }, |
| | | { label: '物品名称', name: 'GoodsName', labtype: 'combox', hidden: false, data: JSON.parse(Goods), cwidth: '5%', cccwidth: '8%'}, |
| | | { label: '物品状态', name: 'GoodsStatus', labtype: 'combox', hidden: false, data: JSON.parse(GoodsStatus), cwidth: '5%', cccwidth: '8%' }, |
| | | { label: '物品类别', name: 'ClassifyId', labtype: 'combox', hidden: false, data: JSON.parse(ClassifyId), cwidth: '5%', cccwidth: '15%' }, |
| | | { label: '物品名称', name: 'GoodsName', labtype: 'combox', hidden: false, data: JSON.parse(Goods), cwidth: '5%', cccwidth: '15%'}, |
| | | { label: '物品状态', name: 'GoodsStatus', labtype: 'combox', hidden: false, data: JSON.parse(GoodsStatus), cwidth: '5%', cccwidth: '15%' }, |
| | | |
| | | |
| | | |
| | |
| | | ]; |
| | | dataUrl = "/SalaryCheck/GetList"; |
| | | searchCol = [ |
| | | { label: '月份', name: 'YearMonth', labtype: 'monthdate', hidden: false }, |
| | | { label: '工号', name: 'Usernumber2', labtype: 'txt', hidden: false }, |
| | | { label: '工作部门', name: 'DeptId', labtype: 'combox', hidden: false, data: JSON.parse(dept) }, |
| | | { label: '职工姓名', name: 'UserName', labtype: 'txt', hidden: false }, |