public static string Query(int bussinessID, EmployeeFineFilter filter = null)
{
var conditions = new List <string>();
if (filter != null)
{
if (filter.EmployeeID.HasValue)
{
conditions.Add(String.Format("and f.EmployeeID = {0}", filter.EmployeeID.Value));
}
if (filter.From.HasValue)
{
conditions.Add(String.Format("and f.SubmitDate >= {0}", filter.From.DbValue()));
}
if (filter.To.HasValue)
{
conditions.Add(String.Format("and f.SubmitDate <= {0}", filter.To.DbValue()));
}
}
var query = String.Format(
@" select f.*, e.Name as [EmployeeName] from EmployeeFine f join Employee e on f.EmployeeID = e.ID where e.BussinessID = {0} {1} order by f.ID desc",
bussinessID, String.Join(" ", conditions));
return(query);
}
public static EmployeeFineList Get(int userID, int employeeID, int bussinessID, string action, EmployeeFineFilter filter = null)
{
QueryOutput queryOutput;
return(new EmployeeFineList(
filter.EmployeeID.HasValue ? filter.EmployeeID.Value : 0,
Query <EmployeeFine>(new DbQuery(userID, employeeID, action, Query(bussinessID, filter)), out queryOutput)));
}
