/// <summary> /// 新增 /// </summary> /// <returns></returns> public static int AddTeacher(VModel.SyUserTeacher.Form m) { using (var db = new fz_basicEntities()) { m.Account = m.Account.Trim(); if (db.sy_user.Where(w => w.Account == m.Account).Count() > 0) { return(-1);//帐号已存在 } sy_user dbm = new sy_user { Id = Guid.NewGuid().ToString(), Account = m.Account, Name = m.Name.Trim(), ExpiresTime = m.ExpiresTime, IsEnabled = m.IsEnabled, Password = Common.Function.MD5Encrypt("123456"), IsSystem = false, IsExpires = false, Type = 12, CreateTime = DateTime.Now }; if (m.RoleIds != null) { foreach (int item in m.RoleIds) { dbm.sy_user_and_role.Add(new sy_user_and_role { UserId = dbm.Id, RoleId = item, Time = DateTime.Now }); } } sy_teacher dbm2 = new sy_teacher { UserId = dbm.Id, Name = dbm.Name, Subject = m.Subject }; db.sy_user.Add(dbm); db.sy_teacher.Add(dbm2); db.SaveChanges(); } Common.Caches.RemoveCache("sy_user"); Common.Caches.RemoveCache("sy_teacher"); return(200); }
/// <summary> /// 获取用户学科 /// </summary> /// <returns></returns> public int?GetUserSubjectId() { using (var db = new fz_basicEntities()) { if (userInfo == null) { return(null); } sy_teacher teacher = db.sy_teacher.Where(w => w.UserId == userInfo.Id).FirstOrDefault(); return(teacher == null ? null : teacher.Subject); } }
/// <summary> /// 导入教职工用户 /// </summary> public static int ImportTeacher(List <VModel.SyUserTeacher.ImportData> list) { using (var db = new fz_basicEntities()) { foreach (var m in list) { sy_user user = db.sy_user.Where(w => w.Account == m.Account).FirstOrDefault(); if (user == null) { sy_user dbm = new sy_user { Id = Guid.NewGuid().ToString(), Account = m.Account, Name = m.Name, IsEnabled = true, Password = Common.Function.MD5Encrypt("123456"), IsSystem = false, IsExpires = false, Type = 12, CreateTime = DateTime.Now }; dbm.sy_user_and_role.Add(new sy_user_and_role { UserId = dbm.Id, RoleId = 3, Time = DateTime.Now }); sy_teacher dbm2 = new sy_teacher { UserId = dbm.Id, Name = dbm.Name, Subject = db.dict_subject.Where(w => w.Name == m.SubjectName).Select(s => s.Id).FirstOrDefault() }; db.sy_user.Add(dbm); db.sy_teacher.Add(dbm2); db.SaveChanges(); } } } Common.Caches.RemoveCache("sy_user"); Common.Caches.RemoveCache("sy_teacher"); return(200); }
/// <summary> /// 编辑 /// </summary> /// <returns></returns> public static int EditTeacher(VModel.SyUserTeacher.Form m) { using (var db = new fz_basicEntities()) { m.Account = m.Account.Trim(); sy_user dbm = db.sy_user.Find(m.Id); if (dbm.Account != m.Account && db.sy_user.Where(w => w.Account == m.Account).Count() > 0) { return(-1);//帐号已存在 } dbm.Account = m.Account; dbm.Name = m.Name.Trim(); dbm.ExpiresTime = m.ExpiresTime; dbm.IsEnabled = m.IsEnabled; dbm.sy_user_and_role.Clear(); if (m.RoleIds != null) { foreach (int item in m.RoleIds) { dbm.sy_user_and_role.Add(new sy_user_and_role { UserId = dbm.Id, RoleId = item, Time = DateTime.Now }); } } sy_teacher dbm1 = db.sy_teacher.FirstOrDefault(w => w.UserId == m.Id); if (dbm1 != null) { dbm1.Name = m.Name; dbm1.Subject = m.Subject; } db.SaveChanges(); } Task excetion = MyResourceBll.UpdateResourceCreaterName(m.Id, m.Name); Common.Caches.RemoveCache("sy_user"); Common.Caches.RemoveCache("sy_teacher"); return(200); }
/// <summary> /// 删除 /// </summary> /// <param name="id"></param> /// <returns></returns> public static void DeleteTeacher(string id) { using (var db = new fz_basicEntities()) { sy_user m = db.sy_user.Find(id); m.sy_user_and_role.Clear(); db.sy_user.Remove(m); sy_teacher m1 = db.sy_teacher.FirstOrDefault(w => w.UserId == id); if (m1 != null) { m1.UserId = null; } db.SaveChanges(); } Common.Caches.RemoveCache("sy_user"); Common.Caches.RemoveCache("sy_teacher"); }
/// <summary> /// 删除多个 /// </summary> /// <param name="id"></param> /// <returns></returns> public static void DeleteTeachers(string[] ids) { using (var db = new fz_basicEntities()) { IEnumerable <sy_user> list = db.sy_user.Where(w => ids.Contains(w.Id)); foreach (var m in list) { m.sy_user_and_role.Clear(); db.sy_user.Remove(m); sy_teacher m1 = db.sy_teacher.FirstOrDefault(w => w.UserId == m.Id); if (m1 != null) { m1.UserId = null; } } db.SaveChanges(); } Common.Caches.RemoveCache("sy_user"); Common.Caches.RemoveCache("sy_teacher"); }
/// <summary> /// 根据教师Id获取名称 /// </summary> /// <param name="id"></param> /// <returns></returns> public static string GetName(int?id) { sy_teacher m = GetList().Where(w => w.Id == id).FirstOrDefault(); return(m == null ? "" : m.Name); }
/// <summary> /// 获取科组 /// </summary> /// <param name="userId"></param> /// <returns></returns> public static int?GetSubject(string userId) { sy_teacher m = GetModelByUserId(userId); return(m == null ? null : m.Subject); }