public DataTable GetExportList(RawMarchivesRequest request)
{
//组装查询语句
#region 模糊搜索条件
var where = new Where <TbRawMaterialArchives>();
if (!string.IsNullOrWhiteSpace(request.MaterialCode))
{
where.And(p => p.MaterialCode.Like(request.MaterialCode));
}
if (!string.IsNullOrWhiteSpace(request.MaterialName))
{
where.And(p => p.MaterialName.Like(request.MaterialName));
}
if (!string.IsNullOrWhiteSpace(request.SpecificationModel))
{
where.And(p => p.SpecificationModel.Like(request.SpecificationModel));
}
if (!string.IsNullOrWhiteSpace(request.RebarType))
{
where.And(p => p.RebarType == request.RebarType);
}
#endregion
try
{
var ret = Db.Context.From <TbRawMaterialArchives>()
.Select(
TbRawMaterialArchives._.All
, TbSysDictionaryData._.DictionaryText.As("MeasurementUnitNew"))
.LeftJoin <TbSysDictionaryData>((a, c) => a.MeasurementUnit == c.DictionaryCode && c.FDictionaryCode == "Unit")
.AddSelect(Db.Context.From <TbSysDictionaryData>().Select(p => p.DictionaryText)
.Where(TbSysDictionaryData._.DictionaryCode == TbRawMaterialArchives._.RebarType && TbSysDictionaryData._.FDictionaryCode == "RebarType"), "RebarTypeNew")
.Where(where).OrderBy(d => d.ID).ToDataTable();
return(ret);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取分页列表数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetGridJson(RawMarchivesRequest request)
{
var data = _rawArchivesImp.GetDataListForPage(request);
return(Content(data.ToJson()));
}
