public string GetStudentByName(string stuName, string schoolName)
{
var res = "";
List <SYS_School> schools = UnitOfWork.Repository <SYS_School>().GetEntitiesAsync(x => x.SchoolName.Contains(schoolName) && x.Status == 1).Result;
if (null != schools && schools.Count > 0)
{
var sb = new StringBuilder();
foreach (var item in schools)
{
List <SYS_Student> stus = UnitOfWork.Repository <SYS_Student>().GetEntitiesAsync(x => x.SchoolId == item.ID && x.StuName.Equals(stuName) && x.Status == 1).Result;
if (null != stus && stus.Count > 0)
{
foreach (var s in stus)
{
SYS_Class cls = UnitOfWork.Repository <SYS_Class>().GetEntitiesAsync(x => x.SchoolId == item.ID && x.ID == s.ClassId && x.Status == 1).Result.FirstOrDefault();
sb.Append("<tr><td><input style='left: initial; opacity: 1; position: initial;' type='checkbox' class='stuChb' stuId=" + s.ID + " schoolId=" + s.SchoolId + " /></td>");
sb.Append("<td>" + s.StuName + "</td>");
sb.Append("<td>" + (cls == null?"未分班级":cls.ClassName) + "</td>");
sb.Append("<td>" + s.Phone.Substring(7) + "</td></tr>");
}
}
}
res = sb.ToString();
}
return(res);
}
/// <summary>
/// 新增或修改班级(type->1:新增,2:修改)
/// </summary>
public int AddOrModifyClass(byte type, string entity)
{
var res = 0;
if (entity.Length > 6)
{
List <SYS_Class> clases = (List <SYS_Class>)GetSchoolEntities("class");
SYS_Class obj = JsonHelper.JsonToT <SYS_Class>(entity);
if (null != obj)
{
if (type == 1)
{
obj.SchoolId = mlUser.School.ID;
obj.Status = 1;
obj.ClassNo = (clases.Count + 1).ToString();
UnitOfWork.Repository <SYS_Class>().AddEntity(obj);
}
else
{
UnitOfWork.Repository <SYS_Class>().UpdateEntity(obj);
}
}
res = UnitOfWork.CommitAsync().Result;
}
return(res);
}
/// <summary>
/// 通过Id删除实体
/// </summary>
public int DelClassById(long id)
{
var res = 0;
SYS_Class obj = UnitOfWork.Repository <SYS_Class>().GetEntitiesAsync(x => x.ID == id).Result.FirstOrDefault();
if (null != obj)
{
UnitOfWork.Repository <SYS_Class>().DeleteEntity(obj);
res = UnitOfWork.CommitAsync().Result;
}
return(res);
}
/// <summary>
/// 新增或修改学生(type->1:新增,2:修改)
/// </summary>
public string AddOrModifyStu(byte type, string entity)
{
var res = "操作失败";
if (entity.Length > 6)
{
List <SYS_Class> classes = (List <SYS_Class>)GetSchoolEntities("class");
SYS_Student obj = JsonHelper.JsonToTByKey <SYS_Student>(entity, "Student");
List <string> cardNos = JsonHelper.JsonToTByKey <List <string> >(entity, "Cards");
if (null != obj)
{
SYS_Class clas = classes.Where(x => x.ID == obj.ClassId).FirstOrDefault();
if (type == 1)//新增
{
obj.SchoolId = mlUser.School.ID;
obj.Status = (byte)StuStatus.正常;
obj.Grade = clas.Grade;
obj.AttStatus = (byte)CurrentAttStatus.未签到;
obj.CreateTime = DateTime.Now;
var oldStu = UnitOfWork.Repository <SYS_Student>().GetEntitiesAsync(x => x.StuName == obj.StuName && x.Phone == obj.Phone && x.SchoolId == obj.SchoolId && x.Status == (byte)StuStatus.正常).Result.FirstOrDefault();
var isOk = 0;
if (oldStu == null)
{
UnitOfWork.Repository <SYS_Student>().AddEntity(obj);
isOk = UnitOfWork.CommitAsync().Result;
if (isOk > 0)
{
res = "OK,学生添加成功";
}
}
else
{
res = "学生信息重复，无法添加\r\n";
}
//建卡
var stuOldCards = UnitOfWork.Repository <SYS_Card>().GetEntitiesAsync(x => x.CardMasterId == obj.ID && x.CardType == (byte)CardType.学生卡).Result;//该学生已有卡
if (isOk > 0 && null != cardNos && cardNos.Count > 0)
{
var repeatCardStr = "";
foreach (var cNo in cardNos)
{
if (stuOldCards.FindIndex(delegate(SYS_Card card) { return(card.CardNo == cNo); }) < 0)
{
var oldCard = UnitOfWork.Repository <SYS_Card>().GetEntitiesAsync(x => x.CardNo == cNo && x.SchoolId == mlUser.School.ID)
.Result.FirstOrDefault();
if (oldCard == null)
{
SYS_Card newCard = new SYS_Card
{
CardNo = cNo,
CardMasterId = obj.ID,
SchoolId = mlUser.School.ID,
CardType = (byte)CardType.学生卡,
Status = (byte)CardStatus.正常,
CreateTime = DateTime.Now
};
UnitOfWork.Repository <SYS_Card>().AddEntity(newCard);
isOk = UnitOfWork.CommitAsync().Result;
}
else
{
repeatCardStr += cNo + " ";
}
}
}
if (repeatCardStr.Length > 0)
{
res = "警告：学生添加成功，但是卡" + repeatCardStr + "已存在，无法添加";
}
}
}
else//修改
{
UnitOfWork.Repository <SYS_Student>().UpdateEntity(obj);
var isOk = UnitOfWork.CommitAsync().Result;
if (isOk > 0)
{
res = "OK,学生修改成功";
}
else
{
res = "学生信息修改失败\r\n";
}
///建卡
//检索该学生已有卡
var stuOldCards = UnitOfWork.Repository <SYS_Card>().GetEntitiesAsync(x => x.CardMasterId == obj.ID && x.CardType == (byte)CardType.学生卡).Result;
if (isOk > 0 && null != cardNos && cardNos.Count > 0)
{
var repeatCardStr = "";
foreach (var cNo in cardNos)
{
if (stuOldCards.FindIndex(delegate(SYS_Card card) { return(card.CardNo == cNo); }) < 0)
{
var oldCard = UnitOfWork.Repository <SYS_Card>().GetEntitiesAsync(x => x.CardNo == cNo && x.SchoolId == mlUser.School.ID && x.Status == (byte)CardStatus.正常)
.Result.FirstOrDefault();
if (oldCard == null)
{
SYS_Card newCard = new SYS_Card
{
CardNo = cNo,
CardMasterId = obj.ID,
SchoolId = mlUser.School.ID,
CardType = (byte)CardType.学生卡,
Status = (byte)CardStatus.正常,
CreateTime = DateTime.Now
};
UnitOfWork.Repository <SYS_Card>().AddEntity(newCard);
isOk = UnitOfWork.CommitAsync().Result;
}
else
{
repeatCardStr += cNo + " ";
}
}
}
if (repeatCardStr.Length > 0)
{
res = "警告：卡" + repeatCardStr + "已存在，无法添加";
}
}
}
}
}
return(res);
}
