private DataTable GetFundSecurityPool(string stockCode, string industryOrRating, bool inBasePool, bool inCorePool, bool inRestPool, bool inProhPool, int analystId, bool isEquity, DateTime startdate, DateTime enddate, int hedgefundId) { try { DBServiceClient client = new DBServiceClient(); ProcedureParameter[] paraList = new ProcedureParameter[11]; if (stockCode == null || stockCode.Length == 0 || stockCode == "*") { stockCode = "%"; } stockCode = stockCode.Replace("*", "%"); if (industryOrRating == null || industryOrRating.Length == 0 || industryOrRating == "*") { industryOrRating = "%"; } industryOrRating = industryOrRating.Replace("*", "%"); paraList[1] = new ProcedureParameter(); paraList[1].Name = "i_stockcode"; paraList[1].Value = stockCode.ToUpper(); paraList[1].Direction = ParameterDirection.Input; paraList[1].Type = ProcedureParameter.DBType.NVarChar; paraList[2] = new ProcedureParameter(); paraList[2].Name = "i_inbasepool"; paraList[2].Value = inBasePool ? "1" : null; paraList[2].Direction = ParameterDirection.Input; paraList[2].Type = ProcedureParameter.DBType.Char; paraList[3] = new ProcedureParameter(); paraList[3].Name = "i_incorepool"; paraList[3].Value = inCorePool ? "1" : null; paraList[3].Direction = ParameterDirection.Input; paraList[3].Type = ProcedureParameter.DBType.Char; paraList[4] = new ProcedureParameter(); paraList[4].Name = "i_inprohpool"; paraList[4].Value = inProhPool ? "1" : null; paraList[4].Direction = ParameterDirection.Input; paraList[4].Type = ProcedureParameter.DBType.Char; paraList[5] = new ProcedureParameter(); paraList[5].Name = "o_cursor"; paraList[5].Type = ProcedureParameter.DBType.Cursor; paraList[5].Direction = ParameterDirection.Output; paraList[6] = new ProcedureParameter(); paraList[6].Name = "i_analystid"; paraList[6].Value = analystId; paraList[6].Direction = ParameterDirection.Input; paraList[6].Type = ProcedureParameter.DBType.Int; paraList[7] = new ProcedureParameter(); paraList[7].Name = "i_inrestpool"; paraList[7].Value = inRestPool ? "1" : null; paraList[7].Direction = ParameterDirection.Input; paraList[7].Type = ProcedureParameter.DBType.Char; paraList[8] = new ProcedureParameter(); paraList[8].Name = "i_startdate"; paraList[8].Value = startdate.ToString("yyyyMMdd"); paraList[8].Direction = ParameterDirection.Input; paraList[8].Type = ProcedureParameter.DBType.NVarChar; paraList[9] = new ProcedureParameter(); paraList[9].Name = "i_enddate"; paraList[9].Value = enddate.ToString("yyyyMMdd"); paraList[9].Direction = ParameterDirection.Input; paraList[9].Type = ProcedureParameter.DBType.NVarChar; paraList[10] = new ProcedureParameter(); paraList[10].Name = "i_hedgefundid"; paraList[10].Value = hedgefundId; paraList[10].Direction = ParameterDirection.Input; paraList[10].Type = ProcedureParameter.DBType.Int; paraList[0] = new ProcedureParameter(); paraList[0].Value = industryOrRating; paraList[0].Direction = ParameterDirection.Input; paraList[0].Type = ProcedureParameter.DBType.NVarChar; DataSet ds = null; if (isEquity) { paraList[0].Name = "i_swindustry"; ds = client.ExecuteStoredProcedure("db2_proc_selectfundequitypool", paraList); } else { paraList[0].Name = "i_rating"; ds = client.ExecuteStoredProcedure("db2_proc_selectfundbondpool", paraList); } return(ds.Tables[0]); } catch (Exception ex) { throw ex; } }
public DataTable GetReportList(string stockCode) { try { DBServiceClient client = new DBServiceClient(); ProcedureParameter[] paraList = new ProcedureParameter[10]; if (stockCode == null || stockCode.Length == 0 || stockCode == "*") { return(null); } paraList[0] = new ProcedureParameter(); paraList[0].Name = "i_reportid"; paraList[0].Value = null; paraList[0].Direction = ParameterDirection.Input; paraList[0].Type = ProcedureParameter.DBType.BigInt; paraList[1] = new ProcedureParameter(); paraList[1].Name = "i_analystid"; paraList[1].Value = null; paraList[1].Direction = ParameterDirection.Input; paraList[1].Type = ProcedureParameter.DBType.BigInt; paraList[2] = new ProcedureParameter(); paraList[2].Name = "i_stockcode"; paraList[2].Value = stockCode; paraList[2].Direction = ParameterDirection.Input; paraList[2].Type = ProcedureParameter.DBType.NVarChar; paraList[3] = new ProcedureParameter(); paraList[3].Name = "i_reporttype1"; paraList[3].Value = null; paraList[3].Direction = ParameterDirection.Input; paraList[3].Type = ProcedureParameter.DBType.BigInt; paraList[4] = new ProcedureParameter(); paraList[4].Name = "i_reporttype2"; paraList[4].Value = null; paraList[4].Direction = ParameterDirection.Input; paraList[4].Type = ProcedureParameter.DBType.BigInt; paraList[5] = new ProcedureParameter(); paraList[5].Name = "i_reportname"; paraList[5].Value = null; paraList[5].Direction = ParameterDirection.Input; paraList[5].Type = ProcedureParameter.DBType.NVarChar; paraList[6] = new ProcedureParameter(); paraList[6].Name = "i_keywords"; paraList[6].Value = null; paraList[6].Direction = ParameterDirection.Input; paraList[6].Type = ProcedureParameter.DBType.NVarChar; paraList[7] = new ProcedureParameter(); paraList[7].Name = "i_reportdate1"; paraList[7].Value = null; paraList[7].Direction = ParameterDirection.Input; paraList[7].Type = ProcedureParameter.DBType.Date; paraList[8] = new ProcedureParameter(); paraList[8].Name = "i_reportdate2"; paraList[8].Value = null; paraList[8].Direction = ParameterDirection.Input; paraList[8].Type = ProcedureParameter.DBType.Date; paraList[9] = new ProcedureParameter(); paraList[9].Name = "o_cursor"; paraList[9].Direction = ParameterDirection.Output; paraList[9].Type = ProcedureParameter.DBType.Cursor; DataSet ds = client.ExecuteStoredProcedure("db1_proc_selectequityreport", paraList); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } }
public DataTable GetAnalyst() { try { DataTable dtAnalyst; DBServiceClient client = new DBServiceClient(); ProcedureParameter[] paraList = new ProcedureParameter[1]; paraList[0] = new ProcedureParameter(); paraList[0].Name = "o_cursor"; paraList[0].Direction = ParameterDirection.Output; paraList[0].Type = ProcedureParameter.DBType.Cursor; DataSet ds = client.ExecuteStoredProcedure("db1_proc_selectanalyst", paraList); dtAnalyst = ds.Tables[0]; return(dtAnalyst); } catch (Exception ex) { throw ex; } }
public DataTable GetGZB(DateTime startDate, DateTime endDate, string fundCode, string itemCode) { DBServiceClient client = new DBServiceClient(); ProcedureParameter[] paraList = new ProcedureParameter[5]; ProcedureParameter para0 = new ProcedureParameter(); para0.Name = "o_cursor"; para0.Direction = ParameterDirection.Output; para0.Type = ProcedureParameter.DBType.Cursor; paraList[0] = para0; ProcedureParameter para1 = new ProcedureParameter(); para1.Name = "i_fundcode"; para1.Value = fundCode; para1.Direction = ParameterDirection.Input; para1.Type = ProcedureParameter.DBType.NVarChar; paraList[1] = para1; ProcedureParameter para2 = new ProcedureParameter(); para2.Name = "i_startdate"; para2.Value = startDate.ToString("yyyyMMdd"); para2.Direction = ParameterDirection.Input; para2.Type = ProcedureParameter.DBType.NVarChar; paraList[2] = para2; ProcedureParameter para3 = new ProcedureParameter(); para3.Name = "i_enddate"; para3.Value = endDate.ToString("yyyyMMdd"); para3.Direction = ParameterDirection.Input; para3.Type = ProcedureParameter.DBType.NVarChar; paraList[3] = para3; ProcedureParameter para4 = new ProcedureParameter(); para4.Name = "i_itemcode"; para4.Value = itemCode; para4.Direction = ParameterDirection.Input; para4.Type = ProcedureParameter.DBType.NVarChar; paraList[4] = para4; return(client.ExecuteStoredProcedure("db5_proc_selectgzb", paraList).Tables[0]); }
public DataTable GetFundSecurityPoolHistory(string stockCode, DateTime startdate, DateTime enddate, bool?isEquity, int?hedgefundid) { try { if (stockCode == null || stockCode.Length == 0) { stockCode = "%"; } stockCode = stockCode.Replace("*", "%"); DBServiceClient client = new DBServiceClient(); ProcedureParameter[] paraList = new ProcedureParameter[6]; paraList[0] = new ProcedureParameter(); paraList[0].Name = "i_stockcode"; paraList[0].Value = stockCode; paraList[0].Direction = ParameterDirection.Input; paraList[0].Type = ProcedureParameter.DBType.NVarChar; paraList[1] = new ProcedureParameter(); paraList[1].Name = "o_cursor"; paraList[1].Type = ProcedureParameter.DBType.Cursor; paraList[1].Direction = ParameterDirection.Output; paraList[2] = new ProcedureParameter(); paraList[2].Name = "i_startdate"; paraList[2].Value = startdate.ToString("yyyyMMdd"); paraList[2].Direction = ParameterDirection.Input; paraList[2].Type = ProcedureParameter.DBType.NVarChar; paraList[3] = new ProcedureParameter(); paraList[3].Name = "i_enddate"; paraList[3].Value = enddate.ToString("yyyyMMdd"); paraList[3].Direction = ParameterDirection.Input; paraList[3].Type = ProcedureParameter.DBType.NVarChar; paraList[4] = new ProcedureParameter(); paraList[4].Name = "i_sectype"; paraList[4].Value = (isEquity == null || isEquity.Value == false) ? "B" : "E"; paraList[4].Direction = ParameterDirection.Input; paraList[4].Type = ProcedureParameter.DBType.Char; paraList[5] = new ProcedureParameter(); paraList[5].Name = "i_hedgefundid"; paraList[5].Value = hedgefundid; paraList[5].Direction = ParameterDirection.Input; paraList[5].Type = ProcedureParameter.DBType.Int; if (isEquity == null) { paraList[4].Value = null; } else { paraList[4].Value = (isEquity.Value == true ? "E" : "B"); } DataSet ds = client.ExecuteStoredProcedure("db2_proc_selectfundequityhist", paraList); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } }
public DataTable GetIndustryCodes() { try { if (_dtIndustryCode == null) { DBServiceClient client = new DBServiceClient(); ProcedureParameter[] paraList = new ProcedureParameter[1]; paraList[0] = new ProcedureParameter(); paraList[0].Name = "o_cursor"; paraList[0].Direction = ParameterDirection.Output; paraList[0].Type = ProcedureParameter.DBType.Cursor; DataSet ds = client.ExecuteStoredProcedure("db2_proc_selectIndustrycodes", paraList); _dtIndustryCode = ds.Tables[0]; } return(_dtIndustryCode); } catch (Exception ex) { throw ex; } }