//查询 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)); }