public CnsysGridReader DocumentDataSearch(string documentIDs, string documentIdentifiers, int startIndex, int pageSize, out int?count)
{
var parameters = new OracleDynamicParameters();
parameters.Add("p_Document_Ids", OracleDbType.Varchar2, documentIDs);
parameters.Add("p_Guid_Ids", OracleDbType.Varchar2, documentIdentifiers);
parameters.Add("p_StartIndex", OracleDbType.Int32, startIndex);
parameters.Add("p_PageSize", OracleDbType.Int32, pageSize);
parameters.Add("p_ResultsCount_out", OracleDbType.Int32, null, System.Data.ParameterDirection.Output);
parameters.Add("p_Data", OracleDbType.RefCursor, ParameterDirection.Output);
var reader = DbConnection.SPExecuteReader("PKG_VELIN.p_Document_Data_Search", parameters);
count = parameters.GetIntNumber("p_ResultsCount_out");
return(reader);
}
public CnsysGridReader ServiceInstanceSearch(string p_ServiceInstance_Ids, long?p_Office_Id, long?p_Applicant_CIN, int p_StartIndex, int p_PageSize, out int count)
{
var parameters = new OracleDynamicParameters();
parameters.Add("p_ServiceInstance_Ids", OracleDbType.Varchar2, p_ServiceInstance_Ids);
parameters.Add("p_Office_Id", OracleDbType.Int32, p_Office_Id);
parameters.Add("p_Applicant_CIN", OracleDbType.Int32, p_Applicant_CIN);
parameters.Add("p_StartIndex", OracleDbType.Int32, p_StartIndex);
parameters.Add("p_PageSize", OracleDbType.Int32, p_PageSize);
parameters.Add("p_ResultsCount_out", OracleDbType.Int32, null, System.Data.ParameterDirection.Output);
parameters.Add("cv_1", OracleDbType.RefCursor, ParameterDirection.Output);
var reader = DbConnection.SPExecuteReader("PKG_VELIN.p_ServiceInstance_Search", parameters);
count = parameters.GetIntNumber("p_ResultsCount_out");
return(reader);
}
