/// <summary>
/// 添加部门信息
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > AddAsync(SysOrganize parm)
{
parm.Guid = Guid.NewGuid().ToString();
parm.EditTime = DateTime.Now;
SysOrganizeDb.Insert(parm);
if (!string.IsNullOrEmpty(parm.ParentGuid))
{
// 说明有父级 根据父级，查询对应的模型
var model = SysOrganizeDb.GetById(parm.ParentGuid);
parm.ParentGuidList = model.ParentGuidList + parm.Guid + ",";
parm.Layer = model.Layer + 1;
}
else
{
parm.ParentGuidList = "," + parm.Guid + ",";
}
//更新 新的对象
SysOrganizeDb.Update(parm);
var res = new ApiResult <string>
{
statusCode = 200,
data = "1"
};
return(await Task.Run(() => res));
}
/// <summary>
/// 查询Tree
/// </summary>
/// <returns></returns>
public async Task <ApiResult <List <SysOrganizeTree> > > GetListTreeAsync()
{
var list = SysOrganizeDb.GetList();
var treeList = new List <SysOrganizeTree>();
foreach (var item in list.Where(m => m.Layer == 0).OrderBy(m => m.Sort))
{
//获得子级
var children = RecursionOrganize(list, new List <SysOrganizeTree>(), item.Guid);
treeList.Add(new SysOrganizeTree()
{
guid = item.Guid,
name = item.Name,
open = children.Count > 0,
children = children.Count == 0?null:children
});
}
var res = new ApiResult <List <SysOrganizeTree> >
{
statusCode = 200,
data = treeList
};
return(await Task.Run(() => res));
}
/// <summary>
/// 添加部门信息
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > AddAsync(SysRole parm)
{
var res = new ApiResult <string>()
{
data = "1", statusCode = 200
};
try
{
//根据部门ID查询部门组
var organizeModel = SysOrganizeDb.GetById(parm.DepartmentGuid);
parm.DepartmentGroup = organizeModel.ParentGuidList;
parm.Guid = Guid.NewGuid().ToString();
parm.EditTime = DateTime.Now;
parm.AddTime = DateTime.Now;
parm.IsSystem = true;
SysRoleDb.Insert(parm);
}
catch (Exception ex)
{
res.statusCode = (int)ApiEnum.Error;
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
}
return(await Task.Run(() => res));
}
/// <summary>
/// 添加部门信息
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > AddAsync(SysRole parm)
{
var res = new ApiResult <string>()
{
data = "1", statusCode = 200
};
try
{
parm.Guid = Guid.NewGuid().ToString();
parm.EditTime = DateTime.Now;
parm.AddTime = DateTime.Now;
if (parm.Level == 1)
{
//根据部门ID查询部门
var organizeModel = SysOrganizeDb.GetById(parm.DepartmentGuid);
parm.DepartmentGroup = organizeModel.ParentGuidList;
}
await Db.Insertable(parm).ExecuteCommandAsync();
}
catch (Exception ex)
{
res.statusCode = (int)ApiEnum.Error;
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
}
return(res);
}
/// <summary>
/// 修改菜单
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > ModifyAsync(SysRole parm)
{
var res = new ApiResult <string>()
{
statusCode = 200
};
try
{
parm.EditTime = DateTime.Now;
if (parm.Level == 1)
{
//根据部门ID查询部门组
var organizeModel = SysOrganizeDb.GetById(parm.DepartmentGuid);
parm.DepartmentGroup = organizeModel.ParentGuidList;
}
await Db.Updateable(parm).ExecuteCommandAsync();
}
catch (Exception ex)
{
res.statusCode = (int)ApiEnum.Error;
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
}
return(res);
}
/// <summary>
/// 修改菜单
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > ModifyAsync(SysRole parm)
{
var res = new ApiResult <string>()
{
data = "1", statusCode = 200
};
try
{
//根据部门ID查询部门组
var organizeModel = SysOrganizeDb.GetById(parm.DepartmentGuid);
parm.DepartmentGroup = organizeModel.ParentGuidList;
parm.IsSystem = true;
parm.EditTime = DateTime.Now;
res.data = SysRoleDb.Update(parm) ? "1" : "0";
}
catch (Exception ex)
{
res.statusCode = (int)ApiEnum.Error;
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
}
return(await Task.Run(() => res));
}
/// <summary>
/// 修改菜单
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > ModifyAsync(SysAdmin parm)
{
var res = new ApiResult <string>
{
statusCode = (int)ApiEnum.Error
};
try
{
//修改，判断用户是否和其它的重复
var isExisteName = await Db.Queryable <SysAdmin>().AnyAsync(m => m.LoginName == parm.LoginName && m.Guid != parm.Guid);
if (isExisteName)
{
res.message = "用户名已存在，请更换~";
res.statusCode = (int)ApiEnum.ParameterError;
return(await Task.Run(() => res));
}
parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd);
if (!string.IsNullOrEmpty(parm.DepartmentGuid))
{
// 说明有父级 根据父级，查询对应的模型
var model = SysOrganizeDb.GetById(parm.DepartmentGuid);
parm.DepartmentGuidList = model.ParentGuidList;
}
var dbres = await Db.Updateable <SysAdmin>().UpdateColumns(m => new SysAdmin()
{
LoginName = parm.LoginName,
LoginPwd = parm.LoginPwd,
DepartmentName = parm.DepartmentName,
DepartmentGuid = parm.DepartmentGuid,
DepartmentGuidList = parm.DepartmentGuidList,
TrueName = parm.TrueName,
Number = parm.Number,
Sex = parm.Sex,
Mobile = parm.Mobile,
Email = parm.Email,
Status = parm.Status
}).Where(m => m.Guid == parm.Guid).ExecuteCommandAsync();
if (dbres > 0)
{
res.statusCode = (int)ApiEnum.Status;
res.message = "更新成功！";
}
else
{
res.message = "更新失败！";
}
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
}
return(res);
}
/// <summary>
/// 添加部门信息
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > AddAsync(SysAdmin parm)
{
var res = new ApiResult <string>
{
statusCode = (int)ApiEnum.ParameterError
};
try
{
//判断用吗是否存在
var isExisteName = await Db.Queryable <SysAdmin>().AnyAsync(m => m.LoginName == parm.LoginName);
if (isExisteName)
{
res.message = "用户名已存在，请更换~";
return(res);
}
parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd);
if (string.IsNullOrEmpty(parm.HeadPic))
{
parm.HeadPic = "/themes/img/avatar.jpg";
}
parm.Guid = Guid.NewGuid().ToString();
parm.AddDate = DateTime.Now;
if (!string.IsNullOrEmpty(parm.DepartmentGuid))
{
// 说明有父级 根据父级，查询对应的模型
var model = SysOrganizeDb.GetById(parm.DepartmentGuid);
parm.DepartmentGuidList = model.ParentGuidList;
}
SysAdminDb.Insert(parm);
//查询授权表，type=2 更新新的权限值
//添加新的
var authorityList = new List <SysPermissions>();
foreach (var item in parm.RoleList)
{
authorityList.Add(new SysPermissions()
{
RoleGuid = item.guid,
AdminGuid = parm.Guid,
Types = 2
});
}
await Db.Insertable(authorityList).ExecuteCommandAsync();
res.statusCode = (int)ApiEnum.Status;
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
}
return(await Task.Run(() => res));
}
/// <summary>
/// 删除部门
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > DeleteAsync(string parm)
{
var list = Utils.StrToListString(parm);
var isok = SysOrganizeDb.Delete(m => list.Contains(m.Guid));
var res = new ApiResult <string>
{
statusCode = isok ? 200 : 500,
data = isok ? "1" : "0",
message = isok ? "删除成功~" : "删除失败~"
};
return(await Task.Run(() => res));
}
/// <summary>
/// 根据唯一编号查询一条部门信息
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <SysOrganize> > GetByGuidAsync(string parm)
{
var model = SysOrganizeDb.GetById(parm);
var res = new ApiResult <SysOrganize>
{
statusCode = 200
};
var pmdel = Db.Queryable <SysOrganize>().OrderBy(m => m.Sort, OrderByType.Desc).First();
res.data = model ?? new SysOrganize()
{
Sort = pmdel?.Sort + 1 ?? 1, Status = true
};
return(await Task.Run(() => res));
}
/// <summary>
/// 修改菜单
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > ModifyAsync(SysAdmin parm)
{
if (!string.IsNullOrEmpty(parm.DepartmentGuid))
{
// 说明有父级 根据父级，查询对应的模型
var model = SysOrganizeDb.GetById(parm.DepartmentGuid);
parm.DepartmentGuidList = model.ParentGuidList;
}
var res = new ApiResult <string>
{
statusCode = 200,
data = SysAdminDb.Update(parm) ? "1" : "0"
};
return(await Task.Run(() => res));
}
/// <summary>
/// 添加部门信息
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > AddAsync(SysAdmin parm)
{
parm.Guid = Guid.NewGuid().ToString();
parm.AddDate = DateTime.Now;
if (!string.IsNullOrEmpty(parm.DepartmentGuid))
{
// 说明有父级 根据父级，查询对应的模型
var model = SysOrganizeDb.GetById(parm.DepartmentGuid);
parm.DepartmentGuidList = model.ParentGuidList;
}
SysAdminDb.Insert(parm);
var res = new ApiResult <string>
{
statusCode = 200,
data = "1"
};
return(await Task.Run(() => res));
}
/// <summary>
/// 添加部门信息
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public new async Task <ApiResult <string> > AddAsync(SysAdmin parm)
{
var res = new ApiResult <string>
{
statusCode = 200,
data = "1"
};
try
{
//判断用吗是否存在
var isExisteName = SysAdminDb.IsAny(m => m.LoginName == parm.LoginName);
if (isExisteName)
{
res.message = "用户名已存在，请更换~";
res.statusCode = (int)ApiEnum.ParameterError;
return(await Task.Run(() => res));
}
parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd);
if (string.IsNullOrEmpty(parm.HeadPic))
{
parm.HeadPic = "/themes/img/avatar.jpg";
}
parm.Guid = Guid.NewGuid().ToString();
parm.AddDate = DateTime.Now;
if (!string.IsNullOrEmpty(parm.DepartmentGuid))
{
// 说明有父级 根据父级，查询对应的模型
var model = SysOrganizeDb.GetById(parm.DepartmentGuid);
parm.DepartmentGuidList = model.ParentGuidList;
}
SysAdminDb.Insert(parm);
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
res.statusCode = (int)ApiEnum.Error;
Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
}
return(await Task.Run(() => res));
}
public async Task <ApiResult <string> > ModifyAsync(SysOrganize parm)
{
parm.EditTime = DateTime.Now;
if (!string.IsNullOrEmpty(parm.ParentGuid))
{
// 说明有父级 根据父级，查询对应的模型
var model = SysOrganizeDb.GetById(parm.ParentGuid);
parm.ParentGuidList = model.ParentGuidList + parm.Guid + ",";
parm.Layer = model.Layer + 1;
}
else
{
parm.ParentGuidList = "," + parm.Guid + ",";
}
var res = new ApiResult <string>
{
statusCode = 200,
data = SysOrganizeDb.Update(parm) ? "1" : "0"
};
return(await Task.Run(() => res));
}
/// <summary>
/// 修改菜单
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > ModifyAsync(SysAdmin parm)
{
var res = new ApiResult <string>
{
statusCode = (int)ApiEnum.Error
};
try
{
//修改，判断用户是否和其它的重复
var isExisteName = await Db.Queryable <SysAdmin>().AnyAsync(m => m.LoginName == parm.LoginName && m.Guid != parm.Guid);
if (isExisteName)
{
res.message = "用户名已存在，请更换~";
res.statusCode = (int)ApiEnum.ParameterError;
return(await Task.Run(() => res));
}
parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd);
if (!string.IsNullOrEmpty(parm.DepartmentGuid))
{
// 说明有父级 根据父级，查询对应的模型
var model = SysOrganizeDb.GetById(parm.DepartmentGuid);
parm.DepartmentGuidList = model.ParentGuidList;
}
//查询授权表，type=2 更新新的权限值
//删除
var authority = await Db.Deleteable <SysPermissions>().Where(m => m.AdminGuid == parm.Guid && m.Types == 2).ExecuteCommandAsync();
//添加新的
var authorityList = new List <SysPermissions>();
foreach (var item in parm.RoleList)
{
authorityList.Add(new SysPermissions()
{
RoleGuid = item.guid,
AdminGuid = parm.Guid,
Types = 2
});
}
await Db.Insertable(authorityList).ExecuteCommandAsync();
var dbres = await Db.Updateable <SysAdmin>().SetColumns(m => new SysAdmin()
{
LoginName = parm.LoginName,
LoginPwd = parm.LoginPwd,
RoleGuid = parm.RoleGuid,
DepartmentName = parm.DepartmentName,
DepartmentGuid = parm.DepartmentGuid,
DepartmentGuidList = parm.DepartmentGuidList,
TrueName = parm.TrueName,
Number = parm.Number,
Sex = parm.Sex,
Mobile = parm.Mobile,
Email = parm.Email,
Status = parm.Status
}).Where(m => m.Guid == parm.Guid).ExecuteCommandAsync();
if (dbres > 0)
{
res.statusCode = (int)ApiEnum.Status;
res.message = "更新成功！";
}
else
{
res.message = "更新失败！";
}
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
}
return(res);
}
