public object JTable([FromBody] JTableModelMaterial jTablePara)
{
int intBeginFor = (jTablePara.CurrentPage - 1) * jTablePara.Length;
string code = jTablePara.MaterialCode.ToLower();
string name = jTablePara.MaterialName.ToLower();
int? parent = jTablePara.MaterialParent;
var query = from a in _context.MaterialTypes
where (a.IsDeleted == false &&
a.Code.ToLower().Contains(code) &&
a.Name.ToLower().Contains(name) &&
(parent == null || parent == a.ParentId))
select new
{
id = a.Id,
code = a.Code,
name = a.Name,
description = a.Description
};
int count = query.Count();
//var data = query.OrderUsingSortExpression(jTablePara.QueryOrderBy).Skip(intBegin).Take(jTablePara.Length).AsNoTracking().ToList();
var data = query.OrderUsingSortExpression(jTablePara.QueryOrderBy).AsNoTracking().ToList();
var data1 = data.Skip(intBeginFor).Take(jTablePara.Length).ToList();
var jdata = JTableHelper.JObjectTable(data1, jTablePara.Draw, count, "id", "code", "name", "description");
return(Json(jdata));
}
public object JTable([FromBody]JTableModelMaterial jTablePara)
{
int intBegin = (jTablePara.CurrentPage - 1) * jTablePara.Length;
DateTime? fromDate = !string.IsNullOrEmpty(jTablePara.FromTo) ? DateTime.ParseExact(jTablePara.FromTo, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null;
DateTime? toDate = !string.IsNullOrEmpty(jTablePara.DateTo) ? DateTime.ParseExact(jTablePara.DateTo, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null;
var query = from a in _context.MaterialStoreBatchGoodss
join b in _context.MaterialProducts on a.ProductCode equals b.ProductCode into b1
from b in b1.DefaultIfEmpty()
join c in _context.MaterialStores on a.StoreId equals c.StoreId into c1
from c in c1.DefaultIfEmpty()
//join d in _context.CommonSettings on a.Unit equals d.CodeSet into d1
//from d in d1.DefaultIfEmpty()
join e in _context.CommonSettings on a.Currency equals e.CodeSet into e1
from e in e1.DefaultIfEmpty()
where !a.IsDeleted
&&((fromDate == null || (a.CreatedTime >= fromDate)) && (toDate == null || (a.CreatedTime <= toDate)))
&& (string.IsNullOrEmpty(jTablePara.Name) || a.Name.ToLower().Contains(jTablePara.Name.ToLower()))
&& (string.IsNullOrEmpty(jTablePara.ProductName) || b.ProductName.ToLower().Contains(jTablePara.ProductName.ToLower()))
select new
{
a.Id,
a.Name,
ProductName = b != null ? b.ProductName : null,
StoreName = c != null ? c.StoreName : null,
a.Quantity,
//ValueSet = d != null ? d.ValueSet : null,
a.Total,
a.Unit,
Currency = e != null ? e.ValueSet : null,
a.DateReiceive
};
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", "Name", "ProductName", "StoreName", "Quantity", "Total", "Unit", "Currency", "DateReiceive");
return Json(jdata);
}
