首页 > 代码库 > ASPxGridView 排序、分页、加载数据必需的三个函数
ASPxGridView 排序、分页、加载数据必需的三个函数
protected void ASPxGridViewPoint_OnCustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { try { PointIdKeys = e.Parameters;//传递参数 LogHelper.WriteLog("PointIdKeys:"+PointIdKeys); object[] paramets = e.Parameters.Split(‘;‘);//分割参数 if (string.IsNullOrEmpty(rootPath)) { rootPath = ConstConfig.strWebServerM; } string filePath = rootPath + @"\App_Config\SQL\ORACLE\index_over_view\overView_34_gridPoint.sql"; string fileContent = FileHelper.FileToString(filePath); string sqlContent = fileContent; LogHelper.WriteLog("PointIdKeys 参数长度:" + paramets.Length); string sql = string.Format(sqlContent,paramets); DataTable dataTable = PublicBllBase.GetDataTable(sql); if (dataTable != null) { this.ASPxGridViewPoint.DataSource = dataTable; this.ASPxGridViewPoint.DataBind(); } } catch (Exception exception) { LogHelper.WriteLog("WebChartControlIndex", exception); } } protected void ASPxGridViewPoint_OnBeforeColumnSortingGrouping(object sender, ASPxGridViewBeforeColumnGroupingSortingEventArgs e) { try { object[] paramets = PointIdKeys.Split(‘;‘);//分割参数 if (string.IsNullOrEmpty(rootPath)) { rootPath = ConstConfig.strWebServerM; } string filePath = rootPath + @"\App_Config\SQL\ORACLE\index_over_view\overView_34_gridPoint.sql"; string fileContent = FileHelper.FileToString(filePath); string sqlContent = fileContent; LogHelper.WriteLog("PointIdKeys 参数长度:" + paramets.Length); string sql = string.Format(sqlContent, paramets); DataTable dataTable = PublicBllBase.GetDataTable(sql); if (dataTable != null) { this.ASPxGridViewPoint.DataSource = dataTable; this.ASPxGridViewPoint.DataBind(); } } catch (Exception exception) { LogHelper.WriteLog("WebChartControlIndex", exception); } } protected void ASPxGridViewPoint_OnPageIndexChanged_(object sender, EventArgs e) { try { object[] paramets = PointIdKeys.Split(‘;‘);//分割参数 if (string.IsNullOrEmpty(rootPath)) { rootPath = ConstConfig.strWebServerM; } string filePath = rootPath + @"\App_Config\SQL\ORACLE\index_over_view\overView_34_gridPoint.sql"; string fileContent = FileHelper.FileToString(filePath); string sqlContent = fileContent; LogHelper.WriteLog("PointIdKeys 参数长度:" + paramets.Length); string sql = string.Format(sqlContent, paramets); DataTable dataTable = PublicBllBase.GetDataTable(sql); if (dataTable != null) { this.ASPxGridViewPoint.DataSource = dataTable; this.ASPxGridViewPoint.DataBind(); } } catch (Exception exception) { LogHelper.WriteLog("WebChartControlIndex", exception); } }
ASPxGridView 排序、分页、加载数据必需的三个函数
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。