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 ExprotStudentBorrowingData(int count, int leftday, int rightday, float leftRange, float rightRange)
* {
* var books = NoBorrowingBooks;
* var students = Students;
* var random = new Random();
*
* for (var i = 0; i < count; i++)
* {
* var day = random.Next(leftday, rightday);
* var studentRange = GetRandomNumber(leftRange, rightRange, 2);
* var studentIndex = Convert.ToInt32(studentRange * Students.Count);
* var student = students[studentIndex];
* var book = books[random.Next(0, books.Count)];
* books.Remove(book);
* var studentBorrowing = new StudentBorrowing
* {
* Id = i + 1,
* SerialNumber = "",
* BookId = book.Id,
* Author = book.Author,
* Category = book.Category,
* Class = student.Class,
* Name = student.Name,
* ISBN = book.ISBN,
* Price = book.Price,
* Version = book.Version,
* PublishYear = book.PublishYear,
* Title = book.Title,
* SeriesTitle = book.SeriesTitle,
* Remarks = "",
*
* };
* studentBorrowing.IsDiscard = "否";//是否丢失
* studentBorrowing.IsOverdue = "否";//是否逾期
*
*
*
* var BorrowDate = DateConstraint.RandomDate(DateTime.Parse("2018-12-28"), DateTime.Parse("2019-12-31"));
* studentBorrowing.SerialNumber = GenerateSerialNum(BorrowDate);
* //var str = studentBorrowing.SerialNumber.ToString("yyyy-MM-dd hh:mm:ss");
*
* studentBorrowing.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);
* }
* }
* studentBorrowing.BorrowBookDay = day + "天";
* studentBorrowing.ReturnDate = returndate.ToString("yyyy-MM-dd");
*
*
* StudentBorrowings.Add(studentBorrowing);
*
* }
* var dt = ListToDataTable(StudentBorrowings);
* dt.Columns["Class"].ColumnName = "班级班级（专业-年级-班）";
* var path = System.IO.Directory.GetCurrentDirectory();
* ExportExcelFile.ExportFile($"{path}\\学生图书借阅登记表.xlsx", dt, "柳州市第二职业技术学校学生图书借阅登记表", "学生图书借阅登记表");
* }*/
public void ExprotStudentBorrowingData(int count, int leftday, int rightday, float leftRange, float rightRange)
{
var books = NoBorrowingBooks;
var students = Students;
var random = new Random();
var student = new Student();
// 确认范围人数
var peopleNum = random.Next(Convert.ToInt32(students.Count * leftRange), Convert.ToInt32(students.Count * rightRange));
count = count < peopleNum ? peopleNum : count;
for (int i = 0; i < (count / peopleNum) + 1; i++)
{
for (int j = 1; j <= peopleNum; j++)
{
student = students[random.Next(students.Count)];
var day = random.Next(leftday, rightday);
var book = books[random.Next(0, books.Count)];
books.Remove(book);
var studentBorrowing = new StudentBorrowing
{
Id = j + 1,
SerialNumber = "",
BookId = book.Id,
Author = book.Author,
Category = book.Category,
Class = student.Class,
Name = student.Name,
ISBN = book.ISBN,
Price = book.Price,
Version = book.Version,
PublishYear = book.PublishYear,
Title = book.Title,
SeriesTitle = book.SeriesTitle,
Remarks = "",
};
studentBorrowing.IsDiscard = "否"; //是否丢失
studentBorrowing.IsOverdue = "否"; //是否逾期
var BorrowDate = DateConstraint.RandomDate(DateTime.Parse("2018-12-28"), DateTime.Parse("2019-12-31"));
studentBorrowing.SerialNumber = GenerateSerialNum(BorrowDate);
//var str = studentBorrowing.SerialNumber.ToString("yyyy-MM-dd hh:mm:ss");
studentBorrowing.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);
}
}
studentBorrowing.BorrowBookDay = day + "天";
studentBorrowing.ReturnDate = returndate.ToString("yyyy-MM-dd");
StudentBorrowings.Add(studentBorrowing);
}
}
var dt = ListToDataTable(StudentBorrowings);
dt.Columns["Class"].ColumnName = "班级班级（专业-年级-班）";
var path = System.IO.Directory.GetCurrentDirectory();
ExportExcelFile.ExportFile($"{path}\\学生图书借阅登记表.xlsx", dt, "柳州市第二职业技术学校学生图书借阅登记表", "学生图书借阅登记表");
}
