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 LigerGrid UserRoleGrid(string systemName, LigerGrid grid) { QueryUser query = new QueryUser(); query.ligerGrid = grid; query.systemName = systemName; grid = QueryTableHelper.QueryTable <CasUserEntity>(query.GetUserRoleSQL(), grid); return(grid); }
public ActionResult RoleAdd(LigerGrid grid, FormCollection data, string id) { grid.ConvertParams(data); ViewBag.UserId = id; if (IsPost) { return(Json(SystemService.FunctionRoleService.RoleAddGrid("MDM", grid))); } return(View()); }
public ActionResult Export(LigerGrid grid, FormCollection data) { string strError = ""; grid.ConvertParams(data); eContract.Common.ExcelConvertHelper.ExcelContext context = new ExcelConvertHelper.ExcelContext(); if (SystemService.FunctionRoleService.ExportExcel(grid, ref context, ref strError)) { return(Json(AjaxResult.Success())); } return(Json(AjaxResult.Error(strError))); }
public virtual bool ExportExcel(LigerGrid grid, ref ExcelConvertHelper.ExcelContext context, ref string Error) { QueryUser query = new QueryUser(); query.ligerGrid = grid; eContract.Common.ExcelConvertHelper.ColumnList columns = new eContract.Common.ExcelConvertHelper.ColumnList(); columns.Add(CasUserTable.C_USER_ACCOUNT, "登录名"); columns.Add(CasUserTable.C_ENGLISH_NAME, "姓名"); context = new ExcelConvertHelper.ExcelContext(); context.FileName = "UserList" + ".xls"; context.Title = "用户列表"; //context.Data = DataAccess.QueryDataSet(query); 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); }
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); }
public static LigerGrid ExcuteTable <T>(string hql, DataAccessParameterCollection lstParameter, LigerGrid grid, DataAccessBroker broker) where T : EntityBase, new() { object total = broker.ExecuteScalar("select count(1) as Total from (" + hql + ") as ttable", lstParameter, CommandType.Text); StringBuilder strsql = new StringBuilder(); if (grid.pageIndex != 0 && grid.pageSize != 0) { strsql.Append("select * from ( select top " + (grid.pageIndex * grid.pageSize) + " row_number() over(order by " + grid.sortName + " " + grid.sortOrder.ToLower() + ") as Row_Number, "); strsql.Append(hql.Replace(":", "@").Substring(7)); if (!string.IsNullOrEmpty(grid.Where)) { strsql.Append(" and (" + grid.Where.Replace(":", "@") + ")");; }//as strsql.Append(" ) ttable where Row_Number between " + (((grid.pageIndex - 1) * grid.pageSize) + 1) + " and " + ((grid.pageIndex) * grid.pageSize)); } else { strsql.Append(hql); if (!string.IsNullOrEmpty(grid.sortName)) { strsql.Append(" order by " + grid.sortName); if (!string.IsNullOrEmpty(grid.sortOrder)) { strsql.Append(" " + grid.sortOrder); } else { strsql.Append(" ASC"); } } } DataSet ds = broker.FillSQLDataSet(strsql.ToString(), lstParameter); EntityCollection <T> lstEntity = new EntityCollection <T>(); List <Dictionary <string, object> > dicLstRow = new List <Dictionary <string, object> >(); ToEntityList <T>(ds.Tables[0], ref dicLstRow, ref lstEntity); if (grid.IsDataEntity) { grid.Rows = lstEntity; } else { grid.Rows = dicLstRow; } grid.Total = (total != null ? Convert.ToInt32(total) : 0); return(grid); }
/// <summary> /// /// </summary> /// <typeparam name="T"></typeparam> /// <param name="sqlString">必须带上where 1=1</param> /// <param name="lstParameter"></param> /// <param name="grid"></param> /// <param name="DbInstanceName">数据库实例</param> /// <returns></returns> public static LigerGrid QueryTable <T>(string sqlString, DataAccessParameterCollection lstParameter, LigerGrid grid, string DbInstanceName = "") where T : EntityBase, new() { string hql = sqlString; string where = grid.Where; if (!string.IsNullOrEmpty(where)) { hql += " and (" + where + ")"; } if (lstParameter == null) { lstParameter = new DataAccessParameterCollection(); } if (grid != null && grid.LstParms != null && grid.LstParms.Count > 0) { foreach (var item in grid.LstParms) { lstParameter.Add(item.Name, new DataAccessParameter(item.Name, item.Value)); } } if (!string.IsNullOrEmpty(DbInstanceName)) { using (DataAccessBroker broker = DataAccessFactory.Instance(DbInstanceName)) { return(ExcuteTable <T>(hql, lstParameter, grid, broker)); } } else { using (DataAccessBroker broker = DataAccessFactory.Instance()) { return(ExcuteTable <T>(hql, lstParameter, grid, broker)); } } }
/// <summary> /// /// </summary> /// <typeparam name="T"></typeparam> /// <param name="wb"></param> /// <param name="grid"></param> /// <param name="DbInstanceName"></param> /// <returns></returns> public static LigerGrid QueryTable <T>(WhereBuilder wb, LigerGrid grid, string DbInstanceName = "") where T : EntityBase, new() { return(QueryTable <T>(wb.SQLString, wb.Parameters, grid, DbInstanceName)); }
/// <summary> /// /// </summary> /// <param name="wb"></param> /// <param name="grid"></param> /// <returns></returns> public static LigerGrid QueryTable <T>(IQuery queryObj, LigerGrid grid) where T : EntityBase, new() { WhereBuilder wb = queryObj.ParseSQL(); return(QueryTable <T>(wb, grid, grid.DbInstanceName)); }