// Used by Janitor.Fody private void DisposeManaged() { CellsCollection.Clear(); ColumnsCollection.Clear(); RowsCollection.Clear(); MergedRanges.RemoveAll(); }
protected override void SetColumnsAndCap(ColumnsCollection columns) { // столбец Марка var col = columns[0]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 10; col[1, 0].TextString = "Марка отв."; // столбец Размеры col = columns[1]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 20; col[1, 1].TextString = "Размеры, мм"; // столбец Назначение col = columns[2]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 20; col[1, 2].TextString = "Назначение"; // столбец Кол col = columns[3]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 15; col[1, 3].TextString = "Кол-во, шт."; // столбец примечаение col = columns[4]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 30; col[1, 4].TextString = "Примечание"; }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid; ColumnsCollection AirlineCols = uwg.Bands[0].Columns; ColumnsCollection WeightBreakCols = uwg.Bands[1].Columns; AirlineCols.FromKey("airline").Hidden = true; WeightBreakCols.FromKey("airline").Hidden = true; AirlineCols.FromKey("dba_name").Header.Caption = "Airline"; AirlineCols.FromKey("carrier_code").Header.Caption = "Carrier Code"; AirlineCols.FromKey("share").Header.Caption = "Profit Share (%)"; WeightBreakCols.FromKey("weight_break").Header.Caption = "Weight Break"; WeightBreakCols.FromKey("kg_lb").Header.Caption = "Kg/Lb"; WeightBreakCols.FromKey("rate").Header.Caption = "Freight Charge Rate"; WeightBreakCols.FromKey("fl_rate").Header.Caption = "Fuel Surcharge Rate"; WeightBreakCols.FromKey("sec_rate").Header.Caption = "Securoty Surcharge Rate"; WeightBreakCols.FromKey("weight_break").Width = Unit.Pixel(100); WeightBreakCols.FromKey("kg_lb").Width = Unit.Pixel(35); WeightBreakCols.FromKey("rate").Width = Unit.Pixel(60); WeightBreakCols.FromKey("fl_rate").Width = Unit.Pixel(60); WeightBreakCols.FromKey("sec_rate").Width = Unit.Pixel(60); }
public void Init_from_grid(UltraGrid grid = null) { if (grid == null) { grid = this.mainGrid; } if (grid == null) { return; } if (grid.DisplayLayout == null || grid.DisplayLayout.Bands.Count < 1) { return; } this.mainGrid = grid; ColumnsCollection columns = grid.DisplayLayout.Bands[0].Columns; if (columns.Count < 1) { return; } else { this.colKey_list.Clear(); } foreach (UltraGridColumn col in columns) { this.colKey_list.Add(new HssGridColumn(col)); } this.colKey_list.Sort((a, b) => (a.visible_position - b.visible_position)); }
protected override void SetColumnsAndCap(ColumnsCollection columns) { var col = columns[0]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 35; col[1, 0].TextString = "Размер, (Высота х Ширина), мм"; int c = 1; for (int i = 1; i <= data.Colors.Count; i++) { col = columns[i]; col.Width = 30; col.Alignment = CellAlignment.MiddleCenter; var cell = col[1, c]; cell.TextString = $"Цвет {data.Colors[i - 1].Item1.BlLayer}"; cell.BackgroundColor = data.Colors[i - 1].Item1.Color; c++; } col = columns.Last(); col.Width = 30; col.Alignment = CellAlignment.MiddleCenter; col[1, c].TextString = "Итого"; }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { ColumnsCollection InvoiceCols = e.Layout.Bands[0].Columns; InvoiceCols.FromKey("invoice_no").Header.Caption = "I/V No."; InvoiceCols.FromKey("customer_name").Header.Caption = "Customer"; InvoiceCols.FromKey("mawb_num").Header.Caption = "Master BL"; InvoiceCols.FromKey("hawb_num").Header.Caption = "House BL"; InvoiceCols.FromKey("entry_date").Header.Caption = "I/V Date"; InvoiceCols.FromKey("invoice_type").Header.Caption = "T"; InvoiceCols.FromKey("import_export").Header.Caption = "I/E"; InvoiceCols.FromKey("air_ocean").Header.Caption = "A/O"; InvoiceCols.FromKey("ref_no").Header.Caption = "Ref. No."; InvoiceCols.FromKey("ref_no_our").Header.Caption = "File No."; InvoiceCols.FromKey("total_pieces").Header.Caption = "PCS"; InvoiceCols.FromKey("total_gross_weight").Header.Caption = "G. Weight"; InvoiceCols.FromKey("total_charge_weight").Header.Caption = "Charge"; InvoiceCols.FromKey("agent_profit").Header.Caption = "Agent P/F"; InvoiceCols.FromKey("sale_tax").Header.Caption = "Tax"; InvoiceCols.FromKey("total_cost").Header.Caption = "Cost"; InvoiceCols.FromKey("subtotal").Header.Caption = "Sub Total"; InvoiceCols.FromKey("lock_ap").Header.Caption = "A/P"; InvoiceCols.FromKey("balance").Header.Caption = "Balance"; InvoiceCols.FromKey("pay_status").Header.Caption = "P"; InvoiceCols.FromKey("arrival_dept").Header.Caption = "Arrival/Departure"; }
/// <summary> /// Apply config info to UltraGrid /// </summary> public void ConfigGrid(UltraGrid grid) { if (grid == null || grid.DisplayLayout.Bands.Count < 1) { return; } else { this.mainGrid = grid; } ColumnsCollection uColumns = grid.DisplayLayout.Bands[0].Columns; HashSet <string> hs = new HashSet <string>(StringComparer.OrdinalIgnoreCase); //int tempPos = 999; foreach (UltraGridColumn uCol in uColumns) { hs.Add(uCol.Key); //uCol.Hidden = true; //Console.WriteLine(uCol.Key + " Position:" + uCol.Header.VisiblePosition); } foreach (HssGridColumn hgc in this.colKey_list) { if (!hs.Contains(hgc.column_key)) { continue; } UltraGridColumn uCol = uColumns[hgc.column_key]; hgc.ConfigColumn(uCol); } }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients(); clients.GetClientsByType(elt_account_number, "All"); ColumnsCollection tmpCols = e.Layout.Bands[0].Columns; tmpCols.FromKey("auto_uid").Hidden = true; tmpCols.FromKey("po_num").Header.Caption = "Pickup Order No"; tmpCols.FromKey("MAWB_NUM").Header.Caption = "Master AWB/BL"; tmpCols.FromKey("HAWB_NUM").Header.Caption = "House AWB/BL"; tmpCols.FromKey("Shipper_Name").Header.Caption = "Shipper"; tmpCols.FromKey("Pickup_Name").Header.Caption = "Pickup From"; tmpCols.FromKey("Carrier_Name").Header.Caption = "Delivery To"; tmpCols.FromKey("Origin_Port_Code").Header.Caption = "From"; tmpCols.FromKey("Dest_Port_Code").Header.Caption = "To"; tmpCols.FromKey("ModifiedDate").Header.Caption = "Last Modified"; tmpCols.FromKey("file_type").Header.Caption = "File Type"; tmpCols.FromKey("ModifiedDate").Format = "MM/dd/yyyy"; tmpCols.FromKey("file_type").Width = Unit.Pixel(60); tmpCols.FromKey("Shipper_Name").Width = Unit.Pixel(150); tmpCols.FromKey("Pickup_Name").Width = Unit.Pixel(150); tmpCols.FromKey("Carrier_Name").Width = Unit.Pixel(150); tmpCols.FromKey("Origin_Port_Code").Width = Unit.Pixel(50); tmpCols.FromKey("Dest_Port_Code").Width = Unit.Pixel(50); tmpCols.FromKey("ModifiedDate").Width = Unit.Pixel(80); }
public void Dispose() { CellsCollection.Clear(); ColumnsCollection.Clear(); RowsCollection.Clear(); MergedRanges.RemoveAll(); }
/// <summary> /// 직급,직군 보이기 여부 /// </summary> /// <param name="columnCollection"></param> public static void VisiblePosColumn(ColumnsCollection columnCollection) { Biz_PositionInfos positionInfo = new Biz_PositionInfos(); DataTable dtPosNotUse = positionInfo.GetPositionInfoByUseYN("N").Tables[0]; foreach (DataRow dataRowPosNotUse in dtPosNotUse.Rows) { string col_key_id = string.Format("TGT_POS_{0}_ID", dataRowPosNotUse["POS_ID"]); string col_key_name = string.Format("TGT_POS_{0}_NAME", dataRowPosNotUse["POS_ID"]); string col_key_id_1 = string.Format("POS_{0}_ID", dataRowPosNotUse["POS_ID"]); string col_key_name_1 = string.Format("POS_{0}_NAME", dataRowPosNotUse["POS_ID"]); if (columnCollection.Exists(col_key_id)) { columnCollection.FromKey(col_key_id).Hidden = true; } if (columnCollection.Exists(col_key_name)) { columnCollection.FromKey(col_key_name).Hidden = true; } if (columnCollection.Exists(col_key_id_1)) { columnCollection.FromKey(col_key_id_1).Hidden = true; } if (columnCollection.Exists(col_key_name_1)) { columnCollection.FromKey(col_key_name_1).Hidden = true; } } }
protected override void SetColumnsAndCap(ColumnsCollection columns) { // столбец Поз. var col = columns[0]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 10; //col[1, 0].TextString = "Поз."; // столбец Артикул col = columns[1]; col.Alignment = CellAlignment.MiddleLeft; col.Width = 20; //col[1, 1].TextString = "Артикул"; //col[1, 1].Alignment = CellAlignment.MiddleCenter; // столбец Образец col = columns[2]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 20; //col[1, 2].TextString = "Образец"; // столбец Расход, шт. col = columns[3]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 20; //col[1, 3].TextString = "Расход, шт."; // столбец Расход, м.кв. col = columns[4]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 20; //col[1, 4].TextString = "Расход, м.кв."; // столбец Цвет col = columns[5]; col.Alignment = CellAlignment.MiddleLeft; col.Width = 30; //col[1, 5].TextString = "Цвет"; //col[1, 5].Alignment = CellAlignment.MiddleCenter; }
protected override void SetColumnsAndCap(ColumnsCollection columns) { // столбец Марка var col = columns[0]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 15; col[1, 0].TextString = "Марка"; // столбец Обозначение col = columns[1]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 60; col[1, 1].TextString = "Обозначение"; // столбец Наименование col = columns[2]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 65; col[1, 2].TextString = "Наименование"; // столбец Кол col = columns[3]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 10; col[1, 3].TextString = "Кол."; // столбец Масса, ед. кг col = columns[4]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 15; col[1, 4].TextString = "Масса, ед. кг"; // столбец примечаение col = columns[5]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 20; col[1, 5].TextString = "Примечание"; }
private void Init(string name) { Name = name; Options = new DbEngineOptions(); Columns = new ColumnsCollection(); Constraints = new ConstraintsCollection(this); Indexes = new IndexCollection(this); ModifiedColumns = new ModifiedColumnsCollection(name); }
public TableSchema(string name) { Name = name; Options= new DbEngineOptions(); Columns= new ColumnsCollection(); Constraints = new ConstraintsCollection(this); Indexes= new IndexCollection(this); ModifiedColumns=new ModifiedColumnsCollection(name); }
protected void WriteColumns(ColumnsCollection columns) { var writer = GetColumnWriter(); foreach (var col in columns) { Builder.AppendLine(); writer.Write(col); Builder.Append(","); } Builder.RemoveLast(); }
private static void RemoveGridTitle(UltraGrid grid, string strOperName) { grid.DisplayLayout.Override.WrapHeaderText = DefaultableBoolean.True; grid.DisplayLayout.Bands[0].UseRowLayout = true; ColumnsCollection cc = grid.DisplayLayout.Bands[0].Columns; grid.DisplayLayout.Bands[0].Columns.Remove("oper"); grid.DisplayLayout.Bands[0].Columns.Remove("date"); if (grid.DisplayLayout.Bands[0].Columns.Exists("title")) { grid.DisplayLayout.Bands[0].Columns.Remove("title"); } for (int i = 0; i < cc.Count; i++) { UltraGridColumn gc = cc[i]; gc.RowLayoutColumnInfo.OriginX = i; gc.RowLayoutColumnInfo.OriginY = gc.RowLayoutColumnInfo.OriginY + 1; } int iCC = cc.Count; grid.DisplayLayout.Bands[0].Columns.Add("oper"); grid.DisplayLayout.Bands[0].Columns.Add("date"); grid.DisplayLayout.Bands[0].Columns["oper"].Header.Appearance.TextHAlign = HAlign.Left; grid.DisplayLayout.Bands[0].Columns["oper"].Header.Appearance.BackColor = Color.White; grid.DisplayLayout.Bands[0].Columns["oper"].Header.Appearance.BorderColor = Color.White; grid.DisplayLayout.Bands[0].Columns["oper"].Header.Caption = "操作员:" + strOperName; grid.DisplayLayout.Bands[0].Columns["oper"].CellActivation = Activation.Disabled; grid.DisplayLayout.Bands[0].Columns["oper"].SortIndicator = SortIndicator.Disabled; grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.OriginX = 0; grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.OriginY = 1; grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.SpanX = iCC - 2; grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.SpanY = 1; grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.PreferredCellSize = new Size(1, 1); grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.AllowCellSizing = RowLayoutSizing.None; grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.LabelPosition = LabelPosition.LabelOnly; grid.DisplayLayout.Bands[0].Columns["date"].Header.Appearance.TextHAlign = HAlign.Left; grid.DisplayLayout.Bands[0].Columns["date"].Header.Appearance.BackColor = Color.White; grid.DisplayLayout.Bands[0].Columns["date"].Header.Appearance.BorderColor = Color.White; grid.DisplayLayout.Bands[0].Columns["date"].Header.Caption = "操作时间:" + DateTime.Now.ToString("yyyy-MM-dd hh:mm");//DateTime.Now.ToShortDateString()+" "+DateTime.Now.ToShortTimeString(); grid.DisplayLayout.Bands[0].Columns["date"].CellActivation = Activation.Disabled; grid.DisplayLayout.Bands[0].Columns["date"].SortIndicator = SortIndicator.Disabled; grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.OriginX = iCC - 2; grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.OriginY = 1; grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.SpanX = 2; grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.SpanY = 1; grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.PreferredCellSize = new Size(1, 1); grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.AllowCellSizing = RowLayoutSizing.None; grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.LabelPosition = LabelPosition.LabelOnly; }
protected override void SetColumnsAndCap(ColumnsCollection columns) { var col = columns[0]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 40; col[1, 0].TextString = "Начало"; col = columns[1]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 40; col[1, 1].TextString = "Конец"; }
public RallyTool(bool selectIssuesMode, string commonRoot) { UsageMetrics.IncrementUsage(UsageMetrics.UsageKind.RallyTool); _selectIssuesMode = selectIssuesMode; _commonRoot = commonRoot; InitializeComponent(); Observable .FromEventPattern<EventHandler, EventArgs>(h => textBoxNameFilter.TextChanged += h, h => textBoxNameFilter.TextChanged -= h) .Do(_ => textBoxNameFilter.BackColor = ChangedFilter) .Throttle(TimeSpan.FromMilliseconds(500)) .ObserveOn(SynchronizationContext.Current) .Subscribe(_ => UpdateFilteredArtifactsList()) ; var ver = new NewVersionControl(); ver.Name = "VersionChecker"; ver.Anchor = versionPlaceholder.Anchor; ver.Location = versionPlaceholder.Location; ver.Size = versionPlaceholder.Size; Controls.Add(ver); Controls.Remove(versionPlaceholder); _columns = InitColumns(); // try find external tools try { using (var rk = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\VssPowerTools.exe", false)) { _vssPowerToolsPath = (string)rk.GetValue(null); } } catch (Exception ex) { _vssPowerToolsPath = null; Logger.LogIt("Error: {0}", ex); } if(_vssPowerToolsPath == null) { sourceSafeCommitsToolStripMenuItem.Text += " (not installed)"; } }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid; ColumnsCollection disputeTotal = uwg.Bands[0].Columns; ColumnsCollection disputeItem = uwg.Bands[1].Columns; disputeTotal.FromKey("elt_account_number").Hidden = true; disputeTotal.FromKey("org_account_number").Hidden = true; disputeItem.FromKey("elt_account_number").Hidden = true; disputeItem.FromKey("vendor_number").Hidden = true; disputeItem.FromKey("memo").Hidden = true; disputeTotal.FromKey("dba_name").Header.Caption = "Vendor"; disputeTotal.FromKey("class_code").Header.Caption = "Class"; disputeTotal.FromKey("business_phone").Header.Caption = "Phone"; disputeItem.FromKey("print_id").Header.Caption = "Tran No"; disputeItem.FromKey("bill_number").Header.Caption = "Bill No"; disputeItem.FromKey("bill_date").Header.Caption = "Tran Date"; disputeItem.FromKey("pmt_method").Header.Caption = "Payment"; disputeItem.FromKey("memo").Header.Caption = "Memo"; disputeItem.FromKey("file_no").Header.Caption = "File No"; disputeItem.FromKey("amt_due").Header.Caption = "Due Amount"; disputeItem.FromKey("amt_paid").Header.Caption = "Paid Amount"; disputeItem.FromKey("amt_dispute").Header.Caption = "Disputed Amount"; disputeTotal.FromKey("dba_name").Width = Unit.Pixel(267); disputeTotal.FromKey("class_code").Width = Unit.Pixel(80); disputeTotal.FromKey("business_phone").Width = Unit.Pixel(100); disputeTotal.FromKey("Bill Amount").Width = Unit.Pixel(100); disputeTotal.FromKey("Paid Amount").Width = Unit.Pixel(100); disputeTotal.FromKey("Balance").Width = Unit.Pixel(100); disputeTotal.FromKey("Dispute Amount").Width = Unit.Pixel(100); disputeItem.FromKey("bill_number").Width = Unit.Pixel(100); disputeItem.FromKey("print_id").Width = Unit.Pixel(100); disputeItem.FromKey("bill_date").Width = Unit.Pixel(80); disputeItem.FromKey("file_no").Width = Unit.Pixel(165); disputeItem.FromKey("pmt_method").Width = Unit.Pixel(70); disputeItem.FromKey("amt_due").Width = Unit.Pixel(100); disputeItem.FromKey("amt_paid").Width = Unit.Pixel(100); disputeItem.FromKey("amt_dispute").Width = Unit.Pixel(100); disputeItem.FromKey("bill_date").Format = "MM/dd/yyyy"; }
public void ColumnsCollectionJsonConverterTest() { ColumnsCollection columnsStrings = new(); ColumnsCollection columnsMixed = new(); columnsStrings.Key = "x"; columnsStrings.Values = new object[] { "2013-01-01", "2013-01-02", "2013-01-03", "2013-01-04" }; columnsMixed.Key = "data1"; columnsMixed.Values = new object[] { -30, 200, 100, 400 }; ColumnsCollection[] columns = new ColumnsCollection[] { columnsStrings, columnsMixed }; string json = JsonSerializer.Serialize(columns); json.ShouldBe("[[\"x\",\"2013-01-01\",\"2013-01-02\",\"2013-01-03\",\"2013-01-04\"],[\"data1\",-30,200,100,400]]"); }
protected override void LoadDataIntoGridDetail(string refId) { var buTransfer = _model.GetBUTransferVoucher(refId, true); if (buTransfer == null) { return; } bindingSourceDetail.DataSource = buTransfer.BUTransferDetailPurchases.OrderBy(c => c.SortOrder).ToList(); gridViewDetail.PopulateColumns(buTransfer.BUTransferDetailPurchases); ColumnsCollection.Add(new XtraColumn { ColumnName = "InventoryItemId", ColumnCaption = "Mã VT,HH", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 1, AllowEdit = true, RepositoryControl = _gridLookUpEditInventoryItem }); ColumnsCollection.Add(new XtraColumn { ColumnName = "Description", ColumnCaption = "Diễn giải", ColumnVisible = true, ColumnWith = 250, ColumnPosition = 2 }); ColumnsCollection.Add(new XtraColumn { ColumnName = "StockId", ColumnCaption = "Kho", ColumnVisible = true, ColumnWith = 150, ColumnPosition = 3, AllowEdit = true, RepositoryControl = _gridLookUpEditStock }); ColumnsCollection.Add(new XtraColumn { ColumnName = "DebitAccount", ColumnCaption = "TK nợ", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 4, AllowEdit = true }); ColumnsCollection.Add(new XtraColumn { ColumnName = "CreditAccount", ColumnCaption = "TK có", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 5, AllowEdit = true }); ColumnsCollection.Add(new XtraColumn { ColumnName = "Unit", ColumnCaption = "ĐVT", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 6, AllowEdit = true, }); ColumnsCollection.Add(new XtraColumn { ColumnName = "Quantity", ColumnCaption = "Số lượng", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 7, AllowEdit = true, IsNumeric = true }); ColumnsCollection.Add(new XtraColumn { ColumnName = "UnitPrice", ColumnCaption = "Đơn giá", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 8, AllowEdit = true, IsNumeric = true }); ColumnsCollection.Add(new XtraColumn { ColumnName = "Amount", ColumnCaption = "Thành tiền", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 9, AllowEdit = true, IsNumeric = true }); ColumnsCollection.Add(new XtraColumn { ColumnName = "TaxAmount", ColumnCaption = "Giá trị nhập kho", ColumnVisible = true, ColumnWith = 150, ColumnPosition = 10, AllowEdit = true, IsNumeric = true }); XtraColumnCollectionHelper <BUTransferDetailPurchaselModel> .ShowXtraColumnInGridView(ColumnsCollection, gridViewDetail); }
protected override void LoadDataIntoGridDetail(string refId) { var buTransfer = _model.GetBUTransferVoucher(refId, true); if (buTransfer == null) { return; } bindingSourceDetail.DataSource = buTransfer.BUTransferDetailFixedAssets.OrderBy(c => c.SortOrder).ToList(); gridViewDetail.PopulateColumns(buTransfer.BUTransferDetailFixedAssets); var columnsCollection = new List <XtraColumn>(); ColumnsCollection.Add(new XtraColumn { ColumnName = "Description", ColumnVisible = true, ColumnWith = 320, ColumnCaption = "Diễn giải", ColumnPosition = 1, }); ColumnsCollection.Add(new XtraColumn { ColumnName = "DebitAccount", ColumnVisible = true, ColumnWith = 100, ColumnCaption = "TK Nợ", ColumnPosition = 2 }); ColumnsCollection.Add(new XtraColumn { ColumnName = "CreditAccount", ColumnVisible = true, ColumnWith = 100, ColumnCaption = "TK Có", ColumnPosition = 3 }); ColumnsCollection.Add(new XtraColumn { ColumnName = "Amount", ColumnVisible = true, ColumnWith = 120, ColumnCaption = "Số tiền", ColumnPosition = 4, IsNumeric = true }); ColumnsCollection.Add(new XtraColumn { ColumnName = "BudgetSourceId", ColumnVisible = true, ColumnWith = 200, ColumnCaption = "Nguồn", ColumnPosition = 5, RepositoryControl = _gridLookUpEditBudgetSource }); ColumnsCollection.Add(new XtraColumn { ColumnName = "BudgetChapterCode", ColumnVisible = true, ColumnWith = 150, ColumnCaption = "Chương", ColumnPosition = 6 }); ColumnsCollection.Add(new XtraColumn { ColumnName = "BudgetSubKindItemCode", ColumnVisible = true, ColumnWith = 150, ColumnCaption = "Khoản", ColumnPosition = 7 }); ColumnsCollection.Add(new XtraColumn { ColumnName = "BudgetSubItemCode", ColumnVisible = true, ColumnWith = 150, ColumnCaption = "Tiểu mục", ColumnPosition = 8 }); ColumnsCollection.Add(new XtraColumn { ColumnName = "BudgetItemCode", ColumnVisible = true, ColumnWith = 150, ColumnCaption = "Mục", ColumnPosition = 9 }); XtraColumnCollectionHelper <BUTransferDetailFixedAssetlModel> .ShowXtraColumnInGridView(ColumnsCollection, gridViewDetail); }
protected void FormatColumns(UltraWebGrid uwg) { ColumnsCollection routeCols = uwg.Bands[0].Columns; ColumnsCollection airlineCols = uwg.Bands[1].Columns; ColumnsCollection weightCols = uwg.Bands[2].Columns; routeCols.FromKey("agent_no").Hidden = true; airlineCols.FromKey("agent_no").Hidden = true; weightCols.FromKey("agent_no").Hidden = true; routeCols.FromKey("dba_name").Header.Caption = "Agent"; UltraGridColumn AgentCol = uwg.Bands[0].Columns.FromKey("dba_name"); AgentCol.EditorControlID = "TextAgent"; AgentCol.Type = ColumnType.Custom; AgentCol.DataType = "System.String"; AgentCol.Width = Unit.Pixel(300); }
protected void FormatColumns(UltraWebGrid uwg) { ColumnsCollection routeCols = uwg.Bands[0].Columns; ColumnsCollection airlineCols = uwg.Bands[1].Columns; ColumnsCollection weightCols = uwg.Bands[2].Columns; // hiding uneccessary columns routeCols.FromKey("customer_no").Hidden = true; airlineCols.FromKey("customer_no").Hidden = true; weightCols.FromKey("customer_no").Hidden = true; // renaming headers routeCols.FromKey("dba_name").Header.Caption = "Customer"; UltraGridColumn CustomerCol = uwg.Bands[0].Columns.FromKey("dba_name"); CustomerCol.EditorControlID = "TextCustomer"; CustomerCol.Type = ColumnType.Custom; CustomerCol.DataType = "System.String"; CustomerCol.Width = Unit.Pixel(300); }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { ColumnsCollection SBCols = e.Layout.Bands[0].Columns; SBCols.FromKey("auto_uid").Hidden = true; SBCols.FromKey("sb").Header.Caption = "Schedule B Code"; SBCols.FromKey("description").Header.Caption = "Item Description"; SBCols.FromKey("sb_unit1").Header.Caption = "Unit 1"; SBCols.FromKey("sb_unit2").Header.Caption = "Unit 2"; SBCols.FromKey("export_code").Header.Caption = "Export Code"; SBCols.FromKey("license_type").Header.Caption = "License Type"; SBCols.FromKey("eccn").Header.Caption = "ECCN"; SBCols.FromKey("sb").Width = Unit.Pixel(100); SBCols.FromKey("description").Width = Unit.Pixel(250); SBCols.FromKey("sb_unit1").Width = Unit.Pixel(60); SBCols.FromKey("sb_unit2").Width = Unit.Pixel(60); SBCols.FromKey("export_code").Width = Unit.Pixel(70); SBCols.FromKey("license_type").Width = Unit.Pixel(70); SBCols.FromKey("eccn").Width = Unit.Pixel(70); }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients(); clients.GetClientsByType(elt_account_number, "All"); UltraGridColumn ConsigneeCol = UltraWebGrid1.Bands[0].Columns.FromKey("consignee_acct"); ConsigneeCol.Type = ColumnType.DropDownList; ConsigneeCol.ValueList.DataSource = clients.Tables["All"]; ConsigneeCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString(); ConsigneeCol.ValueList.ValueMember = clients.Tables["All"].Columns["org_account_number"].ToString(); ConsigneeCol.ValueList.DataBind(); ConsigneeCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", "")); UltraGridColumn ShipperCol = UltraWebGrid1.Bands[0].Columns.FromKey("customer_acct"); ShipperCol.Type = ColumnType.DropDownList; ShipperCol.ValueList.DataSource = clients.Tables["All"]; ShipperCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString(); ShipperCol.ValueList.ValueMember = clients.Tables["All"].Columns["org_account_number"].ToString(); ShipperCol.ValueList.DataBind(); ShipperCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", "")); ColumnsCollection tmpCols = e.Layout.Bands[0].Columns; tmpCols.FromKey("created_date").Format = "MM/dd/yyyy"; tmpCols.FromKey("shipout_date").Format = "MM/dd/yyyy"; tmpCols.FromKey("auto_uid").Hidden = true; tmpCols.FromKey("so_num").Header.Caption = "Shipout No"; tmpCols.FromKey("created_date").Header.Caption = "Created Date"; tmpCols.FromKey("shipout_date").Header.Caption = "Shipout Date"; tmpCols.FromKey("consignee_acct").Header.Caption = "Ship To"; tmpCols.FromKey("customer_acct").Header.Caption = "Customer"; tmpCols.FromKey("file_type").Header.Caption = "File Type"; tmpCols.FromKey("house_num").Header.Caption = "House AWB/BL"; tmpCols.FromKey("master_num").Header.Caption = "Master AWB/BL"; tmpCols.FromKey("file_type").Header.Caption = "File Type"; }
protected override void LoadDataIntoGridDetail(string refId) { var pUInvoice = _model.GetPUInvoice(refId, true); if (pUInvoice == null) { return; } var source = pUInvoice.PUInvoiceDetailFixedAssets ?? new List <PUInvoiceDetailFixedAssetModel>(); bindingSourceDetail.DataSource = source.OrderBy(c => c.SortOrder).ToList();; gridViewDetail.PopulateColumns(source); var columnsCollection = new List <XtraColumn>(); ColumnsCollection.Add(new XtraColumn { ColumnName = nameof(PUInvoiceDetailFixedAssetModel.FixedAssetId), ColumnVisible = true, ColumnWith = 150, ColumnCaption = "Mã tài sản", ColumnPosition = 1, RepositoryControl = _gridLookUpEditFixedAsset }); ColumnsCollection.Add(new XtraColumn { ColumnName = nameof(PUInvoiceDetailFixedAssetModel.Description), ColumnVisible = true, ColumnWith = 320, ColumnCaption = "Diễn giải", ColumnPosition = 2, }); ColumnsCollection.Add(new XtraColumn { ColumnName = nameof(PUInvoiceDetailFixedAssetModel.DepartmentId), ColumnVisible = true, ColumnWith = 200, ColumnCaption = "Phòng ban", ColumnPosition = 3, RepositoryControl = _gridLookUpEditDepartment }); ColumnsCollection.Add(new XtraColumn { ColumnName = nameof(PUInvoiceDetailFixedAssetModel.DebitAccount), ColumnVisible = true, ColumnWith = 100, ColumnCaption = "TK Nợ", ColumnPosition = 4 }); ColumnsCollection.Add(new XtraColumn { ColumnName = nameof(PUInvoiceDetailFixedAssetModel.CreditAccount), ColumnVisible = true, ColumnWith = 100, ColumnCaption = "TK Có", ColumnPosition = 5 }); ColumnsCollection.Add(new XtraColumn { ColumnName = nameof(PUInvoiceDetailFixedAssetModel.Amount), ColumnVisible = true, ColumnWith = 120, ColumnCaption = "Số tiền", ColumnPosition = 6, IsNumeric = true }); ColumnsCollection.Add(new XtraColumn { ColumnName = nameof(PUInvoiceDetailFixedAssetModel.BankAccount), ColumnVisible = true, ColumnWith = 200, ColumnCaption = "Tài khoản NH, KB", ColumnPosition = 5, RepositoryControl = _gridLookUpEditBank }); XtraColumnCollectionHelper <PUInvoiceDetailFixedAssetModel> .ShowXtraColumnInGridView(ColumnsCollection, gridViewDetail); }
protected override void SetColumnsAndCap(ColumnsCollection columns) { int colIndex = 0; var col = columns[colIndex]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 10; var cell = col[1, colIndex]; cell.TextString = "№ п/п"; colIndex++; col = columns[colIndex]; col.Alignment = CellAlignment.MiddleLeft; col.Width = 125; col.Borders.Horizontal.Margin = 2; cell = col[1, colIndex]; cell.TextString = "Наименование"; cell.Alignment = CellAlignment.MiddleCenter; colIndex++; col = columns[colIndex]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 25; cell = col[1, colIndex]; cell.TextString = "Площадь, м" + AcadLib.General.Symbols.Square; colIndex++; col = columns[colIndex]; col.Alignment = CellAlignment.MiddleCenter; col.Width = 25; cell = col[1, colIndex]; cell.TextString = "Процент территории, %"; }
/// <summary> /// Handles the InitializeLayout event of the UltraGrid controls. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs"/> instance containing the event data.</param> private void Grid_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e) { e.Layout.Override.DefaultRowHeight = 30; ColumnsCollection columns = e.Layout.Bands[0].Columns; foreach (UltraGridColumn column in columns) { column.Header.Caption = GetLocalizedString(column.Header.Caption); switch (column.Key) { case "Cost": case "Price": case "Sales": case "Profit": { column.Format = "c"; column.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.CurrencyNonNegative; } break; } } // Hide the unnecessary columns if (sender == this.gridInventory) { columns["Sales"].Hidden = true; columns["Profit"].Hidden = true; columns["IsNew"].Hidden = true; } else if (sender == this.gridReports) { columns["Quantity"].Hidden = true; columns["IsNew"].Hidden = true; } }
protected abstract void SetColumnsAndCap(ColumnsCollection columns);
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { ColumnsCollection columns = e.Layout.Bands[0].Columns; if (lstSearchType.SelectedValue == "house") { columns.FromKey("hawb_num").Header.Caption = "House AWB"; columns.FromKey("masterNo").Header.Caption = "Master AWB"; columns.FromKey("file#").Header.Caption = "File No."; columns.FromKey("sec").Header.Caption = "SEC"; columns.FromKey("p1").Header.Caption = "Departure Port"; columns.FromKey("p2").Header.Caption = "Destination Port"; columns.FromKey("Shipper_name").Header.Caption = "Shipper"; columns.FromKey("consignee_name").Header.Caption = "Consingee"; columns.FromKey("CreatedDate").Header.Caption = "Date"; columns.FromKey("hawb_num").Width = Unit.Percentage(10); columns.FromKey("masterNo").Width = Unit.Percentage(10); columns.FromKey("file#").Width = Unit.Percentage(10); columns.FromKey("sec").Width = Unit.Percentage(4); columns.FromKey("p1").Width = Unit.Percentage(10); columns.FromKey("p2").Width = Unit.Percentage(10); columns.FromKey("Shipper_name").Width = Unit.Percentage(15); columns.FromKey("consignee_name").Width = Unit.Percentage(15); columns.FromKey("CreatedDate").Width = Unit.Percentage(7); columns.FromKey("CreatedDate").Format = "MM/dd/yyyy"; columns.FromKey("Shipper_acct").Hidden = true; columns.FromKey("consignee_acct").Hidden = true; columns.FromKey("agent_org_acct").Hidden = true; columns.FromKey("iType").Hidden = true; columns.FromKey("lastF#").Hidden = true; } if (lstSearchType.SelectedValue == "master") { columns.FromKey("masterNo").Header.Caption = "Master AWB"; columns.FromKey("file#").Header.Caption = "File No."; columns.FromKey("sec").Header.Caption = "SEC"; columns.FromKey("p1").Header.Caption = "Departure Port"; columns.FromKey("p2").Header.Caption = "Destination Port"; columns.FromKey("carrier").Header.Caption = "Carrier"; columns.FromKey("export_agent_name").Header.Caption = "Export Agent"; columns.FromKey("CreatedDate").Header.Caption = "Date"; columns.FromKey("masterNo").Width = Unit.Percentage(10); columns.FromKey("file#").Width = Unit.Percentage(10); columns.FromKey("sec").Width = Unit.Percentage(4); columns.FromKey("p1").Width = Unit.Percentage(10); columns.FromKey("p2").Width = Unit.Percentage(10); columns.FromKey("carrier").Width = Unit.Percentage(15); columns.FromKey("export_agent_name").Width = Unit.Percentage(15); columns.FromKey("CreatedDate").Width = Unit.Percentage(7); columns.FromKey("CreatedDate").Format = "MM/dd/yyyy"; columns.FromKey("agent_org_acct").Hidden = true; columns.FromKey("carrier_code").Hidden = true; columns.FromKey("agent_org_acct").Hidden = true; columns.FromKey("iType").Hidden = true; } }
ColumnsCollection InitColumns() { // init list view with columns var columns = new ColumnsCollection(); var cols = new List<ColumnBase> { new FormattedIDColumn { Width = 90 }, new IterationColumn { Width = 150 }, new WorkItemNameColumn { Width = 400 }, new ParentColumn { Width = 400 } }; columns.Columns = cols.ToArray(); listViewIssues.Columns.Clear(); var colHdrs = columns .Columns .Select(col => new ColumnHeader { TextAlign = col.TextAlign, Text = col.Header, Width = col.Width, Tag = col }) .ToArray() ; listViewIssues.Columns.AddRange(colHdrs); return columns; }
public VirtualListItemArtifact(Artifact workItem, ColumnsCollection columns) { WorkItem = workItem; _columns = columns; }
private static void ProcessSmallTable(Autodesk.AutoCAD.EditorInput.Editor editor, Table table, Transaction tr, ColumnsCollection columns, int i) { var smallTable = editor.GetEntity("Выделите малую таблицу\n"); if (smallTable.Status != Autodesk.AutoCAD.EditorInput.PromptStatus.OK) { throw new Exception(); } var smallTableObj = tr.GetObject(smallTable.ObjectId, OpenMode.ForWrite, false) as Table; var numOfRow = smallTableObj.Rows.Count; for (int j = 1; j < numOfRow - 4; j++) { if (smallTableObj.Cells[j, 0].TextString != string.Empty) { var grunt = smallTableObj.Cells[j, 0].TextString; var area = smallTableObj.Cells[j, 1].TextString; for (int k = 1; k < columns.Count; k++) { var title = table.Cells[0, k].TextString; var formattedArea = area.Replace(".", ",").Replace("м2", ""); if (title != string.Empty) { if (title == grunt) { table.Cells[i, k].TextString = formattedArea; break; } } else { table.Cells[0, k].TextString = grunt; table.Cells[i, k].TextString = formattedArea; break; } } } } }
private static void UpdateTableWithValues(Autodesk.AutoCAD.EditorInput.Editor editor, Table table, Transaction tr, ColumnsCollection columns) { for (int i = 1; i < int.MaxValue; i++) { try { CommonMethods.FillPiket(editor, table, tr, i); ProcessSmallTable(editor, table, tr, columns, i); } catch (Exception) { editor.WriteMessage("Завершение программы. Дай Бог вам здоровья\n"); break; } } }