protected override void InitGridColumn() { //GridPanel1.ColumnModel.Columns.Clear(); ColumnCollection columns = GridPanel1.ColumnModel.Columns; ColumnBase col = new RowNumbererColumn(); //columns.Add(col); col = new NumberColumn() { Header = "排序", DataIndex = "orderID", Width = 50, Fixed = true }; (col as NumberColumn).Format = "0"; col.Editor.Add(new NumberField()); columns.Add(col); col = new Column() { Header = "代码", DataIndex = "ProgCode", Width = 80, Fixed = true }; col.Editor.Add(new TextField()); columns.Add(col); col = new Column() { Header = "名称", DataIndex = "ProgName" }; col.Editor.Add(new TextField()); columns.Add(col); col = new Column() { Header = "页面", DataIndex = "ProgClass" }; col.Editor.Add(new TextField()); columns.Add(col); col = new Column() { Header = "小图标", DataIndex = "ProgIcon1", Width = 50, Fixed = true }; col.Editor.Add(new TextField()); columns.Add(col); col = new Column() { Header = "大图标", DataIndex = "ProgIcon2", Width = 50, Fixed = true }; col.Editor.Add(new TextField()); columns.Add(col); col = new Column() { Header = "分类", DataIndex = "IsCore", Width = 40, Fixed = true }; col.Editor.Add(new TextField()); columns.Add(col); col = new Column() { Header = "组", DataIndex = "IsGroup", Width = 30, Fixed = true }; col.Editor.Add(new TextField()); columns.Add(col); }
public virtual void InitHeader(string PanelID, DataListManage datalistMan) { var list = this.GetCmp <GridPanel>(PanelID); var store = this.GetCmp <Store>(PanelID + "_Store"); store.PageSize = AppSettingValues.DATALISTPAGELIMIT; store.RemoveFields(); RowNumbererColumn col = new RowNumbererColumn(); col.Width = 40; list.AddColumn(col); setStoreField(PanelID, "ID", CosDataBase.INT_TYPE); if (PanelID == "BMKSearch_DataList") { for (int i = 0; i < datalistMan.arrColumn.Count; i++) { bool visiable = true; if (((i >= 9) && (i != datalistMan.arrColumn.Count - 1)) || (i == 0)) { visiable = false; } if (i < datalistMan.arrColumn.Count - 1) { setPanelColumn(PanelID, (ColumnModel)datalistMan.arrColumn[i], datalistMan.bSort, 0, visiable); } else { setPanelColumn(PanelID, (ColumnModel)datalistMan.arrColumn[i], datalistMan.bSort, 1, visiable); } setStoreField(PanelID, (ColumnModel)datalistMan.arrColumn[i]); } } else { for (int i = 0; i < datalistMan.arrColumn.Count; i++) { bool visiable = true; if ((i >= 9) && (i != datalistMan.arrColumn.Count - 1)) { visiable = false; } if (i < datalistMan.arrColumn.Count - 1) { setPanelColumn(PanelID, (ColumnModel)datalistMan.arrColumn[i], datalistMan.bSort, 0, visiable); } else { setPanelColumn(PanelID, (ColumnModel)datalistMan.arrColumn[i], datalistMan.bSort, 1, visiable); } setStoreField(PanelID, (ColumnModel)datalistMan.arrColumn[i]); } } list.SortableColumns = true; }
private ColumnBase[] BuildGridPanel(DataTable data) { ColumnBase[] nameFields = new ColumnBase[data.Columns.Count + 1]; nameFields[0] = new RowNumbererColumn(); int count = 1; foreach (DataColumn column in data.Columns) { if (count <= 1) { nameFields[count] = new Column() { Text = column.ColumnName, DataIndex = column.ColumnName, Visible = false }; } else if (count < 4) { nameFields[count] = new Column() { Text = column.ColumnName, DataIndex = column.ColumnName }; } else if (count == 4) { nameFields[count] = new Column() { Text = column.ColumnName, DataIndex = column.ColumnName, Flex = 1 }; } else if (count == 5) { nameFields[count] = new Column() { Text = column.ColumnName, DataIndex = column.ColumnName }; nameFields[count].Renderer.Fn = "change"; } else { nameFields[count] = new Column() { Text = RemoveLastWord(column.ColumnName), DataIndex = column.ColumnName, Editor = { new TextField() } }; nameFields[count].Renderer.Fn = "change"; } count++; } return(nameFields); }
/// <summary> /// 初始化查询 明细列表 /// </summary> /// <param name="grid"></param> public void IniSelectDetailGrid(Ext.Net.GridPanel grid) { #region 分页每页数量 var pagesize = uiHelper.Select.DetailGrid.PageSize; if (pagesize <= 0) { pagesize = 15; } grid.GetStore().PageSize = pagesize; #endregion string prefix = UiControlNamePrefix.SelectDetailGrid; Model model = grid.GetStore().ModelInstance; #region 网格条数信息 int havecount = grid.ColumnModel.Columns.Count; RowNumbererColumn numbercol = new RowNumbererColumn(); numbercol.Width = 40; grid.ColumnModel.Columns.Insert(grid.ColumnModel.Columns.Count - havecount, numbercol); #endregion #region 添加设置字段 foreach (GridColumn column in uiHelper.Select.DetailGrid.Columns) { ModelField mField = new ModelField(); mField.Name = column.ColumnName; if (column.ColumnType == GridColumnType.Date) { mField.Type = ModelFieldType.Date; } model.Fields.Add(mField); if (column.IsShow) { CellCommandColumn cell = IniGridColumn(prefix, column); grid.ColumnModel.Columns.Insert(grid.ColumnModel.Columns.Count - havecount, cell); } } #endregion }
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; } } } }
private void AddColumn() { // remove fields storeEvaluation.RemoveFields(); // column index var colIndex = new RowNumbererColumn { ColumnID = "colIndex", Header = "STT", Align = Alignment.Center, Width = 40 }; gpEvaluation.AddColumn(colIndex); // column employee code var colEmployeeCode = new Column { ColumnID = "colEmployeeCode", Header = "Mã nhân viên", DataIndex = "EmployeeCode", Align = Alignment.Left, Width = 100 }; var recordFieldEmployeeCode = new RecordField() { Name = "EmployeeCode", Mapping = "EmployeeCode" }; storeEvaluation.AddField(recordFieldEmployeeCode); gpEvaluation.AddColumn(colEmployeeCode); // init column employee name var colFullName = new Column { ColumnID = "colFullName", Header = "Họ và tên", DataIndex = "FullName", Align = Alignment.Left, Width = 150 }; var recordFieldFullName = new RecordField() { Name = "FullName", Mapping = "FullName" }; storeEvaluation.AddField(recordFieldFullName); gpEvaluation.AddColumn(colFullName); //init column departmentName var colDepartmentName = new Column { ColumnID = "colDepartmentName", Header = "Đơn vị", DataIndex = "DepartmentName", Align = Alignment.Left, Width = 150 }; var recordFieldDepartmentName = new RecordField() { Name = "DepartmentName", Mapping = "DepartmentName" }; storeEvaluation.AddField(recordFieldDepartmentName); gpEvaluation.AddColumn(colDepartmentName); // get criterion in group var criterionGroups = CriterionGroupController.GetAll(null, null, Convert.ToInt32(hdfGroupFilter.Text), null, null); // init count var count = 0; // add kpi criterion column foreach (var item in criterionGroups) { // init field var recordField = new RecordField() { Name = item.CriterionCode, Mapping = "CriterionDetailModels[{0}].Display".FormatWith(count++) }; // init column var col = new Column { ColumnID = recordField.Name, Header = item.CriterionName, DataIndex = recordField.Name, Align = Alignment.Center, Width = 150, Renderer = { Fn = "RenderCriterion" } }; // add field storeEvaluation.AddField(recordField); // add column gpEvaluation.AddColumn(col); } }
/// <summary> /// 初始化查询主界面项 /// </summary> /// <param name="grid"></param> public void IniSelectMainGrid(Ext.Net.GridPanel grid) { #region 分页每页数量 var pagesize = uiHelper.Select.MainGrid.PageSize; if (pagesize <= 0) { pagesize = 15; } grid.GetStore().PageSize = pagesize; #endregion string prefix = UiControlNamePrefix.SelectMainGrid; Model model = grid.GetStore().ModelInstance; #region 网格条数信息 int havecount = grid.ColumnModel.Columns.Count; RowNumbererColumn numbercol = new RowNumbererColumn(); numbercol.Width = 40; grid.ColumnModel.Columns.Insert(grid.ColumnModel.Columns.Count - havecount, numbercol); #endregion #region 添加特殊字段 if (uiHelper.UiData.Crud.Primarykey != null && !string.IsNullOrWhiteSpace(uiHelper.UiData.Crud.Primarykey.FieldName)) { IniAddGridColumn(prefix, uiHelper.UiData.Crud.Primarykey.FieldName, havecount, grid); } IniAddGridColumn(prefix, uiHelper.UiData.Crud.DeleteFlag, havecount, grid); #endregion #region 添加设置字段 foreach (GridColumn column in uiHelper.Select.MainGrid.Columns) { ModelField mField = new ModelField(); mField.Name = column.ColumnName; if (column.ColumnType == GridColumnType.Date) { mField.Type = ModelFieldType.Date; } model.Fields.Add(mField); if (column.IsShow) { CellCommandColumn cell = IniGridColumn(prefix, column); grid.ColumnModel.Columns.Insert(grid.ColumnModel.Columns.Count - havecount, cell); } } #endregion #region 更新显示按钮 if (uiHelper.Update.Panel.ParamFields.Count > 0) { return; } int commandcount = 0; if (uiHelper.Select.MainDetail.ParamFields.Count > 0) { commandcount++; } if (uiHelper.Select.DetailGrid.Columns.Count > 0) { commandcount++; } if (commandcount == 0) { return; } CommandColumn commandColumn = new CommandColumn(); commandColumn.ID = "commandColumnShowDetail"; commandColumn.Width = commandcount * 86; commandColumn.Text = "查看"; commandColumn.Align = Alignment.Center; int _command = commandColumn.Commands.Count; if (uiHelper.Select.MainDetail.ParamFields.Count > 0) { GridCommand command = new GridCommand(); command.Icon = Icon.TableColumn; command.Text = "详细信息"; command.CommandName = "ShowFieldsInfo"; commandColumn.Commands.Add(command); commandColumn.Listeners.Command.Fn = "showdetailcommandcolumn_click"; } if (commandColumn.Commands.Count > _command) { commandColumn.Commands.Add(new CommandSeparator()); _command = commandColumn.Commands.Count; } if (uiHelper.Select.DetailGrid.Columns.Count > 0) { GridCommand command = new GridCommand(); command.Icon = Icon.TableColumn; command.Text = "明细信息"; command.CommandName = "ShowDetail"; commandColumn.Commands.Add(command); commandColumn.Listeners.Command.Fn = "showdetailcommandcolumn_click"; } grid.ColumnModel.Columns.Add(commandColumn); #endregion }
/// <summary> /// /// </summary> private void AddColumn() { // remove fields storeInsurance.RemoveFields(); var view = gpInsurance.View[0]; //init group header var headerGroupRow = new HeaderGroupRow(); //add column group header headerGroupRow.Columns.Add(new HeaderGroupColumn { Header = "", ColSpan = 4, Align = Alignment.Center }); // column index var colIndex = new RowNumbererColumn { ColumnID = "colIndex", Header = "STT", Align = Alignment.Center, Width = 40 }; gpInsurance.ColumnModel.Columns.Add(colIndex); // init column employee name var colFullName = new Column { ColumnID = "colFullName", Header = "Họ và tên", DataIndex = "FullName", Align = Alignment.Left, Width = 150 }; var recordFieldFullName = new RecordField() { Name = "FullName", Mapping = "FullName" }; storeInsurance.AddField(recordFieldFullName); gpInsurance.ColumnModel.Columns.Add(colFullName); // column employee code var colEmployeeCode = new Column { ColumnID = "colEmployeeCode", Header = "Mã nhân viên", DataIndex = "EmployeeCode", Align = Alignment.Left, Width = 100 }; var recordFieldEmployeeCode = new RecordField() { Name = "EmployeeCode", Mapping = "EmployeeCode" }; storeInsurance.AddField(recordFieldEmployeeCode); gpInsurance.ColumnModel.Columns.Add(colEmployeeCode); //init column departmentName var colDepartmentName = new Column { ColumnID = "colDepartmentName", Header = "Đơn vị", DataIndex = "DepartmentName", Align = Alignment.Left, Width = 150 }; var recordFieldDepartmentName = new RecordField() { Name = "DepartmentName", Mapping = "DepartmentName" }; storeInsurance.AddField(recordFieldDepartmentName); gpInsurance.ColumnModel.Columns.Add(colDepartmentName); // init count var count = 0; var products = new string[] { "Công ty đóng", "Người LĐ đóng" }; // add column by month for (var i = 0; i < 12; i++) { //add group header headerGroupRow.Columns.Add(new HeaderGroupColumn { Header = @"Tháng {0}".FormatWith(i + 1), ColSpan = products.Length, Align = Alignment.Center }); // init field var recordField = new RecordField() { Name = "Month{0}".FormatWith(i + 1), Mapping = "InsuranceDetailModels[{0}]".FormatWith(count++) }; foreach (var product in products) { var value = "EnterpriseSocial"; if (product == @"Công ty đóng") { value = "EnterpriseSocial"; } else { value = "LaborerSocial"; } // init column var col = new Column { ColumnID = value, Header = product, DataIndex = recordField.Name, Align = Alignment.Left, Width = 150, Renderer = { Fn = "RenderMonth" } }; // add column gpInsurance.ColumnModel.Columns.Add(col); } // add field storeInsurance.AddField(recordField); } //add header group row view.HeaderGroupRows.Add(headerGroupRow); }