public void suacthdb(EC_tb_CTHDB cthdb)
{
string sql = (@"UPDATE tb_CTHDB
SET soluong =N'" + cthdb.SOLUONG + "', khuyenmai = N'" + cthdb.KHUYENMAI + "', thanhtien = N'" + cthdb.THANHTIEN + "' where [mahdb]=N'" + cthdb.MAHDB + "' and masp=N'" + cthdb.MASP + "'");
cn.ExcuteNonQuery(sql);
}
public void suacthdb(EC_tb_CTHDB cthdb)
{
string sql = (@"UPDATE tb_CTHDB
SET soluong =N'" + cthdb.SOLUONG + "', giamgia = N'" + cthdb.GIAMGIA + "', thanhtien = N'" + cthdb.THANHTIEN + "' where sohdb=N'" + cthdb.SOHDB + "' and mahang=N'" + cthdb.MAHANG + "'");
cn.ExcuteNonQuery(sql);
}
public void themoicthdb(EC_tb_CTHDB cthdb)
{
if (!cthdbsql.kiemtracthdb(cthdb.SOHDB, cthdb.MAHANG))
{
cthdbsql.themmoicthdb(cthdb);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void xoacthdb(EC_tb_CTHDB cthdb)
{
cn.ExcuteNonQuery("DELETE FROM [tb_CTHDB] WHERE sohdb=N'" + cthdb.SOHDB + "' and mahang=N'" + cthdb.MAHANG + "' ");
}
public void themmoicthdb(EC_tb_CTHDB cthdb)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_CTHDB
(sohdb, mahang, soluong, giamgia, thanhtien) VALUES (N'" + cthdb.SOHDB + "',N'" + cthdb.MAHANG + "',N'" + cthdb.SOLUONG + "',N'" + cthdb.GIAMGIA + "',N'" + cthdb.THANHTIEN + "')");
}
public void xoacthdb(EC_tb_CTHDB cthdb)
{
cn.ExcuteNonQuery("DELETE FROM [tb_CTHDB] WHERE mahdb=N'" + cthdb.MAHDB + "' and masp=N'" + cthdb.MASP + "' ");
}
public void themmoicthdb(EC_tb_CTHDB cthdb)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_CTHDB
(mahdb, masp, tensp, soluong, thanhtien, khuyenmai) VALUES (N'" + cthdb.MAHDB + "',N'" + cthdb.MASP + "',N'" + cthdb.TENSP + "',N'" + cthdb.SOLUONG + "',N'" + cthdb.THANHTIEN + "',N'" + cthdb.KHUYENMAI + "')");
}
public void xoacthdb(EC_tb_CTHDB cthdb)
{
cthdbsql.xoacthdb(cthdb);
}
public void suacthdb(EC_tb_CTHDB cthdb)
{
cthdbsql.suacthdb(cthdb);
}
