private void DtaListaServicos_SelectedCellsChanged(object sender, System.Windows.Controls.SelectedCellsChangedEventArgs e)
        {
            objetoSelecaoServico = dtaListaServicos.SelectedValue;

            btnExcluirServico.IsEnabled = true;
            btnEditarServico.IsEnabled  = true;
        }
 private void dg_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
 {
     txtb查詢欄位.Text = dg.CurrentCell.Column.Header.ToString();
     DataGridCellInfo cell = e.AddedCells[0];
     TextBlock text = cell.Column.GetCellContent(e.AddedCells[0].Item) as TextBlock;
     txt查詢值.Text = text.Text;
 }
 private void ReservierungData_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
 {
     ColumnData data = ReservierungData.SelectedItem as ColumnData;
     this.cbZimmerEdit.Text = "--Bitte Zimmer wählen--";
     FillData(data);
     
 }
示例#4
0
 private void AccountListData_SelectedCellsChanged(object sender, System.Windows.Controls.SelectedCellsChangedEventArgs e)
 {
     try
     {
         if (AccountListData.SelectedItem != null)
         {
             ProfileRF temp = AccountListData.SelectedItem as ProfileRF;
             tb_serialID.Text    = temp.SERIAL_ID;
             tb_name.Text        = temp.NAME;
             dp_dateofbirth.Text = temp.BIRTHDAY.ToLongDateString();
             tb_student.Text     = temp.STUDENT;
             cbb_class.Text      = temp.CLASS;
             tb_email.Text       = temp.EMAIL;
             tb_address.Text     = temp.ADDRESS;
             tb_phone.Text       = temp.PHONE;
             if (temp.GENDER == Constant.Gender.Male)
             {
                 rb_male.IsChecked = true;
             }
             else
             {
                 rb_female.IsChecked = true;
             }
         }
     }
     catch (Exception ex)
     {
         logFile.Error(ex.Message);
     }
 }
示例#5
0
 private void grid_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
 {
     if (e.AddedCells.Count == 0)
         return;
      //进入编辑模式  这样单击一次就可以打勾了
      existedLayerGrid.BeginEdit();
 }
        private void dataGridOlympiads_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            try
            {
                int oldOlyID = OlympiadID;

                UpdateOlympiadID();
                if (oldOlyID == OlympiadID)
                {
                    return;
                }

                if (tabItemMain.IsSelected)
                {
                    UpdateMainTab();
                }
                else if(tabItemOlympiads.IsSelected)
                {
                    UpdateOlympiadsTab();
                }
                else if (tabItemOlympiads2.IsSelected)
                {
                    UpdateOlympiadsTab2();
                }
                else if(tabItemQuery.IsSelected)
                {
                    UpdateQueries();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
 private void DataGrid_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
 {
     var order = OrdersDataGrid.SelectedItem as OrderVM;
     EmptyWindow ew = new EmptyWindow(order.Name);
     ew.Body.Children.Add(new ProjectsUserControl(order.Order));
     ew.Show();
 }
		private void DataGrid_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
		{
			DataGrid dataGrid = sender as DataGrid;
			if (dataGrid != null && dataGrid.SelectedItem != null && !dataGrid.IsMouseOver)
			{
				dataGrid.ScrollIntoView(dataGrid.SelectedItem);
			}
		}
示例#9
0
        private void AccountListData_SelectedCellsChanged(object sender, System.Windows.Controls.SelectedCellsChangedEventArgs e)
        {
            try
            {
                if (AccountListLocal.SelectedItem != null)
                {
                    ProfileRF temp = AccountListLocal.SelectedItem as ProfileRF;

                    if (temp.STATUS == "Active")
                    {
                        btn_changestatuslb.Content = "Suspend Profile";
                        img_profileStatus.Source   = new System.Windows.Media.Imaging.BitmapImage(new Uri(@"pack://*****:*****@"pack://siteoforigin:,,,/Resources/resultset_next.png"));
                    }

                    tb_serialID.Text    = temp.PIN_NO;
                    tb_adno.Text        = temp.ADNO;
                    tb_name.Text        = temp.NAME;
                    dp_dateofbirth.Text = temp.DOB.ToLongDateString();
                    dp_disu.Text        = temp.DISU.ToLongDateString();
                    cbb_class.Text      = temp.CLASS;
                    //cbb_status.Text = temp.STATUS;
                    tb_email.Text   = temp.EMAIL;
                    tb_image.Text   = temp.IMAGE;
                    tb_address.Text = temp.ADDRESS;
                    tb_phone.Text   = temp.PHONE;
                    cb_automanicsuspension.IsChecked = temp.CHECK_DATE_TO_LOCK;
                    dp_datetolock.Text = temp.DATE_TO_LOCK.ToLongDateString();
                    if (temp.GENDER == Constant.Gender.Male)
                    {
                        rb_male.IsChecked = true;
                    }
                    else
                    {
                        rb_female.IsChecked = true;
                    }

                    try
                    {
                        img_profile.Source = new System.Windows.Media.Imaging.BitmapImage(new Uri(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\ATEK\Image\" + temp.IMAGE));
                    }
                    catch
                    {
                        img_profile.Source = new System.Windows.Media.Imaging.BitmapImage(new Uri(@"pack://siteoforigin:,,,/Resources/" + "images.png"));
                    }
                }
            }
            catch (Exception ex)
            {
                logFile.Error(ex.Message);
                Constant.mainWindowPointer.WriteLog(ex.Message);
            }
        }
示例#10
0
        private void DgCrossRef_SelectedCellsChanged(object sender, System.Windows.Controls.SelectedCellsChangedEventArgs e)
        {
            object item       = this.dgCrossRef.SelectedItem;
            var    filePath   = (this.dgCrossRef.SelectedCells[1].Column.GetCellContent(item) as TextBlock).Text;
            var    variable   = (this.dgCrossRef.SelectedCells[2].Column.GetCellContent(item) as TextBlock).Text;
            var    lineNumber = this.ViewModel.ShowSelectedFile(filePath, variable);

            this.FocusSelectedVariable(lineNumber);
        }
示例#11
0
        protected override void OnSelectedCellsChanged(SelectedCellsChangedEventArgs e)
        {
            foreach (var dataGridCellInfo in e.AddedCells.Where(dataGridCellInfo => (string) dataGridCellInfo.Column.Header == "Timestamp"))
            {
                SelectedCells.Remove(dataGridCellInfo);
            }

            base.OnSelectedCellsChanged(e);
        }
示例#12
0
 private void StudentGridSelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
 {
     foreach (DataGridCellInfo item in e.AddedCells) {
         var student = (StudentDTO) item.Item;
         tbAvg.Text = student.Avg.ToString();
         tbCode.Text = student.Code;
         tbFullname.Text = student.Fullname;
         dpBirthday.Text = DateTime.Parse(student.Birthday.ToString()).ToString();
     }
 }
示例#13
0
        private void dataGrid_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            if (dataGrid.SelectedItem != null)
            {
                CurrentProcess = (from proc in processes
                                 where proc.Id == ((GridObject)dataGrid.SelectedItem).ID
                                 select proc).FirstOrDefault();
            }

            //MessageBox.Show(CurrentProcess.Id.ToString());
        }
示例#14
0
        private void dataGrid_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            if (dataGrid.SelectedItems.Count > 0)
                for (int i = 0; i < dataGrid.SelectedItems.Count; i++)
                {
                    System.Data.DataRowView selectedFile = (System.Data.DataRowView)dataGrid.SelectedItems[i];
                    selectedRunId = selectedFile.Row.ItemArray[0].ToString();

                    recreateArchivedRun(selectedRunId);
                }
        }
        private void dgvAdm_FinalProcurement_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            object item = dgvSale_ContactCustDetails.SelectedItem;
            ContactCID = Convert.ToInt32((dgvSale_ContactCustDetails.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text);
            //loadStockProducts();
            frmCRM_Adm_Dashbord ad2 = new frmCRM_Adm_Dashbord();
            txtCCDID.Text = ContactCID.ToString();
            ad2.ContactCDname(txtCCDID.Text);
            DialogResult = true;
            this.Close();

        }
        private void DataGrid_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            DataGrid dataGrid = (DataGrid)sender;
            if (dataGrid.SelectedCells.Count == 0)
                return;

            DecisionTableViewModel viewModel = DataContext as DecisionTableViewModel;
            if (viewModel != null)
            {
                viewModel.SelectedRuleIndex = dataGrid.SelectedCells[0].Column.DisplayIndex - 1;
            }
        }
示例#17
0
        private void DataGrid_SelectedCellChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            var viewModel = DataContext as ReviewActivityViewModel;

            if (viewModel != null)
            {
                 if (viewModel.SelectedActivityItem != null)
                 {
                     activityItemView.SelectedCategory = viewModel.SelectedActivityItem.Category;
                 }
            }
        }
示例#18
0
        private void ReservierungData_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {    
            Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
            app.Visible = true;
            app.WindowState = XlWindowState.xlMaximized;

           // Workbook wb = app.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
            //Für Install version
            //string path = ".\\Excel\\RechnungZimmer.xltx";
            string path = System.IO.Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)+"\\Excel\\RechnungZimmer.xltx";
            Workbook wb = app.Workbooks.Open(path);
            Worksheet ws = wb.Worksheets[1];
            DateTime currentDate = DateTime.Now;
            ColumnData data = ReservierungData.SelectedItem as ColumnData;


            ZimmerTyp zimmerT = hm.repZimmerTyp.GetById(data.buchung.idZimmerTyp);
            //Anpassung an Rechnungsvorlage
            ws.Range["A19"].Value = "="+data.buchung.erwachseneBuchung + "+" + data.buchung.kinderBuchung;
            ws.Range["A20"].Value = data.buchung.erwachseneBuchung;
            ws.Range["I9"].Value = currentDate.ToShortDateString();
            ws.Range["E14:F14"].Value = data.buchung.vonBuchung;
            ws.Range["I14"].Value = data.buchung.bisBuchung;
            if(data.buchung.preisBuchung != null)
                ws.Range["I19"].Value = data.buchung.preisBuchung;
            else
                ws.Range["I19"].Value = zimmerT.preis;
            ws.Range["I20"].Value = "="+data.buchung.erwachseneBuchung+"*1";
            ws.Range["I22"].Value = "=I19+I20";
            ws.Range["I25"].Value = "=I22-I23";
            ws.Range["I30"].Value = "=I20";
            ws.Range["D30:E30"].Value = "=I30";
            ws.Range["B19"].Value = "Übernachtung " + zimmerT.typBezeichnung;
            //<ORTSTAXE Lösung Überlegen>


            
            //SaveDialog
            Stream myStream;
            SaveFileDialog saveFileDialog1 = new SaveFileDialog();

            saveFileDialog1.Filter = "Excel Datei (*.xlsx)|*.xlsx|All files (*.*)|*.*";
            saveFileDialog1.FilterIndex = 0;
            saveFileDialog1.RestoreDirectory = true;

            if (saveFileDialog1.ShowDialog() == DialogResult.OK)
            {
                wb.SaveAs(saveFileDialog1.FileName);     
            }

           // wb.SaveAs("D:\\Schule\\GIT_Projects\\HRM_Diplomarbeit\\vitoshacademy11.xlsx");
        }
示例#19
0
        private void gridQueues_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            if (this.gridQueues.SelectedItem is QueueDescription) {
                QueueDescription qd = (QueueDescription)this.gridQueues.SelectedItem;

                this.gridMessages.ItemsSource = this.queueAdmin.ListTop10Messages(qd.Url);

                this.buttonDeleteQueue.IsEnabled = true;
                return;
            }

            this.buttonDeleteQueue.IsEnabled = false;
        }
 private void productsTable_SelectedCellsChanged(object sender, System.Windows.Controls.SelectedCellsChangedEventArgs e)
 {
     if (productsTable.SelectedItem != null)
     {
         var product = (Product)productsTable.SelectedItem;
         idTB.Text       = $"{product.Id}";
         nameTB.Text     = $"{product.Name}";
         priceTB.Text    = $"{product.Price}";
         inStockTB.Text  = $"{product.InStock}";
         reservedTB.Text = $"{product.Reserved}";
         soldTB.Text     = $"{product.Sold}";
     }
 }
示例#21
0
        private void scheduleItemsDataGrid_SelectedCellsChanged(object sender, System.Windows.Controls.SelectedCellsChangedEventArgs e)
        {
            if (e.AddedCells.Count == 0)
            {
                return;
            }
            var    currentCell = e.AddedCells[0];
            string header      = (string)currentCell.Column.Header;

            if (currentCell.Column == dg_groups.Columns[3])
            {
                dg_groups.BeginEdit();
            }
        }
        private static void DataGridSelectionChanged(SelectedCellsChangedEventArgs args, RecordsCollection data)
        {
            if (!args.AddedCells.Any())
            {
                data.SelectedRow = -1;
                data.SelectedHeader = -1;

                return;
            }

            data.SelectedRow = data.Records.IndexOf((ObservableCollection<string>)args.AddedCells[0].Item);
            data.SelectedHeader = args.AddedCells[0].Column.DisplayIndex;

            ServiceLocator.Current.GetInstance<Messenger>().Send(new DataGridSelectionChangedMessage(data));
        }
        /// <summary>
        /// Handles the user clicking a cell on the map.
        /// </summary>
        /// <param name="sender">The sender.</param>
        /// <param name="e">The args.</param>
        private void DataGrid_SelectedCellsChanged(object sender, System.Windows.Controls.SelectedCellsChangedEventArgs e)
        {
            DataGrid grid = sender as DataGrid ?? throw new InvalidOperationException("Unable to convert sender to a datagrid.");

            if (grid.SelectedCells.Any())
            {
                Array2DRowView row =
                    grid.SelectedCells.FirstOrDefault().Item as Gu.Wpf.DataGrid2D.Array2DRowView ?? throw new InvalidOperationException("Unable to convert row to a Array2DRowView.");

                int x = grid.SelectedCells.FirstOrDefault().Column.DisplayIndex;
                int y = row.Index;
                this.context.SelectedSquare = this.context.CurrentWorld.Grid.GetSquare(y, x);
            }
            else
            {
                this.context.SelectedSquare = null;
            }
        }
        private void dgrdFEmployeeDetails_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            try
            {
                var id1 = (DataRowView)dgrdFEmployeeDetails.SelectedItem; //get specific ID from          DataGrid after click on Edit button in DataGrid   
                PK_ID = Convert.ToInt32(id1.Row["ID"].ToString());
                con.Open();
                //string sqlquery = "SELECT * FROM Pre_Products where ID='" + PK_ID + "' ";
                string sqlquery = "SELECT [ID],[EmployeeFirstName] + ' ' + [EmployeeLastName] AS [EmpName] FROM [tbl_Employee] WHERE [ID]= '" + PK_ID + "'";
                SqlCommand cmd = new SqlCommand(sqlquery, con);
                SqlDataAdapter adp = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                adp.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    txtFEmpID.Text = dt.Rows[0]["ID"].ToString();
                    txtFEmpName.Text = dt.Rows[0]["EmpName"].ToString();
                }
                frmCRM_Adm_Dashbord obj = new frmCRM_Adm_Dashbord();
                obj.femp(txtFEmpID.Text, txtFEmpName.Text);
            }
            catch
            {
                throw;
            }
            finally
            {
                con.Close();
            }

           // object item = dgrdFEmployeeDetails .SelectedItem;
           // FEmpID = Convert.ToInt32((dgrdFEmployeeDetails.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text);
           // FEName=(dgrdFEmployeeDetails.SelectedCells[2].Column.GetCellContent(item) as TextBlock).Text;
           // FEName2 = (dgrdFEmployeeDetails.SelectedCells[3].Column.GetCellContent(item) as TextBlock).Text;
           // cmbname = FEName + FEName2;
           // //loadStockProducts();
           // frmCRM_Adm_Dashbord ad = new frmCRM_Adm_Dashbord();
           //// ad.FEmpID = FEmpID;
           //// ad.cmbname = cmbname;
           //// ad.Show();
           // eid = FEmpID.ToString();
           // ad.femp(eid);
            
        }
示例#25
0
        private void selectedList_SelectedCellsChanged(object sender, System.Windows.Controls.SelectedCellsChangedEventArgs e)
        {
            var    datagrid = (DataGrid)sender;
            string name     = datagrid.Name.ToString();

            if (datagrid.SelectedItem != null)
            {
                switch (name)
                {
                case "namesList":
                    SelectedGrid = namesList;
                    prisonersList.SelectedItem = null;
                    worldList.SelectedItem     = null;
                    graveyardList.SelectedItem = null;
                    break;

                case "prisonersList":
                    SelectedGrid               = prisonersList;
                    namesList.SelectedItem     = null;
                    worldList.SelectedItem     = null;
                    graveyardList.SelectedItem = null;
                    break;

                case "worldList":
                    SelectedGrid = worldList;
                    prisonersList.SelectedItem = null;
                    namesList.SelectedItem     = null;
                    graveyardList.SelectedItem = null;
                    break;

                case "graveyardList":
                    SelectedGrid = graveyardList;
                    prisonersList.SelectedItem = null;
                    worldList.SelectedItem     = null;
                    namesList.SelectedItem     = null;
                    break;

                default: break;
                }
            }
            shake();
            save();
        }
 private void dg_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
 {
     if (!Validator.IsValid(dg))
     {
         DataGridRow dr = (Validator.GetErrorElement(dg) as DataGridRow);
         if (dr != null)
         {
             dg.SelectedItem = dr.Item;
             UIElement eu = dr as UIElement;
             eu.MoveFocus(new TraversalRequest(FocusNavigationDirection.Left));
             dg.BeginEdit();
         }
         else
         {
             MessageBox.Show(sender.GetType().ToString());
         }
     }
     tbPosElem.Text = (dg.SelectedIndex+1).ToString() + " из " + (dg.Items.Count).ToString();
 }
 /**<summary>选中内容发生变化</summary>**/
 private void DevicesList_SelectedCellsChanged(object sender, System.Windows.Controls.SelectedCellsChangedEventArgs e)
 {
     CurrentDevice = DevicesList.SelectedItem as Device;
 }
        // This method is called from DataGrid.OnSelectedCellsChanged
        // Raises the selection events when Cell selection changes
        internal void RaiseAutomationCellSelectedEvent(SelectedCellsChangedEventArgs e)
        {
            // If the result of an AddToSelection or RemoveFromSelection is a single selected cell,
            // then all we raise is the ElementSelectedEvent for single item
            if (AutomationPeer.ListenerExists(AutomationEvents.SelectionItemPatternOnElementSelected) &&
                this.OwningDataGrid.SelectedCells.Count == 1 && e.AddedCells.Count == 1)
            {
                DataGridCellItemAutomationPeer cellPeer = GetCellItemPeer(e.AddedCells[0]);
                if (cellPeer != null)
                {
                    cellPeer.RaiseAutomationEvent(AutomationEvents.SelectionItemPatternOnElementSelected);
                }
            }
            else
            {
                int i;
                if (AutomationPeer.ListenerExists(AutomationEvents.SelectionItemPatternOnElementAddedToSelection))
                {
                    for (i = 0; i < e.AddedCells.Count; i++)
                    {
                        DataGridCellItemAutomationPeer cellPeer = GetCellItemPeer(e.AddedCells[i]);
                        if (cellPeer != null)
                        {
                            cellPeer.RaiseAutomationEvent(AutomationEvents.SelectionItemPatternOnElementAddedToSelection);
                        }
                    }
                }

                if (AutomationPeer.ListenerExists(AutomationEvents.SelectionItemPatternOnElementRemovedFromSelection))
                {
                    for (i = 0; i < e.RemovedCells.Count; i++)
                    {
                        DataGridCellItemAutomationPeer cellPeer = GetCellItemPeer(e.RemovedCells[i]);
                        if (cellPeer != null)
                        {
                            cellPeer.RaiseAutomationEvent(AutomationEvents.SelectionItemPatternOnElementRemovedFromSelection);
                        }
                    }
                }
            }
        }
示例#29
0
 /// <summary>
 /// 资源库中资源选中状态变化了,预览窗口也跟着变化
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void OnResourceSelected(object sender, SelectedCellsChangedEventArgs e)
 {
     ResItem item = resourceDataGrid.SelectedItem as ResItem;
     BitmapImage bi = null;
     switch (item.ResType)
     {
         case ResourceType.image:
             bi = new BitmapImage(new Uri(projectPath + "/resource/" + item.url, UriKind.Absolute));
             break;
         case ResourceType.sheet:
             bi = new BitmapImage(new Uri(projectPath + "/resource/" + item.Image.url, UriKind.Absolute));
             break;
         default:
             break;
     }
     img.Source = bi;
     if (bi != null)
     {
         img.Width = bi.PixelWidth;
         img.Height = bi.PixelHeight;
     }
 }
示例#30
0
        private void dataGridViewContacts_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            Contact row = (Contact)dataGridViewContacts.SelectedItem;
            txtFirsN.Text = row.FirstN;
            txtLastN.Text = row.LastN;
            txtMiddleN.Text = row.MiddleN;
            txtPhoneNum.Text = row.PhoneNum;
            txtAdress.Text = row.Adress;

            
        }
示例#31
0
 private void dgv_ChequeDetails_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
 {
     Cheque_FillData();
 }
示例#32
0
 private void RunModel_SelectedCellsChanged(object sender, System.Windows.Controls.SelectedCellsChangedEventArgs e)
 {
     UpdateSelectedCell(sender, Models.Run);
 }
示例#33
0
        private void dgvAdm_FinalProcurement_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            //try
            //{
            //    //var id1 = (DataRowView)dgvAdm_FinalProcurement.SelectedItem; //get specific ID from          DataGrid after click on Edit button in DataGrid   
            //    //PK_ID = Convert.ToInt32(id1.Row["Id"].ToString());
            //    //con.Open();
            //    ////string sqlquery = "SELECT * FROM tbl_DealerEntry where Id='" + PK_ID + "' ";

            //    //string sqlquery = "SELECT P.[ID],P.[DealerID],P.[Domain_ID],P.[Product_ID],P.[Brand_ID],P.[P_Category],P.[Model_No_ID],P.[Color_ID],P.[Warranty],P.[Quantity],P.[C_Date],P.[Net_Amount] " +
            //    //      ",D.[DealerFirstName] + '' + D.[DealerLastName] AS [DealerName],D.[MobileNo],D.[PhoneNo] " +
            //    //      ",DM.[Domain_Name] + ' , ' +  PM.[Product_Name] + ' , ' + B.[Brand_Name] + ' , ' + PC.[Product_Category] + ' , ' + MN.[Model_No] + ' , ' + C.[Color] AS [Products]" +
            //    //      ",PP.[Price] " +
            //    //      "FROM [Pre_Procurement] P " +
            //    //      "INNER JOIN [tbl_DealerEntry] D ON D.[ID] = P.[DealerID] " +
            //    //      "INNER JOIN [tb_Domain] DM ON DM.[ID]=P.[Domain_ID] " +
            //    //      "INNER JOIN [tlb_Products] PM ON PM.[ID]=P.[Product_ID] " +
            //    //      "INNER JOIN [tlb_Brand] B ON B.[ID]=P.[Brand_ID] " +
            //    //      "INNER JOIN [tlb_P_Category] PC ON PC.[ID]=P.[P_Category]" +
            //    //      "INNER JOIN [tlb_Model] MN ON MN.[ID]=P.[Model_No_ID] " +
            //    //      "INNER JOIN [tlb_Color] C ON C.[ID]=P.[Color_ID] " +
            //    //      "INNER JOIN [Pre_Products] PP ON PP.[Model_No_ID]=P.[Model_No_ID] " +
            //    //      "WHERE P.[ID]='" + PK_ID + "' ";
       
            //    //SqlCommand cmd = new SqlCommand(sqlquery, con);
            //    //SqlDataAdapter adp = new SqlDataAdapter(cmd);
            //    //DataTable dt = new DataTable();
            //    //adp.Fill(dt);
            //    //if (dt.Rows.Count > 0)
            //    //{
            //    //    txtAdm_DealerID.Text = dt.Rows[0]["DealerID"].ToString();
            //    //    txtAdm_DomainID.Text = dt.Rows[0]["Domain_ID"].ToString();
            //    //    txtAdm_ProductID.Text = dt.Rows[0]["Product_ID"].ToString();
            //    //    txtAdm_BrandID.Text = dt.Rows[0]["Brand_ID"].ToString();
            //    //    txtAdm_ProductCatID.Text = dt.Rows[0]["P_Category"].ToString();
            //    //    txtAdm_ModelID.Text = dt.Rows[0]["Model_No_ID"].ToString();
            //    //    txtAdm_ColorID.Text = dt.Rows[0]["Color_ID"].ToString();

            //    //    lblProcDate.Content = dt.Rows[0]["C_Date"].ToString();
            //    //    lblProducts.Content = dt.Rows[0]["Products"].ToString();
            //    //    double Abc = Convert.ToDouble(dt.Rows[0]["Net_Amount"].ToString());
            //    //    lblProceNetAmt.Content = Convert.ToDouble(Microsoft.VisualBasic.Strings.Format(Abc, "##,###.00"));
            //    //    double price = Convert.ToDouble(dt.Rows[0]["Price"].ToString());
            //    //    lblProcePrice.Content = Convert.ToDouble(Microsoft.VisualBasic.Strings.Format(price, "##,###.00"));
            //    //    double qt = Convert.ToDouble(dt.Rows[0]["Quantity"].ToString());
            //    //    lblProceQty.Content = Convert.ToDouble(Microsoft.VisualBasic.Strings.Format(qt, "##,###.00"));
            //    //}

            //    //grd_FinalizeProducts.Visibility = System.Windows.Visibility.Visible;
            //}
            //catch(Exception)
            //{
            //    throw;
            //}
            //finally
            //{
            //    con.Close();
            //}
            //Salesid();

            ////Final_PreProcurement();
        }
示例#34
0
        private void dgvAdm_SaleCustomerDetails_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            object item = dgvAdm_SaleCustomerDetails.SelectedItem;
            string ID = (dgvAdm_SaleCustomerDetails.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text;
            //MessageBox.Show(ID);
            try
            {
                con.Open();
                string sqlquery = "SELECT [ID],[Customer_ID] " +
                      "FROM [tlb_Bill_No] " +
                      "WHERE [Bill_No]='" + ID + "' ";

                SqlCommand cmd = new SqlCommand(sqlquery, con);
                SqlDataAdapter adp = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                adp.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    txtSaleCustID.Text = dt.Rows[0]["Customer_ID"].ToString();
                }

                //grd_FinalizeProducts.Visibility = System.Windows.Visibility.Visible;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                con.Close();
            }

            SaleCustomer_ProductDetails();
        }
 protected virtual new void OnSelectedCellsChanged(SelectedCellsChangedEventArgs e)
 {
 }
示例#36
0
 private void dgvInsurance_Details_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
 {
     //frmInsurance obj = new frmInsurance();
     //obj.ShowDialog();
     //obj.LoadYearsMonth();
     //obj.LoadInterval();
 }
示例#37
0
文件: DataGrid.cs 项目: JianwenSun/cc
        /// <summary>
        ///     Fires the public change event when there are pending cell changes.
        /// </summary>
        private void NotifySelectedCellsChanged()
        {
            if (((_pendingSelectedCells != null) && (_pendingSelectedCells.Count > 0)) ||
                ((_pendingUnselectedCells != null) && (_pendingUnselectedCells.Count > 0)))
            {
                // Create the new event args
                SelectedCellsChangedEventArgs e = new SelectedCellsChangedEventArgs(this, _pendingSelectedCells, _pendingUnselectedCells);

                // Calculate the previous and current selection counts to determine if commands need invalidating
                int currentSelectionCount = _selectedCells.Count;
                int unselectedCellCount = (_pendingUnselectedCells != null) ? _pendingUnselectedCells.Count : 0;
                int selectedCellCount = (_pendingSelectedCells != null) ? _pendingSelectedCells.Count : 0;
                int previousSelectionCount = currentSelectionCount - selectedCellCount + unselectedCellCount;

                // Clear the pending lists
                _pendingSelectedCells = null;
                _pendingUnselectedCells = null;

                // Fire the public event
                OnSelectedCellsChanged(e);

                // If old or new selection is empty - invalidate Copy command
                if ((previousSelectionCount == 0) || (currentSelectionCount == 0))
                {
                    // The Copy command needs to have CanExecute run
                    CommandManager.InvalidateRequerySuggested();
                }
            }
        }
 private void dataGrid1_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
 {
     //uzyć Binding do zmiany "IsEnabled"
     if (Engine.Positions.Count == 0)
     {
         bEditSelected.IsEnabled = false;
         bDeleteSelectedNote.IsEnabled = false;
     }
     else
     {
         bEditSelected.IsEnabled = true;
         bDeleteSelectedNote.IsEnabled = true;
     }
 }
示例#39
0
文件: DataGrid.cs 项目: JianwenSun/cc
        /// <summary>
        ///     Called when there are changes to the SelectedCells collection.
        /// </summary>
        /// <param name="e">Event arguments that indicate which cells were added or removed.</param>
        /// <remarks>
        ///     Base implementation fires the public SelectedCellsChanged event.
        /// </remarks>
        protected virtual void OnSelectedCellsChanged(SelectedCellsChangedEventArgs e)
        {
            if (SelectedCellsChanged != null)
            {
                SelectedCellsChanged(this, e);
            }

            // Raise automation events
            if (AutomationPeer.ListenerExists(AutomationEvents.SelectionItemPatternOnElementSelected) ||
                AutomationPeer.ListenerExists(AutomationEvents.SelectionItemPatternOnElementAddedToSelection) ||
                AutomationPeer.ListenerExists(AutomationEvents.SelectionItemPatternOnElementRemovedFromSelection))
            {
                DataGridAutomationPeer peer = DataGridAutomationPeer.FromElement(this) as DataGridAutomationPeer;
                if (peer != null)
                {
                    peer.RaiseAutomationCellSelectedEvent(e);
                }
            }
        }
 /// <summary>
 /// Handles the SelectedCellsChanged event of the dgTestCases control. Disable Preview and Duplicate buttons if more than one row is selected.
 /// </summary>
 /// <param name="sender">The source of the event.</param>
 /// <param name="e">The <see cref="SelectedCellsChangedEventArgs"/> instance containing the event data.</param>
 private void dgSharedSteps_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
 {
     this.UpdateButtonsStatus();
 }
        private void dgrd_Tax_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {

        }
 private void DataGrid_SelectedCellsChanged(object s, System.Windows.Controls.SelectedCellsChangedEventArgs e)
 {
 }
示例#43
0
 /// <summary>
 /// Handles the Selected event of the MainDataGrid control.
 /// </summary>
 /// <param name="sender">The source of the event.</param>
 /// <param name="e">The <see cref="System.Windows.Controls.SelectedCellsChangedEventArgs"/> instance containing the event data.</param>
 private void MainDataGrid_Selected(object sender, System.Windows.Controls.SelectedCellsChangedEventArgs e)
 {
     _iMainViewModel.ShowDetailedView();
 }