//查询
public ActionResult Srlete()
{
int dqy = int.Parse(Request["dqy"]);
salarystandard_query_locateCan hu = new salarystandard_query_locateCan();
hu = Session["salarystandard_query_locateCan"] as salarystandard_query_locateCan;
hu.dqy = dqy;
XCcan ji = sa.Fenye2(hu);
//salary_standardFenYe can = sa.fenye(dqy, 2);
string aa = JsonConvert.SerializeObject(ji);
return(Content(aa));
}
public XCcan Fenye2(salarystandard_query_locateCan ji)
{
Expression <Func <salary_standard, bool> > expr = n => GetCondition(n, ji);
XCcan cs = new XCcan();
List <salary_standardModel> li = new List <salary_standardModel>();
int rows = 0;
var data = db.Set <salary_standard>().OrderBy(e => e.Id).Where(expr.Compile()).ToList();
rows = data.Count();//获取总行数
List <salary_standard> list = data.Skip((ji.dqy - 1) * ji.rl)
.Take(ji.rl)
.ToList();
foreach (salary_standard item in list)
{
salary_standardModel ko = new salary_standardModel();
ko.id = item.Id;
ko.standard_id = item.standard_id;
ko.standard_name = item.standard_name;
ko.designer = item.designer;
ko.register = item.register;
ko.checker = item.checker;
ko.changer = item.changer;
ko.regist_time = item.regist_time;
ko.check_time = item.check_time;
ko.change_time = item.change_time;
ko.salary_sum = item.salary_sum;
ko.check_status = item.check_status;
ko.change_status = item.change_status;
ko.check_comment = item.check_comment;
ko.remark = item.remark;
li.Add(ko);
}
cs.li = li;
cs.MyProperty = rows;
cs.zys = (rows % ji.rl == 0 ? rows / ji.rl : rows % ji.rl + 1);
return(cs);
}
//变更ajax
public ActionResult Srlete11()
{
int dqy = int.Parse(Request["dqy"]);
salarystandard_query_locateCan hu = new salarystandard_query_locateCan();
hu = Session["salarystandard_query_locateCan1"] as salarystandard_query_locateCan;
hu.dqy = dqy;
XCcan ji = sa.Fenye2(hu);
List <salary_standardModel> hs = ji.li;
for (int i = 0; i < hs.Count; i++)
{
if (hs[i].check_status == 1)
{
hs.Remove(hs[i]);
}
}
ji.li = hs;
//salary_standardFenYe can = sa.fenye(dqy, 2);
string aa = JsonConvert.SerializeObject(ji);
return(Content(aa));
}
