// Создание фиксированного набора колонок protected void CreateFixedColumn() { MilestoneReportData tmp; var column = new GridViewDataTextColumn { Caption = @" ", Name = nameof(tmp.Prd), FieldName = nameof(tmp.Prd), Width = Unit.Pixel(40) }; this.MSGridView.Columns.Add(column); column = new GridViewDataTextColumn { Caption = @"№", Name = nameof(tmp.Dog), FieldName = nameof(tmp.Dog), Width = Unit.Pixel(50) }; this.MSGridView.Columns.Add(column); column = new GridViewDataTextColumn { Caption = @"Ст.", Name = nameof(tmp.Ct), FieldName = nameof(tmp.Ct), Width = Unit.Pixel(50) }; this.MSGridView.Columns.Add(column); column = new GridViewDataTextColumn { Caption = @"Наменование", Name = nameof(tmp.Npr), FieldName = nameof(tmp.Npr), Width = Unit.Pixel(300) }; this.MSGridView.Columns.Add(column); column = new GridViewDataTextColumn { Caption = @"График в<br>MSProject", Name = $"{nameof(tmp.MsProjectInfo)}.{nameof(tmp.MsProjectInfo.IsExists)}", FieldName = $"{nameof(tmp.MsProjectInfo)}.{nameof(tmp.MsProjectInfo.IsExists)}", Width = Unit.Pixel(80) }; this.MSGridView.Columns.Add(column); }
private void AddTextColumn(string fieldName) { GridViewDataTextColumn c = new GridViewDataTextColumn(); c.FieldName = fieldName; grid.Columns.Add(c); }
protected void btnXlsExport_Click(object sender, EventArgs e) { ASPxGridView1.Columns.RemoveAt(26); ASPxGridView1.Columns.RemoveAt(25); ASPxGridView1.Columns.RemoveAt(24); ASPxGridView1.Columns.RemoveAt(23); ASPxGridView1.Columns.RemoveAt(22); ASPxGridView1.Columns.RemoveAt(21); ASPxGridView1.Columns.RemoveAt(20); ASPxGridView1.Columns.RemoveAt(19); ASPxGridView1.Columns.RemoveAt(18); ASPxGridView1.Columns.RemoveAt(17); ASPxGridView1.Columns.RemoveAt(16); ASPxGridView1.Columns.RemoveAt(15); ASPxGridView1.Columns.RemoveAt(14); ASPxGridView1.Columns.RemoveAt(13); ASPxGridView1.Columns.RemoveAt(12); ASPxGridView1.Columns.RemoveAt(11); GridViewDataTextColumn d3 = new GridViewDataTextColumn(); d3.Caption = "客户"; d3.VisibleIndex = 7; d3.FieldName = "CUSTOMER_NAME"; ASPxGridView1.Columns.Add(d3); GridViewDataTextColumn d1 = new GridViewDataTextColumn(); d1.Caption = "备注"; d1.VisibleIndex = 17; d1.FieldName = "REMARK"; ASPxGridView1.Columns.Add(d1); ASPxGridViewExporter1.WriteXlsToResponse("导出计划"); }
private void InitSubjectList() { ucListManager.ID = "SubjectList"; ucListManager.IsChildList = false; ucListManager.ListLabel = "Subject List"; ucListManager.AllowEditAll = true; ucListManager.GridPageSize = 30; ucListManager.NeedListInstances += new NeedListInstancesEventHandler(ucListManager_NeedListInstances); GridViewHyperLinkColumn hc = new GridViewHyperLinkColumn(); ucListManager.Columns.Add(hc); hc.Caption = "Subject Type"; hc.DataTextField = SubjectDto.FLD_SubjectType; hc.DataNavigateUrlFormatString = string.Format("{0}?{1}={{0}}", ServerPath + SubjectManager.PageUrl, SubjectManager.QrySubjectId); hc.DataNavigateUrlFields = new string[] { SubjectDto.FLD_StringId }; ucListManager.Columns.Add(new GridViewDataTextColumn("Subject Label", SubjectDto.FLD_SubjectLabel)); ucListManager.Columns.Add(new GridViewDataTextColumn("SubjectId Field", SubjectDto.FLD_SubjectIdField)); ucListManager.Columns.Add(new GridViewDataTextColumn("MasterSubjectId Field", SubjectDto.FLD_MasterSubjectIdField)); ucListManager.Columns.Add(new GridViewDataCheckColumn("Allow ListAdd", SubjectDto.FLD_AllowListAdd)); ucListManager.Columns.Add(new GridViewDataCheckColumn("Is AddInGrid", SubjectDto.FLD_IsAddInGrid)); ucListManager.Columns.Add(new GridViewDataCheckColumn("Allow ListEdit", SubjectDto.FLD_AllowListEdit)); ucListManager.Columns.Add(new GridViewDataCheckColumn("Is Grid InForm Edit", SubjectDto.FLD_IsGridInFormEdit)); ucListManager.Columns.Add(new GridViewDataCheckColumn("Allow ListDelete", SubjectDto.FLD_AllowListDelete)); ucListManager.Columns.Add(new GridViewDataCheckColumn("Allow ListFiltering", SubjectDto.FLD_AllowListFiltering)); GridViewDataTextColumn rc = new GridViewDataTextColumn("RowIndex Max", SubjectDto.FLD_RowIndexMax); ucListManager.Columns.Add(rc); rc.IsReadOnly = true; GridViewDataTextColumn cc = new GridViewDataTextColumn("ColIndex Max", SubjectDto.FLD_ColIndexMax); ucListManager.Columns.Add(cc); cc.IsReadOnly = true; }
private void CreateDetailColumns(ASPxGridView detailGrid) { GridViewCommandColumn colCmd = new GridViewCommandColumn(); colCmd.ShowEditButton = true; colCmd.ShowNewButton = true; colCmd.ShowDeleteButton = true; detailGrid.Columns.Add(colCmd); GridViewDataColumn colProductID = new GridViewDataColumn(); colProductID.FieldName = "ProductID"; colProductID.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; detailGrid.Columns.Add(colProductID); detailGrid.Columns.Add(new GridViewDataColumn("ProductName")); GridViewDataTextColumn colCategoryID = new GridViewDataTextColumn(); colCategoryID.FieldName = "CategoryID"; colCategoryID.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; detailGrid.Columns.Add(colCategoryID); detailGrid.Columns.Add(new GridViewDataColumn("UnitPrice")); GridViewDataCheckColumn colDiscontinued = new GridViewDataCheckColumn(); colDiscontinued.FieldName = "Discontinued"; detailGrid.Columns.Add(colDiscontinued); }
private void GetTitle() { gridview.GetTitle(ASPxGridView1, tablename); ReportData rep = new ReportData(); DataTable dt = rep.Report5_1(); for (int i = 0; i < dt.Rows.Count; i++) { GridViewDataTextColumn col = new GridViewDataTextColumn(); col.FieldName = dt.Rows[i]["cInvCName"].ToString(); col.Caption = dt.Rows[i]["cInvCName"].ToString(); ASPxGridView1.Columns.Add(col); ASPxSummaryItem sum = new ASPxSummaryItem(); sum.SummaryType = DevExpress.Data.SummaryItemType.Sum; sum.FieldName = dt.Rows[i]["cInvCName"].ToString(); sum.DisplayFormat = "{0,2}"; ASPxGridView1.TotalSummary.Add(sum); //ASPxSummaryItem sum = new ASPxSummaryItem(); //sum.FieldName = dt.Rows[i]["cInvCName"].ToString(); //sum.SummaryType = DevExpress.Data.SummaryItemType.Sum; //ASPxGridView1.TotalSummary.Add(sum); } //GridViewDataTextColumn col1 = new GridViewDataTextColumn(); //col1.FieldName = "合计"; //col1.Caption = "合计"; //ASPxGridView1.Columns.Add(col1); //GridViewDataTextColumn col2 = new GridViewDataTextColumn(); //col2.FieldName = "百分比"; //col2.Caption = "百分比"; //ASPxGridView1.Columns.Add(col2); }
protected override object CreateControlsCore() { grid = new ASPxGridView(); grid.ID = Model.Id; foreach (var c in Model.Columns.Where(x => x.Index > -1)) { var column = new GridViewDataTextColumn(); column.FieldName = c.PropertyName; column.Caption = c.Caption; grid.Columns.Add(column); } grid.KeyFieldName = Model.ModelClass.KeyProperty; grid.SettingsEditing.Mode = GridViewEditingMode.Batch; var m = this.Model as IModelListViewNewItemRow; if (m != null && m.NewItemRowPosition != NewItemRowPosition.None) { grid.SettingsEditing.NewItemRowPosition = m.NewItemRowPosition == NewItemRowPosition.Bottom ? GridViewNewItemRowPosition.Bottom : GridViewNewItemRowPosition.Top; // GridViewNewItemRowPosition.Top; } grid.Templates.StatusBar = new StatusBarTemplate(grid); grid.ClientInstanceName = grid.ID; return(grid); }
public override void InitGridLookup(ASPxGridLookup gridlookup) { gridlookup.KeyFieldName = "BillId"; gridlookup.TextFormatString = "{0}"; gridlookup.Columns.Clear(); GridViewColumn selectionColumn = new GridViewCommandColumn() { ShowSelectCheckbox = true, VisibleIndex = 0 }; GridViewColumn codeColumn = new GridViewDataTextColumn() { ShowInCustomizationForm = true, FieldName = "Code", Caption = "Số phiếu bán", VisibleIndex = 1 }; GridViewColumn nameColumn = new GridViewDataTextColumn() { ShowInCustomizationForm = true, FieldName = "IssuedDate", Caption = "Ngày", VisibleIndex = 2 }; gridlookup.Columns.Add(selectionColumn); gridlookup.Columns.Add(codeColumn); gridlookup.Columns.Add(nameColumn); }
protected override void OnViewControlsCreated() { base.OnViewControlsCreated(); // Access and customize the target View control. // Thêm số thứ tự ListView dv = (ListView)View; ASPxGridListEditor gridListEditor = dv.Editor as ASPxGridListEditor; if (gridListEditor != null) { ASPxGridView gridView = gridListEditor.Grid; // reset the VisibleIndxe start from 1, 0 will be use for ItemNo for (int j = gridView.VisibleColumns.Count - 1; j >= 0; j--) { if (gridView.VisibleColumns[j].VisibleIndex > 0) { gridView.VisibleColumns[j].VisibleIndex = gridView.VisibleColumns[j].VisibleIndex + 1; } } // to add the ItemNo for each row if (gridView.Columns["itemNo"] == null) { GridViewDataTextColumn itemNo = new GridViewDataTextColumn(); itemNo.Caption = "STT"; itemNo.ReadOnly = true; itemNo.UnboundType = UnboundColumnType.String; itemNo.Width = 32; gridView.Columns.Add(itemNo); itemNo.VisibleIndex = 1; } gridView.CustomColumnDisplayText += GridView_CustomColumnDisplayText;; } }
private void LoadColumns(bool isProvider) { GrLookProvider.GridView.Columns.Clear(); GridViewColumn column1 = new GridViewBandColumn(); GridViewColumn column2 = new GridViewBandColumn(); if (isProvider) { ASPxLabel2.Text = "Proveedor:"; column1 = new GridViewDataTextColumn { FieldName = "CODE_PROVIDER", Caption = "Codigo" }; GrLookProvider.GridView.Columns.Add(column1); column2 = new GridViewDataTextColumn { FieldName = "NAME_PROVIDER", Caption = "Nombre" }; GrLookProvider.GridView.Columns.Add(column2); GrLookProvider.KeyFieldName = "CODE_PROVIDER"; } else { ASPxLabel2.Text = "Cliente:"; column1 = new GridViewDataTextColumn { FieldName = "CODE_CUSTOMER", Caption = "Codigo" }; GrLookProvider.GridView.Columns.Add(column1); column2 = new GridViewDataTextColumn { FieldName = "NAME_CUSTOMER", Caption = "Nombre Cliente" }; GrLookProvider.GridView.Columns.Add(column2); GrLookProvider.KeyFieldName = "CODE_CUSTOMER"; } }
public void grid_header() { GridViewBandColumn bandColumn; GridViewDataTextColumn fieldColumn = new GridViewDataTextColumn { FieldName = "stt", Caption = "Số TT" }; GridView_S04b4DN.Columns.Add(fieldColumn); fieldColumn = new GridViewDataTextColumn { FieldName = "tk_no", Caption = "Các TK ghi nợ" }; GridView_S04b4DN.Columns.Add(fieldColumn); bandColumn = new GridViewBandColumn("Các TK ghi có"); foreach (string column_name in list_header()) { fieldColumn = new GridViewDataTextColumn { FieldName = column_name, Caption = column_name }; fieldColumn.PropertiesEdit.DisplayFormatString = "#,#"; bandColumn.Columns.Add(fieldColumn); } fieldColumn = new GridViewDataTextColumn { FieldName = "cong_tt", Caption = "Tổng cộng" }; fieldColumn.PropertiesEdit.DisplayFormatString = "#,#"; bandColumn.Columns.Add(fieldColumn); GridView_S04b4DN.Columns.Add(bandColumn); }
public void GridView_header(int FinancialAccountDimId) { try { GridViewDataTextColumn GVDTC = new GridViewDataTextColumn(); FinancialAccountDim FAD = session.GetObjectByKey <FinancialAccountDim>(FinancialAccountDimId); if (FAD != null) { GVDTC = new GridViewDataTextColumn { FieldName = "TK", Caption = "Ghi Có các TK, đối xứng Nợ TK " + FAD.Code }; xGridView.Columns.Add(GVDTC); for (int i = 1; i <= 12; i++) { GVDTC = new GridViewDataTextColumn { FieldName = i.ToString(), Caption = "Tháng " + i }; GVDTC.PropertiesEdit.DisplayFormatString = ("#,#"); xGridView.Columns.Add(GVDTC); } } } catch (Exception) { } }
private void CreateGrid() { ASPxGridView grid = new ASPxGridView(); grid.ID = "grid"; this.Form.Controls.Add(grid); grid.EnableCallBacks = false; grid.KeyFieldName = "Id"; grid.DataBinding += grid_DataBinding; grid.RowDeleting += grid_RowDeleting; grid.RowUpdating += grid_RowUpdating; grid.RowInserting += grid_RowInserting; grid.DataBound += grid_DataBound; grid.RowValidating += new ASPxDataValidationEventHandler(grid_RowValidating); grid.DataBind(); if (!this.IsPostBack) { GridViewCommandColumn c = new GridViewCommandColumn(); grid.Columns.Add(c); c.ShowEditButton = true; c.ShowUpdateButton = true; c.ShowNewButtonInHeader = true; } GridViewDataTextColumn col = grid.Columns["Id"] as GridViewDataTextColumn; col.PropertiesTextEdit.ValidationSettings.RegularExpression.ValidationExpression = "\\d{1,9}"; }
public override void InitGridLookup(ASPxGridLookup gridlookup) { gridlookup.KeyFieldName = "OrganizationId"; gridlookup.TextFormatString = "{0} - {1}"; gridlookup.Columns.Clear(); GridViewColumn selectionColumn = new GridViewCommandColumn() { ShowSelectCheckbox = true, VisibleIndex = 0 }; GridViewColumn codeColumn = new GridViewDataTextColumn() { ShowInCustomizationForm = true, FieldName = "Code", Caption = "Mã khách hàng", VisibleIndex = 1 }; GridViewColumn nameColumn = new GridViewDataTextColumn() { ShowInCustomizationForm = true, FieldName = "Name", Caption = "Tên khách hàng", VisibleIndex = 2 }; gridlookup.Columns.Add(selectionColumn); gridlookup.Columns.Add(codeColumn); gridlookup.Columns.Add(nameColumn); }
public virtual void Custom_GridView() { if (this.MyGV == null) { return; } var gvData = this.MyGV; // Thiết lập chung... gvData.ClientInstanceName = this.MyClientInstanceName; try { var arrColumn = this.MySett.Columns.Where(p => !string.IsNullOrEmpty(p.FieldName)) .OrderBy(p => p.VisibleIndex); gvData.Width = new Unit(arrColumn.Sum(p => p.Width + 50), UnitType.Pixel); // Xóa các Column dữ liệu gvData.Columns.Clear(); // Thêm cột số thứ tự var colLine = new GridViewDataTextColumn { Name = "colLine", Caption = "No", FieldName = "#", VisibleIndex = 0, Width = new Unit(50, UnitType.Pixel), UnboundType = DevExpress.Data.UnboundColumnType.Integer, }; gvData.KeyFieldName = "#"; gvData.SettingsBehavior.AllowFocusedRow = true; gvData.SettingsBehavior.EnableRowHotTrack = true; if (!this.IsDemo) { gvData.SettingsBehavior.AllowSort = true; gvData.SettingsBehavior.AllowDragDrop = false; } gvData.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Disabled; colLine.PropertiesTextEdit.DisplayFormatString = "#,##0"; colLine.HeaderStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; colLine.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; gvData.Columns.Add(colLine); var lstFields = this.MySett.Get_ColumnFields(); foreach (var field in arrColumn) { var col = new GridViewDataTextColumn(); col.Name = field.Name; col.Caption = field.Caption; var objField = lstFields.FirstOrDefault(p => p.Prop2 == field.FieldName); col.FieldName = objField.Prop3; col.VisibleIndex = field.VisibleIndex; col.Width = new Unit(field.Width, UnitType.Pixel); col.CellStyle.HorizontalAlign = field.Align; col.PropertiesEdit.DisplayFormatString = field.DisplayF; this.FormatGridColumn(col, objField.Prop1); gvData.Columns.Add(col); } } catch { } }
public void grid_header() { GridViewBandColumn bandColumn; GridViewDataTextColumn fieldColumn = new GridViewDataTextColumn { FieldName = "stt", Caption = "Số TT" }; GridView_S12DN.Columns.Add(fieldColumn); fieldColumn = new GridViewDataTextColumn { FieldName = "date", Caption = "Ngày tháng" }; GridView_S12DN.Columns.Add(fieldColumn); bandColumn = new GridViewBandColumn("Số hiệu chứng từ"); fieldColumn = new GridViewDataTextColumn { FieldName = "nhap_dau", Caption = "Nhập" }; fieldColumn.PropertiesEdit.DisplayFormatString = "#,#"; bandColumn.Columns.Add(fieldColumn); fieldColumn = new GridViewDataTextColumn { FieldName = "xuat_dau", Caption = "Xuất" }; fieldColumn.PropertiesEdit.DisplayFormatString = "#,#"; bandColumn.Columns.Add(fieldColumn); GridView_S12DN.Columns.Add(bandColumn); fieldColumn = new GridViewDataTextColumn { FieldName = "dien_giai", Caption = "Diễn giải" }; GridView_S12DN.Columns.Add(fieldColumn); fieldColumn = new GridViewDataTextColumn { FieldName = "date_nhap_xuat", Caption = "Ngày nhập xuất" }; GridView_S12DN.Columns.Add(fieldColumn); bandColumn = new GridViewBandColumn("Số lượng"); fieldColumn = new GridViewDataTextColumn { FieldName = "nhap_cuoi", Caption = "Nhập" }; fieldColumn.PropertiesEdit.DisplayFormatString = "#,#"; bandColumn.Columns.Add(fieldColumn); fieldColumn = new GridViewDataTextColumn { FieldName = "xuat_cuoi", Caption = "Xuất" }; fieldColumn.PropertiesEdit.DisplayFormatString = "#,#"; bandColumn.Columns.Add(fieldColumn); fieldColumn = new GridViewDataTextColumn { FieldName = "ton_cuoi", Caption = "Tồn" }; fieldColumn.PropertiesEdit.DisplayFormatString = "#,#"; bandColumn.Columns.Add(fieldColumn); GridView_S12DN.Columns.Add(bandColumn); fieldColumn = new GridViewDataTextColumn { FieldName = "ky", Caption = "Ký xác nhận của kế toán" }; GridView_S12DN.Columns.Add(fieldColumn); }
private GridViewDataTextColumn createGrid(string caption, string fieldName) { GridViewDataTextColumn g = new GridViewDataTextColumn(); g.Caption = caption; g.FieldName = fieldName; return(g); }
private object GetColor() { GridViewDataTextColumn col = grid.Columns["DxColor"] as GridViewDataTextColumn; ASPxColorEdit colorEdit = grid.FindEditRowCellTemplateControl(col, "colorEdit") as ASPxColorEdit; Color color = colorEdit.Color; return(color.ToArgb().ToString()); }
private void initializeGridView() { GridViewDataTextColumn column; column = new GridViewDataTextColumn() { FieldName = "AttributeKey", Caption = "AttributeKey" }; column.PropertiesEdit.DisplayFormatString = base.DateOutputFormat; gdvPartyAttribute.Columns.Add(column); column = new GridViewDataTextColumn() { Name = "EffectiveFrom", Caption = ResGeneral.EffectiveFrom }; column.PropertiesEdit.DisplayFormatString = base.DateOutputFormat; gdvPartyAttribute.Columns.Add(column); column = new GridViewDataTextColumn() { Name = "EffectiveTo", Caption = ResGeneral.EffectiveTo }; column.PropertiesEdit.DisplayFormatString = base.DateOutputFormat; gdvPartyAttribute.Columns.Add(column); gdvPartyAttribute.ClientSideEvents.EndCallback = @" function(s,e) { var objs = eval('(' + s." + KEY_CP_RESULT + @" + ')'); if(objs == null)return; if(objs.Message != '') { alert(objs.Message); } var index = s.GetFocusedRowIndex(); if(index > -1) { " + btnAdd.ClientInstanceName + @".SetEnabled(true); " + cbpEdit.ClientInstanceName + @".PerformCallback('" + KEY_DISPLAY + @";' + index); }else { " + cbpEdit.ClientInstanceName + @".PerformCallback('" + KEY_DISPLAY + @"'); } //" + hddPartyAttribute.ClientInstanceName + @".Set('" + HKEY_VALUE_IMG + @"', ''); s." + KEY_CP_RESULT + @" = null; } "; gdvPartyAttribute.ClientSideEvents.FocusedRowChanged = @"function(s,e) { if(typeof(" + cbpEdit.ClientInstanceName + @") != 'undefined' && " + cbpEdit.ClientInstanceName + @" != null) { var index = s.GetFocusedRowIndex(); if(index > -1) { " + btnExpire.ClientInstanceName + @".SetEnabled(false); " + cbpEdit.ClientInstanceName + @".PerformCallback('" + KEY_DISPLAY + @";' + index); } } }"; }
private GridViewDataTextColumn createGrid(string caption, string fieldName, string columnFormat) { GridViewDataTextColumn g = new GridViewDataTextColumn(); g.Caption = caption; g.FieldName = fieldName; g.PropertiesTextEdit.DisplayFormatString = columnFormat; return(g); }
/// <summary> /// Returns <see cref="GridViewEditDataColumn"/> instance based on meta data passed in column argument. /// </summary> /// <param name="column">An instance of <see cref="ColumnMeta"/> containing meta data of column to be created.</param> /// <param name="connectionString">Connection string to underlying database.</param> /// <returns></returns> internal static GridViewEditDataColumn AddGridViewDataColumn(ColumnMeta column, string connectionString) { GridViewEditDataColumn dataColumn = null; // As per 11 Oct 2016, the following evaluation criteria for data type and its column editor are not yet complete. // We still has some works to do to deal with picture and blob/document. (--github.com/ganagus) // --- if ((new TypeCode[] { TypeCode.String, TypeCode.Int64, TypeCode.Int32, TypeCode.Single, TypeCode.Decimal }) .Contains(column.DataType) && !column.IsForeignKey && string.IsNullOrEmpty(column.EnumTypeName)) { // regular text column, editor => text box dataColumn = AddGridViewDataTextColumn(column, dataColumn); } else if (!string.IsNullOrEmpty(column.EnumTypeName)) { // enum data type column, editor => check box dataColumn = AddGridViewEnumColumn(column, dataColumn); } // foreign key should be rendered in combo box column else if (column.IsForeignKey) { // foreign key column, it's a look up to other table, editor => combo box dataColumn = AddGridViewForeignKeyColumn(column, dataColumn, connectionString); } else if (column.DataType == TypeCode.DateTime) { // date / datetime column, editor => DevExpress date editor dataColumn = new GridViewDataDateColumn(); if (column.Name.ToLower() == "createddate" || column.Name.ToLower() == "modifieddate") { //hide createdby, createddate, modifiedby, modifieddate from edit form //dataColumn.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; } } else if (column.DataType == TypeCode.Boolean) { // boolean column, editor => check box dataColumn = new GridViewDataCheckColumn(); } else { // other data type, default to text box dataColumn = new GridViewDataTextColumn(); } if (column.IsIdentity) { dataColumn.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; } dataColumn.FieldName = column.Name; dataColumn.Caption = column.Caption; dataColumn.VisibleIndex = column.OrderNo; return(dataColumn); }
private void AddColumnsFondAmortizationGrid() { var columnInventory = new GridViewDataTextColumn { FieldName = "Inventory", Caption = "Инв. №", VisibleIndex = 0, Width = 110 }; var columnName = new GridViewDataTextColumn { FieldName = "NameFond", Caption = "Наименование ОС", VisibleIndex = 1 }; var columnNameGroup = new GridViewDataTextColumn { FieldName = "NameGroup", Caption = "Группа", VisibleIndex = 2 }; var columnSpir = new GridViewDataTextColumn { FieldName = "Spir", Caption = "Ост. СПИ", VisibleIndex = 3 }; var columnIsFiled = new GridViewDataTextColumn { FieldName = "IsFilled", Caption = "Заполнен", VisibleIndex = 4, Visible = false}; gridFondSpi.Columns.AddRange(columnInventory, columnName, columnNameGroup, columnSpir, columnIsFiled); }
protected void Page_Load(object sender, EventArgs e) { string DSN = "PostgreSQL30"; OdbcConnection connection = new OdbcConnection("Dsn=" + DSN); loginErrorLabel.Text = "State: " + connection.State.ToString(); string query = "SELECT * FROM q1;"; GridViewDataTextColumn myCol0 = new GridViewDataTextColumn(); GridViewDataTextColumn myCol1 = new GridViewDataTextColumn(); GridViewDataTextColumn myCol2 = new GridViewDataTextColumn(); GridViewDataTextColumn myCol3 = new GridViewDataTextColumn(); try { OdbcDataAdapter adapter = new OdbcDataAdapter(query, connection); DataTable dt = new DataTable(); connection.Open(); adapter.Fill(dt); myCol0.FieldName = dt.Columns[0].ColumnName; myCol0.VisibleIndex = 0; myCol1.FieldName = dt.Columns[1].ColumnName; myCol1.VisibleIndex = 1; myCol2.FieldName = dt.Columns[2].ColumnName; myCol2.VisibleIndex = 2; myCol3.FieldName = dt.Columns[3].ColumnName; myCol3.VisibleIndex = 3; grid.Columns.Clear(); grid.Columns.Add(myCol0); grid.Columns.Add(myCol1); grid.Columns.Add(myCol2); grid.Columns.Add(myCol3); grid.DataSource = dt; grid.DataBind(); Chart1.DataSource = dt; Chart1.DataBind(); Chart1.Series["Series1"].XValueMember = dt.Columns[0].ColumnName; Chart1.Series["Series1"].YValueMembers = dt.Columns[2].ColumnName; Chart1.ChartAreas["ChartArea1"].AxisY.Title = dt.Columns[2].ColumnName; Chart1.ChartAreas["ChartArea1"].AxisX.Title = "Time Stamp"; //connection.Close(); } catch (Exception exp) { loginErrorLabel.Text = exp.Message; } }
protected void Page_Load(object sender, EventArgs e) { LogCallMethod(true); if (!IsPostBack) { NavControl1.gv = gvStockImport.gridControl; GridViewDataTextColumn A4 = new GridViewDataTextColumn(); A4.Caption = "In A4"; A4.VisibleIndex = 13; A4.DataItemTemplate = new MyHyperlinkTemplate(); gvStockImport.gridControl.Columns.Add(A4); } LogCallMethod(false); }
private void AddColumnsGridPostingLoadBalance() { var columnDescription = new GridViewDataTextColumn { FieldName = "EventName", Caption = "Проводки", VisibleIndex = 1 }; var columnDateEvent = new GridViewDataTextColumn { FieldName = "DateEvent", Caption = "Дата сброса", VisibleIndex = 2 }; var columnFilePath = new GridViewDataTextColumn { FieldName = "NamePostingFile", Caption = "Имя файла", VisibleIndex = 3 }; var columnMonth = new GridViewDataTextColumn { FieldName = "Month", Caption = "Месяц", VisibleIndex = 4 }; var columnYear = new GridViewDataTextColumn { FieldName = "Year", Caption = "Год", VisibleIndex = 5 }; var columnFioUser = new GridViewDataTextColumn { FieldName = "FioUser", Caption = "ФИО пользователя", VisibleIndex = 6 }; var columnIsSuccessfully = new GridViewDataTextColumn { FieldName = "IsSuccessfully", Caption = "Успешно", VisibleIndex = 7 }; var columnMessage = new GridViewDataTextColumn { FieldName = "Message", Caption = "Сообщение", VisibleIndex = 8 }; gridPostingLoadBalance.Columns.AddRange(columnDescription,columnDateEvent,columnFilePath, columnMonth, columnYear, columnFioUser, columnIsSuccessfully, columnMessage); }
public void PopulateColumns() { GridViewDataTextColumn colID = new GridViewDataTextColumn(); colID.FieldName = "ID"; ASPxGridView1.Columns.Add(colID); GridViewDataTextColumn colItemTemplate = new GridViewDataTextColumn(); colItemTemplate.DataItemTemplate = new MyHyperlinkTemplate(); // Create a template colItemTemplate.Name = "colItemTemplate"; colItemTemplate.Caption = "Template Column"; ASPxGridView1.Columns.Add(colItemTemplate); }
public void PopulateColumns() { GridViewDataTextColumn colID = new GridViewDataTextColumn(); colID.FieldName = "ID"; ASPxGridView1.Columns.Add(colID); GridViewDataHyperLinkColumn colItemName = new GridViewDataHyperLinkColumn(); colItemName.FieldName = "ItemName"; colItemName.PropertiesHyperLinkEdit.NavigateUrlFormatString = "~/details.aspx?Device={0}"; colItemName.PropertiesHyperLinkEdit.TextFormatString = "Get details about device {0}"; colItemName.PropertiesHyperLinkEdit.TextField = "ItemName"; ASPxGridView1.Columns.Add(colItemName); }
protected void grid_DataBound(object sender, EventArgs e) { ASPxGridView g = sender as ASPxGridView; for (int i = 0; i < g.Columns.Count; i++) { GridViewDataTextColumn c = g.Columns[i] as GridViewDataTextColumn; if (c == null) { continue; } c.PropertiesTextEdit.ValidationSettings.RequiredField.IsRequired = true; } }
private void ReCreateColumns() { ASPxGridView1.Columns.Clear(); DataTable table = GetCurrentTable(); foreach (DataColumn dataColumn in table.Columns) { GridViewDataTextColumn column = new GridViewDataTextColumn(); column.FieldName = dataColumn.ColumnName; // set additional column properties column.Caption = dataColumn.ColumnName; ASPxGridView1.Columns.Add(column); } }
protected void gdvPayments_Init(object sender, EventArgs e) { ASPxGridView gdv = (ASPxGridView)sender; GridViewDataTextColumn column = gdv.Columns["Amount"] as GridViewDataTextColumn; if (column != null) { column.PropertiesEdit.DisplayFormatString = base.CurrencyFormat; } gdv.TotalSummary.Add(new ASPxSummaryItem("Amount", DevExpress.Data.SummaryItemType.Sum) { DisplayFormat = base.CurrencyFormat }); gdv.Templates.PreviewRow = new PaymentTemplate(iSabayaContext); }
protected override void AddGridViewColumns(DevExpress.Web.ASPxGridLookup.ASPxGridLookup control) { GridViewDataTextColumn colFirstName = new GridViewDataTextColumn(); colFirstName.Caption = "First Name"; colFirstName.FieldName = "FirstName"; colFirstName.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; control.Columns.Add(colFirstName); GridViewDataTextColumn colLastName = new GridViewDataTextColumn(); colLastName.Caption = "Last Name"; colLastName.FieldName = "LastName"; control.Columns.Add(colLastName); }
public void ColumnsForGridview(int creditAccount, string owner, int month, int year, string currency) { //khai báo space, cân chỉnh report // int a = DataTable_ContraAccount(creditAccount, owner, month, year, currency).Columns.Count; // String space = new String(' ', 180 - a*5); //1.Add Column1:"Số TT" GridViewColumn column1 = new GridViewDataTextColumn { FieldName = "Số TT", Caption = "Số TT" }; ASPxGridViewS04a2.Columns.Add(column1); //2.Add Column2:"Chứng từ" là BandColumn chứa các column:"Số hiệu", "Ngày,tháng" GridViewColumn column2 = new GridViewBandColumn("Chứng từ"); (column2 as GridViewBandColumn).Columns.Add(new GridViewDataTextColumn { FieldName = "Số hiệu" }); (column2 as GridViewBandColumn).Columns.Add(new GridViewDataTextColumn { FieldName = "Ngày,tháng" }); ASPxGridViewS04a2.Columns.Add(column2); //3.Add Column3:"Diễn Giải" GridViewColumn column3 = new GridViewDataTextColumn { FieldName = "Diễn giải" }; ASPxGridViewS04a2.Columns.Add(column3); //4.Add Column4 là BandColumns("Tài khoản có 112, Nợ các tài khoản...") chứa các Column:"TK đối ứng" GridViewColumn column4 = new GridViewBandColumn("Tài Khoản Có " + creditAccount + ", Nợ các tài khoản"); //lấy ra tên các tài khoản đối ứng tìm được ở trên, cho vào các columns: "nợ các tài khoản..." foreach (DataColumn ContraAccount in DataTable_ContraAccount(creditAccount, owner, month, year, currency).Columns) { (column4 as GridViewBandColumn).Columns.Add(new GridViewDataTextColumn { FieldName = ContraAccount.ColumnName, Caption = ContraAccount.ColumnName }); } //ASPxGridViewS04a2.Columns.Add(column4); //5.Add Colum5:"Cộng có TK" (column4 as GridViewBandColumn).Columns.Add(new GridViewDataTextColumn { FieldName = "Cộng có TK " + creditAccount + "", Caption = space + "Cộng có TK " + creditAccount }); //add column:"Cộng có tài khoản 112" ASPxGridViewS04a2.Columns.Add(column4); }
public GridViewDataTextColumn kolumnaDoTabeli(string Napis, int rowSpan) { GridViewDataTextColumn kolumna_ = new GridViewDataTextColumn { Caption = Napis, CellRowSpan = rowSpan, }; kolumna_.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; kolumna_.CellStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; kolumna_.CellStyle.CssClass = "normal center "; kolumna_.HeaderStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; return(kolumna_); }
protected void gvPreViewData_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e) { try { var kpi = this.Get_DefineInfo(); var inq = kpi.ReFilter_InqMDX(); inq.Reset_SummariesID(); foreach (var f in inq.Fields.OrderBy(P => P.Level)) { var col = new GridViewDataTextColumn(); col.Name = f.KeyField; col.Caption = f.ColAliasVI; col.FieldName = f.ColName; if (new[] { "DateKey", "Period", "Quarter", "Year" }.Contains(f.ColName)) { this.Format_GridColumn(col, ValueFormat.DateTime); } else { this.Format_GridColumn(col, ValueFormat.Normal); } this.gvPreViewData.Columns.Add(col); } foreach (var f in inq.Summaries) { var col = new GridViewDataTextColumn(); col.Name = f.Field.KeyField; col.Caption = f.FieldAlias; col.FieldName = f.Get_SummaryKeyField(); this.Format_GridColumn(col, ValueFormat.Numeric); this.gvPreViewData.Columns.Add(col); } foreach (var f in inq.CalcMembers) { var col = new GridViewDataTextColumn(); col.Name = f.Code; col.Caption = f.Cat; col.FieldName = f.Code; this.Format_GridColumn(col, ValueFormat.Numeric); this.gvPreViewData.Columns.Add(col); } var ds = Lib.Db.ExecuteMDX(GlobalVar.DbOLAP_ConnectionStr_Tiny, inq.ToMDX()); this.gvPreViewData.DataSource = ds; this.gvPreViewData.DataBind(); } catch { } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { NavControl.gv = gvInvoiceN.gridControl; Session["ssFromDate"] = DateTime.Now.AddDays(-3).ToString("yyyy-MM-dd"); Session["ssTodate"] = DateTime.Now.ToString("yyyy-MM-dd"); GridViewDataTextColumn A4 = new GridViewDataTextColumn(); A4.Caption = "In A4"; A4.VisibleIndex = 13; A4.DataItemTemplate = new MyHyperlinkTemplate(); gvInvoiceN.gridControl.Columns.Add(A4); GridViewDataTextColumn A5 = new GridViewDataTextColumn(); A5.Caption = "In A5"; A5.VisibleIndex = 14; A5.DataItemTemplate = new MyHyperlinkTemplate(); gvInvoiceN.gridControl.Columns.Add(A5); } }
public void Format_GridColumn(GridViewDataTextColumn col, ValueFormat valF) { col.HeaderStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; col.HeaderStyle.Font.Bold = true; col.HeaderStyle.Font.Name = "Arial"; col.HeaderStyle.Font.Size = new FontUnit(9, UnitType.Point); col.CellStyle.Font.Name = "Arial"; col.CellStyle.Font.Size = new FontUnit(9, UnitType.Point); switch (valF) { case ValueFormat.Date: case ValueFormat.DateTime: case ValueFormat.ShortTime: case ValueFormat.Time: col.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; break; case ValueFormat.Numeric: col.PropertiesEdit.DisplayFormatString = "#,##0"; col.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right; break; } }
public virtual void Custom_GridView() { if (this.MyGV == null) return; var gvData = this.MyGV; // Thiết lập chung... gvData.ClientInstanceName = this.MyClientInstanceName; try { var arrColumn = this.MySett.Columns.Where(p => !string.IsNullOrEmpty(p.FieldName)) .OrderBy(p => p.VisibleIndex); gvData.Width = new Unit(arrColumn.Sum(p => p.Width + 50), UnitType.Pixel); // Xóa các Column dữ liệu gvData.Columns.Clear(); // Thêm cột số thứ tự var colLine = new GridViewDataTextColumn { Name = "colLine", Caption = "No", FieldName = "#", VisibleIndex = 0, Width = new Unit(50, UnitType.Pixel), UnboundType = DevExpress.Data.UnboundColumnType.Integer, }; gvData.KeyFieldName = "#"; gvData.SettingsBehavior.AllowFocusedRow = true; gvData.SettingsBehavior.EnableRowHotTrack = true; if (!this.IsDemo) { gvData.SettingsBehavior.AllowSort = true; gvData.SettingsBehavior.AllowDragDrop = false; } gvData.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Disabled; colLine.PropertiesTextEdit.DisplayFormatString = "#,##0"; colLine.HeaderStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; colLine.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; gvData.Columns.Add(colLine); var lstFields = this.MySett.Get_ColumnFields(); foreach (var field in arrColumn) { var col = new GridViewDataTextColumn(); col.Name = field.Name; col.Caption = field.Caption; var objField = lstFields.FirstOrDefault(p => p.Prop2 == field.FieldName); col.FieldName = objField.Prop3; col.VisibleIndex = field.VisibleIndex; col.Width = new Unit(field.Width, UnitType.Pixel); col.CellStyle.HorizontalAlign = field.Align; col.PropertiesEdit.DisplayFormatString = field.DisplayF; this.FormatGridColumn(col, objField.Prop1); gvData.Columns.Add(col); } } catch { } }
internal static void BuildColumnsByEntity(BusinessMapper.eEntities entidad, ASPxGridView gv) { if (BusinessMapper.AbmConfigXmlPath == null || BusinessMapper.AbmConfigXmlPath == string.Empty) throw new Exception("Path del archivo AbmConfig.xml sin definir."); XmlDocument xDoc = new XmlDocument(); xDoc.Load(BusinessMapper.AbmConfigXmlPath); gv.Columns.Clear(); if (xDoc.SelectSingleNode( "Entities/Entity[@EntityName='" + entidad.ToString() + "']") == null) throw new AbmConfigXMLException("No existe la configuración de mapeo para la entidad: " + entidad.ToString()); foreach (XmlNode nodeControl in xDoc.SelectSingleNode( "Entities/Entity[@EntityName='" + entidad.ToString() + "']").ChildNodes) { if (nodeControl.Attributes["ControlType"].Value == "ComboBox") { GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; var mapInfo = BusinessMapper.GetMapInfo(nodeControl.Attributes["EntityName"].Value); gvc.PropertiesComboBox.TextField = mapInfo.EntityTextField; gvc.PropertiesComboBox.ValueField = mapInfo.EntityValueField; gvc.PropertiesComboBox.DataSource = mapInfo.DAOHandler.ReadAll(""); gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "RadioButtonList") { GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gvc.PropertiesComboBox.Items.Clear(); foreach (XmlNode item in nodeControl.ChildNodes[0].ChildNodes) { gvc.PropertiesComboBox.Items.Add(item.Attributes["Name"].Value, item.Attributes["Value"].Value); } gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "TextBox" || nodeControl.Attributes["ControlType"].Value == "SpinEdit" || nodeControl.Attributes["ControlType"].Value == "TimeEdit") { GridViewDataTextColumn gvc = new GridViewDataTextColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "DateEdit") { GridViewDataDateColumn gvc = new GridViewDataDateColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "CheckBox") { GridViewDataCheckColumn gvc = new GridViewDataCheckColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } } }
public virtual void FormatGridColumn(GridViewDataTextColumn col, string tinyDataTypeStr) { col.HeaderStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; col.HeaderStyle.Font.Bold = true; col.HeaderStyle.Font.Name = "Arial"; col.HeaderStyle.Font.Size = new FontUnit(9, UnitType.Point); col.CellStyle.Font.Name = "Arial"; col.CellStyle.Font.Size = new FontUnit(9, UnitType.Point); switch (tinyDataTypeStr.ToUpper()) { case "NORMAL": col.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Left; break; case "TIME": col.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; break; case "NUM": col.PropertiesEdit.DisplayFormatString = "#,##0"; col.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right; break; } }
private void proccessCreateColumnGridLookup(string type,string select ,string colSetting, ASPxGridLookup gl) { if (type == "query" && select.IndexOf('*')<0) colSetting = colSetting.ToLower(); DataTable dtLiscolSetting = JsonConvert.DeserializeObject<DataTable>(colSetting); for (int i = 0; i < dtLiscolSetting.Rows.Count; i++) { string colname = dtLiscolSetting.Rows[i]["colname"].ToString(); string caption = string.Format("{0}{1}", dtLiscolSetting.Rows[i]["caption"].ToString().Substring(0, 1).ToUpper(), dtLiscolSetting.Rows[i]["caption"].ToString().Remove(0, 1)); GridViewDataTextColumn cl = new GridViewDataTextColumn(); cl.Caption = string.Format("<Center>{0}<Center>", caption); cl.FieldName = colname; cl.VisibleIndex = i; cl.Width = 150; cl.Settings.AutoFilterCondition = AutoFilterCondition.Contains; gl.Columns.Add(cl); } }
protected void gvPreViewData_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e) { try { var kpi = this.Get_DefineInfo(); var inq = kpi.ReFilter_InqMDX(); inq.Reset_SummariesID(); foreach (var f in inq.Fields.OrderBy(P => P.Level)) { var col = new GridViewDataTextColumn(); col.Name = f.KeyField; col.Caption = f.ColAliasVI; col.FieldName = f.ColName; if (new[] { "DateKey", "Period", "Quarter", "Year" }.Contains(f.ColName)) this.Format_GridColumn(col, ValueFormat.DateTime); else this.Format_GridColumn(col, ValueFormat.Normal); this.gvPreViewData.Columns.Add(col); } foreach (var f in inq.Summaries) { var col = new GridViewDataTextColumn(); col.Name = f.Field.KeyField; col.Caption = f.FieldAlias; col.FieldName = f.Get_SummaryKeyField(); this.Format_GridColumn(col, ValueFormat.Numeric); this.gvPreViewData.Columns.Add(col); } foreach (var f in inq.CalcMembers) { var col = new GridViewDataTextColumn(); col.Name = f.Code; col.Caption = f.Cat; col.FieldName = f.Code; this.Format_GridColumn(col, ValueFormat.Numeric); this.gvPreViewData.Columns.Add(col); } var ds = Lib.Db.ExecuteMDX(GlobalVar.DbOLAP_ConnectionStr_Tiny, inq.ToMDX()); this.gvPreViewData.DataSource = ds; this.gvPreViewData.DataBind(); } catch { } }
/// <summary> /// Ham tạo Column cho Gridview loại GridViewDataTextColumn /// </summary> /// <param name="Caption">Tiêu đề cho column</param> /// <param name="FieldName">FieldName cho column</param> /// <param name="Width">Độ rộng cho column</param> /// <param name="Format">Định dạng của column</param> /// <param name="typeTemp">Loại Template cho column</param> /// <returns>GridViewDataTextColumn</returns> public GridViewDataTextColumn BuildTextColumn(string Caption, string FieldName, string Alias, int Width, string Format, string tempeditor, int moduleid, string tablename, string datasource, bool ishyperlinkrelate, string keyFieldName, string objectnamefk) { GridViewDataTextColumn textColumn = new GridViewDataTextColumn(); textColumn.Caption = Caption; if (datasource == "") { if (tempeditor.ToLower() != "hyperlinkbutton") textColumn.FieldName = Alias + FieldName; } else { textColumn.FieldName = Caption; } if (Width != 0) textColumn.Width = Unit.Pixel(Width); else textColumn.MinWidth = 80; textColumn.Name = FieldName; textColumn.PropertiesTextEdit.DisplayFormatString = Format; textColumn.Settings.AutoFilterCondition = AutoFilterCondition.Contains; textColumn.Settings.HeaderFilterMode = HeaderFilterMode.CheckedList; switch (tempeditor.ToLower()) { case "textbox": textColumn.DataItemTemplate = new EditorTemplate("textedit", moduleid, tablename); break; case "checkbox": textColumn.DataItemTemplate = new EditorTemplate("checkbox", moduleid, tablename); break; case "spinedit": textColumn.DataItemTemplate = new EditorTemplate("spinedit", moduleid, tablename); break; case "hyperlink": if (ishyperlinkrelate == false) textColumn.DataItemTemplate = new EditorTemplate("hyperlink", moduleid, tablename, FieldName, keyFieldName, objectnamefk); else textColumn.DataItemTemplate = new EditorTemplate("hyperlinkrl", moduleid, tablename, FieldName, keyFieldName, objectnamefk);//moduleid= modulerelateid break; case "hyperlinkbutton": textColumn.DataItemTemplate = new EditorTemplate("hyperlinkbutton", moduleid, tablename); break; } return textColumn; }
protected void Page_Init() { grid.ClientSideEvents.RowDblClick = "GridRowDoubleClick"; grid.ClientSideEvents.EndCallback = "PrintMulti"; NavControl.gv = grid; GridViewDataTextColumn A4 = new GridViewDataTextColumn(); A4.Caption = "In A4"; A4.VisibleIndex = 17; A4.DataItemTemplate = new MyHyperlinkTemplate(); grid.Columns.Add(A4); }
protected void gvPreViewData_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e) { try { var inq = this.Get_DefineSource(); foreach (var f in inq.Fields.OrderBy(P => P.Level)) { var col = new GridViewDataTextColumn(); col.Name = f.KeyField; col.Caption = f.ColAliasVI; col.FieldName = f.ColName; if (new[] { "DateKey", "Period", "Quarter", "Year" }.Contains(f.ColName)) this.Format_GridColumn(col, ValueFormat.DateTime); else this.Format_GridColumn(col, ValueFormat.Normal); this.gvPreViewData.Columns.Add(col); } foreach (var f in inq.Summaries) { var col = new GridViewDataTextColumn(); col.Name = f.Field.KeyField; col.Caption = f.FieldAlias; col.FieldName = f.Get_SummaryKeyField(); this.Format_GridColumn(col, ValueFormat.Numeric); this.gvPreViewData.Columns.Add(col); } var ds = Lib.Db.ExecuteMDX(GlobalVar.DbOLAP_ConnectionStr_Tiny, inq.ToMDX()); //var ds = Lib.Db.ExecuteMDX(GlobalVar.DbOLAP_ConnectionStr_Tiny, "WITH MEMBER [Measures].[QuantitySUM1] AS COALESCEEMPTY([Measures].[Quantity],0) SELECT {[ARDimItem].[ItemGroupName].MEMBERS * [ARDimItem].[ItemName].MEMBERS} ON ROWS,{[Measures].[QuantitySUM1]} ON COLUMNS FROM [ARCube]"); this.gvPreViewData.DataSource = ds; this.gvPreViewData.DataBind(); } catch { } }
protected void Bind() { if ((!this.IsCallback) && (!this.IsPostBack)) { //Restore filter from cookies this.LoadFilterFromCookies(); this.InitialFilterBind(); SessionManager.CurrentCategories = this.GetListOfCategories(); } //Get main results try { List<int> channelIds = (SessionManager.CurrentChannels.Count==0)?this.GetListOfChannels() :SessionManager.CurrentChannels; List<int> categoryIds = (SessionManager.CurrentCategories.Count==0)?this.GetListOfCategories() :SessionManager.CurrentCategories; SessionManager.CurrentChannels = channelIds; SessionManager.CurrentCategories = categoryIds; CanonMainMonitor monitor = new CanonMainMonitor(Cdb.ConnectionString); monitor.Date = deDate.Date; monitor.ChannelIds = channelIds; monitor.PriceCondition = this.GetPriceCondition(); if (categoryIds != null) monitor.CategoryIds = categoryIds; if (!string.IsNullOrEmpty(txtProduct.Text.Trim())) monitor.ProductName = Memos.Framework.Utilities.TruncateString(txtProduct.Text.Trim(), 300); mappingRules = monitor.GetMappingRules(); DataSet ds = monitor.GetMainMonitorValues(); //get sorting settings before columns clearing DevExpress.Data.ColumnSortOrder sortOrder = DevExpress.Data.ColumnSortOrder.None; string sortColumn = string.Empty; foreach (GridViewColumn gvc in gridMainMonitor.Columns) { GridViewDataColumn gvdc = gvc as GridViewDataColumn; if (gvdc != null) if (gvdc.SortOrder != DevExpress.Data.ColumnSortOrder.None) { sortColumn = gvdc.FieldName; sortOrder = gvdc.SortOrder; } } gridMainMonitor.Columns.Clear(); GridViewCommandColumn col0 = new GridViewCommandColumn(); col0.ShowSelectCheckbox = true; col0.VisibleIndex = 0; col0.HeaderTemplate = new CommandColumnHeaderTemplate(gridMainMonitor, "selCheckbox", "gridMainMonitorSelectionBox"); col0.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; col0.HeaderStyle.VerticalAlign = VerticalAlign.Middle; gridMainMonitor.Columns.Add(col0); int visIndex = 1; foreach (DataColumn dc in ds.Tables[0].Columns) { GridViewDataTextColumn col1 = new GridViewDataTextColumn(); col1.Caption = this.LocalizeColumnName(dc.ColumnName); col1.FieldName = dc.ColumnName; col1.VisibleIndex = visIndex++; if (dc.ColumnName == "ProductId") col1.Visible = false; if ((!string.IsNullOrEmpty(sortColumn)) && (col1.FieldName == sortColumn)) col1.SortOrder = sortOrder; col1.Settings.SortMode = DevExpress.XtraGrid.ColumnSortMode.Custom; gridMainMonitor.Columns.Add(col1); } gridMainMonitor.SettingsPager.PageSize = int.Parse(cbPageSize.SelectedItem.Value.ToString()); gridMainMonitor.DataSource = ds.Tables[0]; gridMainMonitor.DataBind(); gridMainMonitor.JSProperties["cpRowsCount"] = gridMainMonitor.VisibleRowCount; } catch (Exception ex) { Logger.Log(string.Format("exception {0}", ex.ToString()), LogLevel.Error); gridMainMonitor.Columns.Clear(); gridMainMonitor.DataSource = null; gridMainMonitor.DataBind(); } }
protected void ReCreateColumns() { gridLogRecords.Columns.Clear(); //create columns switch (this.LogType) { case LogTypesEnum.ProductMappingHistory: gridLogRecords.KeyFieldName = "RecordId"; GridViewDataDateColumn dateColumn = new GridViewDataDateColumn(); dateColumn.Caption = Utilities.GetResourceString("Common", "LogDate"); dateColumn.FieldName = "LogDate"; dateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm"; dateColumn.VisibleIndex = 0; gridLogRecords.Columns.Add(dateColumn); GridViewDataTextColumn stateColumn = new GridViewDataTextColumn(); stateColumn.Caption = Utilities.GetResourceString("Common", "LogStatus"); stateColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage); stateColumn.VisibleIndex = 1; gridLogRecords.Columns.Add(stateColumn); break; case LogTypesEnum.ChannelMonitoringHistory: gridLogRecords.KeyFieldName = "LogId"; GridViewDataDateColumn logDateColumn = new GridViewDataDateColumn(); logDateColumn.Caption = Utilities.GetResourceString("Common", "LogDate"); logDateColumn.FieldName = "LogDate"; logDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm"; logDateColumn.VisibleIndex = 0; gridLogRecords.Columns.Add(logDateColumn); GridViewDataTextColumn statusColumn = new GridViewDataTextColumn(); statusColumn.Caption = Utilities.GetResourceString("Common", "LogStatus"); statusColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage); statusColumn.VisibleIndex = 1; gridLogRecords.Columns.Add(statusColumn); break; case LogTypesEnum.ProductImportHistory: GridViewDataDateColumn impDateColumn = new GridViewDataDateColumn(); impDateColumn.Caption = Utilities.GetResourceString("Common", "LogDate"); impDateColumn.FieldName = "LogDate"; impDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm"; impDateColumn.VisibleIndex = 0; gridLogRecords.Columns.Add(impDateColumn); GridViewDataTextColumn userColumn = new GridViewDataTextColumn(); userColumn.Caption = Utilities.GetResourceString("Common", "FullName"); userColumn.FieldName = "FullName"; userColumn.VisibleIndex = 1; gridLogRecords.Columns.Add(userColumn); break; case LogTypesEnum.RecommendedPriceHistory: gridLogRecords.KeyFieldName = "LogId"; GridViewDataDateColumn recDateColumn = new GridViewDataDateColumn(); recDateColumn.Caption = Utilities.GetResourceString("Common", "LogDate"); recDateColumn.FieldName = "RecomDate"; recDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy"; recDateColumn.VisibleIndex = 0; gridLogRecords.Columns.Add(recDateColumn); GridViewDataTextColumn recUserColumn = new GridViewDataTextColumn(); recUserColumn.Caption = Utilities.GetResourceString("Common", "FullName"); recUserColumn.FieldName = "User.FullName"; recUserColumn.VisibleIndex = 1; gridLogRecords.Columns.Add(recUserColumn); GridViewDataTextColumn recTypeColumn = new GridViewDataTextColumn(); recTypeColumn.Caption = Utilities.GetResourceString("Common", "ChangeType"); recTypeColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage); recTypeColumn.VisibleIndex = 2; gridLogRecords.Columns.Add(recTypeColumn); GridViewDataTextColumn recPriceColumn = new GridViewDataTextColumn(); recPriceColumn.Caption = Utilities.GetResourceString("Common", "NewPrice"); recPriceColumn.FieldName = "Price"; recPriceColumn.VisibleIndex = 3; gridLogRecords.Columns.Add(recPriceColumn); break; case LogTypesEnum.ChannelLog: gridLogRecords.KeyFieldName = "ErrorId"; GridViewDataTextColumn errorColumn = new GridViewDataTextColumn(); errorColumn.Caption = Utilities.GetResourceString("Common", "ErrorType"); errorColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage); errorColumn.VisibleIndex = 0; gridLogRecords.Columns.Add(errorColumn); GridViewDataTextColumn prodColumn = new GridViewDataTextColumn(); prodColumn.Caption = Utilities.GetResourceString("Common", "ProductName"); prodColumn.FieldName = "ProductName"; prodColumn.VisibleIndex = 1; gridLogRecords.Columns.Add(prodColumn); break; } }