public JsonResult JTableCardJob([FromBody] JTableModelCardJob jtablePara)
{
int intBegin = (jtablePara.CurrentPage - 1) * jtablePara.Length;
var query = from a in _context.CardForWObj
join b in _context.WORKOSCards on a.CardCode equals b.CardCode into b1
from b in b1.DefaultIfEmpty()
where a.IsDeleted == false &&
a.CatObjCode.Equals("CUSTOMER") &&
a.ObjCode.Equals(_context.Customers.FirstOrDefault(x => x.CusID == jtablePara.CustomerId).CusCode) &&
(string.IsNullOrEmpty(jtablePara.CardCode) || a.CardCode.ToLower().Contains(jtablePara.CardCode.ToLower())) &&
(string.IsNullOrEmpty(jtablePara.CardName) || b.CardName.ToLower().Contains(jtablePara.CardName.ToLower()))
select new
{
Id = a.Id,
CardCode = a.CardCode,
Customer = a.ObjCode,
CardName = b.CardName
};
int count = query.Count();
var data = query.OrderUsingSortExpression(jtablePara.QueryOrderBy).Skip(intBegin).Take(jtablePara.Length).AsNoTracking().ToList();
var jdata = JTableHelper.JObjectTable(data, jtablePara.Draw, count, "Id", "CardCode", "Customer", "CardName");
return(Json(jdata));
}
public JsonResult JTableCardJob([FromBody] JTableModelCardJob jtablePara)
{
int intBegin = (jtablePara.CurrentPage - 1) * jtablePara.Length;
var query = from a in _context.CardForWObj
where a.IsDeleted == false &&
a.CatObjCode.Equals("SUPPLIER") &&
a.ObjCode.Equals(_context.Suppliers.FirstOrDefault(x => x.SupID == jtablePara.SupplierId).SupCode)
select new
{
Id = a.Id,
CardCode = a.CardCode,
Supplier = a.ObjCode,
CardName = (_context.WORKOSCards.FirstOrDefault(x => x.CardCode.Equals(a.CardCode)).CardName)
};
int count = query.Count();
var data = query.OrderUsingSortExpression(jtablePara.QueryOrderBy).Skip(intBegin).Take(jtablePara.Length).AsNoTracking().ToList();
var jdata = JTableHelper.JObjectTable(data, jtablePara.Draw, count, "Id", "CardCode", "Supplier", "CardName");
return(Json(jdata));
}
