//thêm
public void themud(string makh, string mucud, int tongmua)
{
SqlParameter[] mang = new SqlParameter[3];
mang[0] = new SqlParameter("@MaKH", makh);
mang[1] = new SqlParameter("@MucUD", mucud);
mang[2] = new SqlParameter("@TongMua", tongmua);
dc.ExecuteNonQuery("ThemUD", mang);
}
public void themncc(string mancc, string tenncc, string sdt, string diachi)
{
SqlParameter[] mang = new SqlParameter[4];
mang[0] = new SqlParameter("@MaNCC", mancc);
mang[1] = new SqlParameter("@TenNCC", tenncc);
mang[2] = new SqlParameter("@SDT", sdt);
mang[3] = new SqlParameter("@DiaChi", diachi);
dc.ExecuteNonQuery("ThemNCC", mang);
}
public void themct_nhap(string mapn, string mahang, int soluong, float dongia, float thanhtien)
{
SqlParameter[] mang = new SqlParameter[5];
mang[0] = new SqlParameter("@MaPN", mapn);
mang[1] = new SqlParameter("@MaHang", mahang);
mang[2] = new SqlParameter("@Soluong", soluong);
mang[3] = new SqlParameter("@DonGia", dongia);
mang[4] = new SqlParameter("@ThanhTien", thanhtien);
dc.ExecuteNonQuery("ThemCT_PN", mang);
}
public void themkh(string makh, string tenkh, string diachi, string dienthoai, string email)
{
SqlParameter[] mang = new SqlParameter[5];
mang[0] = new SqlParameter("@MaKH", makh);
mang[1] = new SqlParameter("@TenKH", tenkh);
mang[2] = new SqlParameter("@DiaChi", diachi);
mang[3] = new SqlParameter("@DienThoai", dienthoai);
mang[4] = new SqlParameter("@Email", email);
dc.ExecuteNonQuery("ThemKH", mang);
}
public void thempn(string maphieun, string manv, string mancc, DateTime ngaynhap, float tongtiennhap)
{
SqlParameter[] mang = new SqlParameter[5];
mang[0] = new SqlParameter("@MaPhieuNhap", maphieun);
mang[1] = new SqlParameter("@MaNV", manv);
mang[2] = new SqlParameter("@MaNCC", mancc);
mang[3] = new SqlParameter("@NgayNhap", ngaynhap);
mang[4] = new SqlParameter("@TongTienNhap", tongtiennhap);
dc.ExecuteNonQuery("ThemPN", mang);
}
public void thempx(string maphieu, string makh, string manv, DateTime ngaylap, float chietkhau, float tongtien)
{
SqlParameter[] mang = new SqlParameter[6];
mang[0] = new SqlParameter("@MaPhieu", maphieu);
mang[1] = new SqlParameter("@MaKH", makh);
mang[2] = new SqlParameter("@MaNV", manv);
mang[3] = new SqlParameter("@NgayLap", ngaylap);
mang[4] = new SqlParameter("@ChietKhau", chietkhau);
mang[5] = new SqlParameter("@TongTien", tongtien);
dc.ExecuteNonQuery("ThemPX", mang);
}
public void themsp(string mahang, string tenhang, float gianhap, float giaban, int soluong, float vat, string ncc)
{
SqlParameter[] mang = new SqlParameter[7];
mang[0] = new SqlParameter("@MaHang", mahang);
mang[1] = new SqlParameter("@TenHang", tenhang);
mang[2] = new SqlParameter("@GiaNhap", gianhap);
mang[3] = new SqlParameter("@GiaBan", giaban);
mang[4] = new SqlParameter("@SoLuong", soluong);
mang[5] = new SqlParameter("@VAT", vat);
mang[6] = new SqlParameter("@NCC", ncc);
dc.ExecuteNonQuery("ThemSP", mang);
}
public void xoanv(string manv)
{
SqlParameter[] mang = new SqlParameter[1];
mang[0] = new SqlParameter("@MaNV", manv);
dc.ExecuteNonQuery("XoaNV", mang);
}