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, "柳州市第二职业技术学校教师图书借阅登记表", "教师图书借阅登记表");
}
