public ActionResult tjSelect(salary_standardModel s)
{
//DateTime.Now.Date.ToString("yyyy/MM/dd");
//ViewData["rows"] = sa.rows(s.standard_id, s.designer,Convert.ToDateTime(s.regist_time),s.check_time);
//ViewData["Pagescx"] = sa.Pagescx();
//return View();
string salaId = Request["id"];
string salaGJZ = Request["gjz"];
string endDate = Request["endDate"];
string date_start = Request["date_start"];
ListFenYeModel l = new ListFenYeModel()
{
Dq = int.Parse(Request["rl"]), //当前页
PageSize = 2, //每页要显示多少条数据
standard_id = salaId, //根据id模糊查询
standard_name = salaGJZ, //根据关键字来模糊查询，用了concat函数，不管输入的是什么，它都能根据多个字段查
startDate = Convert.ToDateTime(date_start),
endDate = Convert.ToDateTime(endDate)
};
ArrayList list = sa.Salarystandard_query_locateLikeFenYe(l);
ViewBag.ls = list;
return(View());
}
public ArrayList Salarystandard_query_locateLikeFenYe(ListFenYeModel l)
{
ArrayList list2 = new ArrayList();
int rows = 0;
List <salary_standard> list = null;
List <salary_standardModel> list1 = new List <salary_standardModel>();
//string.Concat函数是根据提供的字段进行模糊查询，可以多个字段
//|| string.Concat(e.designer, e.changer, e.standard_name,e.checker).Contains(l.standard_name) || e.regist_time >l.startDate && e.regist_time<= l.endDate,
list = FenYe <int>(e => e.Id, e => e.standard_id.Contains(l.standard_id) && string.Concat(e.designer, e.changer, e.standard_name, e.checker).Contains(l.standard_name) && e.regist_time <= l.startDate && e.regist_time >= l.endDate && e.change_status > 0, ref rows, l.Dq, l.PageSize);
foreach (var item in list)
{
salary_standardModel s = new salary_standardModel()
{
Id = item.Id,
standard_id = item.standard_id,
standard_name = item.standard_name,
designer = item.designer,
register = item.register,
checker = item.checker,
changer = item.changer,
regist_time = item.regist_time,
//check_time = item.check_time,
change_time = item.change_time,
salary_sum = item.salary_sum,
check_status = item.check_status,
change_status = item.change_status,
check_comment = item.check_comment,
remark = item.remark
};
list1.Add(s);
}
list2.Add(list1);
list2.Add(rows);
list2.Add(l.Dq);
list2.Add(l.PageSize);
list2.Add((rows - 1) / l.PageSize + 1);
return(list2);
}
public ArrayList Salarystandard_query_locateLikeFenYe(ListFenYeModel l)
{
return(st.Salarystandard_query_locateLikeFenYe(l));
}
