private void BarbtnOpen_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { CTechCore.Tools.frmSearch frm = new CTechCore.Tools.frmSearch(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(typeof(CTechCore.WaitForms.frmWaitBasic)); DataTable dt = new DataTable(); MyApp.CTech.ExecSQL($"select AutoIndex, OrderNum, Account, Name, OrderDate, ulIDPOrdConfirmed State from vw_XR_PurchaseOrdersForGRV ", ref dt); frm.cntrlSearch1.DataSource = dt; DevExpress.XtraSplashScreen.SplashScreenManager.CloseForm(); frm.cntrlSearch1.gridView1.Columns.ToList().ForEach(c => c.MinWidth = 150); if (frm.ShowDialog() == DialogResult.OK) { if (frm.cntrlSearch1.EditValue is DataRow) { purchaseOrderToGRVBindingSource.DataSource = new PurchaseOrderToGRV(((DataRow)frm.cntrlSearch1.EditValue).Field <Int64>("AutoIndex")); } else if (frm.cntrlSearch1.EditValue is PurchaseOrderToGRV) { purchaseOrderToGRVBindingSource.DataSource = (PurchaseOrderToGRV)frm.cntrlSearch1.EditValue; } PurchaseOrderToGRV grv = (PurchaseOrderToGRV)purchaseOrderToGRVBindingSource.DataSource; gcPOHeader.DataSource = grv.HeaderInfo; gcPODetails.DataSource = grv.DetailInfo; //lkpStokGroup.Enabled = false; } }
private void BarbtnPrintBarcodes_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { PurchaseOrderToGRV grv = (PurchaseOrderToGRV)purchaseOrderToGRVBindingSource.DataSource; List <int> rolls = new List <int>(); DataTable dt = new DataTable(); MyApp.CTech.ExecSQL($"SELECT StockRollID FROM StockRollHdr (NOLOCK) WHERE PONumber = '{grv.HeaderInfo.Table.AsEnumerable().FirstOrDefault().Field<string>("Ordernum")}' ", ref dt); Stock.StockRollItems.PrintBarcodes(dt.AsEnumerable().Select(r => (int)r["StockRollID"]).ToList()); }
private void gvPODetails_DoubleClick(object sender, EventArgs e) { DevExpress.Utils.DXMouseEventArgs ea = e as DevExpress.Utils.DXMouseEventArgs; DevExpress.XtraGrid.Views.Grid.GridView view = sender as DevExpress.XtraGrid.Views.Grid.GridView; DevExpress.XtraGrid.Views.Grid.ViewInfo.GridHitInfo info = view.CalcHitInfo(ea.Location); if (info.InRow || info.InRowCell) { frmReceiveStock frm = new frmReceiveStock((DataRow)view.GetDataRow(info.RowHandle)); frm.StartPosition = FormStartPosition.CenterParent; if (frm.ShowDialog() == DialogResult.OK) { PurchaseOrderToGRV grv = (PurchaseOrderToGRV)purchaseOrderToGRVBindingSource.DataSource; grv.Reload(); gcPOHeader.DataSource = grv.HeaderInfo; gcPODetails.DataSource = grv.DetailInfo; } } }
private void BarbtnProcess_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (lkpBinLocation.EditValue == null) { MessageBox.Show("Please select a bin location for all these items", "Invalid Bin Location ", MessageBoxButtons.OK); lkpBinLocation.Focus(); return; } if (lkpBinLocation.Text.ToLower() == "photo") { //if(not user in ("vanessa", "richard", "cheslyn") ) //if not((vStaffID = 'vanessa') or(vStaffID = 'cheslyn') or(vStaffID = 'richard')) then //begin // messagedlg('You are not permitted to use this bin location', mtError, [mbOK], 0); // exit; //end; } PurchaseOrderToGRV grv = (PurchaseOrderToGRV)purchaseOrderToGRVBindingSource.DataSource; string OrdNumber = grv.HeaderInfo.Table.AsEnumerable().FirstOrDefault().Field <string>("OrderNum"); if (MessageBox.Show($"Are you sure that you want to create a GRV for Purchase Order number '{OrdNumber}'?'", "Please confirm", MessageBoxButtons.YesNo) == DialogResult.Yes) { UseWaitCursor = true; grv.Location = lkpBinLocation.Text; DataSet results = (DataSet)CTechCore.WaitForms.cWaitWindow.Show(grv.Process, "", new object[] { }); List <int> rolls = results.Tables.OfType <DataTable>().ToList().SelectMany(t => t.AsEnumerable().Select(r => (int)r["StockRollID"])).ToList(); Stock.StockRollItems.PrintBarcodes(rolls); grv.Reload(grv.DocumentNumber); purchaseOrderToGRVBindingSource.DataSource = grv; gcPOHeader.DataSource = grv.HeaderInfo; gcPODetails.DataSource = grv.DetailInfo; UseWaitCursor = false; } }