/// <summary>
/// 研究单元-语言
///获取所有语言下的所有文献数量
/// </summary>
/// <returns>所有语言，所有语言下的文献数量</returns>
public async Task <List <TypeNameCount> > GetSYS_LanguageListAndCount()
{
SYS_TemplateFieldAdapter sys_TemplateFieldModelAdapter = new SYS_TemplateFieldAdapter();
ProductionsFieldAdapter productionsFieldAdapter = new ProductionsFieldAdapter();
string sql = @"SELECT DISTINCT Iso FROM dbo.StaticProductions WHERE iso IS NOT NULL AND iso<>''";
using (var db = new OperationManagerDbContext())
{
List <string> strlist = db.Database.SqlQuery <string>(sql).ToList();
List <TypeNameCount> dicList = new List <TypeNameCount>();
int lif = 0;
for (int i = 0; i < strlist.Count; i++)
{
lif = productionsFieldAdapter.LoadByDefaultText("iso", strlist[i]);
TypeNameCount dic = new TypeNameCount();
// dic.TypeID = "8BC5C3A3-6565-45F8-B77A-891077D4E2A5";
dic.TypeID = "iso";
dic.TypeName = strlist[i];
dic.TypeCount = lif;
dicList.Add(dic);
}
return(dicList);
}
}
/// <summary>
/// 研究单元-收录类别
///获取所有收录类别下的所有文献数量
/// </summary>
/// <returns>所有收录类别，收录类别下的文献数量</returns>
public List <TypeNameCount> GetSYS_IndexedTypeListAndCount()
{
ProductionsFieldAdapter productionsFieldAdapter = new ProductionsFieldAdapter();
string sql = @"SELECT DISTINCT indexed FROM dbo.StaticProductions WHERE indexed IS NOT NULL AND indexed<>''";
List <TypeNameCount> dicList = new List <TypeNameCount>();
using (var db = new OperationManagerDbContext())
{
List <string> strlist = db.Database.SqlQuery <string>(sql).ToList();
int lif = 0;
for (int i = 0; i < strlist.Count; i++)
{
string indexsql = @"SELECT COUNT(*) FROM dbo.StaticProductions WHERE indexed='" + strlist[i] + "'";
lif = db.Database.SqlQuery <int>(indexsql).FirstOrDefault();
TypeNameCount typeNameCount = new TypeNameCount();
typeNameCount.TypeID = "indexed";//收录类别
typeNameCount.TypeName = strlist[i];
typeNameCount.TypeCount = lif;
dicList.Add(typeNameCount);
}
}
return(dicList);
}
/// <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);
}
}
