.nettiers 在Service层自定义逻辑--EmployeesService() --时间之间的查询【原创】
在Service里加入函数:
public TList<Employees> GetEmployeesHiredBetween(DateTime startDate, DateTime endDate)
{
EmployeesParameterBuilder pb = new EmployeesParameterBuilder();
pb.AppendRange(EmployeesColumn.HireDate, startDate.ToString(), endDate.ToString());
return DataRepository.EmployeesProvider.Find(pb.GetParameters());
}
{
EmployeesParameterBuilder pb = new EmployeesParameterBuilder();
pb.AppendRange(EmployeesColumn.HireDate, startDate.ToString(), endDate.ToString());
return DataRepository.EmployeesProvider.Find(pb.GetParameters());
}
在.aspx.cs页面引用:
EmployeesService ES = new EmployeesService();
TList<Employees> List = ES.GetEmployeesHiredBetween(Convert.ToDateTime(this.TextBox1.Text), Convert.ToDateTime(this.TextBox2.Text));
this.GridView1.DataSource = List;
this.GridView1.DataBind();
TList<Employees> List = ES.GetEmployeesHiredBetween(Convert.ToDateTime(this.TextBox1.Text), Convert.ToDateTime(this.TextBox2.Text));
this.GridView1.DataSource = List;
this.GridView1.DataBind();