public int PatchRecoveryStuInfo(List <Guid> stuids) { using (var db = new sim.StuInfoEntities()) { return(db.StuInfo.Where(c => stuids.Contains(c.StuID)).Update(c => new sim.StuInfo { IsState = 1 })); } }
public bool DeleteStuInfo(Guid stuid) { using (var db = new sim.StuInfoEntities()) { sim.StuInfo si = GetStuInfo(stuid); si.IsState = 0; return(ModifyStuInfo(si)); } }
public bool RecoveryStuInfo(Guid stuid) { using (var db = new sim.StuInfoEntities()) { sim.StuInfo si = GetStuInfo(stuid, false); si.IsState = 1; return(ModifyStuInfo(si)); } }
public int GetStuCount(Guid schid, Guid bjid, string stunumber, string stucode, string stuidentity, string stuname, bool bstate = true) { using (var db = new sim.StuInfoEntities()) { if (bstate) { return(db.vwStuInfo.Count(si => si.StuID_SchID == schid && si.StuID_BJID == bjid && si.IsState == 1 && si.StuName.Contains(stuname) && si.StuCode.Contains(stucode) && si.StuIdentity.Contains(stuidentity) && si.StuNumber.Contains(stunumber))); } else { return(db.vwStuInfo.Count(si => si.StuID_SchID == schid && si.StuID_BJID == bjid && si.StuName.Contains(stuname) && si.StuCode.Contains(stucode) && si.StuIdentity.Contains(stuidentity) && si.StuNumber.Contains(stunumber))); } } }
/// <summary> /// 获取班级学生 /// </summary> /// <param name="schid"></param> /// <param name="bjid"></param> /// <param name="stunumber"></param> /// <param name="stucode"></param> /// <param name="stuidentity"></param> /// <param name="stuname"></param> /// <param name="maxrecord"></param> /// <returns></returns> public List <sim.vwStuInfo> GetStuList(Guid schid, Guid bjid, string stunumber, string stucode, string stuidentity, string stuname, int maxrecord = 1000, bool bstate = true) { using (var db = new sim.StuInfoEntities()) { if (bstate) { return(db.vwStuInfo.Where(si => si.StuID_SchID == schid && si.StuID_BJID == bjid && si.IsState == 1 && si.StuName.Contains(stuname) && si.StuCode.Contains(stucode) && si.StuIdentity.Contains(stuidentity) && si.StuNumber.Contains(stunumber)).OrderBy(si => si.StuNumber).Take(maxrecord).ToList()); } else { return(db.vwStuInfo.Where(si => si.StuID_SchID == schid && si.StuID_BJID == bjid && si.StuName.Contains(stuname) && si.StuCode.Contains(stucode) && si.StuIdentity.Contains(stuidentity) && si.StuNumber.Contains(stunumber)).OrderBy(si => si.StuNumber).Take(maxrecord).ToList()); } } }
public sim.vwStuInfo GetStuInfo(Guid stuid, bool bstate = true) { using (var db = new sim.StuInfoEntities()) { if (bstate) { return(db.vwStuInfo.SingleOrDefault(si => si.StuID == stuid && si.IsState == 1)); } else { return(db.vwStuInfo.SingleOrDefault(si => si.StuID == stuid)); } } }
public int GetStuCount(string stunumber, string stucode, string stuidentity, string stuname, bool bstate = true) { using (var db = new sim.StuInfoEntities()) { if (bstate) { return(db.StuInfo.Count(si => si.IsState == 1 && si.StuName.Contains(stuname) || si.StuCode.Contains(stucode) || si.StuIdentity.Contains(stuidentity) || si.StuNumber.Contains(stunumber))); } else { return(db.StuInfo.Count(si => si.StuName.Contains(stuname) || si.StuCode.Contains(stucode) || si.StuIdentity.Contains(stuidentity) || si.StuNumber.Contains(stunumber))); } } }
/// <summary> /// 模糊查询 /// </summary> /// <param name="stunumber">学号</param> /// <param name="stucode">学籍号</param> /// <param name="stuidentity">身份证号</param> /// <param name="stuname">姓名</param> /// <returns></returns> public List <sim.StuInfo> GetStuList(string stunumber, string stucode, string stuidentity, string stuname, int maxrecord = 1000, bool bstate = true) { using (var db = new sim.StuInfoEntities()) { if (bstate) { return(db.StuInfo.Where(si => si.IsState == 1 && si.StuName.Contains(stuname) || si.StuCode.Contains(stucode) || si.StuIdentity.Contains(stuidentity) || si.StuNumber.Contains(stunumber)).OrderByDescending(si => si.StuID_BJID).ThenBy(si => si.StuNumber).Take(maxrecord).ToList()); } else { return(db.StuInfo.Where(si => si.StuName.Contains(stuname) || si.StuCode.Contains(stucode) || si.StuIdentity.Contains(stuidentity) || si.StuNumber.Contains(stunumber)).OrderByDescending(si => si.StuID_BJID).ThenBy(si => si.StuNumber).Take(maxrecord).ToList()); } } }
public bool AddStuInfo(sim.StuInfo si) { using (var db = new sim.StuInfoEntities()) { if (!IsExistStu(si.StuID, si.StuCode, si.StuIdentity)) { db.StuInfo.Add(si); if (db.SaveChanges() == 1) { return(true); } } return(false); } }
public bool ModifyStuInfo(sim.StuInfo si) { using (var db = new sim.StuInfoEntities()) { if (!IsExistStu(si.StuID, si.StuCode, si.StuIdentity)) { DbEntityEntry <sim.StuInfo> entityEntry = db.Entry(si); entityEntry.State = EntityState.Modified; if (db.SaveChanges() == 1) { return(true); } } return(false); } }
public int GetStuCount(Expression <Func <sim.vwStuInfo, bool> > filterexpression) { using (var db = new sim.StuInfoEntities()) { return(db.vwStuInfo.Count(filterexpression)); } }
/// <summary> /// 开放式条件查询学生信息 /// </summary> /// <param name="filterexpression"></param> /// <returns></returns> public List <sim.vwStuInfo> GetStuList(Expression <Func <sim.vwStuInfo, bool> > filterexpression, int top = 1000) { using (var db = new sim.StuInfoEntities()) { return(db.vwStuInfo.Where(filterexpression).OrderByDescending(si => si.StuID_BJID).ThenBy(si => si.StuNumber).Take(top).ToList()); } }
public bool IsExistStu(Guid stuid, string stucode, string stuidentity) { using (var db = new sim.StuInfoEntities()) { return(db.StuInfo.Any(si => (si.StuCode == stucode || si.StuIdentity == stuidentity) && si.StuID != stuid)); } }