public new List <Class_NhaCungCap> Select() { string sql = "SELECT * FROM NhaCungCap"; List <Class_NhaCungCap> list = new List <Class_NhaCungCap>(); SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=DESKTOP-MFCIF4Q\SQLEXPRESS;Initial Catalog=QLNhaHang;Integrated Security=True"; con.Open(); SqlCommand cmd = new SqlCommand(sql, con); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { string MaNhaCungCap = reader.GetString(0); string TenNhaCungCap = reader.GetString(1); string DiaChi = reader.GetString(2); string DienThoai = reader.GetString(3); Class_NhaCungCap ncc = new Class_NhaCungCap(MaNhaCungCap, TenNhaCungCap, DiaChi, DienThoai); list.Add(ncc); } } } con.Close(); return(list); }
public void update(Class_NhaCungCap ncc) { string sql = "UPDATE NhaCungCap WHERE SET MaNhaCungCap=" + ncc.MaNhaCungCap1 + ",TenNhaCungCap=N'" + ncc.TenNhaCungCap1 + "', DiaChi=N'" + ncc.DiaChi1 + "', DienThoai='" + ncc.DienThoai1 + "')"; query.insert(sql); }
public void insert(Class_NhaCungCap ncc) { string sql = "INSERT INTO NhaCungCap(MaNhaCungCap,TenNhaCungCap,DiaChi,DienThoai) VALUES("; sql += ncc.MaNhaCungCap1 + ",N'" + ncc.TenNhaCungCap1 + "',N'" + ncc.DiaChi1 + "',N'" + ncc.DienThoai1 + "')"; query.insert(sql); }
public new List <Class_NhaCungCap> Select() { string sql = "SELECT * FROM NhaCungCap"; List <Class_NhaCungCap> list = new List <Class_NhaCungCap>(); query.ketnoiSQL(); using (DbDataReader reader = query.Reader(sql)) { if (reader.HasRows) { while (reader.Read()) { string MaNhaCungCap = reader.GetString(0); string TenNhaCungCap = reader.GetString(1); string DiaChi = reader.GetString(2); string DienThoai = reader.GetString(3); Class_NhaCungCap ncc = new Class_NhaCungCap(MaNhaCungCap, TenNhaCungCap, DiaChi, DienThoai); list.Add(ncc); } } } query.DongketnoiSQL(); return(list); }
public void delete(Class_NhaCungCap ncc) { string sql = "DELETE FROM NhaCungCap WHERE MaNhaCungCap = " + ncc.MaNhaCungCap1; query.insert(sql); }