public static List <VModelAPI.TextbookCatalog> GetTextbookCatalogByBookid(int bookId)
{
using (var db = new MODMetaDatabaseBranchEntities())
{
IQueryable <tb_StandardCatalog> query = db.tb_StandardCatalog.Where(w => w.Deleted == 0 && w.BookID == bookId);
return(query.Select(s => new VModelAPI.TextbookCatalog {
Id = s.ID, PId = s.ParentID, Name = s.FolderName, PageStart = s.PageStart, PageEnd = s.PageEnd
}).ToList());
}
}
/// <summary>
/// 获取全部并缓存
/// </summary>
/// <returns></returns>
public static List <tb_StandardBook> GetList()
{
List <tb_StandardBook> list = Common.Caches.GetCache("dict_textbook") as List <tb_StandardBook>;
if (list == null)
{
using (var db = new MODMetaDatabaseBranchEntities())
{
list = db.tb_StandardBook.ToList();
}
Common.Caches.SetCache("dict_textbook", list);
}
return(list);
}
public string GetUnitNameStu(int?unitid)
{
tb_StandardCatalog unit = new tb_StandardCatalog();
using (var db = new MODMetaDatabaseBranchEntities())
{
unit = db.tb_StandardCatalog.Where(w => w.ID == unitid).FirstOrDefault();
}
if (unit == null)
{
return("目录");
}
return(unit.FolderName);
}
public string GetBookName(int?BookID)
{
tb_StandardBook book;
using (var db1 = new MODMetaDatabaseBranchEntities())
{
book = db1.tb_StandardBook.Where(w => w.ID == BookID).FirstOrDefault();
}
if (book == null)
{
return("无教材");
}
else
{
return(book.BooKName);
}
}
// GET api/<controller>/5
/// <summary>
/// 获取教材
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public C_Textbook Get(int id)
{
using (var db = new MODMetaDatabaseBranchEntities())
{
tb_StandardBook s = db.tb_StandardBook.Find(id);
return(new C_Textbook
{
Id = s.ID,
BookName = s.BooKName,
Stage = s.Stage,
Subject = s.Subject,
Grade = s.Grade,
Edition = s.Edition,
Booklet = s.Booklet
});
}
}
// GET api/<controller>/5
/// <summary>
/// 获取教材
/// </summary>
/// <param name="Stage">所属学段</param>
/// <param name="Subject">所属学科</param>
/// <param name="Grade">所属年级</param>
/// <param name="Booklet">册别</param>
/// <param name="Edition">版本</param>
/// <returns></returns>
public List <C_Textbook> Get(int?Stage, int?Subject, int?Grade, int?Booklet, int?Edition)
{
using (var db = new MODMetaDatabaseBranchEntities())
{
IQueryable <tb_StandardBook> query = db.tb_StandardBook.Where(w => w.Deleted == 0);
if (Stage != null && Stage != 0)
{
query = query.Where(w => w.Stage == Stage);
}
if (Subject != null && Subject != 0)
{
query = query.Where(w => w.Subject == Subject);
}
if (Grade != null && Grade != 0)
{
query = query.Where(w => w.Grade == Grade);
}
if (Booklet != null && Booklet != 0)
{
query = query.Where(w => w.Booklet == Booklet);
}
if (Edition != null && Edition != 0)
{
query = query.Where(w => w.Edition == Edition);
}
return(query.Select(s => new C_Textbook
{
Id = s.ID,
BookName = s.BooKName,
Stage = s.Stage,
Subject = s.Subject,
Grade = s.Grade,
Edition = s.Edition,
Booklet = s.Booklet,
}).ToList());
}
}
public string GetUnitNameTech(int?unitid)
{
tb_StandardCatalog unit = new tb_StandardCatalog();
tb_StandardCatalog unitP = new tb_StandardCatalog();
string unitName;
using (var db1 = new MODMetaDatabaseBranchEntities())
{
unit = db1.tb_StandardCatalog.Where(w => w.ID == unitid).FirstOrDefault();
if (unit != null && unit.ParentID != 0)
{
unitP = db1.tb_StandardCatalog.Where(w => w.ID == unit.ParentID).FirstOrDefault();
unitName = unitP.FolderName + "-" + unit.FolderName;
return(unitName);
}
}
if (unit == null)
{
return("目录");
}
return(unit.FolderName);
}