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