public override void Initialization()
{
var strWhere = "";
if (ID == 55) //Fx market
{
strWhere = "WHERE num<=5 AND BusinessCodeType='FX' ";
}
else if (ID == 61) // Fi market
{
strWhere += "WHERE num<=5 AND BusinessCodeType IN('FI','MM') ";
}
else if (ID == 22003)
{
strWhere = "WHERE num<=5 AND BusinessCodeType IN('Agriculture','Energy','Commodities','Metal','Others') ";
}
var oracleDBHelper =
new OracleDBHelper(ConfigurationManager.AppSettings["FileDBConStr"]);
var sql = "select * FROM GETReseachReportByType " + strWhere +
"ORDER BY InstitutionOrder,Code,TypeOrder,fileTypeCTIME,ReportDate DESC,num";
var dt = oracleDBHelper.GetDataTableBySql(sql);
//var cmd = new OracleCommand
//{
// Connection = (OracleConnection)(db.Database.Connection),
// CommandText = "select * FROM GETReseachReportByType " + strWhere +
// "ORDER BY InstitutionOrder,Code,TypeOrder,fileTypeCTIME,ReportDate DESC,num"
//};
//var da = new OracleDataAdapter(cmd);
//da.Fill(dt);
InstitList = (from DataRow dr in dt.Rows
select new InstitutionViewModel
{
Code = dr["Code"].ToString(),
InstitutionNameCn = dr["InstitutionNameCn"].ToString(),
InstitutionNameEn = dr["InstitutionNameEn"].ToString(),
Mtime = Convert.ToDateTime(dr["MTIME"]),
InstitutionExtension = dr["InstitutionExtension"].ToString(),
FileTypeNameCn = dr["FileTypeNameCn"].ToString(),
FileTypeNameEn = dr["FileTypeNameEn"].ToString(),
FileNameCn = dr["FileNameCn"].ToString(),
FileNameEn = dr["FileNameEn"].ToString(),
FileId = Convert.ToInt32(dr["FileId"]),
Extension = dr["Extension"].ToString(),
ReportDate = Convert.ToDateTime(dr["ReportDate"]),
}).ToList();
INSTITUTIONINFO = (from m in InstitList.Select(re => new { re.InstitutionNameCn, re.InstitutionNameEn, re.Mtime, re.Code, Extension = re.InstitutionExtension }).Distinct()
select new INSTITUTIONINFO {
INSTITUTIONNAMECN = m.InstitutionNameCn, INSTITUTIONNAMEEN = m.InstitutionNameEn, MTIME = m.Mtime, CODE = m.Code, EXTENSION = m.Extension
}).Distinct().ToList();
foreach (var inst in INSTITUTIONINFO)
{
inst.LogoPath = GetLogoImagePath(inst);
}
}