public static int xoa_PN(PhieuNhap a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maPN", a.MaPN),
};
return(Dataprovider.ExecuteNonQuery("xoa_PN", para));
}
public static int xoa_PX(PhieuXuat a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maPX", a.MaPX),
};
return(Dataprovider.ExecuteNonQuery("xoa_PX", para));
}
public static int xoa_NCC(NCC a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maNCC", a.MaNCC),
};
return(Dataprovider.ExecuteNonQuery("xoa_NCC", para));
}
public static int xoa_HH(HangHoa a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maHH", a.MaHH),
};
return(Dataprovider.ExecuteNonQuery("xoa_HH", para));
}
public static int xoa_CTX(ChiTietXuat a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maCTX", a.MaCTX),
};
return(Dataprovider.ExecuteNonQuery("xoa_CTX", para));
}
public static int them_PX(PhieuXuat a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maPX", a.MaPX),
new SqlParameter("@ngayXuat", a.NgayXuat),
new SqlParameter("@tongTien", a.TongTien),
};
return(Dataprovider.ExecuteNonQuery("them_PX", para));
}
public static int them_PN(PhieuNhap a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maPN", a.MaPN),
new SqlParameter("@ngayNhap", a.NgayNhap),
new SqlParameter("@tongTien", a.TongTien),
};
return(Dataprovider.ExecuteNonQuery("them_PN", para));
}
public static int sua_HH(HangHoa a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maHH", a.MaHH),
new SqlParameter("@tenHH", a.TenHH),
new SqlParameter("@maNCC", a.MaNCC),
};
return(Dataprovider.ExecuteNonQuery("sua_HH", para));
}
public static int them_NCC(NCC a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maNCC", a.MaNCC),
new SqlParameter("@tenNCC", a.TenNCC),
new SqlParameter("@diaChi", a.DiaChi),
new SqlParameter("@SDT", a.SoDT),
new SqlParameter("@email", a.Email),
};
return(Dataprovider.ExecuteNonQuery("them_NCC", para));
}
public static int them_CTX(ChiTietXuat a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maCTX", a.MaCTX),
new SqlParameter("@maPX", a.MaPX),
new SqlParameter("@maHH", a.MaHH),
new SqlParameter("@soLuong", a.SoLuong),
new SqlParameter("@donGia", a.DonGia),
};
return(Dataprovider.ExecuteNonQuery("them_CTX", para));
}
//sua
public static int sua_CTN(ChiTietNhap a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maCTN", a.MaCTN),
new SqlParameter("@maPN", a.MaPN),
new SqlParameter("@maHH", a.MaHH),
new SqlParameter("@soLuong", a.SoLuong),
new SqlParameter("@donGia", a.DonGia),
};
return(Dataprovider.ExecuteNonQuery("sua_CTN", para));
}