旧版报表、仓库
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 

28 lines
837 B

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Warehouse.Models.mesModel;
namespace Warehouse.DAL.Report
{
public class ConfigWksDal
{
public List<dynamic> ConfigWks(string area_code)
{
using (var context = new mesModel())
{
string strWhere = string.Empty;
if (!string.IsNullOrEmpty(area_code))
{
strWhere += " and area_code = '" + area_code + "' ";
}
string sql = @"SELECT [wks_desc]
FROM mes_main.dbo.config_workstation
where 1=1 " + strWhere;
var res = context.DynamicListFromSql(sql, null);
return res.ToList();
}
}
}
}