public void ThemHD(int _mahd, string _tenkhachhang, string _diachi, string _sodienthoai, string _email) { EndUser.Open(); string now = DateTime.Now.ToString("MM/dd/yyyy"); string qry = "insert into hoadon values('" + _mahd + "','" + _tenkhachhang + "','" + _diachi + "','" + _sodienthoai + "','" + _email + "','" + now + "','" + now + "','False')"; SqlCommand cmd = new SqlCommand(qry, EndUser.cnn); cmd.ExecuteNonQuery(); cmd.Dispose(); EndUser.Close(); }
public DataTable getall_sp_chude(int _chude) { EndUser.Open(); string qry = "SELECT top 20 SanPham.[MaSP], [TenSP], [GiaMua], [GiaBan], [LoaiSP], [ThongTin], [ChuDe], [GioiTinh], [hot], [HinhAnh], [NgayNhapHang],[SoLuong],[Size] FROM [SanPham] inner join SanPham_Size on SanPham.MaSP = SanPham_Size.MaSP inner join Size on SanPham_Size.MaSize = Size.MaSize WHERE ChuDe =" + _chude; SqlCommand cmd = new SqlCommand(qry, EndUser.cnn); SqlDataReader reader = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(reader); cmd.Dispose(); reader.Dispose(); EndUser.Close(); return(dt); }