public void suaHDB(EC_tb_HDB hdb)
{
string sql = (@"UPDATE tb_HDB
SET sohdb =N'" + hdb.MANV + "',ngayban =N'" + hdb.NGAYBAN + "',tongtien =N'" + hdb.TONGTIEN + "',makh =N'" + hdb.MAKH + "' where mahdb =N'" + hdb.SOHDB + "'");
cn.ExcuteNonQuery(sql);
}
public void suaHDB(EC_tb_HDB hdb)
{
string sql = (@"UPDATE tb_HDB
SET manv =N'" + hdb.MANV + "',ngayban =N'" + hdb.NGAYBAN + "',thue =N'" + hdb.THUE + "',makhach =N'" + hdb.MAKHACH + "' where sohdb =N'" + hdb.SOHDB + "'");
cn.ExcuteNonQuery(sql);
}
public void suaHDB(EC_tb_HDB hdb)
{
string sql = (@"UPDATE tb_HDB
SET manv =N'" + hdb.MANV + "',ngayban =N'" + hdb.NGAYBAN + "',makh =N'" + hdb.MAKH + "' where mahdb =N'" + hdb.MAHDB + "'");
cn.ExcuteNonQuery(sql);
}
public void themoihdb(EC_tb_HDB hdb)
{
if (!hdbsql.kiemtraHDB(hdb.SOHDB))
{
hdbsql.themmoiHDB(hdb);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void xoahdb(EC_tb_HDB hdb)
{
hdbsql.xoaHDB(hdb);
}
public void suahdb(EC_tb_HDB hdb)
{
hdbsql.suaHDB(hdb);
}
public void xoaHDB(EC_tb_HDB hdb)
{
cn.ExcuteNonQuery("DELETE FROM [tb_HDB] WHERE [sohdb] = N'" + hdb.SOHDB + "'");
}
public void themmoiHDB(EC_tb_HDB hdb)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_HDB
(sohdb, manv, ngayban, makh, tongtien) VALUES (N'" + hdb.SOHDB + "',N'" + hdb.MANV + "',N'" + hdb.NGAYBAN + "',N'" + hdb.MAKH + "',N'" + hdb.TONGTIEN + "')");
}
public void themmoiHDB(EC_tb_HDB hdb)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_HDB
(sohdb, manv,ngayban,thue,makhach) VALUES (N'" + hdb.SOHDB + "',N'" + hdb.MANV + "',N'" + hdb.NGAYBAN + "',N'" + hdb.THUE + "',N'" + hdb.MAKHACH + "')");
}
