39 lines
935 B
39 lines
935 B
using JHReport.DAL;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Web;
|
|
using Warehouse.Models.mesModel;
|
|
|
|
namespace Warehouse.DAL.Report
|
|
{
|
|
public class BeforeCapacityDal
|
|
{
|
|
public List<dynamic> BeforeCapacity()
|
|
{
|
|
using (var context = new mesModel())
|
|
{
|
|
ReportDal report = new ReportDal();
|
|
|
|
string sql = report.BeforeCapacitySql();
|
|
|
|
var res = context.DynamicListFromSql(sql, null);
|
|
return res.ToList();
|
|
}
|
|
}
|
|
|
|
|
|
public List<dynamic> AfterCapacity()
|
|
{
|
|
using (var context = new mesModel())
|
|
{
|
|
ReportDal report = new ReportDal();
|
|
|
|
string sql = report.AfterCapacitySql();
|
|
|
|
var res = context.DynamicListFromSql(sql, null);
|
|
return res.ToList();
|
|
}
|
|
}
|
|
}
|
|
}
|