/// <summary>
/// Get data by store procedure
/// </summary>
/// <param name="inName">sp name</param>
/// <param name="inParms">parameters</param>
/// <returns></returns>
protected DataSet GetOracleDataSetBySp(string inName, OracleParameter[] inParms)
{
using (var openmarket = new OpenMarketEntities())
{
using (var spCmd = new OracleCommand())
{
DataSet ds = null;
openmarket.Database.Connection.Open();
spCmd.Connection = new OracleConnection(openmarket.Database.Connection.ConnectionString);
spCmd.CommandText = inName;
spCmd.CommandType = CommandType.StoredProcedure;
spCmd.CommandTimeout = 0;
if (inParms != null)
{
spCmd.Parameters.AddRange(inParms);
}
var da = new OracleDataAdapter(spCmd);
ds = new DataSet();
da.Fill(ds);
return(ds);
}
}
}
/// <summary>
/// select items by maturity_dt when the expried checkbox is checked
/// </summary>
/// <param name="reportPara"></param>
/// <returns></returns>
private IEnumerable <OpenMarketRepo> GetOpenMarketRepoIncludeExpired(DetailDataReportParams reportPara)
{
using (var VAVDB = new OpenMarketEntities())
{
return((from r in VAVDB.V_OPENMARKET
where DateTime.Compare((DateTime)r.MATURITY_DT, (DateTime)reportPara.StartDate) > 0 && DateTime.Compare((DateTime)r.MATURITY_DT, (DateTime)reportPara.EndDate) < 0
select new OpenMarketRepo
{
IsSumItem = false,
Code = r.RIC,
Date = r.MATURITY_DT,
IssueDate = r.ISSUEDATE,
MaturityDate = r.MATURITY_DT,
Direction = "",
OperationType = "IE",
AssetId = r.ASSET_ID,
Volume = (double)r.VOLUME,
Amount = (double)r.VOLUME,
PirceRate = (double)r.YIELD,
RefRate = (double)r.YIELD,
OperationTerm = "",
Term = (int)r.TERM,
TermEn = r.TERM_EN,
TermCn = r.TERM_CN,
Category = ""
}).ToList());
}
}
