public void suacthdn(EC_tb_CTHDN cthdn)
{
string sql = (@"UPDATE tb_CTHDN
SET soluong =N'" + cthdn.SOLUONG + "', giamgia = N'" + cthdn.GIAMGIA + "', dongia = N'" + cthdn.DONGIA + "', thanhtien = N'" + cthdn.THANHTIEN + "' where sohdn=N'" + cthdn.SOHDN + "' and mahang=N'" + cthdn.MAHANG + "'");
cn.ExcuteNonQuery(sql);
}
public void themmoicthdn(EC_tb_CTHDN cthdn)
{
string sql = (@"INSERT INTO tb_CTHDN
(sohdn, mahang, soluong, dongia, giamgia, thanhtien) VALUES (N'" + cthdn.SOHDN + "',N'" + cthdn.MAHANG + "',N'" + cthdn.SOLUONG + "',N'" + cthdn.DONGIA + "',N'" + cthdn.GIAMGIA + "',N'" + cthdn.THANHTIEN + "')");
cn.ExcuteNonQuery(sql);
}
public void suacthdb(EC_tb_CTHDN cthdb)
{
string sql = (@"UPDATE tb_CTHDN
SET soluong =N'" + cthdb.SOLUONG + "', khuyenmai = N'" + cthdb.KHUYENMAI + "', thanhtien = N'" + cthdb.THANHTIEN + "' where mhdb=N'" + cthdb.MAHDN + "' and masp=N'" + cthdb.MASP + "'");
cn.ExcuteNonQuery(sql);
}
public void themoicthdn(EC_tb_CTHDN cthdn)
{
if (!cthdnsql.kiemtracthdn(cthdn.SOHDN, cthdn.MAHANG))
{
cthdnsql.themmoicthdn(cthdn);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void xoacthdn(EC_tb_CTHDN cthdn)
{
cthdnsql.xoacthdn(cthdn);
}
public void suacthdn(EC_tb_CTHDN cthdn)
{
cthdnsql.suacthdn(cthdn);
}
public void xoacthdn(EC_tb_CTHDN cthdn)
{
cn.ExcuteNonQuery("DELETE FROM [tb_CTHDN] WHERE sohdn=N'" + cthdn.SOHDN + "' and mahang=N'" + cthdn.MAHANG + "' ");
}
public void xoacthdb(EC_tb_CTHDN cthdb)
{
cn.ExcuteNonQuery("DELETE FROM [tb_CTHDN] WHERE mahdn=N'" + cthdb.MAHDN + "' and masp=N'" + cthdb.MASP + "' ");
}
public void themmoicthdb(EC_tb_CTHDN cthdb)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_CTHDN
(mahdn, masp, soluong, dongia, thanhtien, khuyenmai) VALUES (N'" + cthdb.MAHDN + "',N'" + cthdb.MASP + "',N'" + cthdb.SOLUONG + "',N'" + cthdb.DONGIA + "',N'" + cthdb.THANHTIEN + "',N'" + cthdb.KHUYENMAI + "')");
}
