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