public ExportBorrowingData() { DB dB = new DB(); Students = dB.ReadStudentData(); Books = dB.ReadBookData(); Teachers = dB.ReadTeacherData(); NoBorrowingBooks = Books; var sBorrow = StudentBorrowings.Where(x => x.ReturnDate == string.Empty).ToList(); var tBorrow = TeacherBorrowings.Where(x => x.ReturnDate == string.Empty).ToList(); foreach (var item in sBorrow) { var borrowingBook = NoBorrowingBooks.SingleOrDefault(x => x.Id == item.BookId); NoBorrowingBooks.Remove(borrowingBook); } foreach (var item in tBorrow) { var borrowingBook = NoBorrowingBooks.SingleOrDefault(x => x.Id == item.BookId); NoBorrowingBooks.Remove(borrowingBook); } }
public void ExprotTeacherBorrowing(int count, int leftday, int rightday, float leftRange, float rightRange) { var books = NoBorrowingBooks; var teachers = Teachers; var random = new Random(); for (int k = 0; k < count; k++) { var peopleNum = random.Next(Convert.ToInt32(teachers.Count * leftRange), Convert.ToInt32(teachers.Count * rightRange)); for (int j = 1; j <= peopleNum; j++) { var day = random.Next(leftday, rightday); var teacher = teachers[random.Next(teachers.Count)]; var book = books[random.Next(0, books.Count)]; books.Remove(book); var teachersBorrowing = new TeacherBorrowing { Id = j + 1, SerialNumber = "", BookId = book.Id, Author = book.Author, Category = book.Category, Department = teacher.Department, Name = teacher.Name, ISBN = book.ISBN, Price = book.Price, Version = book.Version, PublishYear = book.PublishYear, Title = book.Title, SeriesTitle = book.SeriesTitle, Remarks = "", }; var BorrowDate = DateConstraint.RandomDate(DateTime.Parse("2018-12-28"), DateTime.Parse("2019-12-31")); teachersBorrowing.SerialNumber = GenerateSerialNum(BorrowDate); teachersBorrowing.IsDiscard = "否"; //是否丢失 teachersBorrowing.IsOverdue = "否"; //是否逾期 teachersBorrowing.BorrowDate = BorrowDate.ToString("yyyy-MM-dd"); var returndate = BorrowDate.AddDays(day); if (!DateConstraint.IsValidDate(returndate)) { while (!DateConstraint.IsValidDate(returndate)) { day = random.Next(leftday, rightday); returndate = returndate.AddDays(day); } } teachersBorrowing.BorrowBookDay = day + "天"; teachersBorrowing.ReturnDate = returndate.ToString("yyyy-MM-dd"); TeacherBorrowings.Add(teachersBorrowing); } } var dt = ListToDataTable(TeacherBorrowings); dt.Columns["Department"].ColumnName = "部门"; var path = System.IO.Directory.GetCurrentDirectory(); ExportExcelFile.ExportFile($"{path}\\教师图书借阅登记表.xlsx", dt, "柳州市第二职业技术学校教师图书借阅登记表", "教师图书借阅登记表"); }