public JsonResult tjlist(int page, string name = "", string category = "", string groups = "", string fzr = "", string state = "", string category1 = "")
{
List <product> list = new List <product>();
list = context.product.Where(a => a.ID > 0).ToList();
if (!string.IsNullOrWhiteSpace(name))
{
list = list.Where(a => a.Name.Contains(name)).ToList();
}
if (!string.IsNullOrWhiteSpace(category))
{
list = list.Where(a => a.Category == category).ToList();
}
if (!string.IsNullOrWhiteSpace(category1))
{
list = list.Where(a => a.QRDJ == category1).ToList();
}
if (!string.IsNullOrWhiteSpace(groups))
{
list = list.Where(a => a.Groups == groups).ToList();
}
if (!string.IsNullOrWhiteSpace(fzr))
{
list = list.Where(a => a.FZR.Contains(fzr)).ToList();
}
if (!string.IsNullOrWhiteSpace(state))
{
list = list.Where(a => a.state == state).ToList();
}
int total = list.Count;
list = list.Skip((page - 1) * 10).Take(10).ToList();
List <hjtjModel> result = new List <hjtjModel>();
foreach (var i in list)
{
hjtjModel d = new hjtjModel();
var u = context.users.FirstOrDefault(a => a.UserName == app.username);
var p = i.pjtj.FirstOrDefault(a => a.ID > 0);
if (p != null)
{
d.tjfl = p.state;
}
else
{
pjtj pj = new pjtj();
var jd = context.productjd.FirstOrDefault(a => a.State != "-1");
pj.jdId = jd.ID;
pj.MemberId = u.ID;
pj.productId = i.ID;
pj.state = 4;
context.pjtj.Add(pj);
context.SaveChanges();
tp t = new tp();
t.state = 0;
t.zdstate = 0;
t.productId = i.ID;
t.MemberId = u.ID;
context.tp.Add(t);
context.SaveChanges();
}
p = i.pjtj.FirstOrDefault(a => a.ID > 0);
d.tjfl = p.state;
p = i.pjtj.FirstOrDefault(a => a.MemberId == u.ID);
d.BH = i.BH;
d.name = i.Name;
d.dfhj = i.ktpf.Sum(a => a.dfhj);
d.jjxy = i.ktpf.Sum(a => a.jjxy);
d.tgyy = i.ktpf.Sum(a => a.tgyy);
d.Id = p.ID;
d.jsnd = i.ktpf.Sum(a => a.jsnd);
d.jssp = i.ktpf.Sum(a => a.jssp);
d.shxy = i.ktpf.Sum(a => a.shxy);
d.tgyy = i.ktpf.Sum(a => a.tgyy);
d.zscq = i.ktpf.Sum(a => a.zscq);
result.Add(d);
}
result = result.OrderByDescending(d => d.zscq).ToList();
return(Json(new { rows = result, total = total }));
}
internal bool Types(tp type, bool set = false, bool value = false)
{
if (set == false) { return types[(int)type].isChecked; }
else { types[(int)type].isChecked = value; }
return types[(int)type].isChecked;
}
