public DataSet GetHedgeFunds()
{
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("o_cursor", ProcedureParameter.DBType.Cursor, ParameterDirection.Output));
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure("db1_proc_selecthedgefund", paraList));
}
public DataSet GetPortfolioBenchmarks(string portfolioCode)
{
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("i_fundcode", ProcedureParameter.DBType.NVarChar, ParameterDirection.Input, portfolioCode));
paraList.Add(new ProcedureParameter("o_cursor", ProcedureParameter.DBType.Cursor, ParameterDirection.Output));
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure("db5_proc_selectbenchmarklist", paraList));
}
public DataSet GetWebConfigsByProject(string project)
{
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("i_project", project));
paraList.Add(new ProcedureParameter("o_cursor", ProcedureParameter.DBType.Cursor, ParameterDirection.Output));
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure("db0_proc_selectwebconfig", paraList));
}
public DataSet GetCategoryList()
{
try
{
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("o_cursor", ProcedureParameter.DBType.Cursor, ParameterDirection.Output));
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure("db3_proc_selectcategory", paraList));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetReportByDate(DateTime reportDate)
{
try
{
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("i_reportdate", reportDate.ToString("yyyyMMdd")));
paraList.Add(new ProcedureParameter("o_cursor", ProcedureParameter.DBType.Cursor, ParameterDirection.Output));
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure("db3_proc_selectmeetingreport", paraList));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetHS300Weight(DateTime endDate)
{
try
{
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("i_date", endDate.ToString("yyyyMMdd")));
paraList.Add(new ProcedureParameter("o_cursor", ProcedureParameter.DBType.Cursor, ParameterDirection.Output));
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure("mkt_proc_selecths300weight", paraList));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetTradingDays(DateTime startDate, DateTime endDate)
{
try
{
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("o_cursor", ProcedureParameter.DBType.Cursor, ParameterDirection.Output));
paraList.Add(new ProcedureParameter("i_startdate", ProcedureParameter.DBType.NVarChar, ParameterDirection.Input, startDate.ToString("yyyyMMdd")));
paraList.Add(new ProcedureParameter("i_enddate", ProcedureParameter.DBType.NVarChar, ParameterDirection.Input, endDate.ToString("yyyyMMdd")));
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure("mkt_proc_selecttradedays", paraList));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetFreeFloatCapital(DateTime endDate, string code)
{
try
{
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("i_date", endDate.ToString("yyyyMMdd")));
paraList.Add(new ProcedureParameter("i_code", code));
paraList.Add(new ProcedureParameter("o_cursor", ProcedureParameter.DBType.Cursor, ParameterDirection.Output));
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure("mkt_proc_selectfreecapital", paraList));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetChinaBondList(string code, string exchange)
{
try
{
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("i_exchange", exchange));
paraList.Add(new ProcedureParameter("i_code", code));
paraList.Add(new ProcedureParameter("o_cursor", ProcedureParameter.DBType.Cursor, ParameterDirection.Output));
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure("mkt_proc_selectchinabondlist", paraList));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetSearchResult(DateTime startDate, DateTime endDate, string keyword)
{
try
{
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("i_startdate", startDate.ToString("yyyyMMdd")));
paraList.Add(new ProcedureParameter("i_enddate", endDate.ToString("yyyyMMdd")));
paraList.Add(new ProcedureParameter("i_keyword", keyword));
paraList.Add(new ProcedureParameter("o_cursor", ProcedureParameter.DBType.Cursor, ParameterDirection.Output));
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure("db3_proc_selectreportbykey", paraList));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetStockPrices(DateTime startDate, DateTime endDate, string code)
{
try
{
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("i_startdate", startDate.ToString("yyyyMMdd")));
paraList.Add(new ProcedureParameter("i_enddate", endDate.ToString("yyyyMMdd")));
paraList.Add(new ProcedureParameter("i_code", code));
paraList.Add(new ProcedureParameter("o_cursor", ProcedureParameter.DBType.Cursor, ParameterDirection.Output));
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure("mkt_proc_selectequityprices", paraList));
}
catch (Exception ex)
{
throw ex;
}
}
public long SubmitReport(DateTime submitDate, int categoryId, string keywords, string content)
{
try
{
Int64 newId = 0;
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
paraList.Add(new ProcedureParameter("i_reportdate", submitDate.ToString("yyyyMMdd")));
paraList.Add(new ProcedureParameter("i_categoryid", categoryId));
paraList.Add(new ProcedureParameter("i_keywords", keywords));
paraList.Add(new ProcedureParameter("i_content", ProcedureParameter.DBType.NClob, ParameterDirection.Input, content));
paraList.Add(new ProcedureParameter("o_insertid", ProcedureParameter.DBType.BigInt, ParameterDirection.Output));
newId = Convert.ToInt64(DBInstanceFactory.GetDBInstance().ExecuteNonQuery("db3_proc_updatemeetingreport", paraList, "o_insertid"));
return(newId);
}
catch (Exception ex)
{
throw ex;
}
}
public string GetReportTitle()
{
try
{
string title = "";
List <ProcedureParameter> paraList = new List <ProcedureParameter>();
ProcedureParameter para = new ProcedureParameter();
para.Name = "o_title";
para.Size = 100;
para.Type = ProcedureParameter.DBType.NVarChar;
para.Direction = ParameterDirection.Output;
paraList.Add(para);
title = DBInstanceFactory.GetDBInstance().ExecuteNonQuery("db3_proc_selecttitle", paraList, "o_title").ToString();
return(title);
}
catch (Exception ex)
{
throw ex;
}
}
DataSet IDBService.ExecuteStoredProcedure(string procedureName, List <ProcedureParameter> procedureParameter)
{
return(DBInstanceFactory.GetDBInstance().ExecuteStoredProcedure(procedureName, procedureParameter));
}
public DataSet ExecuteSQL(string sql)
{
return(DBInstanceFactory.GetDBInstance().ExecuteSQL(sql));
}
public object ExecuteNonQuery(string procedureName, List <ProcedureParameter> procedureParameter, string outputParameterName)
{
return(DBInstanceFactory.GetDBInstance().ExecuteNonQuery(procedureName, procedureParameter, outputParameterName));
}