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.Config { public class ProductsInfoDal : ApiController { //产品 public List ProductsInfo() { using (var context = new mesModel()) { string sql = string.Empty; string strWhere = string.Empty; sql = @"SELECT products.product_code productcode,description.descriptions descriptions,products.family_code familycode,products.busbar_type_desc busbartype,products.crys_type_desc crystype, products.mod_spec_desc modulespec,process_group.descriptions flow,products.cell_qty cellqty,products.process_type_desc processtype,products.feature_code_desc featurecode FROM [mes_main].[dbo].[config_products] products LEFT JOIN [mes_main].[dbo].[config_process_group] process_group on products.process_group_id = process_group.process_group_id left join mes_level4_iface.dbo.master_part description on description.bom_part_nbr = products.product_code"; var res = context.DynamicListFromSql(sql, null); return res.ToList(); } } } }