using PadApplication.DB;
|
using PadApplication.Entites.DbModels;
|
|
namespace PadApplication.Services;
|
|
public class MesMachineManager : Repository<MesMachine>
|
{
|
public List<int> GetOrderMachineNo()
|
{
|
//查询有工单开工的注释机台
|
var sql =
|
"select a.MACHINE_NO from WOMDAA a join mes_machine b on a.MACHINE_NO = b.MACHINE_NO where Daa018 = '开工' and b.MACHINE_NAME like '%注塑机' group by a.MACHINE_NO ";
|
|
var stringList = Db.Ado.SqlQuery<string>(sql);
|
var intList = stringList
|
.Select(s => int.Parse(s)) // 将每个字符串转换为整数
|
.OrderBy(n => n) // 按照从小到大的顺序排序
|
.ToList(); // 转换为 List<int>
|
|
return intList;
|
}
|
|
public List<MesMachine> GetInjectionMachine()
|
{
|
return Db.Queryable<MesMachine>()
|
.Where(s => s.Department.Contains("齿轮车间")).ToList();
|
}
|
}
|
