/// <summary>
/// 获取教材
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private static string GetStandBook(HttpContext context)
{
string Json;
string stage = context.Request["t[Stage]"];
string subject = context.Request["t[Subject]"];
string grade = context.Request["t[Grade]"];
string edition = context.Request["t[Edition]"];
string booklet = context.Request["t[Booklet]"];
BasicServiceClient basicWebService = new BasicServiceClient();
C_Textbook[] standbookList = basicWebService.GetTextbookDict(Utils.StrToInt(stage, 0), Utils.StrToInt(subject, 0), Utils.StrToInt(grade, 0), Utils.StrToInt(booklet, 0), Utils.StrToInt(edition, 0));
List <StandBook> list = new List <StandBook>();
foreach (var item in standbookList)
{
StandBook model = new StandBook();
model.ID = item.Id;
model.Stage = item.Stage;
model.Subject = item.Subject;
model.Grade = item.Grade;
model.Edition = item.Edition;
model.Booklet = item.Booklet;
model.BooKName = item.BookName;
model.BookCover = item.BookCover;
list.Add(model);
}
Json = "{\"Data\":" + JsonHelper.JsonSerializer(list) + "}";
return(Json);
}
public static StandBook GetStandBookByID(int bookID)
{
StandBook book = new StandBook();
using (var db = new ModMetaEntities())
{
var list = db.tb_StandardBook.Where(m => m.ID == bookID && m.Deleted == 0).ToList();
book.ID = list[0].ID;
book.BookName = list[0].BooKName;
book.SubjectID = list[0].Subject;
var subject = db.tb_Code_ListTable2.Where(m => m.ID == book.SubjectID && m.Deleted == 0).ToList();
book.SubjectName = subject[0].CodeName;
book.StageID = list[0].Stage;
var stage = db.tb_Code_SchoolStage.Where(m => m.ID == book.StageID && m.Deleted == 0).ToList();
book.StageName = stage[0].CodeName;
book.EditionID = list[0].Edition;
var edition = db.tb_Code_ListTable3.Where(m => m.ID == book.EditionID && m.Deleted == 0).ToList();
book.EditionName = edition[0].CodeName;
}
return(book);
}
/// <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));
}
}
