/// <summary>
/// 个人详细信息-收录类别
///获取个人所有模板的收录类别,该收录类别的所有文献数量
/// </summary>
/// <param name="username">作者的名字</param>
/// <returns>所有模板收录类别和该收录类别下的所有文献and数量</returns>
//E134A22A-4187-4318-BB70-BCC66711ED1D 收录类型
//50883877-E367-4D5B-85FD-5F15A5B2E789 作者
public List <Dictionary <String, Object> > GetUserIndexedTypeListAndCount(string username)
{
SYS_TemplateFieldAdapter sys_TemplateFieldModelAdapter = new SYS_TemplateFieldAdapter();
ProductionsFieldAdapter productionsFieldAdapter = new ProductionsFieldAdapter();
ProductionsAdapter productionsAdapter = new ProductionsAdapter();
string IndexedTypesql = @"SELECT DISTINCT indexed FROM dbo.StaticProductions WHERE indexed IS NOT NULL AND indexed<>''";
using (var db = new OperationManagerDbContext())
{
List <string> IndexedType = db.Database.SqlQuery <string>(IndexedTypesql).ToList();
List <Dictionary <String, Object> > dicList = new List <Dictionary <string, object> >();
for (int i = 0; i < IndexedType.Count; i++)
{
int count = 0;
string sql = @" SELECT count(*) FROM StaticProductions WHERE indexed = '" + IndexedType[i] + "' and author LIKE'%" + username + "%'";
count = db.Database.SqlQuery <int>(sql).FirstOrDefault();
Dictionary <String, Object> dic = new Dictionary <string, object>();
dic.Add("IndexedTypeID", "indexed");
dic.Add("IndexedType", IndexedType[i]);
dic.Add("IndexedTypeCount", count);
dicList.Add(dic);
}
return(dicList);
}
}
/// <summary>
/// 个人详细信息-语言
///获取所有语言下的所有文献数量
/// </summary>
/// <param name="username">作者的名字</param>
/// <returns>所有语言，所有语言下的文献数量</returns>
public List <Dictionary <String, Object> > GetSYS_LanguageListAndCount(string username)
{
SYS_TemplateFieldAdapter sys_TemplateFieldModelAdapter = new SYS_TemplateFieldAdapter();
ProductionsAdapter productionsAdapter = new ProductionsAdapter();
//var templateField = sys_TemplateFieldModelAdapter.GetSYS_TemplateFieldByMetaDataID("8BC5C3A3-6565-45F8-B77A-891077D4E2A5");
string languagesql = @"SELECT DISTINCT Iso FROM dbo.StaticProductions WHERE iso IS NOT NULL AND iso<>''";
using (var db = new OperationManagerDbContext())
{
List <string> language = db.Database.SqlQuery <string>(languagesql).ToList();
// string[] language = templateField.DefaultText.Split(';');
List <Dictionary <String, Object> > dicList = new List <Dictionary <string, object> >();
for (int i = 0; i < language.Count; i++)
{
//List<ProductionsField> lif = LoadByDefaultText("8BC5C3A3-6565-45F8-B77A-891077D4E2A5", language[i], "50883877-E367-4D5B-85FD-5F15A5B2E789", username);
int count = 0;
string sql = @" SELECT count(*) FROM StaticProductions WHERE iso LIKE '%" + language[i] + "%' and author LIKE'%" + username + "%'";
count = db.Database.SqlQuery <int>(sql).FirstOrDefault();
Dictionary <String, Object> dic = new Dictionary <string, object>();
dic.Add("LanguageTypeID", "iso");
dic.Add("LanguageType", language[i]);
dic.Add("LanguageTypeCount", count);
dicList.Add(dic);
}
return(dicList);
}
}
/// <summary>
/// 成果收录情况年度比较
/// </summary>
/// <returns></returns>
public IHttpActionResult GetTongJiByNDChengGuoBiJiao()
{
SYS_TemplateFieldAdapter sys_TemplateFieldModelAdapter = new SYS_TemplateFieldAdapter();
return(Json(sys_TemplateFieldModelAdapter.GetSYS_IndexedTypeListAndCount()));
}
