public ActionResult Index(OutBoundRequest request)
{
if (request.export == "export")//导出EXCEL
{
request.PageSize = 10000000;
var ibrAll = this.StoreService.GetOutBound(request);
DataTable dt = new DataTable();
dt.Columns.Add("客户名称");
dt.Columns.Add("订单类别");
dt.Columns.Add("出库数量");
dt.Columns.Add("领用单位");
dt.Columns.Add("出库时间");
foreach (OutBoundRecord inBoundItem in ibrAll)
{
DataRow dr = dt.NewRow();
dr["客户名称"] = inBoundItem.DictionaryTree.parent_name;
dr["订单类别"] = inBoundItem.DictionaryTree.name;
dr["出库数量"] = inBoundItem.number;
dr["领用单位"] = inBoundItem.employment;
dr["出库时间"] = inBoundItem.CreateTime;
dt.Rows.Add(dr);
}
byte[] excelByte = this.StoreService.DataTable2Excel(dt, "出入库记录");
using (MemoryStream ms = new MemoryStream())
{
return(File(excelByte, "application/ms-excel", "出库记录.xls"));
}
}
var obrlist = this.StoreService.GetOutBound(request);
return(View(obrlist));
}
public IEnumerable <OutBoundRecord> GetOutBound(OutBoundRequest request)
{
request = request ?? new OutBoundRequest();
using (var dbContext = new StoreDbContext())
{
IQueryable <OutBoundRecord> obr = dbContext.OutBoundRecord.Include("DictionaryTree");
if (!string.IsNullOrEmpty(request.khmc))
{
obr = obr.Where(d => d.DictionaryTree.parent_name.Contains(request.khmc));
}
if (!string.IsNullOrEmpty(request.ddmc))
{
obr = obr.Where(d => d.DictionaryTree.name.Contains(request.ddmc));
}
if (request.starttime.ToString() != "0001/1/1 0:00:00" && request.endtime.ToString() == "0001/1/1 0:00:00")
{ //有开始时间和无结束时间
obr = obr.Where(d => d.CreateTime >= request.starttime);
}
if (request.starttime.ToString() == "0001/1/1 0:00:00" && request.endtime.ToString() != "0001/1/1 0:00:00")
{ //无开始时间和有结束时间
obr = obr.Where(m => m.CreateTime <= request.endtime);
}
if (request.starttime.ToString() != "0001/1/1 0:00:00" && request.endtime.ToString() != "0001/1/1 0:00:00")
{ //有开始时间和结束时间
obr = obr.Where(m => m.CreateTime <= request.endtime).Where(d => d.CreateTime >= request.starttime);
}
return(obr.OrderByDescending(u => u.CreateTime).ToPagedList(request.PageIndex, request.PageSize));
}
}
public ActionResult Index(OutBoundRequest request)
{
var obrlist = this.StoreService.GetOutBound(request);
return(View(obrlist));
}
