private SyncResponse UpdateStanBookUsingTime(SyncRequest request)
{
clr_electronic_book submitData = JsonHelper.DecodeJson <clr_electronic_book>(request.Data);
using (var db = new fz_wisdomcampusEntities())
{
clr_electronic_book book = db.clr_electronic_book.FirstOrDefault(b => b.UserID == submitData.UserID && b.BookID == submitData.BookID);
book.EndUseDate = DateTime.Now;
db.SaveChanges();
return(SyncResponse.GetResponse(request, true));
}
}
public PageInit GET(string UserID, int SubjectID, int GradeID)
{
PageInit m = new PageInit();
clr_electronic_book eb = null;
List <r_resource> lRes = null;
using (var db = new fz_wisdomcampusEntities())
{
eb = db.clr_electronic_book.Where(w => w.UserID == UserID && w.SubjectID == SubjectID && w.GradeID == GradeID).FirstOrDefault();
}
//using (var db1 = new fz_resourceEntities())
//{
// lRes = db1.r_resource.Where(w => w.ResourceCreaterID == UserID && w.SubjectID == SubjectID && w.GradeID == eb.GradeID).ToList();
//}
//foreach (var ds in eb)
//{
// m.Add(new PageInit
// {
// BookID = ds.BookID,
// BookName = ds.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)ds.BookID),
// UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)ds.BookID).Select(s => new UnitInfo
// {
// UnitID = s.Id,
// UnitName = s.Name
// }).ToList(),
// UserID = ds.UserID
// });
//}
m.UserID = UserID;
m.BookID = eb.BookID;
m.BookName = eb.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)eb.BookID);
//m.UnitInfo = lRes.Select(s => new UnitInfo
//{
// UnitID = s.Catalog,
// UnitName = s.KeyWords
//}).ToList();
m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo
{
UnitID = s.Id,
UnitName = s.Name
}).ToList();
return(m);
}
/// <summary>
/// 学生端获取目录信息
/// </summary>
/// <param name="UserID">131b1f49-7064-4fba-a380-9c169701a818</param>
/// <param name="SubjectID"></param>
/// <returns></returns>
public PageInit GET(string UserID, int SubjectID, int GradeID)
{
string tid = "";
int? grade = null;
List <r_resource> lRes = null;
using (var db1 = new FzDatabase.Basic.fz_basicEntities())
{
var stu = db1.sy_student.Where(w => w.UserId == UserID.Trim()).FirstOrDefault();
grade = stu.sy_grade.SGradeId + 1;
tid = db1.sy_teacher_and_class_and_subject.Where(w => w.ClassId == stu.Class && w.Subject == SubjectID).Select(s => s.sy_teacher.UserId).FirstOrDefault();
}
using (var db2 = new fz_resourceEntities())
{
lRes = db2.r_resource.Where(w => w.ResourceCreaterID == tid && w.SubjectID == SubjectID && w.GradeID == GradeID).ToList();
}
PageInit m = new PageInit();
clr_electronic_book eb = null;
using (var db = new fz_wisdomcampusEntities())
{
eb = db.clr_electronic_book.Where(w => w.UserID == tid && w.GradeID == GradeID && w.SubjectID == SubjectID).FirstOrDefault();
}
m.UserID = tid;
m.BookID = eb.BookID;
m.BookName = eb.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)eb.BookID);
List <UnitInfo> nonDuplicateList1 = lRes.Select(s => new UnitInfo
{
UnitID = s.Catalog,
UnitName = GetUnitNameStu(s.Catalog)
}).Distinct().ToList();
List <UnitInfo> nonDuplicateList2 = nonDuplicateList1.Where((x, i) => nonDuplicateList1.FindIndex(z => z.UnitID == x.UnitID) == i).ToList();//Lambda表达式去重
m.UnitInfo = nonDuplicateList2;
//m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo
//{
// UnitID = s.Id,
// UnitName = s.Name
//}).ToList();
return(m);
}
/// <summary>
/// 老师端获取目录信息
/// </summary>
/// <param name="UserID"></param>
/// <param name="SubjectID"></param>
/// <param name="GradeID"></param>
/// <returns></returns>
public PageInit GET(string UserID, int SubjectID, int GradeID)
{
PageInit m = new PageInit();
clr_electronic_book eb = null;
List <r_resource> lRes = null;
using (var db = new fz_wisdomcampusEntities())
{
eb = db.clr_electronic_book.Where(w => w.UserID == UserID && w.SubjectID == SubjectID && w.GradeID == GradeID).FirstOrDefault();
}
using (var db1 = new fz_resourceEntities())
{
lRes = db1.r_resource.Where(w => w.ResourceCreaterID == UserID && w.SubjectID == SubjectID && w.GradeID == eb.GradeID).ToList();
}
m.UserID = UserID;
m.BookID = eb.BookID;
m.BookName = GetBookName(eb.BookID);
List <UnitInfo> nonDuplicateList1 = lRes.Select(s => new UnitInfo
{
UnitID = s.Catalog,
UnitName = GetUnitNameTech(s.Catalog)
}).Distinct().ToList();
List <UnitInfo> nonDuplicateList2 = nonDuplicateList1.Where((x, i) => nonDuplicateList1.FindIndex(z => z.UnitID == x.UnitID) == i).ToList();//Lambda表达式去重
m.UnitInfo = nonDuplicateList2;
//m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo
//{
// UnitID = s.Id,
// UnitName = s.Name
//}).ToList();
//string UnitID = null;
//foreach (UnitInfo un in m.UnitInfo)
//{
// if (un.UnitID == UnitID)
// {
// }
// UnitID=
//}
return(m);
}
/// <summary>
/// 老师获取单元目录
/// </summary>
/// <param name="UserID"></param>
/// <param name="SubjectID"></param>
/// <returns></returns>
public PageInit GET(string UserID, int SubjectID, int GradeID)
{
string tid = UserID;
PageInit m = new PageInit();
clr_electronic_book eb = null;
using (var db = new fz_wisdomcampusEntities())
{
eb = db.clr_electronic_book.Where(w => w.UserID == tid && w.GradeID == GradeID).FirstOrDefault();
}
m.UserID = tid;
m.BookID = eb.BookID;
m.BookName = eb.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)eb.BookID);
m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo
{
UnitID = s.Id,
UnitName = s.Name
}).ToList();
return(m);
}
/// <summary>
/// 用户添加教材
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
private SyncResponse AddUserStandBook(SyncRequest request)
{
try
{
UserStandBookModul submitData = JsonHelper.DecodeJson <UserStandBookModul>(request.Data);
using (var db = new fz_wisdomcampusEntities())
{
List <StandBook> AddList = new List <StandBook>();
List <clr_electronic_book> RemoveList = new List <clr_electronic_book>();;
var list = db.clr_electronic_book.Where(b => b.UserID == submitData.UserID).ToList();
////////////////添加的教材为空的时候,清空用户教材//////////////////////
if (submitData.StandBookList.Count() == 0)
{
foreach (var item in list)
{
db.clr_electronic_book.Remove(item);
}
db.SaveChanges();
}
else
{
///////////////匹配获取需要添加的教材//////////////////
foreach (var book in submitData.StandBookList)
{
clr_electronic_book model = list.FirstOrDefault(b => b.BookID == book.ID);
if (model == null)
{
AddList.Add(book);
}
}
///////////////匹配获取需要删除的教材//////////////////
foreach (var book in list)
{
StandBook model = submitData.StandBookList.FirstOrDefault(b => b.ID == book.BookID);
if (model == null)
{
RemoveList.Add(book);
}
}
///////////////删除教材/////////////////
foreach (var item in RemoveList)
{
clr_electronic_book model = list.FirstOrDefault(b => b.BookID == item.BookID);
db.clr_electronic_book.Remove(model);
db.SaveChanges();
}
///////////////添加教材/////////////////
foreach (var book in AddList)
{
clr_electronic_book model = new clr_electronic_book();
model.BookID = book.ID;
model.SubjectID = book.Subject;
model.EditionID = book.Edition;
model.GradeID = book.Grade;
model.BookType = book.BookType;
model.Stage = book.Stage;
model.UserID = submitData.UserID;
model.CreateDate = DateTime.Now;
db.clr_electronic_book.Add(model);
}
db.SaveChanges();
}
}
return(SyncResponse.GetResponse(request, true));
}
catch (Exception ex)
{
return(SyncResponse.GetErrorResponse(ex.Message));
}
}
