private void btnSearch_Click(object sender, RoutedEventArgs e)
        {
            if (txbSearch.Text.Length > 0)
            {
                page = new Paging(Common.connection, "NhanVien where TrangThai = 0 and NhanVienId = '" + txbSearch.Text + "'", "NhanVienId desc");
                QLVTDataSet.NhanVienDataTable nhanViens = new QLVTDataSet.NhanVienDataTable();
                nhanViens.Rows.Clear();

                DataTable dataTable = page.getPage(0);
                if (dataTable != null)
                {
                    nhanViens.Merge(dataTable);
                    nhanViens.DefaultView.RowFilter = "TrangThai <> 1";
                }
                dgContent.ItemsSource = nhanViens;
                tableLog        = new DataTableLog((DataTable)nhanViens);
                tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1);

                //QLVTDataSet.NhanVienDataTable nhanViens = new QLVTDataSet.NhanVienDataTable();
                //try
                //{
                //    DataTable table = ((QLVTDataSet.NhanVienDataTable)dgContent.ItemsSource).Select("NhanVienId=" + txbSearch.Text).CopyToDataTable();
                //    nhanViens.Merge(table);
                //    dgContent.ItemsSource = nhanViens;
                //}
                //catch (Exception ex)
                //{
                //    MessageBox.Show("Result not found!");

                //}
            }
        }
Example #2
0
        public void loadData(int p)
        {
            try
            {
                Common.LoaiHangTableAdapter.Connection = Common.connection;
                Common.LoaiHangTableAdapter.Fill(Common.LoaiHangDataTable);

                page = new Paging(Common.connection, "MatHang", "MatHangId desc");
                QLVTDataSet.MatHangDataTable VatTus = new QLVTDataSet.MatHangDataTable();


                DataTable dataTable = page.getPage(p);
                if (dataTable != null)
                {
                    VatTus.Merge(dataTable);
                }
                dgContent.ItemsSource = VatTus;
                tableLog = new DataTableLog((DataTable)dgContent.ItemsSource);

                tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Example #3
0
        private void btnSearch_Click(object sender, RoutedEventArgs e)
        {
            page = new Paging(Common.connection, "Kho where KhoId = '" + txbSearch.Text + "'", "KhoId desc");
            QLVTDataSet.KhoDataTable khos = new QLVTDataSet.KhoDataTable();
            DataTable dataTable           = page.getPage(0);

            if (dataTable != null)
            {
                khos.Merge(dataTable);
            }
            dgContent.ItemsSource = khos;
            tableLog        = new DataTableLog((DataTable)khos);
            tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1);
        }
Example #4
0
        private void btnSearch_Click(object sender, RoutedEventArgs e)
        {
            page = new Paging(Common.connection, "LoaiHang where LoaiHangId= '" + txbSearch.Text + "'", "LoaiHangId desc");
            QLVTDataSet.LoaiHangDataTable DanhMucVatTus = new QLVTDataSet.LoaiHangDataTable();


            DataTable dataTable = page.getPage(0);

            if (dataTable != null)
            {
                DanhMucVatTus.Merge(dataTable);
            }
            dgContent.ItemsSource = DanhMucVatTus;
            tableLog = new DataTableLog((DataTable)dgContent.ItemsSource);

            tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1);
        }
Example #5
0
 public void loadData(int p)
 {
     try
     {
         page = new Paging(Common.connection, "Kho", "KhoId desc");
         QLVTDataSet.KhoDataTable khos = new QLVTDataSet.KhoDataTable();
         DataTable dataTable           = page.getPage(p);
         if (dataTable != null)
         {
             khos.Merge(dataTable);
         }
         dgContent.ItemsSource = khos;
         tableLog        = new DataTableLog((DataTable)khos);
         tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
        public void loadData(int p)
        {
            try
            {
                page = new Paging(Common.connection, "NhanVien where TrangThai = 0", "NhanVienId desc");
                QLVTDataSet.NhanVienDataTable nhanViens = new QLVTDataSet.NhanVienDataTable();
                nhanViens.Rows.Clear();

                DataTable dataTable = page.getPage(p);
                if (dataTable != null)
                {
                    nhanViens.Merge(dataTable);
                }
                nhanViens.DefaultView.RowFilter = "TrangThai <> 1";
                dgContent.ItemsSource           = nhanViens;
                tableLog        = new DataTableLog((DataTable)nhanViens);
                tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1);
            }catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }