public object Salaries(int year = 0, string searchKey = null, int page = 1, int rows = 15)
{
var parameter = new SalaryParameter
{
Year = year,
SearchKey = searchKey,
Page = new PageParameter(page, rows)
};
var list = Core.SalaryManager.GetList(parameter);
return(new { List = list, parameter.Page });
}
public IEnumerable <Salary> GetList(SalaryParameter parameter)
{
var query = DB.Salaries.AsQueryable();
if (parameter.Year > 0)
{
query = query.Where(e => e.Year == parameter.Year);
}
if (!string.IsNullOrEmpty(parameter.SearchKey))
{
query = query.Where(e => e.Title.Contains(parameter.SearchKey));
}
return(query.OrderByDescending(e => e.ID).SetPage(parameter.Page));
}
public IEnumerable <SalaryData> GetSalaryDatas(SalaryParameter parameter)
{
var query = DB.SalaryDatas.AsQueryable();
if (parameter.Year > 0)
{
query = query.Where(e => e.Salary.Year == parameter.Year);
}
if (!string.IsNullOrEmpty(parameter.SearchKey))
{
query = query.Where(e => e.Salary.Title.Contains(parameter.SearchKey));
}
if (parameter.UserId > 0)
{
query = query.Where(e => e.UserId == parameter.UserId);
}
if (parameter.SalaryId > 0)
{
query = query.Where(e => e.SalaryId == parameter.SalaryId);
}
return(query.OrderBy(e => e.ID).SetPage(parameter.Page));
}
public object SalaryDatas(int year = 0, int salaryId = 0, string searchKey = null, int userId = 0, int page = 1, int rows = 15)
{
var hasViewAllRight = CurrentUser.HasRight("Form.Salary.View");
if (userId == 0)
{
if (!hasViewAllRight)
{
userId = Identity.ID;
}
}
else if (userId != Identity.ID)
{
if (!hasViewAllRight)
{
throw new Exception("无法查看他人工资");
}
}
var parameter = new SalaryParameter
{
SalaryId = salaryId,
Year = year,
SearchKey = searchKey,
UserId = userId,
Page = new PageParameter(page, rows)
};
var list = Core.SalaryManager.GetSalaryDatas(parameter).Select(e => new
{
e.ID,
e.UserId,
e.UserName,
e.Salary.Title,
e.Salary.Year,
e.Data
});
return(new { List = list, parameter.Page });
}
