public DataTable GetUnderNetProjects() { try { DBServiceClient client = new DBServiceClient(); string sql = @"Select A.Fundcode , B.Name AS FundName , A.Stockcode , A.Stockname , A.QUOTEDATE , A.Price , A.Volume , CASE A.Success WHEN '1' THEN '有效' ELSE '无效' END AS Success , A.Getvolume From db6_t_ipo A LEFT JOIN db5_t_portfoliolist B ON A.Fundcode = B.Code WHERE A.IsActive = '1' ORDER BY A.Fundcode, A.Quotedate DESC"; DataSet ds = client.ExecuteSQL(sql); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } }
public DataTable GetIPOUndernet() { //获得网下参与新股申购的列表 DBServiceClient client = new DBServiceClient(); string sql = @"Select * From db6_t_ipo t Where 1=1 AND (quotedate is null OR QuoteDate > sysdate-30)"; DataSet ds = client.ExecuteSQL(sql); return(ds.Tables[0]); }
public DataTable GetStatisticData(bool isGroupByIndustry) { string sql = ""; if (isGroupByIndustry) { sql = "select * from db2_v_fundequitypoolstat1"; } else { sql = "select * from db2_v_fundequitypoolstat2"; } DBServiceClient client = new DBServiceClient(); DataSet dt = client.ExecuteSQL(sql); return(dt.Tables[0]); }
public DataTable GetTebonPortfolios(bool isTebon) { DBServiceClient client = new DBServiceClient(); string sql = @"select * from db5_t_portfoliolist t where IsActive='1' "; if (isTebon) { sql += " AND istebon ='1' "; } else { sql += " AND istebon <>'1' "; } sql += " ORDER BY assettype, startdate"; DataSet ds = client.ExecuteSQL(sql); return(ds.Tables[0]); }