public DataTable GetData(QP00xx queryArgs)
{
List <DbParameterEx> parms = new List <DbParameterEx>()
{
new DbParameterEx("IN_START_DATE", queryArgs.IN_START_DATE),
new DbParameterEx("IN_END_DATE", queryArgs.IN_END_DATE)
//new DbParameterEx("RETURNPARAMETER",0)
};
string sql = "pos_owner.PKG_UTILITY.SP_QUERY_LOCK_TIMES";
return(queryArgs.posDB.ExecuteStoredProcedureEx(sql, parms, true));
}
public DataTable GetData(QP00xx queryArgs)
{
List <DbParameterEx> parms = new List <DbParameterEx>()
{
new DbParameterEx("IN_FCM_NO", queryArgs.IN_FCM_NO),
new DbParameterEx("IN_ACC_NO", queryArgs.IN_ACC_NO)
//new DbParameterEx("RETURNPARAMETER",null)
};
string sql = "pos_owner.PKG_UTILITY.SP_QUERY_USER_STATUS";
return(queryArgs.posDB.ExecuteStoredProcedureEx(sql, parms, true));
}
public DataTable GetData(QP00xx queryArgs)
{
List <DbParameterEx> parms = new List <DbParameterEx>()
{
new DbParameterEx("IN_START_DATE", queryArgs.IN_START_DATE),
new DbParameterEx("IN_END_DATE", queryArgs.IN_END_DATE),
new DbParameterEx("IN_SYSTEM", queryArgs.IN_SYSTEM),
new DbParameterEx("IN_KIND", queryArgs.IN_KIND),
new DbParameterEx("IN_GROUP_TYPE", queryArgs.IN_GROUP_TYPE),
//new DbParameterEx("RETURNPARAMETER",0)
};
string sql = "pos_owner.PKG_UTILITY.SP_QUERY_APPLY_CASE";
return(queryArgs.posDB.ExecuteStoredProcedureEx(sql, parms, true));
}
