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
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();
|
|
}
|
|
}
|
|
}
|
|
}
|