private void ppDeliverMethod_EditValueChanged(object sender, EventArgs e) { layoutControlGroup10.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; layoutControlItem22.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; CTechCore.Tools.CustomControls.CustomSearchEditor cntrl = (CTechCore.Tools.CustomControls.CustomSearchEditor)sender; if (cntrl.EditValue is int && (int)cntrl.EditValue > 0) { DataView dv = (DataView)cntrl.Properties.DataSource; DataRow dr = dv.Table.Select($"counter = {(int)cntrl.EditValue}").FirstOrDefault(); if (dr.Field <string>("method").ToUpper().StartsWith("3RD")) { layoutControlGroup10.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layoutControlItem22.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; } } else if (cntrl.EditValue is DataRow) { DataRow dr = (DataRow)cntrl.EditValue; if (dr.Field <string>("method").ToUpper().StartsWith("3RD")) { layoutControlGroup10.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layoutControlItem22.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; } } }
private void ppStk_EditValueChanged(object sender, EventArgs e) { Decimal finalPrice = 0; CTechCore.Tools.CustomControls.CustomSearchEditor cntrl = (CTechCore.Tools.CustomControls.CustomSearchEditor)sender; DataRow dr = ((DataView)cntrl.Properties.DataSource).Table.Select($"StockLink = {(int)cntrl.EditValue}").FirstOrDefault(); int stockLink = int.Parse(dr["StockLink"].ToString()); Decimal defaultPrice = Decimal.Parse(dr["fExclPrice"].ToString()); SalesOrder so = (SalesOrder)salesOrderBindingSource.DataSource; Detail soLine = (Detail)gridView1.GetFocusedRow(); Models.Stock.StockPrice CurPrice = new Models.Stock.StockPrice(ClientID: so.CustomerID, docdate: so.OrderDate, stockId: (int)cntrl.EditValue, qty: 0); if (soLine.PriceListID > 0) { DataTable dt = new DataTable(); MyApp.Evo.ExecSQL($"SELECT * FROM zz_CTECH_InvLinesDiscInfo WHERE AutoIDX = {soLine.PriceListID}", ref dt); if (dt.Rows.Count > 0) { CurPrice.ID = dt.Rows[0].Field <int>("AutoIDX"); if ( dr.Field <int>("StockLink") == int.Parse(dt.Rows[0]["StockLink"].ToString()) && (so.OrderDate >= DateTime.Parse(dt.Rows[0]["dEffDate"].ToString()) && so.OrderDate <= DateTime.Parse(dt.Rows[0]["dExpDate"].ToString()))) { CurPrice.SpecialPrice = bool.Parse(dt.Rows[0]["bUseStockPrc"].ToString()) ? decimal.Parse(dt.Rows[0]["fPriceDisc"].ToString()) : 0; CurPrice.UseStockPrc = bool.Parse(dt.Rows[0]["bUseStockPrc"].ToString()); CurPrice.UseThisPriceExcl = decimal.Parse(dt.Rows[0]["fPriceDisc"].ToString()); } } } finalPrice = CurPrice.UseThisPriceExcl; }
private void PpAddress_EditValueChanged(object sender, EventArgs e) { CTechCore.Tools.CustomControls.CustomSearchEditor cntrl = (CTechCore.Tools.CustomControls.CustomSearchEditor)sender; DataRow row = (DataRow)cntrl.EditValue; txtAddr1.Text = row["Address1"].ToString(); txtAddr2.Text = row["Address2"].ToString(); txtAddr3.Text = row["Address3"].ToString(); txtAddr4.Text = row["Address4"].ToString(); txtAddr5.Text = row["Address5"].ToString(); txtAddrPC.Text = row["AddressPC"].ToString(); txtName.Text = row["Name"].ToString(); txtcontactnumber.Text = row["ContactNumber"].ToString(); txtContactPerson.Text = row["ContactPerson"].ToString(); }
private void ppRep_EditValueChanged(object sender, EventArgs e) { SalesOrder so = (SalesOrder)salesOrderBindingSource.DataSource; CTechCore.Tools.CustomControls.CustomSearchEditor cntrl = (CTechCore.Tools.CustomControls.CustomSearchEditor)sender; if (cntrl.EditValue is int && (int)cntrl.EditValue > 0) { DataView dv = (DataView)cntrl.Properties.DataSource; DataRow dr = dv.Table.Select($"idSalesRep = {(int)cntrl.EditValue}").FirstOrDefault(); so.SalesRepresentativeEMail = dr.Field <string>("RepMail"); } else if (cntrl.EditValue is DataRow) { so.SalesRepresentativeEMail = ((DataRow)cntrl.EditValue).Field <string>("RepMail"); } else { } }
private void ppCustomer_EditValueChanged(object sender, EventArgs e) { CTechCore.Tools.CustomControls.CustomSearchEditor cntrl = ((CTechCore.Tools.CustomControls.CustomSearchEditor)sender); if (cntrl.EditValue != null && cntrl.EditValue is int && (int)cntrl.EditValue > 0) { SalesOrder so = (SalesOrder)salesOrderBindingSource.DataSource; Cursor.Current = Cursors.WaitCursor; ppStk.DataSource = new DataView(HertexData.StockItems.GetStockItemList((int)cntrl.EditValue)); ppStk.PopupControl.Width = 1000; ppStk.cntrlSearch1.Columns.ToList().ForEach(c => c.Visible = new List <string>() { "Item", "ItemDesc", "ItemGroup" }.Contains(c.FieldName)); ppStk.cntrlSearch1.Columns["Item"].MinWidth = 100; ppStk.cntrlSearch1.Columns["ItemDesc"].MinWidth = 300; ppStk.cntrlSearch1.Columns["ItemColour"].MinWidth = 200; Console.WriteLine($"lookup stk: {so.CustomerInfo.Field<int>("ClientID")} | {so.CustomerInfo.Field<string>("Account")} | {so.CustomerInfo.Field<string>("Name")}"); Cursor.Current = Cursors.Default; } else { ppStk.DataSource = null; } }