static Common() { server0 = "LAPTOP-U7HEJ86K"; database0 = "QLVT"; userid0 = "QLVT_HTKN"; password0 = "123"; LoaiHangDataTable = new QLVTDataSet.LoaiHangDataTable(); NhanVienDataTable = new QLVTDataSet.NhanVienDataTable(); NhaCungCapDataTable = new QLVTDataSet.NhaCungCapDataTable(); MatHangDataTable = new QLVTDataSet.MatHangDataTable(); CTDatHangDataTable = new QLVTDataSet.CTDatHangDataTable(); KhoDataTable = new QLVTDataSet.KhoDataTable(); KhachHangDataTable = new QLVTDataSet.KhachHangDataTable(); CTHoaDonDataTable = new QLVTDataSet.CTHoaDonDataTable(); PhieuNhapDataTable = new QLVTDataSet.PhieuNhapDataTable(); CTPhieuNhapDataTable = new QLVTDataSet.CTPhieuNhapDataTable(); NhanVienTableAdapter = new QLVTDataSetTableAdapters.NhanVienTableAdapter(); NhanVienTableAdapter.Adapter.InsertCommand.CommandText = "INSERT INTO NhanVien (Ten,Ho,Phai,DiaChi,SoDienThoai,TrangThai,NgaySinh,ChiNhanhId)" + "VALUES(@Ten,@Ho,@Phai,@DiaChi,@SoDienThoai,@TrangThai,@NgaySinh,@ChiNhanhId)"; KhoTableAdapter = new QLVTDataSetTableAdapters.KhoTableAdapter(); KhoTableAdapter.Adapter.InsertCommand.CommandText = "IF(@KhoId < 0) INSERT INTO Kho (Ten,ViTri,ChiNhanhId) VALUES(@Ten,@ViTri,@ChiNhanhId) " + "ELSE INSERT INTO Kho (KhoId,Ten,ViTri,ChiNhanhId) VALUES(@KhoId,@Ten,@ViTri,@ChiNhanhId)"; KhachHangTableAdapter = new QLVTDataSetTableAdapters.KhachHangTableAdapter(); KhachHangTableAdapter.Adapter.InsertCommand.CommandText = "IF(@KhachHangId < 0) INSERT INTO KhachHang (Ten,SoDienThoai,DiaChi,ChiNhanhId) VALUES(@Ten,@SoDienThoai,@DiaChi,@ChiNhanhId)" + "ELSE INSERT INTO KhachHang (KhachHangId,Ten,SoDienThoai,DiaChi,ChiNhanhId) VALUES(@KhachHangId,@Ten,@SoDienThoai,@DiaChi,@ChiNhanhId)"; NhaCungCapTableAdapter = new QLVTDataSetTableAdapters.NhaCungCapTableAdapter(); NhaCungCapTableAdapter.Adapter.InsertCommand.CommandText = "IF(@NhaCungCapId < 0) INSERT INTO NhaCungCap (Ten,SoDienThoai,DiaChi) VALUES(@Ten,@SoDienThoai,@DiaChi)" + "ELSE INSERT INTO NhaCungCap (NhaCungCapId,Ten,SoDienThoai,DiaChi) VALUES(@NhaCungCapId,@Ten,@SoDienThoai,@DiaChi)"; LoaiHangTableAdapter = new QLVTDataSetTableAdapters.LoaiHangTableAdapter(); LoaiHangTableAdapter.Adapter.InsertCommand.CommandText = "IF(@LoaiHangId < 0) INSERT INTO LoaiHang (Ten) VALUES(@Ten)" + "ELSE INSERT INTO LoaiHang (LoaiHangId,Ten) VALUES(@LoaiHangId,@Ten)"; MatHangTableAdapter = new QLVTDataSetTableAdapters.MatHangTableAdapter(); MatHangTableAdapter.Adapter.InsertCommand.CommandText = "IF(@MatHangId < 0) INSERT INTO MatHang (Ten,DonViTinh,LoaiHangId) VALUES(@Ten,@DonViTinh,@LoaiHangId)" + "ELSE INSERT INTO MatHang (MatHangId,Ten,DonViTinh,LoaiHangId) VALUES(@MatHangId,@Ten,@DonViTinh,@LoaiHangId)"; DatHangTableAdapter = new QLVTDataSetTableAdapters.DatHangTableAdapter(); //DatHangTableAdapter.Adapter.InsertCommand.CommandText = // "IF(@DatHangId < 0) INSERT INTO DatHang (NhanVienId,NhaCungCapId,ThoiGian) VALUES(@NhanVienId,@NhaCungCapId)" // + "ELSE INSERT INTO DatHang (DatHangId,Ten,DonViTinh,LoaiHangId) VALUES(@DatHangId,@NhanVienId,@NhaCungCapId)"; CTDatHangTableAdapter = new QLVTDataSetTableAdapters.CTDatHangTableAdapter(); PhieuNhapTableAdapter = new QLVTDataSetTableAdapters.PhieuNhapTableAdapter(); PhieuNhapTableAdapter.Adapter.InsertCommand.CommandText = "INSERT INTO PhieuNhap (NhanVienId,KhoId,DatHangId) VALUES(@NhanVienId,@KhoId,@DatHangId)"; HoaDonTableAdapter = new QLVTDataSetTableAdapters.HoaDonTableAdapter(); //HoaDonTableAdapter.Adapter.InsertCommand.CommandText= "INSERT INTO HoaDon (NhanVienId,KhoId,DatHangId) VALUES(@NhanVienId,@KhoId,@DatHangId)"; CTHoaDonTableAdapter = new QLVTDataSetTableAdapters.CTHoaDonTableAdapter(); CTPhieuNhapTableAdapter = new QLVTDataSetTableAdapters.CTPhieuNhapTableAdapter(); }
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); } }
private void btnOk_Click(object sender, RoutedEventArgs e) { ForceValidation(); if (!Validation.GetHasError(tbxTen) && !Validation.GetHasError(tbxDVT) && !Validation.GetHasError(dgLoaiMatHang)) { if (row == null) { QLVTDataSet.MatHangDataTable matHangs = (QLVTDataSet.MatHangDataTable)dataGrid.ItemsSource; DataRow row = matHangs.NewRow(); row["Ten"] = tbxTen.Text; row["DonViTinh"] = tbxDVT.Text; row["MatHangId"] = Common.genId--; row["LoaiHangId"] = ((DataRow)((DataRowView)dgLoaiMatHang.SelectedItem).Row)["LoaiHangId"]; matHangs.Rows.Add(row); this.Close(); } else { row["Ten"] = tbxTen.Text; row["DonViTinh"] = tbxDVT.Text; row["LoaiHangId"] = ((DataRow)((DataRowView)dgLoaiMatHang.SelectedItem).Row)["LoaiHangId"]; this.Close(); } } }
private void btnSearch_Click(object sender, RoutedEventArgs e) { page = new Paging(Common.connection, "MatHang where MatHangId= '" + txbSearch.Text + "'", "MatHangId desc"); QLVTDataSet.MatHangDataTable VatTus = new QLVTDataSet.MatHangDataTable(); DataTable dataTable = page.getPage(0); if (dataTable != null) { VatTus.Merge(dataTable); } dgContent.ItemsSource = VatTus; tableLog = new DataTableLog((DataTable)dgContent.ItemsSource); tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1); }
private void txbVT_KeyUp(object sender, KeyEventArgs e) { QLVTDataSet.MatHangDataTable matHangs = new QLVTDataSet.MatHangDataTable(); try { DataTable table; int rs; if (int.TryParse(txbVT.Text, out rs)) { table = Common.MatHangDataTable.Select("Ten like '%" + txbVT.Text + "%' or MatHangId = " + rs).CopyToDataTable(); } else { table = Common.MatHangDataTable.Select("Ten like '%" + txbVT.Text + "%'").CopyToDataTable(); } matHangs.Merge(table); dgMatHang.ItemsSource = matHangs; } catch (Exception ex) { } }