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