/// <summary>
/// 根据角色id查询一条角色信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static SysRole GetSysRoleById(int id)
{
SysRole sr = null;
string sql = "SELECT * FROM [dbo].[SysRole] where id = " + id;
DataTable dt = DBHelperSQL.Query(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
sr = new SysRole();
sr.Id = Convert.ToInt32(dr["id"]);
sr.RoleName = dr["RoleName"].ToString();
sr.RoleDesc = dr["RoleDesc"].ToString();
sr.CreatingTime = Convert.ToDateTime(dr["creatingTime"]);
sr.DepartmentId = Convert.ToInt32(dr["departmentId"]);
sr.Status = Convert.ToInt32(dr["Status"]);
sr.IsPayOrder = Convert.ToInt32(dr["isPayOrder"]);
}
return(sr);
}
/// <summary>
/// 查询所有的系统角色
/// </summary>
/// <returns></returns>
public static List <SysRole> GetAllSysRole()
{
List <SysRole> list = new List <SysRole>();
string sql = "SELECT * FROM [dbo].[SysRole] where id <> 1 order by creatingTime desc";
DataTable dt = DBHelperSQL.Query(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
SysRole sr = new SysRole();
sr.Id = Convert.ToInt32(dr["id"]);
sr.RoleName = dr["RoleName"].ToString();
sr.RoleDesc = dr["RoleDesc"].ToString();
sr.CreatingTime = Convert.ToDateTime(dr["creatingTime"]);
sr.DepartmentId = Convert.ToInt32(dr["departmentId"]);
sr.Status = Convert.ToInt32(dr["Status"]);
sr.IsPayOrder = Convert.ToInt32(dr["isPayOrder"]);
list.Add(sr);
}
return(list);
}
/// <summary>
/// 创建一个人员
/// </summary>
/// <param name="validationErrors">返回的错误信息</param>
/// <param name="db">数据库上下文</param>
/// <param name="entity">一个人员</param>
/// <returns></returns>
public bool Create(ref ValidationErrors validationErrors, SysEntities db, SysPerson entity)
{
int count = 1;
if (CheckName(entity.Name))
{
validationErrors.Add("用户名已被占用，请换一个新的用户名");
return false;
}
foreach (string item in entity.SysRoleId.GetIdSort())
{
SysRole sys = new SysRole { Id = item };
db.SysRole.Attach(sys);
entity.SysRole.Add(sys);
count++;
}
repository.Create(db, entity);
if (count == repository.Save(db))
{
return true;
}
else
{
validationErrors.Add("创建出错了");
}
return false;
}
/// <summary>
/// 编辑一个人员
/// </summary>
/// <param name="validationErrors">返回的错误信息</param>
/// <param name="db">数据上下文</param>
/// <param name="entity">一个人员</param>
/// <returns>是否编辑成功</returns>
public bool Edit(ref ValidationErrors validationErrors, SysEntities db, SysPerson entity)
{
/*
* 不操作 原有 现有
* 增加 原没 现有
* 删除 原有 现没
*/
if (entity == null)
{
return false;
}
if (CheckName(entity))
{
validationErrors.Add("用户名已被占用，请换一个新的用户名");
return false;
}
int count = 1;
SysPerson editEntity = repository.Edit(db, entity);
List<string> addSysRoleId = new List<string>();
List<string> deleteSysRoleId = new List<string>();
DataOfDiffrent.GetDiffrent(entity.SysRoleId.GetIdSort(), entity.SysRoleIdOld.GetIdSort(), ref addSysRoleId, ref deleteSysRoleId);
if (addSysRoleId != null && addSysRoleId.Count() > 0)
{
foreach (var item in addSysRoleId)
{
SysRole sys = new SysRole { Id = item };
db.SysRole.Attach(sys);
editEntity.SysRole.Add(sys);
count++;
}
}
if (deleteSysRoleId != null && deleteSysRoleId.Count() > 0)
{
List<SysRole> listEntity = new List<SysRole>();
foreach (var item in deleteSysRoleId)
{
SysRole sys = new SysRole { Id = item };
listEntity.Add(sys);
db.SysRole.Attach(sys);
}
foreach (SysRole item in listEntity)
{
editEntity.SysRole.Remove(item);//查询数据库
count++;
}
}
if (count == repository.Save(db))
{
return true;
}
else
{
validationErrors.Add("编辑人员出错了");
}
return false;
}
/// <summary>
/// 编辑一个角色对象
/// </summary>
/// <param name="db">实体数据</param>
/// <param name="entity">将要编辑的一个角色对象</param>
public SysRole Edit(SysEntities db, SysRole entity)
{
db.SysRole.Attach(entity);
db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
return(entity);
}