protected void btnUpdateConfigGridPanel_Click(object sender, DirectEventArgs e) { GridPanelInfo gridPanel = GridController.GetInstance().GetGridPanel(GridPanelName); gridPanel.TableName = cbTable.SelectedItem.Value; gridPanel.Title = txtTitle.Text; gridPanel.Width = int.Parse(txtwidth.Text); gridPanel.Header = chkHeader.Checked; gridPanel.AllowFilter = chkFilter.Checked; gridPanel.RowCheckBox = chkCheckBox.Checked; gridPanel.DisplayRowNumber = chkRowNumber.Checked; gridPanel.PageSize = int.Parse(cbPageSize.SelectedItem.Value); if (cbAutoExpandColumn.SelectedIndex >= 0) { gridPanel.AutoExpandColumn = cbAutoExpandColumn.SelectedItem.Value; } gridPanel.InformationPanel = ""; // cbInformationPanel.SelectedItem.Value; gridPanel.WhereClause = txtWhereClause.Text; gridPanel.OrderBy = txtOrderBy.Text.Trim(); if (cbDataSource.SelectedItem.Value == "View") { gridPanel.ViewName = cbView.SelectedItem.Value; } else { gridPanel.ViewName = ""; } gridPanel.Icon = txtIcon.Text; this.TableName = cbTable.SelectedItem.Value; GridController.GetInstance().Update(gridPanel); wdUpdatePanelInfo.Hide(); }
/// <summary> /// /// </summary> public void ShowGridPanelInformationConfig() { if (gridPanel == null) { gridPanel = GridController.GetInstance().GetGridPanel(GridPanelName); } cbTable.Text = gridPanel.TableName; txtTitle.Text = gridPanel.Title; if (gridPanel.Width.HasValue) { txtwidth.Text = gridPanel.Width.Value.ToString(); } if (gridPanel.Height.HasValue) { txtheight.Text = gridPanel.Height.Value.ToString(); } txtIcon.Text = gridPanel.Icon; cbAutoExpandColumn.Text = gridPanel.AutoExpandColumn; chkHeader.Checked = gridPanel.Header; chkRowNumber.Checked = gridPanel.DisplayRowNumber; chkFilter.Checked = gridPanel.AllowFilter; chkCheckBox.Checked = gridPanel.RowCheckBox; chkAllowEditOnGrid.Checked = gridPanel.AllowEditOnGrid; chkOneManyForm.Checked = gridPanel.OneManyForm; wdUpdatePanelInfo.Show(); cbPageSize.SelectedIndex = gridPanel.PageSize.Value / 5 - 1; txtWhereClause.Text = gridPanel.WhereClause; txtOrderBy.Text = gridPanel.OrderBy; int index = 0; cbInformationPanel.SelectedIndex = index; foreach (var item in cbInformationPanel.Items) { if (item.Value == gridPanel.InformationPanel) { cbInformationPanel.SelectedIndex = index; break; } index++; } //Load các trường dữ liệu của bảng hiện thời DataTable datatable = DataController.DataHandler.GetInstance() .ExecuteDataTable("select top 1 * from " + TableName); foreach (DataColumn column in datatable.Columns) { Ext.Net.ListItem item = new Ext.Net.ListItem(); item.Text = column.ColumnName; item.Value = column.ColumnName; cbColumnField.Items.Add(item); //cbbColumnField.Items.Add(item); } }
protected void FilterStore_Refresh(object sender, StoreRefreshDataEventArgs e) { if (gridPanel == null) { gridPanel = GridController.GetInstance().GetGridPanel(GridPanelName); } List <GridFilterPermissionInfo> rsList = gridPanel.GetAllFilter(-1); FilterStore.DataSource = rsList; FilterStore.DataBind(); }
public void ShowData() { gridPanel = GridController.GetInstance().GetGridPanel(this.ID); if (gridPanel == null) { gridPanel = new GridPanelInfo(1, this.ID, "", "", 800, 200, "", 5, defaultTable, true, false, false, false, "", "", "", false, "", false); GridController.GetInstance().AddGridPanel(gridPanel); } if (columnList == null) { columnList = GridController.GetInstance().GetColumnInfo(this.ID, TableName, 1); } InitComponent(gridPanel, columnList); LoadField2Store(); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnUpdateConfigGridPanel_Click(object sender, DirectEventArgs e) { if (gridPanel == null) { gridPanel = GridController.GetInstance().GetGridPanel(GridPanelName); } gridPanel.TableName = cbTable.SelectedItem.Value; gridPanel.Title = txtTitle.Text; gridPanel.Width = int.Parse(txtwidth.Text); gridPanel.Header = chkHeader.Checked; gridPanel.AllowFilter = chkFilter.Checked; gridPanel.RowCheckBox = chkCheckBox.Checked; gridPanel.AllowEditOnGrid = chkAllowEditOnGrid.Checked; gridPanel.OneManyForm = chkOneManyForm.Checked; gridPanel.DisplayRowNumber = chkRowNumber.Checked; gridPanel.PageSize = int.Parse(cbPageSize.SelectedItem.Value); if (cbAutoExpandColumn.SelectedIndex >= 0) { gridPanel.AutoExpandColumn = cbAutoExpandColumn.SelectedItem.Value; } gridPanel.InformationPanel = cbInformationPanel.SelectedItem.Value; gridPanel.WhereClause = txtWhereClause.Text; gridPanel.OrderBy = txtOrderBy.Text.Trim(); if (cbDataSource.SelectedItem.Value == "View") { gridPanel.ViewName = cbView.SelectedItem.Value; } else { gridPanel.ViewName = ""; } gridPanel.Icon = txtIcon.Text; this.TableName = cbTable.SelectedItem.Value; GridController.GetInstance().Update(gridPanel); wdUpdatePanelInfo.Hide(); if (AfterClickUpdateInformation != null) { AfterClickUpdateInformation(null, null); } // Page.ClientScript.RegisterStartupScript(Page.GetType(),"ReloadPageAgain", "location.reload();"); }
private void InitComponent(GridPanelInfo panel, List <GridPanelColumnInfo> columnList) { if (panel.DisplayRowNumber) { RowNumbererColumn stt = new RowNumbererColumn(); stt.Header = "STT"; GridPanel1.ColumnModel.Columns.Add(stt); } if (panel.Header == false) { GridPanel1.Title = ""; } else { GridPanel1.Title = panel.Title; } if (!string.IsNullOrEmpty(panel.AutoExpandColumn)) { columnList = GridController.GetInstance().GetColumnInfo(this.ID, TableName, 1); if (columnList.Count() != 0) { if (columnList.Where(p => p.ColumnName == panel.AutoExpandColumn).FirstOrDefault() != null) { GridPanel1.AutoExpandColumn = panel.AutoExpandColumn; } } else { datatable = DataController.DataHandler.GetInstance().ExecuteDataTable("select top 1 * from " + TableName); foreach (DataColumn item in datatable.Columns) { if (item.ColumnName == panel.AutoExpandColumn) { GridPanel1.AutoExpandColumn = panel.AutoExpandColumn; break; } } } } this.PrimaryKey = Util.GetInstance().GetPrimaryKeyOfTable(panel.TableName); // Store1.AutoLoadParams.Add(new Ext.Net.Parameter("limit", panel.PageSize.ToString())); //sHdfgridName.Value = this.ID.ToString(); //sHdftable.Value = this.TableName; //sHdfPrimaryKey.Value = panel.PrimaryColumn; //sHdfwhere.Value = panel.WhereClause.Replace("where", ""); //if (this.Height != 0) // GridPanel1.Height = this.Height; //else // GridPanel1.Height = panel.Height.Value; //if (this.Width != 0) // GridPanel1.Width = this.Width; //else // GridPanel1.Width = panel.Width.Value; GenerateListener(); //if (panel.PageSize.HasValue) // PagingToolbar1.PageSize = panel.PageSize.Value; //else // PagingToolbar1.PageSize = 5; if (!string.IsNullOrEmpty(panel.Icon)) { GridPanel1.IconCls = panel.Icon; } else { GridPanel1.Icon = Icon.Table; } //set local filter if (panel.AllowFilter) { GridFilters filter = new GridFilters(); filter.Local = true; filter.FiltersText = "Lọc"; GridPanel1.Plugins.Add(filter); datatable = DataController.DataHandler.GetInstance().ExecuteDataTable("select top 1 * from " + TableName); foreach (DataColumn item in datatable.Columns) { switch (item.DataType.ToString()) { case "System.Int32": NumericFilter numberic = new NumericFilter(); numberic.DataIndex = item.ColumnName; filter.Filters.Add(numberic); break; case "System.Boolean": BooleanFilter boolean = new BooleanFilter(); boolean.DataIndex = item.ColumnName; filter.Filters.Add(boolean); break; case "System.String": StringFilter str = new StringFilter(); str.DataIndex = item.ColumnName; filter.Filters.Add(str); break; case "System.DateTime": DateFilter datefilter = new DateFilter(); datefilter.BeforeText = "Trước ngày"; datefilter.AfterText = "Sau ngày"; datefilter.OnText = "Vào ngày"; datefilter.DataIndex = item.ColumnName; filter.Filters.Add(datefilter); break; } } } }