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); }