//变更查询
public ActionResult ChaxunfaSelete()
{
string standardId = Request["standard.standardId"];
string primarKey = Request["utilbean.primarKey"];
string startDate = Request["utilBean.startDate"];
string datePropertyName = Request["utilBean.endDate"];
salarystandard_query_locateCan hu = new salarystandard_query_locateCan();
hu.datePropertyName = DateTime.Parse(datePropertyName);
hu.startDate = DateTime.Parse(startDate);
if (primarKey == null || primarKey.Equals(""))
{
//hu.standard = standardId;
primarKey = "查询全部";
}
else
{
hu.utilbean = primarKey;
}
if (standardId == null || standardId.Equals(""))
{
standardId = "查询全部";
}
else
{
hu.standard = standardId;
}
hu.dqy = 1;
hu.rl = 2;
Session["salarystandard_query_locateCan1"] = hu;
return(RedirectToAction("salarystandard_change_list"));
}
//查询
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));
}
private bool GetCondition(salary_standard fb, salarystandard_query_locateCan ji)
{
bool boolResult = true;
if (!ji.standard.Equals("查询全部"))
{
boolResult &= fb.standard_id.Contains(ji.standard);
}
if (!ji.utilbean.Equals("查询全部"))
{
boolResult &= fb.designer.Contains(ji.utilbean);
}
boolResult &= fb.regist_time >= ji.startDate;
boolResult &= fb.regist_time <= ji.datePropertyName;
return(boolResult);
}
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));
}
public XCcan Fenye2(salarystandard_query_locateCan ji)
{
return(st1.Fenye2(ji));
}
