public LigerGrid RoleAddGrid(string systemName, LigerGrid grid)
{
SecRoleQuery query = new SecRoleQuery();
query.ligerGrid = grid;
query.systemName = systemName;
grid = QueryTableHelper.QueryTable <SecRoleEntity>(query.RoleAddSQL(), grid);
return(grid);
}
/// <summary>
/// 分页
/// </summary>
/// <param name="grid">列表</param>
/// <returns></returns>
public JqGrid ForGrid(string systemName, JqGrid grid)
{
SecRoleQuery query = new SecRoleQuery();
//query.ligerGrid = grid;
query.systemName = systemName;
grid = QueryTableHelper.QueryGrid <SecRoleEntity>(query, grid);
return(grid);
}
public virtual bool ExportExcel(LigerGrid grid, ref ExcelConvertHelper.ExcelContext context, ref string Error)
{
SecRoleQuery query = new SecRoleQuery();
query.ligerGrid = grid;
eContract.Common.ExcelConvertHelper.ColumnList columns = new eContract.Common.ExcelConvertHelper.ColumnList();
columns.Add(SecRoleTable.C_ROLE_ID, "角色编号");
columns.Add("role_type_name", "角色类型");
columns.Add(SecRoleTable.C_ROLE_NAME, "角色名称");
columns.Add(SecRoleTable.C_REMARK, "角色描述");
context = new ExcelConvertHelper.ExcelContext();
context.FileName = "RoleList" + ".xls";
context.Title = "角色列表";
WhereBuilder where = query.ParseSQL();
context.Data = DataAccess.Select(where.SQLString, where.Parameters).Tables[0];
if (columns != null)
{
context.Columns.Add(columns);
}
CacheHelper.Instance.Set(WebCaching.UserId + "_" + ExcelHelper.EXPORT_EXCEL_CONTEXT, context);
return(true);
}
