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