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]);
}
