/// <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);
}
