public void NapraviSpisakDrzava() { try { popuniDefaultDrzave(); cmbDrzava.DataSource = MainForm.getData.GetTableDrzava(); cmbDrzava.ValueMember = "Drzava_ID"; cmbDrzava.DisplayMember = "Naziv"; cmbDrzava.PopulateViewColumns(); cmbDrzava.View.Columns.ColumnByFieldName("Drzava_ID").Visible = false; gridControl.RepositoryItems.Add(cmbDrzava); gridView.Columns["Drzava_Naziv"].ColumnEdit = cmbDrzava; cmbDrzava.NullText = "Izaberite državu"; } catch (DbUpdateException ex) { if (ex.InnerException != null) { if (ex.InnerException.ToString().Contains("The DELETE statement conflicted with the REFERENCE constraint")) { MessageBox.Show("Došlo je do greške prilikom brisanja. \nNije moguće obrsati elemnt koji se već koristi u drugoj tabeli.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MainForm.logger.Error("Naziv klase: " + this.GetType().Name + "\n Funkcija: " + System.Reflection.MethodBase.GetCurrentMethod().Name + "\n\"" + ex.InnerException.ToString().Trim().Substring(0, Math.Min(ex.InnerException.ToString().Trim().Length, 350)) + "\""); } } } catch (Exception ex) { MainForm.logger.Error("Naziv klase: " + this.GetType().Name + "\n Funkcija: " + System.Reflection.MethodBase.GetCurrentMethod().Name + "\n\"" + ex.Message.ToString().Trim().Substring(0, Math.Min(ex.Message.ToString().Trim().Length, 350)) + "\""); } }
private void CreateUnboundColumn(GridView view, string unboundColumnFieldName) { edit.PopulateViewColumns(); GridColumn originColumn = view.Columns[convertedProperty]; if (originColumn != null) { originColumn.Visible = false; GridColumn column = view.Columns.AddField(unboundColumnFieldName); column.UnboundType = DevExpress.Data.UnboundColumnType.Object; column.VisibleIndex = view.VisibleColumns.Count; SubscribeToEvents(); } }
void AddCombDebit() { try { DataTable dtsed = new DataTable(); repComboLookBox.DataSource = null; dtsed.Clear(); //System.Data.DataSet ds; using (var ds = new System.Data.DataSet()) { ds.Clear(); using (SqlDataAdapter ada = new SqlDataAdapter("SELECT Description,TransID FROM Reconciliation.tblTransDefinition WHERE Type='dr' AND IsActive=1", Logic.ConnectionString)) { ada.Fill(ds, "table"); } repComboLookBox.NullText = "select"; dtsed = ds.Tables[0]; if (dtsed != null && dtsed.Rows.Count > 0) { repComboLookBox.DataSource = dtsed; repComboLookBox.DisplayMember = "Description"; repComboLookBox.ValueMember = "TransID"; repComboLookBox.AllowNullInput = DefaultBoolean.True; //if (!boolIsUpdate2) //{ repComboLookBox.PopulateViewColumns(); var view = repComboLookBox.View; view.Columns["TransID"].Visible = false; //} repComboLookBox.AutoComplete = true; } } } catch (Exception ex) { Tripous.Sys.ErrorBox(String.Format("{0}{1}", ex.Message, ex.StackTrace)); return; } }
void AddCombDefinition() { try { DataTable dtse = new DataTable(); repComboLookBox.DataSource = null; dtse.Clear(); //System.Data.DataSet ds; using (var dsed = new System.Data.DataSet()) { dsed.Clear(); using (SqlDataAdapter adas = new SqlDataAdapter("SELECT DefinitionID,Description FROM Reconciliation.tblSwepDefinition", Logic.ConnectionString)) { adas.Fill(dsed, "table"); } repComboLookBox.NullText = "Select Text"; dtse = dsed.Tables[0]; if (dtse != null && dtse.Rows.Count > 0) { repComboLookBox.DataSource = dtse; repComboLookBox.DisplayMember = "Description"; repComboLookBox.ValueMember = "DefinitionID"; repComboLookBox.AllowNullInput = DefaultBoolean.True; //Autocomplete on all values repComboLookBox.PopulateViewColumns(); var view = repComboLookBox.View; view.Columns["DefinitionID"].Visible = false; repComboLookBox.AutoComplete = true; } } } catch (Exception ex) { Tripous.Sys.ErrorBox(String.Format("{0}{1}", ex.Message, ex.StackTrace)); return; } }
private void GridSetting() { //gvDetail.Columns.ColumnByName["colTotalAmount"].OptionsColumn.ReadOnly = True gvDetail.Columns.ColumnByName("colStockReqDetailId").OptionsColumn.ReadOnly = true; gvDetail.Columns.ColumnByName("colStockReqMasterId").OptionsColumn.ReadOnly = true; gvDetail.Columns.ColumnByName("colStockReqDetailId").Visible = false; gvDetail.Columns.ColumnByName("colStockReqMasterId").Visible = false; gvDetail.Columns.ColumnByName("colProductCategoryId").Visible = false; gvDetail.Columns.ColumnByName("colCategoryName").Visible = false; gvDetail.Columns.ColumnByName("colProductId").Caption = "Product Name"; gvDetail.Columns.ColumnByName("colQty").Caption = "Quantity"; gvDetail.Columns.ColumnByName("colProductId").VisibleIndex = 0; gvDetail.Columns.ColumnByName("colQty").VisibleIndex = 1; gvDetail.Columns.ColumnByName("colProductId").Width = 300; gvDetail.Columns.ColumnByName("colQty").Width = 50; bsProducts.DataSource = dset; bsProducts.DataMember = "Product"; repositoryGridLookup.DataSource = bsProducts; repositoryGridLookup.DisplayMember = "ProductName"; repositoryGridLookup.ValueMember = "ProductId"; repositoryGridLookup.PopupFormMinSize = new Size(450, 150); repositoryGridLookup.NullText = ""; repositoryGridLookup.ShowFooter = true; repositoryGridLookup.View.OptionsView.ColumnAutoWidth = false; repositoryGridLookup.PopulateViewColumns(); GCDetail.RepositoryItems.Add(repositoryGridLookup); (GCDetail.MainView as GridView).Columns.ColumnByName("colProductId").ColumnEdit = repositoryGridLookup; if (repositoryGridLookup.View.Columns.Count > 0) { repositoryGridLookup.View.Columns.ColumnByName("colProductId").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colBarcode").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colDiscountPerc").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colProductCategoryId").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colProductName").Caption = "Name"; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").Caption = "Code"; repositoryGridLookup.View.Columns.ColumnByName("colCostPrice").Caption = "Cost Price"; repositoryGridLookup.View.Columns.ColumnByName("colQtyInhand").Caption = "QtyInHand"; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").Caption = "Category Name"; repositoryGridLookup.View.Columns.ColumnByName("colProductName").Width = 150; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").Width = 80; repositoryGridLookup.View.Columns.ColumnByName("colCostPrice").Width = 70; repositoryGridLookup.View.Columns.ColumnByName("colQtyInhand").Width = 40; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").Width = 100; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").VisibleIndex = 0; repositoryGridLookup.View.Columns.ColumnByName("colProductName").VisibleIndex = 1; repositoryGridLookup.View.Columns.ColumnByName("colCostPrice").VisibleIndex = 2; repositoryGridLookup.View.Columns.ColumnByName("colQtyInhand").VisibleIndex = 3; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").VisibleIndex = 4; } gvDetail.Columns.ColumnByName("colProductId").Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left; }
private void GridSetting() { gvDetail.Columns.ColumnByName("colWTDetailId").OptionsColumn.ReadOnly = true; gvDetail.Columns.ColumnByName("colWTMasterId").OptionsColumn.ReadOnly = true; gvDetail.Columns.ColumnByName("colWTDetailId").Visible = false; gvDetail.Columns.ColumnByName("colWTMasterId").Visible = false; gvDetail.Columns.ColumnByName("colProductId").Caption = "Material Name"; gvDetail.Columns.ColumnByName("colQtyToTransfer").Caption = "Quantity"; gvDetail.Columns.ColumnByName("colProductId").VisibleIndex = 0; gvDetail.Columns.ColumnByName("colQtyToTransfer").VisibleIndex = 1; gvDetail.Columns.ColumnByName("colProductId").Width = 250; gvDetail.Columns.ColumnByName("colQtyToTransfer").Width = 50; bsProduct.DataSource = dsMain; bsProduct.DataMember = "Products"; repositoryGridLookup.DataSource = bsProduct; repositoryGridLookup.DisplayMember = "ProductName"; repositoryGridLookup.ValueMember = "ProductId"; repositoryGridLookup.PopupFormSize = new Size(500, 200); repositoryGridLookup.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains; repositoryGridLookup.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; repositoryGridLookup.ImmediatePopup = true; repositoryGridLookup.NullText = ""; repositoryGridLookup.ShowFooter = false; repositoryGridLookup.View.OptionsView.ColumnAutoWidth = false; repositoryGridLookup.PopulateViewColumns(); GCDetail.RepositoryItems.Add(repositoryGridLookup); (GCDetail.MainView as GridView).Columns.ColumnByName("colProductId").ColumnEdit = repositoryGridLookup; if (repositoryGridLookup.View.Columns.Count > 0) { repositoryGridLookup.View.Columns.ColumnByName("colProductId").Visible = false; //repositoryGridLookup.View.Columns.ColumnByName("colMesurementUnitId").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").Caption = "Code"; repositoryGridLookup.View.Columns.ColumnByName("colProductName").Caption = "Product Name"; // repositoryGridLookup.View.Columns.ColumnByName("colProductNature").Caption = "Product Name"; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").Caption = "Category"; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").Width = 80; repositoryGridLookup.View.Columns.ColumnByName("colProductName").Width = 150; //repositoryGridLookup.View.Columns.ColumnByName("colProductNature").Width = 80; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").Width = 100; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").VisibleIndex = 0; repositoryGridLookup.View.Columns.ColumnByName("colProductName").VisibleIndex = 1; //repositoryGridLookup.View.Columns.ColumnByName("colProductNature").VisibleIndex = 2; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").VisibleIndex = 3; } }
private void GridSetting() { gvDetail.Columns.ColumnByName("colAdjustDetailId").OptionsColumn.ReadOnly = true; gvDetail.Columns.ColumnByName("colAdjustId").OptionsColumn.ReadOnly = true; gvDetail.Columns.ColumnByName("colAdjustDetailId").Visible = false; gvDetail.Columns.ColumnByName("colAdjustId").Visible = false; gvDetail.Columns.ColumnByName("colProductCategoryId").Visible = false; gvDetail.Columns.ColumnByName("colCategoryName").Visible = false; gvDetail.Columns.ColumnByName("colStockType").Visible = false; gvDetail.Columns.ColumnByName("colWarehouseId").Visible = false; gvDetail.Columns.ColumnByName("colProductId").Caption = "Product Name"; gvDetail.Columns.ColumnByName("colFlagIO").Caption = "I/O"; gvDetail.Columns.ColumnByName("colQty").Caption = "Quantity"; gvDetail.Columns.ColumnByName("colProductId").VisibleIndex = 0; gvDetail.Columns.ColumnByName("colFlagIO").VisibleIndex = 1; gvDetail.Columns.ColumnByName("colQty").VisibleIndex = 2; gvDetail.Columns.ColumnByName("colProductId").Width = 300; gvDetail.Columns.ColumnByName("colFlagIO").Width = 50; gvDetail.Columns.ColumnByName("colQty").Width = 50; bsProducts.DataSource = dset; bsProducts.DataMember = "Product"; bsFlagIO.DataSource = dset; bsFlagIO.DataMember = "FlagIO"; repositoryGridLookup.DataSource = bsProducts; repositoryGridLookup.DisplayMember = "ProductName"; repositoryGridLookup.ValueMember = "ProductId"; repositoryGridLookup.PopupFormMinSize = new Size(450, 150); repositoryGridLookup.NullText = ""; repositoryGridLookup.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains; repositoryGridLookup.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; repositoryGridLookup.ShowFooter = true; repositoryGridLookup.ImmediatePopup = true; repositoryGridLookup.View.OptionsView.ColumnAutoWidth = false; repositoryGridLookup.PopulateViewColumns(); GCDetail.RepositoryItems.Add(repositoryGridLookup); (GCDetail.MainView as GridView).Columns.ColumnByName("colProductId").ColumnEdit = repositoryGridLookup; if (repositoryGridLookup.View.Columns.Count > 0) { repositoryGridLookup.View.Columns.ColumnByName("colProductId").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colBarcode").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colDiscountPerc").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colProductCategoryId").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colProductName").Caption = "Name"; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").Caption = "Code"; repositoryGridLookup.View.Columns.ColumnByName("colCostPrice").Caption = "Cost Price"; repositoryGridLookup.View.Columns.ColumnByName("colQtyInhand").Caption = "QtyInHand"; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").Caption = "Category Name"; repositoryGridLookup.View.Columns.ColumnByName("colProductName").Width = 150; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").Width = 80; repositoryGridLookup.View.Columns.ColumnByName("colCostPrice").Width = 70; repositoryGridLookup.View.Columns.ColumnByName("colQtyInhand").Width = 40; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").Width = 100; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").VisibleIndex = 0; repositoryGridLookup.View.Columns.ColumnByName("colProductName").VisibleIndex = 1; repositoryGridLookup.View.Columns.ColumnByName("colCostPrice").VisibleIndex = 2; repositoryGridLookup.View.Columns.ColumnByName("colQtyInhand").VisibleIndex = 3; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").VisibleIndex = 4; } repositoryFagIO.DataSource = bsFlagIO; repositoryFagIO.DisplayMember = "FlagIO"; repositoryFagIO.ValueMember = "FlagIO"; repositoryFagIO.PopupFormMinSize = new Size(150, 150); repositoryFagIO.NullText = ""; repositoryFagIO.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains; repositoryFagIO.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; repositoryFagIO.ShowFooter = true; repositoryFagIO.ImmediatePopup = true; repositoryFagIO.View.OptionsView.ColumnAutoWidth = false; repositoryFagIO.PopulateViewColumns(); GCDetail.RepositoryItems.Add(repositoryFagIO); (GCDetail.MainView as GridView).Columns.ColumnByName("colFlagIO").ColumnEdit = repositoryFagIO; if (repositoryFagIO.View.Columns.Count > 0) { repositoryFagIO.View.Columns.ColumnByName("colFlagIO").Caption = "I/O"; repositoryFagIO.View.Columns.ColumnByName("colFlagIO").Width = 50; } gvDetail.Columns.ColumnByName("colProductId").Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left; }
private void GridSetting() { gvDetail.Columns.ColumnByName("colFormulaConfigId").OptionsColumn.ReadOnly = true; gvDetail.Columns.ColumnByName("colFormulaConfigId").Visible = false; gvDetail.Columns.ColumnByName("colWarehouseId").Caption = "Warehouse"; gvDetail.Columns.ColumnByName("colProductId").Caption = "Raw Material Name"; gvDetail.Columns.ColumnByName("colUnitId").Caption = "Unit Name"; gvDetail.Columns.ColumnByName("colWarehouseSequance").Caption = "Dept Sq"; gvDetail.Columns.ColumnByName("colProductSequance").Caption = "Raw Sq"; gvDetail.Columns.ColumnByName("colWarehouseId").VisibleIndex = 0; gvDetail.Columns.ColumnByName("colProductId").VisibleIndex = 1; gvDetail.Columns.ColumnByName("colUnitId").VisibleIndex = 2; gvDetail.Columns.ColumnByName("colWarehouseSequance").VisibleIndex = 3; gvDetail.Columns.ColumnByName("colProductSequance").VisibleIndex = 4; gvDetail.Columns.ColumnByName("colWarehouseId").Width = 120; gvDetail.Columns.ColumnByName("colProductId").Width = 280; gvDetail.Columns.ColumnByName("colUnitId").Width = 100; gvDetail.Columns.ColumnByName("colWarehouseSequance").Width = 50; gvDetail.Columns.ColumnByName("colProductSequance").Width = 50; bsProduct.DataSource = dsMain; bsProduct.DataMember = "Products"; bsProductUnit.DataSource = dsMain; bsProductUnit.DataMember = "MesurementUnit"; bsWarehouse.DataSource = dsMain; bsWarehouse.DataMember = "Warehouse"; repositoryGridLookup.DataSource = bsProduct; repositoryGridLookup.DisplayMember = "ProductName"; repositoryGridLookup.ValueMember = "ProductId"; repositoryGridLookup.PopupFormSize = new Size(500, 200); repositoryGridLookup.NullText = ""; repositoryGridLookup.ShowFooter = false; repositoryGridLookup.View.OptionsView.ColumnAutoWidth = false; repositoryGridLookup.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains; repositoryGridLookup.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; repositoryGridLookup.PopulateViewColumns(); GCDetail.RepositoryItems.Add(repositoryGridLookup); (GCDetail.MainView as GridView).Columns.ColumnByName("colProductId").ColumnEdit = repositoryGridLookup; if (repositoryGridLookup.View.Columns.Count > 0) { repositoryGridLookup.View.Columns.ColumnByName("colProductId").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colMesurementUnitId").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").Caption = "Code"; repositoryGridLookup.View.Columns.ColumnByName("colProductName").Caption = "Product Name"; repositoryGridLookup.View.Columns.ColumnByName("colProductNature").Caption = "Product Name"; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").Caption = "Category"; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").Width = 80; repositoryGridLookup.View.Columns.ColumnByName("colProductName").Width = 150; repositoryGridLookup.View.Columns.ColumnByName("colProductNature").Width = 80; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").Width = 100; repositoryGridLookup.View.Columns.ColumnByName("colProductCode").VisibleIndex = 0; repositoryGridLookup.View.Columns.ColumnByName("colProductName").VisibleIndex = 1; repositoryGridLookup.View.Columns.ColumnByName("colProductNature").VisibleIndex = 2; repositoryGridLookup.View.Columns.ColumnByName("colCategoryName").VisibleIndex = 3; } //************************************************* repositoryUnitGridLookup.DataSource = bsProductUnit; repositoryUnitGridLookup.DisplayMember = "MesurementName"; repositoryUnitGridLookup.ValueMember = "MesurementId"; repositoryUnitGridLookup.PopupFormSize = new Size(130, 100); repositoryUnitGridLookup.NullText = ""; repositoryUnitGridLookup.ShowFooter = false; repositoryUnitGridLookup.View.OptionsView.ColumnAutoWidth = false; repositoryUnitGridLookup.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains; repositoryUnitGridLookup.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; repositoryUnitGridLookup.PopulateViewColumns(); GCDetail.RepositoryItems.Add(repositoryUnitGridLookup); (GCDetail.MainView as GridView).Columns.ColumnByName("colUnitId").ColumnEdit = repositoryUnitGridLookup; if (repositoryUnitGridLookup.View.Columns.Count > 0) { repositoryUnitGridLookup.View.Columns.ColumnByName("colMesurementId").Visible = false; repositoryUnitGridLookup.View.Columns.ColumnByName("colMesurementName").Caption = "Product Unit"; repositoryUnitGridLookup.View.Columns.ColumnByName("colMesurementName").Width = 150; repositoryUnitGridLookup.View.Columns.ColumnByName("colMesurementName").VisibleIndex = 0; } //************************************************************ repositoryWarehouseGridLookup.DataSource = bsWarehouse; repositoryWarehouseGridLookup.DisplayMember = "WarehouseName"; repositoryWarehouseGridLookup.ValueMember = "WarehouseId"; repositoryWarehouseGridLookup.PopupFormSize = new Size(130, 100); repositoryWarehouseGridLookup.NullText = ""; repositoryWarehouseGridLookup.ShowFooter = false; repositoryWarehouseGridLookup.View.OptionsView.ColumnAutoWidth = false; repositoryWarehouseGridLookup.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains; repositoryWarehouseGridLookup.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; repositoryWarehouseGridLookup.PopulateViewColumns(); GCDetail.RepositoryItems.Add(repositoryWarehouseGridLookup); (GCDetail.MainView as GridView).Columns.ColumnByName("colWarehouseId").ColumnEdit = repositoryWarehouseGridLookup; if (repositoryWarehouseGridLookup.View.Columns.Count > 0) { repositoryWarehouseGridLookup.View.Columns.ColumnByName("colWarehouseId").Visible = false; repositoryWarehouseGridLookup.View.Columns.ColumnByName("colWarehouseName").Caption = "Department"; repositoryWarehouseGridLookup.View.Columns.ColumnByName("colWarehouseName").Width = 150; repositoryWarehouseGridLookup.View.Columns.ColumnByName("colWarehouseName").VisibleIndex = 0; } }
private void Frm_Invoices_Load(object sender, EventArgs e) { switch (Type) { case Master.InvoiceType.Purshases: this.LabelName.Text = "فاتورة مشتريات"; break; case Master.InvoiceType.Sales: this.LabelName.Text = "فاتورة مبيعات"; break; case Master.InvoiceType.PurchasesReturn: this.LabelName.Text = "فاتورة مرتجع مشتريات"; break; case Master.InvoiceType.SalesReturn: this.LabelName.Text = "فاتورة مرتجع مبيعات"; break; default: break; } //ColorTranslator.FromHtml("#FF99FFCC");// Grid.OptionsView.ShowIndicator = false; Lkp_PartType.IntializeData(Master.PartTypesList); Grid.OptionsView.NewItemRowPosition = NewItemRowPosition.Top; Grid.Columns[nameof(details.total_price)].OptionsColumn.AllowFocus = false; Grid.Columns[nameof(details.id)].Visible = false; Grid.Columns[nameof(details.invoiceid)].Visible = false; Grid.OptionsView.ShowVerticalLines = DefaultBoolean.False; Grid.OptionsView.BestFitMode = GridBestFitMode.Full; Grid.Appearance.EvenRow.BackColor = Master.color(220, "#FAFAD2"); //Color.FromArgb(220,255, 249, 210); Grid.OptionsView.EnableAppearanceEvenRow = true; Grid.Appearance.OddRow.BackColor = Master.color(50, "#D2D2FA"); //Color.FromArgb(50,220, 220, 220); Grid.OptionsView.EnableAppearanceOddRow = true; Grid.Columns.Add(new GridColumn() { Name = "clmCode", FieldName = "Code", Caption = "باركود", UnboundType = UnboundColumnType.String, }); Grid.Columns.Add(new GridColumn() { Name = "clmIndex", FieldName = "Index", Caption = "#", UnboundType = UnboundColumnType.Integer, MaxWidth = 30, //Nulltext }); Grid.Columns["Index"].OptionsColumn.AllowFocus = false; Grid.Columns[nameof(details.total_price)].OptionsColumn.AllowFocus = false; Grid.Columns[nameof(details.itemid)].Caption = "إسم الصنف"; Grid.Columns[nameof(details.itemunit_id)].Caption = "الوحدة"; Grid.Columns[nameof(details.item_Qty)].Caption = "الكمية"; Grid.Columns[nameof(details.price)].Caption = "السعر"; Grid.Columns[nameof(details.total_price)].Caption = "إجمالي السعر"; Grid.Columns[nameof(details.cost_value)].Caption = "التكلفة"; Grid.Columns[nameof(details.totalcoste_value)].Caption = "إجمالي التكلفة"; Grid.Columns[nameof(details.discount)].Caption = "% الخصم"; Grid.Columns[nameof(details.discount_value)].Caption = "الخصم"; Grid.Columns[nameof(details.store_id)].Caption = "المخزن"; Grid.Columns["Index"].VisibleIndex = 0; Grid.Columns["Code"].VisibleIndex = 1; Grid.Columns[nameof(details.itemid)].VisibleIndex = 2; Grid.Columns[nameof(details.itemunit_id)].VisibleIndex = 3; Grid.Columns[nameof(details.item_Qty)].VisibleIndex = 4; Grid.Columns[nameof(details.price)].VisibleIndex = 5; Grid.Columns[nameof(details.discount)].VisibleIndex = 6; Grid.Columns[nameof(details.discount_value)].VisibleIndex = 7; Grid.Columns[nameof(details.total_price)].VisibleIndex = 8; Grid.Columns[nameof(details.cost_value)].VisibleIndex = 9; Grid.Columns[nameof(details.totalcoste_value)].VisibleIndex = 10; Grid.Columns[nameof(details.store_id)].VisibleIndex = 11; /*Create Grid view items in cells itemid*/ repoItems.IntializeData(Session.ProductView.Where(x => x.status == true), Grid.Columns[nameof(details.itemid)], Grid_Details); repoItems.ValidateOnEnterKey = true; repoItems.AllowNullInput = DefaultBoolean.False; repoItems.BestFitMode = BestFitMode.BestFitResizePopup; repoItems.ImmediatePopup = true; repoItemsAll.IntializeData(Session.ProductView, Grid.Columns[nameof(details.itemid)], Grid_Details); GridView repoview = repoItems.View; repoview.FocusRectStyle = DrawFocusRectStyle.RowFullFocus; repoview.OptionsSelection.UseIndicatorForSelection = true; repoview.OptionsView.ShowAutoFilterRow = true; repoItems.PopulateViewColumns(); repoview.Columns[nameof(product.status)].Visible = false; repoview.Columns[nameof(product.type)].Visible = false; repoview.Columns[nameof(product.id)].Visible = false; repoview.Columns[nameof(product.code)].Caption = "الكود "; repoview.Columns[nameof(product.name)].Caption = "الإسم "; repoview.Columns[nameof(product.category)].Caption = "الفئة "; repoview.Columns[nameof(product.details)].Caption = "الوصف "; repoUOM.IntializeData(Session.units, Grid.Columns[nameof(details.itemunit_id)], Grid_Details); repoStores.IntializeData(Session.Stores, Grid.Columns[nameof(details.store_id)], Grid_Details); //repoItems.ValueMember = "id"; repoStores.ForceInitialize(); repoStores.PopulateColumns(); repoStores.Columns[0].Visible = false; repoview.Columns[1].Caption = "اسم المخزن "; repoStores.BestFitMode = BestFitMode.BestFitResizePopup; #region : SpinEdit RepositoryItemSpinEdit spinEdit = new RepositoryItemSpinEdit(); Grid.Columns[nameof(details.total_price)].ColumnEdit = spinEdit; Grid.Columns[nameof(details.price)].ColumnEdit = spinEdit; Grid.Columns[nameof(details.discount_value)].ColumnEdit = spinEdit; spinEdit.Mask.EditMask = "N3"; spinEdit.Mask.UseMaskAsDisplayFormat = true; spinEdit.MinValue = Convert.ToDecimal(0.1); spinEdit.MaxValue = Convert.ToDecimal(1000000000); spinEdit.Increment = 1; RepositoryItemSpinEdit spinRatioEdit = new RepositoryItemSpinEdit(); Grid.Columns[nameof(details.discount)].ColumnEdit = spinRatioEdit; spinRatioEdit.Increment = 0.01m; spinRatioEdit.Mask.EditMask = "p"; spinRatioEdit.Mask.UseMaskAsDisplayFormat = true; spinRatioEdit.MaxValue = 1; RepositoryItemSpinEdit spinspinQteEdit = new RepositoryItemSpinEdit(); Grid.Columns[nameof(details.item_Qty)].ColumnEdit = spinspinQteEdit; spinspinQteEdit.Increment = 0.1m; spinspinQteEdit.Mask.EditMask = "n"; spinRatioEdit.Mask.UseMaskAsDisplayFormat = true; spinspinQteEdit.MinValue = Convert.ToDecimal(0.1); spinspinQteEdit.MaxValue = Convert.ToDecimal(1000000000); spinspinQteEdit.Increment = 1; Grid_Details.RepositoryItems.Add(spinspinQteEdit); Grid_Details.RepositoryItems.Add(spinRatioEdit); Grid_Details.RepositoryItems.Add(spinEdit); #endregion #region : Events this.Activated += Frm_Invoices_Activated; GLkp_PartName.ButtonClick += GLkp_PartName_ButtonClick; /*احتساب قيم و نسب الضريبة*/ Sp_DiscValue.Enter += new EventHandler(Sp_InvDiscValue_Enter); Sp_DiscValue.Leave += Sp_InvDiscValue_Leave;; Sp_DiscValue.EditValueChanged += Sp_InvDiscValue_EditValueChanged; Sp_DiscRatio.EditValueChanged += Sp_InvDiscValue_EditValueChanged; Sp_TaxValue.Enter += Sp_InvTaxValue_Enter; Sp_TaxValue.Leave += Sp_InvTaxValue_Leave; Sp_TaxValue.EditValueChanged += Sp_InvTaxValue_EditValueChanged; Sp_TaxRatio.EditValueChanged += Sp_InvTaxValue_EditValueChanged; Sp_Total.EditValueChanged += Spn_EditValueChanged; Sp_Expences.EditValueChanged += Spn_EditValueChanged; Sp_Expences.EditValueChanged += Sp_InvPaid_EditValueChanged; Sp_Paid.EditValueChanged += Sp_InvPaid_EditValueChanged; Sp_Net.DoubleClick += Sp_Net_DoubleClick; Sp_Net.EditValueChanging += Sp_Net_EditValueChanging; /* الصنف "ID" جلب الوحدات حسب*/ Grid.CustomRowCellEditForEditing += GridCustomRowCellEditForEditing; /* جلب بيانات وحدة الصنف */ Grid.CellValueChanged += GridCellValueChanged; Grid.RowCountChanged += GridRowCountChanged; Grid.RowUpdated += GridRowUpdated; Lkp_Branch.EditValueChanging += Lkp_Branch_EditValueChanging; Grid.CustomUnboundColumnData += GridCustomUnboundColumnData; Grid_Details.ProcessGridKey += Grid_Details_ProcessGridKey; Grid.ValidateRow += GridValidateRow; Grid.InvalidRowException += GridInvalidRowException; #endregion MoveFocusToGrid(); }
private void GridSetting() { gvDetail.Columns.ColumnByName("colVoucherDetailId").OptionsColumn.ReadOnly = true; gvDetail.Columns.ColumnByName("colVoucherMasterId").OptionsColumn.ReadOnly = true; gvDetail.Columns.ColumnByName("colVoucherDetailId").Visible = false; gvDetail.Columns.ColumnByName("colVoucherMasterId").Visible = false; gvDetail.Columns.ColumnByName("colCustomerCode").Visible = false; gvDetail.Columns.ColumnByName("colVendorCode").Visible = false; gvDetail.Columns.ColumnByName("colCOAId").Caption = "Account Name"; gvDetail.Columns.ColumnByName("colAccountCode").Caption = "Account Code"; gvDetail.Columns.ColumnByName("colFlagDC").Caption = "D/C"; gvDetail.Columns.ColumnByName("colAmount").Caption = "Amount"; gvDetail.Columns.ColumnByName("colRemarks").Caption = "Remarks"; gvDetail.Columns.ColumnByName("colAccountCode").VisibleIndex = 0; gvDetail.Columns.ColumnByName("colCOAId").VisibleIndex = 1; gvDetail.Columns.ColumnByName("colFlagDC").VisibleIndex = 2; gvDetail.Columns.ColumnByName("colAmount").VisibleIndex = 3; gvDetail.Columns.ColumnByName("colRemarks").VisibleIndex = 4; gvDetail.Columns.ColumnByName("colCOAId").Width = 150; gvDetail.Columns.ColumnByName("colAccountCode").Width = 100; gvDetail.Columns.ColumnByName("colFlagDC").Width = 80; gvDetail.Columns.ColumnByName("colAmount").Width = 100; gvDetail.Columns.ColumnByName("colRemarks").Width = 200; bsCOA.DataSource = dsMain; bsCOA.DataMember = "ChartOfAccounts"; bsFlagDC.DataSource = dsMain; bsFlagDC.DataMember = "FlagDC"; repositoryGridLookup.DataSource = bsCOA; repositoryGridLookup.DisplayMember = "AccountName"; repositoryGridLookup.ValueMember = "COAId"; repositoryGridLookup.PopupFormSize = new Size(380, 150); repositoryGridLookup.NullText = ""; repositoryGridLookup.ShowFooter = true; repositoryGridLookup.View.OptionsView.ColumnAutoWidth = false; repositoryGridLookup.PopulateViewColumns(); GCDetail.RepositoryItems.Add(repositoryGridLookup); (GCDetail.MainView as GridView).Columns.ColumnByName("colCOAId").ColumnEdit = repositoryGridLookup; if (repositoryGridLookup.View.Columns.Count > 0) { repositoryGridLookup.View.Columns.ColumnByName("colCOAId").Visible = false; repositoryGridLookup.View.Columns.ColumnByName("colAccountCode").Caption = "Code"; repositoryGridLookup.View.Columns.ColumnByName("colAccountName").Caption = "Account Name"; repositoryGridLookup.View.Columns.ColumnByName("colAccountCode").Width = 80; repositoryGridLookup.View.Columns.ColumnByName("colAccountName").Width = 250; repositoryGridLookup.View.Columns.ColumnByName("colAccountCode").VisibleIndex = 0; repositoryGridLookup.View.Columns.ColumnByName("colAccountName").VisibleIndex = 1; } repositoryAccountCodeGridLookup.DataSource = bsCOA; repositoryAccountCodeGridLookup.DisplayMember = "AccountCode"; repositoryAccountCodeGridLookup.ValueMember = "AccountCode"; repositoryAccountCodeGridLookup.PopupFormSize = new Size(380, 150); repositoryAccountCodeGridLookup.NullText = ""; repositoryAccountCodeGridLookup.ShowFooter = true; repositoryAccountCodeGridLookup.View.OptionsView.ColumnAutoWidth = false; repositoryAccountCodeGridLookup.PopulateViewColumns(); GCDetail.RepositoryItems.Add(repositoryAccountCodeGridLookup); (GCDetail.MainView as GridView).Columns.ColumnByName("colAccountCode").ColumnEdit = repositoryAccountCodeGridLookup; if (repositoryAccountCodeGridLookup.View.Columns.Count > 0) { repositoryAccountCodeGridLookup.View.Columns.ColumnByName("colCOAId").Visible = false; repositoryAccountCodeGridLookup.View.Columns.ColumnByName("colAccountCode").Caption = "Code"; repositoryAccountCodeGridLookup.View.Columns.ColumnByName("colAccountName").Caption = "Account Name"; repositoryAccountCodeGridLookup.View.Columns.ColumnByName("colAccountCode").Width = 80; repositoryAccountCodeGridLookup.View.Columns.ColumnByName("colAccountName").Width = 250; repositoryAccountCodeGridLookup.View.Columns.ColumnByName("colAccountCode").VisibleIndex = 0; repositoryAccountCodeGridLookup.View.Columns.ColumnByName("colAccountName").VisibleIndex = 1; } repositoryFlagGridLookup.DataSource = bsFlagDC; repositoryFlagGridLookup.DisplayMember = "Flag"; repositoryFlagGridLookup.ValueMember = "FlagDC"; repositoryFlagGridLookup.PopupFormMinSize = new Size(100, 90); //repositoryFlagGridLookup. = new Size(50, 50); repositoryFlagGridLookup.PopupFormSize = new Size(100, 90); repositoryFlagGridLookup.NullText = ""; repositoryFlagGridLookup.ShowFooter = true; repositoryFlagGridLookup.View.OptionsView.ColumnAutoWidth = false; repositoryFlagGridLookup.PopulateViewColumns(); GCDetail.RepositoryItems.Add(repositoryFlagGridLookup); (GCDetail.MainView as GridView).Columns.ColumnByName("colFlagDC").ColumnEdit = repositoryFlagGridLookup; if (repositoryFlagGridLookup.View.Columns.Count > 0) { repositoryFlagGridLookup.View.Columns.ColumnByName("colFlagDC").Visible = false; repositoryFlagGridLookup.View.Columns.ColumnByName("colFlag").Width = 80; } //gvDetail.Columns.ColumnByName("colAccountCode").Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left; //gvDetail.Columns.ColumnByName("colCOAId").Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left; }