///// <summary>
///// 获取数据列表(分页)
///// </summary>
//public List<TbRole> GetDataListForPage(TbRoleRequset param, string keyword)
//{
// //组装查询语句
// #region 模糊搜索条件
// var where = new Where<TbRole>();
// if (!string.IsNullOrEmpty(keyword))
// {
// where.And(d => d.RoleCode.Like(keyword));
// where.Or(d => d.RoleName.Like(keyword));
// }
// #endregion
// var orderBy = OrderByOperater.ASC;
// if (param.sord.Equals("desc"))
// orderBy = OrderByOperater.DESC;
// try
// {
// //取总数，以计算共多少页。
// var dateCount = Repository<TbRole>.Count(where);
// var orderByClip = new OrderByClip(new Field(param.sidx), orderBy);//排序字段
// var list = Repository<TbRole>.Query(where, orderByClip, param.sord, param.rows, param.page).ToList();
// param.records = dateCount;
// return list;
// }
// catch (Exception)
// {
// throw;
// }
//}
/// <summary>
/// 获取数据列表(分页)
/// </summary>
public PageModel GetDataListForPage(TbRoleRequset request)
{
//组装查询语句
#region 模糊搜索条件
var where = new Where <TbRole>();
if (!string.IsNullOrWhiteSpace(request.RoleName))
{
where.And(p => p.RoleName.Contains(request.RoleName));
}
if (!string.IsNullOrWhiteSpace(request.DepartmentId))
{
where.And(p => p.DepartmentId == request.DepartmentId);
}
#endregion
try
{
var ret = Db.Context.From <TbRole>()
.Select(TbRole._.All).Where(where).OrderByDescending(d => d.RoleId).ToPageList(request.rows, request.page);
return(ret);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 新增数据(单条)
/// </summary>
public AjaxResult Insert(TbRoleRequset request)
{
if (request == null)
{
return(AjaxResult.Warning("参数错误"));
}
try
{
var model1 = Repository <TbRole> .First(d => d.RoleName == request.RoleName);
if (model1 != null)
{
return(AjaxResult.Error("角色名称重复"));
}
var model = MapperHelper.Map <TbRoleRequset, TbRole>(request);
model.RoleCode = request.RoleCode;
model.RoleName = request.RoleName;
model.RoleDetail = request.RoleDetail;
model.State = "启用";
var count = Repository <TbRole> .Insert(model);
if (count > 0)
{
return(AjaxResult.Success());
}
return(AjaxResult.Error());
}
catch (Exception)
{
return(AjaxResult.Error());
}
}
/// <summary>
/// 新增数据(单条)
/// </summary>
public AjaxResult CopyRole(TbRoleRequset request, string roleCode)
{
if (request == null)
{
return(AjaxResult.Warning("参数错误"));
}
try
{
var model1 = Repository <TbRole> .First(d => d.RoleName == request.RoleName);
if (model1 != null)
{
return(AjaxResult.Error("角色名称重复"));
}
var model = MapperHelper.Map <TbRoleRequset, TbRole>(request);
model.RoleCode = request.RoleCode;
model.RoleName = request.RoleName;
model.RoleDetail = request.RoleDetail;
model.State = "启用";
//获取要拷贝的角色的角色权限
var roleMenu = Repository <TbRoleMenu> .Query(p => p.RoleCode == roleCode).ToList();
List <TbRoleMenu> roleMenuUpdate = new List <TbRoleMenu>();
if (roleMenu != null && roleMenu.Count > 0)
{
for (int i = 0; i < roleMenu.Count; i++)
{
var roleMenu1 = MapperHelper.Map <TbRoleMenu, TbRoleMenu>(roleMenu[i]);
roleMenu1.RoleCode = model.RoleCode;
roleMenuUpdate.Add(roleMenu1);
}
}
using (DbTrans trans = Db.Context.BeginTransaction())//使用事务
{
Repository <TbRole> .Insert(trans, model);
if (roleMenuUpdate != null && roleMenuUpdate.Count > 0)
{
Repository <TbRoleMenu> .Insert(trans, roleMenuUpdate); //拷贝角色权限
}
trans.Commit(); //提交事务
}
return(AjaxResult.Success());
}
catch (Exception)
{
return(AjaxResult.Error());
}
}
public ActionResult SubmitForm(TbRoleRequset request, string type, string roleCodeOld)
{
if (type == "add")
{
var data = _role.Insert(request);
return(Content(data.ToJson()));
}
else if (type == "copy")
{
var data = _role.CopyRole(request, roleCodeOld);
return(Content(data.ToJson()));
}
else
{
var data = _role.Update(request);
return(Content(data.ToJson()));
}
}
/// <summary>
/// 修改数据(单条)
/// </summary>
public AjaxResult Update(TbRoleRequset request)
{
if (request == null)
{
return(AjaxResult.Warning("参数错误"));
}
try
{
var model = Repository <TbRole> .First(p => p.RoleCode == request.RoleCode);
if (model == null)
{
return(AjaxResult.Error("信息不存在"));
}
var model1 = Repository <TbRole> .First(d => d.RoleName == request.RoleName && d.RoleCode != request.RoleCode);
if (model1 != null)
{
return(AjaxResult.Error("角色名称重复"));
}
model.RoleCode = request.RoleCode;
model.RoleName = request.RoleName;
model.RoleDetail = request.RoleDetail;
var count = Repository <TbRole> .Update(model);
if (count > 0)
{
return(AjaxResult.Success());
}
return(AjaxResult.Error());
}
catch (Exception)
{
return(AjaxResult.Error());
}
}
///// <summary>
///// 获取分页列表数据
///// </summary>
///// <param name="request"></param>
///// <returns></returns>
//[HttpGet]
//public ActionResult GetGridJson(TbRoleRequset request, string keyword)
//{
// var data = new
// {
// rows = _role.GetDataListForPage(request, keyword),
// total = request.total,
// page = request.page,
// records = request.records
// };
// return Content(data.ToJson());
//}
/// <summary>
/// 获取分页列表数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetGridJson(TbRoleRequset request)
{
var data = _role.GetDataListForPage(request);
return(Content(data.ToJson()));
}
