/// <summary>
/// 修改数据(单条)
/// </summary>
public AjaxResult Update(TbSysMenuTableRequset request)
{
if (request == null)
{
return(AjaxResult.Warning("参数错误"));
}
try
{
var model = MapperHelper.Map <TbSysMenuTableRequset, TbSysMenuTable>(request);
if (model == null)
{
return(AjaxResult.Error("信息不存在"));
}
var count = Repository <TbSysMenuTable> .Update(model);
if (count > 0)
{
return(AjaxResult.Success());
}
return(AjaxResult.Error());
}
catch (Exception)
{
return(AjaxResult.Error());
}
}
public ActionResult GetAppointMenuTableGridJson(TbSysMenuTableRequset request, string keyword)
{
var data = new
{
rows = _sysMenuTable.GetDataListForPage(request, keyword),
total = request.total,
page = request.page,
records = request.records
};
return(Content(data.ToJson()));
}
public ActionResult SubmitAppointMenuTableForm(TbSysMenuTableRequset request, string type)
{
if (type == "add")
{
var data = _sysMenuTable.Insert(request);
return(Content(data.ToJson()));
}
else
{
var data = _sysMenuTable.Update(request);
return(Content(data.ToJson()));
}
}
/// <summary>
/// 获取数据列表(分页)
/// </summary>
public List <TbSysMenuTable> GetDataListForPage(TbSysMenuTableRequset param, string keyword)
{
//组装查询语句
#region 模糊搜索条件
var where = new Where <TbSysMenuTable>();
if (!string.IsNullOrWhiteSpace(keyword))
{
where.And(d => d.MenuCode.Like(keyword));
where.Or(d => d.TableName.Like(keyword));
}
//if (!string.IsNullOrWhiteSpace(param.TableName))
//{
// where.And(d => d.TableName.Like(param.TableName));
//}
#endregion
var orderBy = OrderByOperater.ASC;
if (param.sord.Equals("desc"))
{
orderBy = OrderByOperater.DESC;
}
try
{
//取总数，以计算共多少页。
var dateCount = Repository <TbSysMenuTable> .Count(where);
var orderByClip = new OrderByClip(new Field(param.sidx), orderBy);//排序字段
var list = Repository <TbSysMenuTable> .Query(where, orderByClip, param.sord, param.rows, param.page).ToList();
param.records = dateCount;
return(list);
}
catch (Exception)
{
throw;
}
}
