/// <summary> /// 查询得到正式表数据表信息 /// </summary> /// <param name="querys">条件数据集</param> /// <param name="recount">返回执行数据数</param> /// <returns></returns> public IEnumerable <Student> Getstudent(QueryConditions querys, out int recount) { using (DBModelEntities1 db = new DBModelEntities1()) { return(db.Student.Where(querys, out recount).ToArray()); } }
/// <summary> /// 删除数据不是真删除,只是修改状态,未审核状态 /// </summary> /// <param name="studentP">ObservableCollection的StudentPending集合</param> /// <returns></returns> public bool delStudentPending(ObservableCollection <StudentPending> studentPs) { using (DBModelEntities1 db = new DBModelEntities1()) { foreach (var studentP in studentPs) { //执行更新原始pending数据 var stItems = db.StudentPending.ToArray(); foreach (var st in stItems) { if (st.StudentId == studentP.StudentId) { st.UPDATE_OPERATOR_ID = studentP.UPDATE_OPERATOR_ID; st.UPDATE_TIME = studentP.UPDATE_TIME; st.OPERATOR_TYPE = studentP.OPERATOR_TYPE; st.AUDIT_STATE = studentP.AUDIT_STATE; break; } } } if (db.SaveChanges() > 0) { return(true); } else { return(false); } } }
/// <summary> /// 认证当前数据是否已经处于提交状态或是拒审状态 /// </summary> /// <param name="StudentId">学号</param> public int ReState(int StudentId) { using (DBModelEntities1 db = new DBModelEntities1()) { var student = db.StudentPending.Where(st => st.StudentId == StudentId).FirstOrDefault(); return((int)student.AUDIT_STATE); } }
/// <summary> /// 添加数据是未审核已提交的数据 /// </summary> /// <param name="studentP">Pending数据对象</param> /// <returns></returns> public int addStudentPending(StudentPending studentP) { using (DBModelEntities1 db = new DBModelEntities1()) { //添加pending数据 db.StudentPending.AddObject(studentP); return(db.SaveChanges()); } }
/// <summary> /// 拒审执行,操作结果是一样的,与正式表无关 /// </summary> /// <param name="studentP">ObservableCollection的StudentPending集合</param> /// <returns></returns> public bool UnAduit(ObservableCollection <StudentPending> studentPs) { using (DBModelEntities1 db = new DBModelEntities1()) { //执行更新原始pending数据 if (Utility.UpdateEntityWithoutQuery <StudentPending>(db, studentPs) > 0) { return(true); } return(false); } }
/// <summary> /// 审核操作,所有的业务在数据中进行分类 /// </summary> /// <param name="studentPs">ObservableCollection的SudentPending集合</param> /// <returns></returns> public bool Aduit(ObservableCollection <StudentPending> studentPs) { using (DBModelEntities1 db = new DBModelEntities1()) { //为了获取需要更新的Student表的原始数据 var sItems = db.Student.ToArray(); //获取需要的SttudentPending表的原始数据 var sPItems = db.StudentPending.ToArray(); //记录删除的对象 ObservableCollection <StudentPending> delStudentPs = new ObservableCollection <StudentPending>(); foreach (var studentP in studentPs) { if (studentP.OPERATOR_TYPE == (int?)NCS.Business.DataFlow.EnumOperatorType.Add) { //正式表插入 Student student = new Student(); NCS.Utility.CopyObjectProperties(studentP, student, "EntityKey"); db.Student.AddObject(student); //更新对象的pending对象 foreach (var stP in sPItems) { if (stP.StudentId == studentP.StudentId) { //更新对象 NCS.Utility.CopyObjectProperties(studentP, stP); break; } } } else if (studentP.OPERATOR_TYPE == (int?)NCS.Business.DataFlow.EnumOperatorType.Edit) { //更新Student表数据 foreach (var s in sItems) { if (s.StudentId == studentP.StudentId) { s.StudentAge = studentP.StudentAge; s.StudentClass = studentP.StudentClass; s.StudentName = studentP.StudentName; s.StudentSex = studentP.StudentSex; s.CHECK_OPERATOR_ID = studentP.CHECK_OPERATOR_ID; s.CHECK_OPERATOR_TIME = studentP.CHECK_OPERATOR_TIME; s.UPDATE_OPERATOR_ID = studentP.UPDATE_OPERATOR_ID; s.UPDATE_TIME = studentP.UPDATE_TIME; break; } } //更新StudentPending对象 foreach (var stP in sPItems) { if (stP.StudentId == studentP.StudentId) { //更新对象 NCS.Utility.CopyObjectProperties(studentP, stP); break; } } } else if (studentP.OPERATOR_TYPE == (int?)NCS.Business.DataFlow.EnumOperatorType.Delete) { //找到对应的student数据进行处理。 foreach (var st in sItems) { if (st.StudentId == studentP.StudentId) { //正式表删除 db.Student.DeleteObject(st); break; } } //删除对应的pending数据 foreach (var stP in sPItems) { if (stP.StudentId == studentP.StudentId) { //删除pending表数据 db.StudentPending.DeleteObject(stP); break; } } } } //最后更新表 if (db.SaveChanges() > 0) { return(true); } else { return(false); } } }