public bool Them(KhachHang khachhang) { string strSql = string.Format("insert into KhachHang (TenKH, SDT, GioiTinh, DiaChi, SoDiem) values(N'{0}', '{1}', N'{2}', N'{3}', {4})", khachhang.TenKH, khachhang.SDT, khachhang.GioiTinh, khachhang.DiaChi, khachhang.SoDiem); return(_dbConnect.ExecuteNonQuery(strSql)); }
public bool Them(NhanVien nhanvien) { string strSql = string.Format("insert into NhanVien (TenNV, GioiTinh, DiaChi, SDT, MatKhau, ChucDanh, Luong) values (N'{0}', N'{1}', N'{2}', '{3}', '{4}', N'{5}', {6})", nhanvien.TenNV, nhanvien.GioiTinh, nhanvien.DiaChi, nhanvien.SDT, nhanvien.MatKhau, nhanvien.ChucDanh, nhanvien.Luong); MessageBox.Show(strSql, "Thong bao", MessageBoxButtons.OK); return(_dbConnect.ExecuteNonQuery(strSql)); }
public bool Them(HangHoa hang) { string strSql = string.Format("insert into HangHoa (TenHH, DonGia, SoLuong, DVCungCap, NgayNhapHang, NgayHetHan) values(N'{0}', {1}, {2}, N'{3}', '{4}', '{5}')", hang.TenHH, hang.DonGia, hang.SoLuong, hang.DVCungCap, hang.NgayNhapHang.ToString("yyyy-MM-dd"), hang.NgayHetHan.ToString("yyyy-MM-dd")); return(_dbConnect.ExecuteNonQuery(strSql)); }
public bool Them(HoaDon hoadon) { string strSql = string.Format("insert into HoaDon (MaKH, MaNV, NgayLap,Tong) values({0}, {1}, '{2}',{3})", hoadon.MaKH, hoadon.MaNV, hoadon.Ngay.ToString("yyyy-MM-dd"), hoadon.Tong); return(_dbConnect.ExecuteNonQuery(strSql)); }
public bool Them(ChiTietHoaDon chitietHD) { string strSql = string.Format("insert into ChiTietHoaDon values({0}, {1}, {2}, {3})", chitietHD.MaHD, chitietHD.MaHH, chitietHD.DonGia, chitietHD.SoLuong); return(_dbConnect.ExecuteNonQuery(strSql)); }