using System.Data;
using MES.Service.DB;

namespace MES.Service.service;

public class DemoService
{
    private static readonly OracleSQLHelper SQLHelper = new();

    public DataTable getAll(string deptNo)
    {
        //string sql = string.Format(@"select * from WOMDAA where DEPARTMENT_NO = '{0}'", daa001);

        var sql = string.Format(@"SELECT * FROM (
                SELECT t.*, ROWNUM AS row_num
                FROM WOMDAA t
                WHERE DEPARTMENT_NO = '{0}' and ROWNUM <= 50
            )
            WHERE row_num >= 1", deptNo);

        if ("ALL".Equals(deptNo))
            sql = @"SELECT * FROM (
                SELECT t.*, ROWNUM AS row_num  FROM WOMDAA t WHERE  ROWNUM <= 50 ) WHERE row_num >= 1";
        return SQLHelper.ExecuteQuery(sql);
    }

    public DataTable getItemById(string id)
    {
        var sql = string.Format(@"select * from WOMDAA where id = '{0}'", id);
        return SQLHelper.ExecuteQuery(sql);
    }
}