public DataTable QueryCodeFileLineByID(ArrayList ParameterList)
{
try
{
DBO.SYS_Code_DetlDBO CodeFileL = new DBO.SYS_Code_DetlDBO(ref USEDB);
return CodeFileL.doQueryByID(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable QueryLineSwitch(QueryType QT,
ArrayList ParameterList
)
{
DBO.SYS_Code_DetlDBO CodeFileL = new SYS_Code_DetlDBO(ref USEDB);
DataTable Dt;
try
{
switch (QT)
{
case QueryType.ALL:
Dt = CodeFileL.doQueryAll();
break;
case QueryType.ID:
Dt = CodeFileL.doQueryByID(ParameterList);
break;
case QueryType.CODE:
Dt = CodeFileL.doQueryByCode(ParameterList);
break;
case QueryType.Custom:
Dt = CodeFileL.doQueryByFind(ParameterList);
break;
case QueryType.Scode:
Dt = CodeFileL.doQueryByScode(ParameterList);
break;
case QueryType.Rownum:
Dt = CodeFileL.doQueryByRownum(ParameterList);
break;
case QueryType.SLP:
Dt = CodeFileL.doQueryBySLP(ParameterList);
break;
case QueryType.POP:
Dt = CodeFileL.doQueryLikeBySLPPop(ParameterList);
break;
case QueryType.Empty:
Dt = CodeFileL.getEmptyTable();
break;
default:
Dt = new DataTable();
break;
}
return Dt;
}
catch (Exception ex)
{
throw ex;
}
}