/// <summary> /// 根据学年学期,书商查询书商实发教材 /// </summary> /// <param name="term"></param> /// <param name="booksellerId"></param> /// <returns></returns> public IEnumerable <BooksellerReleaseDetailView> GetBooksellerReleaseDetail(string term, string booksellerId) { var id = booksellerId.ConvertToGuid(); var yearTerm = new SchoolYearTerm(term); var booksellerRecord = _recordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Bookseller_Id == id).GroupBy(t => new { t.SchoolName, t.Name, t.Isbn, t.Author, t.Press, t.Price }).Select(d => new BooksellerReleaseDetailView() { SchoolName = d.Key.SchoolName, TextbookName = d.Key.Name, Isbn = d.Key.Isbn, Author = d.Key.Author, Press = d.Key.Press, RetailPrice = d.Key.Price.ToString(), TotalCount = d.Sum(p => p.ReleaseCount).ToString(), TotalRetailCharge = d.Sum(p => p.Price * p.ReleaseCount).ToString(), TotalDiscountCharge = d.Sum(p => p.Discount * p.Price * p.ReleaseCount).ToString() }); return(booksellerRecord); }
/// <summary> /// 根据学年学期,学生查询学生实发教材 /// </summary> /// <param name="term"></param> /// <param name="studentId"></param> /// <returns></returns> public IEnumerable <StudentReleaseDetailView> GetStudentReleaseDetail(string term, string studentId) { var studentid = studentId.ConvertToGuid(); var yearTerm = new SchoolYearTerm(term); var studentRecord = _recordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Student_Id == studentid ).Select(p => new StudentReleaseDetailView() { TextbookId = p.Textbook_Id.ToString(), TextbookName = p.Name, RetailPrice = p.Price.ToString(), DiscountPrice = p.DiscountPrice.ToString(), Term = p.SchoolYearTerm.ToString(), SchoolName = p.SchoolName, ClassName = p.ClassName, StudentNum = p.StudentNum, ReleaseCount = p.ReleaseCount.ToString(), Recipient = p.Recipient1Name, Telephone = p.Recipient1Phone, RecipientDate = p.ReleaseDate.ToString() }); return(_adapter.Adapt <StudentReleaseDetailView>(studentRecord)); }
/// <summary> /// 根据学年学期,学生取学生个人教材费用 /// </summary> /// <param name="term"></param> /// <param name="studentName"></param> /// <returns></returns> public IEnumerable <TextbookFeeForStudentView> GetStudentFee(string term, string studentNum) { var yearTerm = new SchoolYearTerm(term); var studentFee = _studentRecordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.StudentNum == studentNum ).GroupBy(t => new { t.Textbook_Id, t.Name, t.Isbn, t.Author, t.Press, t.Price, t.Discount }).Select(d => new TextbookFeeForStudentView() { TextbookId = d.Key.Textbook_Id.ToString(), TextbookName = d.Key.Name, Isbn = d.Key.Isbn, Author = d.Key.Author, Press = d.Key.Press, RetailPrice = d.Key.Price.ToString(), Discount = d.Key.Discount.ToString(), ReleaseCount = d.Sum(t => t.ReleaseCount).ToString(), DiscountPrice = d.Sum(t => t.DiscountPrice).ToString() }); return(studentFee); }
/// <summary> /// 根据学年学期,书商查询书商实发教材 /// </summary> /// <param name="term"></param> /// <param name="booksellerId"></param> /// <returns></returns> public IEnumerable<BooksellerReleaseDetailView> GetBooksellerReleaseDetail(string term, string booksellerId) { var id = booksellerId.ConvertToGuid(); var yearTerm = new SchoolYearTerm(term); var booksellerRecord = _recordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Bookseller_Id == id).GroupBy(t => new { t.SchoolName, t.Name, t.Isbn, t.Author, t.Press, t.Price }).Select(d => new BooksellerReleaseDetailView() { SchoolName = d.Key.SchoolName, TextbookName = d.Key.Name, Isbn = d.Key.Isbn, Author = d.Key.Author, Press = d.Key.Press, RetailPrice = d.Key.Price.ToString(), TotalCount = d.Sum(p => p.ReleaseCount).ToString(), TotalRetailCharge = d.Sum(p => p.Price * p.ReleaseCount).ToString(), TotalDiscountCharge = d.Sum(p => p.Discount * p.Price * p.ReleaseCount).ToString() }); return booksellerRecord; }
public void Operator_Smaller() { var left = new SchoolYearTerm("2013-2014-1"); var right = new SchoolYearTerm("2013-2014-2"); Assert.IsFalse(left > right); }
public void Operator_Greater() { var left = new SchoolYearTerm("2013-2014-1"); var right = new SchoolYearTerm("2013-2014-2"); Assert.IsTrue(left < right); }
public void CompareTo_Equal() { var left = new SchoolYearTerm("2013-2014-1"); var right = new SchoolYearTerm("2013-2014-1"); Assert.AreEqual(0, left.CompareTo(right)); }
public void Operator_NotEqual() { var left = new SchoolYearTerm("2013-2014-1"); var right = new SchoolYearTerm("2013-2014-2"); Assert.IsTrue(left != right); }
public void ObjectCompareTo_LeftIsNull() { var right = new SchoolYearTerm("2013-2014-2"); SchoolYearTerm left = null; left.CompareTo(right as object); }
public void CompareTo_TermSmaller() { var right = new SchoolYearTerm("2013-2014-2"); var left = new SchoolYearTerm("2013-2014-1"); Assert.AreEqual(-1, left.CompareTo(right)); }
public void ObjectCompareTo_YearSmaller() { var right = new SchoolYearTerm("2013-2014-1"); var left = new SchoolYearTerm("2012-2013-2"); Assert.AreEqual(-1, left.CompareTo(right as object)); }
public void ObjectCompareTo_RightNotInitialized() { var left = new SchoolYearTerm("2013-2014-2"); SchoolYearTerm right = new SchoolYearTerm(); left.CompareTo(right as object); }
public void ObjectCompartTo_YearGreater() { var right = new SchoolYearTerm("2013-2014-1"); var left = new SchoolYearTerm("2014-2015-2"); Assert.AreEqual(1, left.CompareTo(right as object)); }
public IEnumerable <string> GetPressByBookseller(string term, string booksellerId) { //学期 var yearTerm = new SchoolYearTerm(term); //书商ID var id = booksellerId.ConvertToGuid(); //取订单 var subscriptions = _subscriptionRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Bookseller_Id == id && t.SubscriptionState != FeedbackState.未征订 ); //取出版社 var press = subscriptions.Select(t => t.Textbook.Press).Distinct().OrderBy(t => t).ToList(); //检查 if (press.Count == 0) { press = new List <string> { "没有订单" }; } return(press); }
public static async Task <List <SchoolYearTerm> > GetSchoolYearsTermsAsync(int schoolyearid) { List <SchoolYearTerm> lstResults = new List <SchoolYearTerm>(); await Task.Run(() => { using (var db = new dbSchoolAttendanceEntities()) { var dbresult = (from t in db.tblSchoolYearTerm.Where(trm => trm.SchoolYearID == schoolyearid) select t).ToList(); if (dbresult.Count > 0) { foreach (var term in dbresult) { SchoolYearTerm exSchoolYearTerm = new SchoolYearTerm(); exSchoolYearTerm.ID = term.ID; exSchoolYearTerm.SchoolYearID = Convert.ToInt32(term.SchoolYearID); exSchoolYearTerm.Description = term.Description; exSchoolYearTerm.AttendanceDaysRequire = Convert.ToDecimal(term.AttendanceDaysRequirement); exSchoolYearTerm.StartOfTerm = Convert.ToDateTime(term.StartOfTerm); exSchoolYearTerm.StartOfHalfTerm = Convert.ToDateTime(term.StartOfHalfTerm); exSchoolYearTerm.EndOfHalfTerm = Convert.ToDateTime(term.EndOfHalfTerm); exSchoolYearTerm.EndOfTerm = Convert.ToDateTime(term.EndOfTerm); exSchoolYearTerm.StartOfTerm = Convert.ToDateTime(term.StartOfTerm); exSchoolYearTerm.Notes = term.Notes; lstResults.Add(exSchoolYearTerm); } } } }); return(lstResults); }
/// <summary> /// 取学生用书申报 /// </summary> /// <param name="courId">课程ID</param> /// <param name="depaId">部门ID</param> /// <param name="term">学年学期</param> /// <returns></returns> private List <DeclarationJiaoWu> GetStudentDeclarations(Guid courId, Guid depaId, string term) { var yearTerm = new SchoolYearTerm(term); var declarations = _studentRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Course_Id == courId && t.Department_Id == depaId ); return(declarations.Cast <DeclarationJiaoWu>().ToList()); }
/// <summary> /// 根据回告状态,取订单 /// </summary> /// <param name="term"></param> /// <param name="booksellerId"></param> /// <param name="state"></param> /// <returns></returns> private IEnumerable <Subscription> GetSubscriptionByState(string term, Guid booksellerId, FeedbackState state) { var yearTerm = new SchoolYearTerm(term); return(_subscriptionRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Bookseller_Id == booksellerId && //t.Feedback.FeedbackState == state t.SubscriptionState == state )); }
/// <summary> /// 创建订单 /// </summary> /// <param name="subscriptionId"></param> /// <param name="textbookId"></param> /// <param name="booksellerId"></param> /// <param name="declarations"></param> /// <param name="planCount"></param> /// <param name="spareCount"></param> /// <returns></returns> public static Subscription CreateSubscription(Guid subscriptionId, Guid textbookId, Guid booksellerId, SchoolYearTerm term, int planCount, int spareCount) { var sub = new Subscription { Bookseller_Id = booksellerId, PlanCount = planCount, SpareCount = spareCount, SubscriptionDate = DateTime.Now, ID = subscriptionId, Textbook_Id = textbookId, SchoolYearTerm = term }; return sub; }
/// <summary> /// 根据学年学期,书商,专业班级取书商班级教材费用 /// </summary> /// <param name="term"></param> /// <param name="booksellerId"></param> /// <param name="classId"></param> /// <returns></returns> public IEnumerable <TextbookFeeForBooksellerProfessionClassView> GetBooksellerProfessionalClassFee(string term, string booksellerId, string classId) { var booksellerid = booksellerId.ConvertToGuid(); var classid = classId.ConvertToGuid(); var yearTerm = new SchoolYearTerm(term); //var fee = from p in _studentRecordRepo.GetAll() // where // p.Bookseller_Id == booksellerId.ConvertToGuid() && p.Class_Id == classId.ConvertToGuid() && // p.Term == term // group p by p.Textbook_Id // into s // select new // { // name = s.Key, // count = s.Sum(a => a.ReleaseCount) // }; var booksellerFee = _studentRecordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Bookseller_Id == booksellerid && t.Class_Id == classid ).GroupBy(t => new { t.Textbook_Id, t.Name, t.Isbn, t.Author, t.Press, t.Price, t.Discount }).Select(d => new TextbookFeeForBooksellerProfessionClassView { TextbookId = d.Key.Textbook_Id.ToString(), TextbookName = d.Key.Name, Isbn = d.Key.Isbn, Author = d.Key.Author, Press = d.Key.Press, RetailPrice = d.Key.Price.ToString(), Discount = d.Key.Discount.ToString(), ReleaseCount = d.Sum(t => t.ReleaseCount).ToString(), TotalRetailPrice = d.Sum(t => t.ReleaseCount * t.Price).ToString(), DiscountTotalPrice = d.Sum(t => t.Discount * t.Price).ToString() }); return(booksellerFee); }
public IEnumerable <SubscriptionForFeedbackView> GetSubscriptions(string term, string booksellerId, string press) { //学期 var yearTerm = new SchoolYearTerm(term); //书商ID var id = booksellerId.ConvertToGuid(); //取订单 var subscriptions = _subscriptionRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Bookseller_Id == id && t.Textbook.Press == press ); //按教材名称排序 subscriptions = subscriptions.OrderBy(t => t.Textbook.Name); var result = _adapter.Adapt <SubscriptionForFeedbackView>(subscriptions); return(result); }
public IEnumerable <SubscriptionForFeedbackView> GetSubscriptionWithNotFeedback(string term, string loginName) { //取当前用户的书商ID //var id = new TbmisUserAppl(loginName).GetUser().SchoolId; var id = "60D6E947-EC9C-4A0A-AEA6-26673C046B3C".ConvertToGuid(); //学期 var yearTerm = new SchoolYearTerm(term); //var subscriptions = _subscriptionRepo.Find(t => // t.SchoolYearTerm.Year == yearTerm.Year && //当前学期 // t.SchoolYearTerm.Term == yearTerm.Term && // t.Bookseller_Id == id &&//书商 // t.SubscriptionState == FeedbackState.征订中 // ).Where(t => // !t.Feedback_Id.HasValue // ); //未回告; var subscriptions = GetSubscriptionByState(term, id, FeedbackState.征订中).Where(t => !t.Feedback_Id.HasValue); return(_adapter.Adapt <SubscriptionForFeedbackView>(subscriptions)); }
/// <summary> /// 由系教研室ID与学期 /// 取课程 /// </summary> /// <param name="departmentId"></param> /// <param name="term"></param> /// <returns></returns> public IEnumerable <Course> GetCourseByDepartmentId(Guid departmentId, string term) { var currentTerm = new SchoolYearTerm(term); //处理学期,为空则取当前学期 if (string.IsNullOrWhiteSpace(term)) { var yearTerm = new TermAppl().GetCurrentTerm().YearTerm; currentTerm = new SchoolYearTerm(yearTerm); } //构造学年学期,与教务匹配 var courses = _teachingTaskRepo.Find(t => t.SchoolYearTerm.Year == currentTerm.Year && t.SchoolYearTerm.Term == currentTerm.Term && t.Department_Id == departmentId ).Select(t => t.Course ).Distinct(); return(courses); }
/// <summary> /// 由系教研室ID与学期 /// 取课程 /// </summary> /// <param name="departmentId"></param> /// <param name="term"></param> /// <returns></returns> public IEnumerable<Course> GetCourseByDepartmentId(Guid departmentId, string term) { var currentTerm = new SchoolYearTerm(term); //处理学期,为空则取当前学期 if (string.IsNullOrWhiteSpace(term)) { var yearTerm = new TermAppl().GetCurrentTerm().YearTerm; currentTerm = new SchoolYearTerm(yearTerm); } //构造学年学期,与教务匹配 var courses = _teachingTaskRepo.Find(t => t.SchoolYearTerm.Year == currentTerm.Year && t.SchoolYearTerm.Term == currentTerm.Term && t.Department_Id == departmentId ).Select(t => t.Course ).Distinct(); return courses; }
/// <summary> /// 根据学年学期,专业班级取班级教材费用 /// </summary> /// <param name="term"></param> /// <param name="classId"></param> /// <returns></returns> public IEnumerable <TextbookFeeForProfessionalClassView> GetProfessionalClassFee(string term, string classId) { var classid = classId.ConvertToGuid(); var yearTerm = new SchoolYearTerm(term); var classFee = _studentRecordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Class_Id == classid ).GroupBy(t => new { t.StudentNum, t.StudentName }).Select(d => new TextbookFeeForProfessionalClassView() { StudentNum = d.Key.StudentNum, StudentName = d.Key.StudentName, TotalCount = d.Sum(t => t.ReleaseCount).ToString(), TotalRetailPrice = d.Sum(t => t.Price).ToString(), DiscountTotalPrice = d.Sum(t => t.DiscountPrice).ToString() }); return(classFee); }
/// <summary> /// 取学年学期未征订的教师用书申报 /// </summary> /// <param name="term"></param> /// <returns></returns> public List <TeacherDeclarationJiaoWu> GetNotSubscriptionTeacherDeclarationJiaoWu(string term) { //学年学期 var yearTerm = new SchoolYearTerm(term); //是否归档等于4 var query = _teaDeclJiaoWuRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Sfgd == "4" //0申报中,1学院审核中,2教材科审核中,3教务处审核中,4审核完成,A学院审核未通过,B教学建设科审核未通过,C教务处审核未通过 ); //已征订 var decl = _teaDeclRepo.Find(t => t.DeclarationJiaoWu.SchoolYearTerm.Year == yearTerm.Year && t.DeclarationJiaoWu.SchoolYearTerm.Term == yearTerm.Term ).Select(t => t.ID); //未征订 var result = from d in query where !decl.Contains(d.ID) select d; return(result.ToList()); }
/// <summary> /// 根据学年学期,班级查询班级实发教材 /// </summary> /// <param name="term"></param> /// <param name="classId"></param> /// <returns></returns> public IEnumerable <ClassReleaseDetailView> GetClassReleaseDetail(string term, string classId) { var classid = classId.ConvertToGuid(); var yearTerm = new SchoolYearTerm(term); var classRecord = _recordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Class_Id == classid ).GroupBy(t => new { t.SchoolYearTerm, t.SchoolName, t.ClassName, t.BooksellerName, t.Textbook_Id, t.Name, t.Isbn, t.Press } ).Select(d => new ClassReleaseDetailView() { Term = d.Key.SchoolYearTerm.ToString(), SchoolName = d.Key.SchoolName, BooksellerName = d.Key.BooksellerName, TextbookId = d.Key.Textbook_Id.ToString(), TextbookName = d.Key.Name, Isbn = d.Key.Isbn, Press = d.Key.Press, ReleaseCount = d.Sum(p => p.ReleaseCount).ToString() } ); return(classRecord); }
/// <summary> /// 取学年学期未征订的学生用书申报 /// </summary> /// <param name="term"></param> /// <returns></returns> public List <StudentDeclarationJiaoWu> GetNotSubscriptionStudentDeclarationJiaoWu(string term) { //学年学期 var yearTerm = new SchoolYearTerm(term); var context1 = _stuDeclJiaoWuRepo.Context; var context2 = _stuDeclRepo.Context; //是否归档等于0 var query = _stuDeclJiaoWuRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Sfgd == "0" //0确认征订教材,2确认不要教材,1确认取消教材 ); //已征订 var decl = _stuDeclRepo.Find(t => t.DeclarationJiaoWu.SchoolYearTerm.Year == yearTerm.Year && t.DeclarationJiaoWu.SchoolYearTerm.Term == yearTerm.Term ).Select(d => d.ID); //未征订 var result = from d in query where !decl.Contains(d.ID) select d; return(result.ToList()); }
public IEnumerable<SubscriptionForFeedbackView> GetSubscriptions(string term, string booksellerId, string press) { //学期 var yearTerm = new SchoolYearTerm(term); //书商ID var id = booksellerId.ConvertToGuid(); //取订单 var subscriptions = _subscriptionRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Bookseller_Id == id && t.Textbook.Press == press ); //按教材名称排序 subscriptions = subscriptions.OrderBy(t => t.Textbook.Name ); var result = _adapter.Adapt<SubscriptionForFeedbackView>(subscriptions); return result; }
public IEnumerable<string> GetPressByBookseller(string term, string booksellerId) { //学期 var yearTerm = new SchoolYearTerm(term); //书商ID var id = booksellerId.ConvertToGuid(); //取订单 var subscriptions = _subscriptionRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Bookseller_Id == id && t.SubscriptionState != FeedbackState.未征订 ); //取出版社 var press = subscriptions.Select(t => t.Textbook.Press).Distinct().OrderBy(t => t).ToList(); //检查 if (press.Count == 0) { press = new List<string> { "没有订单" }; } return press; }
public void CompareTo_YearSmaller() { var right = new SchoolYearTerm("2013-2014-1"); var left = new SchoolYearTerm("2012-2013-2"); Assert.AreEqual(-1, left.CompareTo(right)); }
/// <summary> /// 根据学年学期,学生取学生个人教材费用 /// </summary> /// <param name="term"></param> /// <param name="studentName"></param> /// <returns></returns> public IEnumerable<TextbookFeeForStudentView> GetStudentFee(string term, string studentNum) { var yearTerm = new SchoolYearTerm(term); var studentFee = _studentRecordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.StudentNum == studentNum ).GroupBy(t => new { t.Textbook_Id, t.Name, t.Isbn, t.Author, t.Press, t.Price, t.Discount }).Select(d => new TextbookFeeForStudentView() { TextbookId = d.Key.Textbook_Id.ToString(), TextbookName = d.Key.Name, Isbn = d.Key.Isbn, Author = d.Key.Author, Press = d.Key.Press, RetailPrice = d.Key.Price.ToString(), Discount = d.Key.Discount.ToString(), ReleaseCount = d.Sum(t => t.ReleaseCount).ToString(), DiscountPrice = d.Sum(t => t.DiscountPrice).ToString() }); return studentFee; }
/// <summary> /// 根据学年学期,书商,专业班级取书商班级教材费用 /// </summary> /// <param name="term"></param> /// <param name="booksellerId"></param> /// <param name="classId"></param> /// <returns></returns> public IEnumerable<TextbookFeeForBooksellerProfessionClassView> GetBooksellerProfessionalClassFee(string term, string booksellerId, string classId) { var booksellerid = booksellerId.ConvertToGuid(); var classid = classId.ConvertToGuid(); var yearTerm = new SchoolYearTerm(term); //var fee = from p in _studentRecordRepo.GetAll() // where // p.Bookseller_Id == booksellerId.ConvertToGuid() && p.Class_Id == classId.ConvertToGuid() && // p.Term == term // group p by p.Textbook_Id // into s // select new // { // name = s.Key, // count = s.Sum(a => a.ReleaseCount) // }; var booksellerFee = _studentRecordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Bookseller_Id == booksellerid && t.Class_Id == classid ).GroupBy(t => new { t.Textbook_Id, t.Name, t.Isbn, t.Author, t.Press, t.Price, t.Discount }).Select(d => new TextbookFeeForBooksellerProfessionClassView { TextbookId = d.Key.Textbook_Id.ToString(), TextbookName = d.Key.Name, Isbn = d.Key.Isbn, Author = d.Key.Author, Press = d.Key.Press, RetailPrice = d.Key.Price.ToString(), Discount = d.Key.Discount.ToString(), ReleaseCount = d.Sum(t => t.ReleaseCount).ToString(), TotalRetailPrice = d.Sum(t => t.ReleaseCount * t.Price).ToString(), DiscountTotalPrice = d.Sum(t => t.Discount * t.Price).ToString() }); return booksellerFee; }
public IEnumerable<SubscriptionForFeedbackView> GetSubscriptionWithNotFeedback(string term, string loginName) { //取当前用户的书商ID //var id = new TbmisUserAppl(loginName).GetUser().SchoolId; var id = "60D6E947-EC9C-4A0A-AEA6-26673C046B3C".ConvertToGuid(); //学期 var yearTerm = new SchoolYearTerm(term); //var subscriptions = _subscriptionRepo.Find(t => // t.SchoolYearTerm.Year == yearTerm.Year && //当前学期 // t.SchoolYearTerm.Term == yearTerm.Term && // t.Bookseller_Id == id &&//书商 // t.SubscriptionState == FeedbackState.征订中 // ).Where(t => // !t.Feedback_Id.HasValue // ); //未回告; var subscriptions = GetSubscriptionByState(term, id, FeedbackState.征订中).Where(t => !t.Feedback_Id.HasValue); return _adapter.Adapt<SubscriptionForFeedbackView>(subscriptions); }
/// <summary> /// 取教师用书申报 /// </summary> /// <param name="courId">课程ID</param> /// <param name="depaId">部门ID</param> /// <param name="term">学年学期</param> /// <returns></returns> private List<DeclarationJiaoWu> GetTeacherDeclarations(Guid courId, Guid depaId, string term) { var yearTerm = new SchoolYearTerm(term); var declarations = _teacherRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Course_Id == courId && t.Department_Id == depaId ); return declarations.Cast<DeclarationJiaoWu>().ToList(); }
public void ObjectCompareTo_TermSmaller() { var right = new SchoolYearTerm("2013-2014-2"); var left = new SchoolYearTerm("2013-2014-1"); Assert.AreEqual(-1, left.CompareTo(right as object)); }
public void ObjectCompareTo_RightIsNull() { var left = new SchoolYearTerm("2013-2014-2"); SchoolYearTerm right = null; left.CompareTo(right as object); }
public void CompartTo_YearGreater() { var right = new SchoolYearTerm("2013-2014-1"); var left = new SchoolYearTerm("2014-2015-2"); Assert.AreEqual(1, left.CompareTo(right)); }
public System.Collections.Generic.IEnumerable <Subscription> GetSubscriptions(System.Guid booksellerId, SchoolYearTerm schoolYearTerm) { var ctx = this.EFContext.Context as TbMisDbContext; if (ctx != null) { var results = ctx.Subscriptions.Where(t => t.SchoolYearTerm.Year == schoolYearTerm.Year && t.SchoolYearTerm.Term == schoolYearTerm.Term && t.Bookseller_Id == booksellerId ); return(results.ToList()); } return(new List <Subscription>()); }
/// <summary> /// 根据回告状态,取订单 /// </summary> /// <param name="term"></param> /// <param name="booksellerId"></param> /// <param name="state"></param> /// <returns></returns> private IEnumerable<Subscription> GetSubscriptionByState(string term, Guid booksellerId, FeedbackState state) { var yearTerm = new SchoolYearTerm(term); return _subscriptionRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Bookseller_Id == booksellerId && //t.Feedback.FeedbackState == state t.SubscriptionState == state ); }
/// <summary> /// 根据学年学期,专业班级取班级教材费用 /// </summary> /// <param name="term"></param> /// <param name="classId"></param> /// <returns></returns> public IEnumerable<TextbookFeeForProfessionalClassView> GetProfessionalClassFee(string term, string classId) { var classid = classId.ConvertToGuid(); var yearTerm = new SchoolYearTerm(term); var classFee = _studentRecordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Class_Id == classid ).GroupBy(t => new { t.StudentNum, t.StudentName }).Select(d => new TextbookFeeForProfessionalClassView() { StudentNum = d.Key.StudentNum, StudentName = d.Key.StudentName, TotalCount = d.Sum(t => t.ReleaseCount).ToString(), TotalRetailPrice = d.Sum(t => t.Price).ToString(), DiscountTotalPrice = d.Sum(t => t.DiscountPrice).ToString() }); return classFee; }
/// <summary> /// 取学年学期未征订的教师用书申报 /// </summary> /// <param name="term"></param> /// <returns></returns> public List<TeacherDeclarationJiaoWu> GetNotSubscriptionTeacherDeclarationJiaoWu(string term) { //学年学期 var yearTerm = new SchoolYearTerm(term); //是否归档等于4 var query = _teaDeclJiaoWuRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Sfgd == "4" //0申报中,1学院审核中,2教材科审核中,3教务处审核中,4审核完成,A学院审核未通过,B教学建设科审核未通过,C教务处审核未通过 ); //已征订 var decl = _teaDeclRepo.Find(t => t.DeclarationJiaoWu.SchoolYearTerm.Year == yearTerm.Year && t.DeclarationJiaoWu.SchoolYearTerm.Term == yearTerm.Term ).Select(t => t.ID); //未征订 var result = from d in query where !decl.Contains(d.ID) select d; return result.ToList(); }
/// <summary> /// 取学年学期未征订的学生用书申报 /// </summary> /// <param name="term"></param> /// <returns></returns> public List<StudentDeclarationJiaoWu> GetNotSubscriptionStudentDeclarationJiaoWu(string term) { //学年学期 var yearTerm = new SchoolYearTerm(term); var context1 = _stuDeclJiaoWuRepo.Context; var context2 = _stuDeclRepo.Context; //是否归档等于0 var query = _stuDeclJiaoWuRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Sfgd == "0" //0确认征订教材,2确认不要教材,1确认取消教材 ); //已征订 var decl = _stuDeclRepo.Find(t => t.DeclarationJiaoWu.SchoolYearTerm.Year == yearTerm.Year && t.DeclarationJiaoWu.SchoolYearTerm.Term == yearTerm.Term ).Select(d => d.ID); //未征订 var result = from d in query where !decl.Contains(d.ID) select d; return result.ToList(); }
/// <summary> /// 根据学年学期,班级查询班级实发教材 /// </summary> /// <param name="term"></param> /// <param name="classId"></param> /// <returns></returns> public IEnumerable<ClassReleaseDetailView> GetClassReleaseDetail(string term, string classId) { var classid = classId.ConvertToGuid(); var yearTerm = new SchoolYearTerm(term); var classRecord = _recordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Class_Id == classid ).GroupBy(t => new { t.SchoolYearTerm, t.SchoolName, t.ClassName, t.BooksellerName, t.Textbook_Id, t.Name, t.Isbn, t.Press } ).Select(d => new ClassReleaseDetailView() { Term = d.Key.SchoolYearTerm.ToString(), SchoolName = d.Key.SchoolName, BooksellerName = d.Key.BooksellerName, TextbookId = d.Key.Textbook_Id.ToString(), TextbookName = d.Key.Name, Isbn = d.Key.Isbn, Press = d.Key.Press, ReleaseCount = d.Sum(p => p.ReleaseCount).ToString() } ); return classRecord; }
/// <summary> /// 根据学年学期,学生查询学生实发教材 /// </summary> /// <param name="term"></param> /// <param name="studentId"></param> /// <returns></returns> public IEnumerable<StudentReleaseDetailView> GetStudentReleaseDetail(string term, string studentId) { var studentid = studentId.ConvertToGuid(); var yearTerm = new SchoolYearTerm(term); var studentRecord = _recordRepo.Find(t => t.SchoolYearTerm.Year == yearTerm.Year && t.SchoolYearTerm.Term == yearTerm.Term && t.Student_Id == studentid ).Select(p => new StudentReleaseDetailView() { TextbookId = p.Textbook_Id.ToString(), TextbookName = p.Name, RetailPrice = p.Price.ToString(), DiscountPrice = p.DiscountPrice.ToString(), Term = p.SchoolYearTerm.ToString(), SchoolName = p.SchoolName, ClassName = p.ClassName, StudentNum = p.StudentNum, ReleaseCount = p.ReleaseCount.ToString(), Recipient = p.Recipient1Name, Telephone = p.Recipient1Phone, RecipientDate = p.ReleaseDate.ToString() }); return _adapter.Adapt<StudentReleaseDetailView>(studentRecord); }