using JHReport.DAL; using System; using System.Collections.Generic; using System.Linq; using System.Net; using System.Net.Http; using System.Web.Http; using Warehouse.Models.mesModel; namespace Warehouse.DAL.Report { public class SuppliesConsumedDal : ApiController { public List SuppliesConsumed(string sale_order, string workorder, string workshop) { using (var context = new mesModel()) { ReportDal report = new ReportDal(); string sql = report.SuppliesConsumedSql(sale_order, workorder, workshop); var res = context.DynamicListFromSql(sql, null); return res.ToList(); } } } }