31 lines
1007 B
C#
31 lines
1007 B
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Data.OracleClient;
|
|
|
|
namespace WX.CRM.DAL.Res
|
|
{
|
|
public class RES_SENIORSHAREDPOOL_DAL
|
|
{
|
|
public DataSet FindSeniorSharedPoolRes(decimal userId, decimal eid)
|
|
{
|
|
try
|
|
{
|
|
var p = new List<OracleParameter>
|
|
{
|
|
new OracleParameter{ ParameterName = "p_userId", OracleType = OracleType.Number, Value = userId },
|
|
new OracleParameter{ ParameterName = "p_eid", OracleType = OracleType.Number, Value = eid },
|
|
new OracleParameter {ParameterName = "p_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output},
|
|
};
|
|
|
|
return OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_DISTRIBUTE.FindSeniorSharedPoolRes", p.ToArray());
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
|
|
throw;
|
|
}
|
|
}
|
|
}
|
|
}
|