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();
}
private AddVatTu()
{
this.DataContext = new ViewModel();
InitializeComponent();
QLVTDataSet.LoaiHangDataTable loaiHangs = new QLVTDataSet.LoaiHangDataTable();
Common.LoaiHangTableAdapter.Connection = Common.connection;
Common.LoaiHangTableAdapter.Fill(loaiHangs);
dgLoaiMatHang.ItemsSource = loaiHangs;
Id = 0;
EventHandler eventHandler = (o, i) => { signleton = new AddVatTu(); };
this.Closed += eventHandler;
}
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);
}
public AddVatTu(DataRow row)
{
this.DataContext = new ViewModel();
InitializeComponent();
QLVTDataSet.LoaiHangDataTable loaiHangs = new QLVTDataSet.LoaiHangDataTable();
Common.LoaiHangTableAdapter.Connection = Common.connection;
Common.LoaiHangTableAdapter.Fill(loaiHangs);
dgLoaiMatHang.ItemsSource = loaiHangs;
((ViewModel)this.DataContext).Ten = tbxTen.Text = row["Ten"] as string;
((ViewModel)this.DataContext).DonVi = tbxDVT.Text = row["DonViTinh"] as string;
((ViewModel)this.DataContext).LoaiVatTu = dgLoaiMatHang.SelectedValue = row["LoaiHangId"].ToString();
this.row = row;
tblTitle.Text = "Chỉnh sửa";
tblTitle.Text = "ID:" + row["MatHangId"].ToString();
}
public void loadData(int p)
{
try
{
page = new Paging(Common.connection, "LoaiHang", "LoaiHangId desc");
QLVTDataSet.LoaiHangDataTable DanhMucVatTus = new QLVTDataSet.LoaiHangDataTable();
DataTable dataTable = page.getPage(p);
if (dataTable != null)
{
DanhMucVatTus.Merge(dataTable);
}
dgContent.ItemsSource = DanhMucVatTus;
tableLog = new DataTableLog((DataTable)dgContent.ItemsSource);
tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1);
}catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void tbxLoaiHang_KeyUp(object sender, KeyEventArgs e)
{
QLVTDataSet.LoaiHangDataTable loaiHangs = new QLVTDataSet.LoaiHangDataTable();
try
{
DataTable table;
int rs;
if (int.TryParse(tbxLoaiHang.Text, out rs))
{
table = Common.LoaiHangDataTable.Select("Ten like '%" + tbxLoaiHang.Text + "%' or LoaiHangId = " + rs).Take(5).CopyToDataTable();
}
else
{
table = Common.LoaiHangDataTable.Select("Ten like '%" + tbxLoaiHang.Text + "%'").Take(5).CopyToDataTable();
}
loaiHangs.Merge(table);
dgLoaiMatHang.ItemsSource = loaiHangs;
}
catch (Exception ex)
{
}
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
ForceValidation();
if (!Validation.GetHasError(txbTen))
{
if (row == null)
{
QLVTDataSet.LoaiHangDataTable nhaCungCaps = (QLVTDataSet.LoaiHangDataTable)dataGrid.ItemsSource;
DataRow row = nhaCungCaps.NewRow();
row["Ten"] = txbTen.Text;
row["LoaiHangId"] = Common.genId--;
nhaCungCaps.Rows.Add(row);
//this.Close();
this.txbTen.Text = "";
MessageBox.Show("Đã thêm!");
}
else
{
row["Ten"] = txbTen.Text;
this.Close();
}
}
}
