首页 > 代码库 > 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 排序、分页、加载数据必需的三个函数