/// <summary>
/// 创建学生
/// </summary>
/// <param name="name"></param>
/// <param name="ClassName"></param>
/// <param name="GradeName"></param>
/// <param name="phoneNum"></param>
/// <param name="image"></param>
/// <returns></returns>
public static async Task CreatStudentAsync(int Id, string name, string ClassName, string GradeName, string DeviceSerial, string StudentID = null, string caller = null, string phoneNum = null, string image = null)
{
try {
using (DAL.StudentService stuSvc = new DAL.StudentService()) {
var Grad = GradeManager.QueryGrad(GradeName);
var Classes = ClassManager.QueryClass(ClassName);
foreach (var item in Classes)
{
if (item.GradeID == Grad.Id)
{
await stuSvc.CreatAsync(new Student()
{
Id = Id, Name = name, PhoneNum = phoneNum, Image = image, ClassId = item.Id, ClassName = ClassName, GradeName = GradeName, StudentID = StudentID, DeviceSerial = DeviceSerial
}, true);
}
else
{
continue;
}
}
}
}
catch (Exception ex) {
throw new Exception(ex.Message);
}
}
/// <summary>
/// 分页搜索查询学生对象
/// </summary>
/// <param name="SchoolID">学生所属的学校id</param>
/// <param name="PageSize">一页的数量</param>
/// <param name="PageIndex">页码</param>
/// <param name="Name">学生名字</param>
/// <returns></returns>
public static StudentDTO QueryCount(int SchoolID, int PageSize, int PageIndex, string Name = null)
{
#region 函数注释
/*
* 这个函数在做的事情：查询学生对象，分页是必须的，可以加名字搜索
* 1.通过学校id获取这个学校所有的班
* 2.定义一个count用于存放总学生的数量，arrlist暂存器，StudentDTO要返回的数据类
* 4.遍历所有的班级,定义一个temp临时存放学生对象的数组
* 3.判断要不要搜索名字
* 5.第一层循环过后temp里面装的是一个班的学生
* 6.因为没办法将数组合并只好再次遍历学生数组，再一一添加至arraylist
* 7.合计学生总数量（每个班级都有一个学生数量）
* 8.arrayList分页
* 还需：学生Model里面添加班级名和年级名字段
*/
#endregion
using (DAL.StudentService student = new DAL.StudentService()) {
var result = ClassManager.QueryClassList(SchoolID);
int count = 0;
ArrayList arrayList = new ArrayList();
StudentDTO dTO = new StudentDTO();
foreach (var item in result)
{
List <Student> temp;
if (Name != null)
{
temp = student.GetAll(m => m.ClassId == item.Id && m.IsDelete == false && m.Name == Name, true).ToList();//获取学生列表，temp是一个数组
}
else
{
temp = student.GetAll(m => m.ClassId == item.Id && m.IsDelete == false, true).ToList(); //获取学生列表，temp是一个数组
}
foreach (var students in temp) //
{
students.ClassName = item.Name;
students.GradeName = item.GradeName;
arrayList.Add(students);
}
count += item.StudentCount;
}
dTO.arr = arrayList.ToArray().Skip(PageIndex * PageSize).Take(PageSize).ToArray();
dTO.count = count;
return(dTO);
}
}
public async Task AddStudents(string departmentId, string classId, string stuId, string stuName, string gender, string telephone, string IDNumber, string pwd, string major)
{
using (IDAL.IStudentService Svc = new DAL.StudentService())
{
await Svc.CreateAsync(new Student()
{
DepartmentId = departmentId,
ClassId = classId,
StuId = stuId,
StuName = stuName,
Gender = gender,
Telephone = telephone,
IDNumber = IDNumber,
Pwd = pwd,
Major = major,
ModifyTime = DateTime.Now
});
}
}
public async Task ChangePwd(string userId, int identity, string oldPwd, string newPwd)
{
if (identity == 0)
{
using (IDAL.IStudentService userSvc = new DAL.StudentService())
{
if (await userSvc.GetAllAsync().AnyAsync(m => m.StuId == userId && m.Pwd == oldPwd))
{
var user = await userSvc.GetAllAsync().FirstAsync(m => m.StuId == userId);
user.Pwd = newPwd;
await userSvc.EditAsync(user);
}
}
}
else if (identity == 1)
{
using (IDAL.ITeacherService userSvc = new DAL.TeacherService())
{
if (await userSvc.GetAllAsync().AnyAsync(m => m.TeaId == userId && m.Pwd == oldPwd))
{
var user = await userSvc.GetAllAsync().FirstAsync(m => m.TeaId == userId);
user.Pwd = newPwd;
await userSvc.EditAsync(user);
}
}
}
else if (identity == 2)
{
using (IDAL.IAdminService userSvc = new DAL.AdminService())
{
if (await userSvc.GetAllAsync().AnyAsync(m => m.AdminId == userId && m.Pwd == oldPwd))
{
var user = await userSvc.GetAllAsync().FirstAsync(m => m.AdminId == userId);
user.Pwd = newPwd;
await userSvc.EditAsync(user);
}
}
}
}
/// <summary>
/// 获取学生的数量
/// </summary>
/// <param name="ClassID"></param>
/// <returns></returns>
public static int QueryStudentCount(int ClassID)
{
using (DAL.StudentService student = new DAL.StudentService()) {
return(student.GetAll(m => m.ClassId == ClassID && m.IsDelete == false).Count());
}
}
public int Login(string userId, string pwd, string identity, out Guid id)
{
if (identity == "0") //学生
{
using (IDAL.IStudentService userSvc = new DAL.StudentService())
{
var user = userSvc.GetAllAsync().FirstOrDefaultAsync(m => m.StuId == userId && m.Pwd == pwd);
user.Wait();
var data = user.Result;
if (data == null)
{
id = new Guid();
return(-1);
}
else
{
id = data.Id;
return(0);
}
}
}
else if (identity == "1") //教师
{
using (IDAL.ITeacherService userSvc = new DAL.TeacherService())
{
var user = userSvc.GetAllAsync().FirstOrDefaultAsync(m => m.TeaId == userId && m.Pwd == pwd);
user.Wait();
var data = user.Result;
if (data == null)
{
id = new Guid();
return(-1);
}
else
{
id = data.Id;
return(1);
}
}
}
else if (identity == "2") //管理员
{
using (IDAL.IAdminService userSvc = new DAL.AdminService())
{
var user = userSvc.GetAllAsync().FirstOrDefaultAsync(m => m.AdminId == userId && m.Pwd == pwd);
user.Wait();
var data = user.Result;
if (data == null)
{
id = new Guid();
return(-1);
}
else
{
id = data.Id;
return(2);
}
}
}
id = new Guid();
return(-1);
}
public async Task <Dto.UserInfoDto> GetUserByUserId(string userId, int identity)
{
if (identity == 0)
{
using (IDAL.IStudentService userSvc = new DAL.StudentService())
{
if (await userSvc.GetAllAsync().AnyAsync(m => m.StuId == userId))
{
return(await userSvc.GetAllAsync().Where(m => m.StuId == userId).Select(m =>
new Dto.UserInfoDto()
{
Id = m.Id,
UserId = m.StuId,
Identity = identity,
Gender = m.Gender,
IDNumber = m.IDNumber
}).FirstAsync());
}
}
}
else if (identity == 1)
{
using (IDAL.ITeacherService userSvc = new DAL.TeacherService())
{
if (await userSvc.GetAllAsync().AnyAsync(m => m.TeaId == userId))
{
return(await userSvc.GetAllAsync().Where(m => m.TeaId == userId).Select(m =>
new Dto.UserInfoDto()
{
Id = m.Id,
UserId = m.TeaId,
Identity = identity,
Gender = m.Gender,
IDNumber = m.IDNumber
}).FirstAsync());
}
}
}
else if (identity == 2)
{
using (IDAL.IAdminService userSvc = new DAL.AdminService())
{
if (await userSvc.GetAllAsync().AnyAsync(m => m.AdminId == userId))
{
return(await userSvc.GetAllAsync().Where(m => m.AdminId == userId).Select(m =>
new Dto.UserInfoDto()
{
Id = m.Id,
UserId = m.AdminId,
Identity = identity,
Gender = m.Gender,
IDNumber = m.IDNumber
}).FirstAsync());
}
}
}
else
{
throw new ArgumentException("账号不存在");
}
return(null);
}
