public void suaHDN(EC_tb_HDN hdn)
{
string sql = (@"UPDATE tb_HDN
SET manv =N'" + hdn.MANV + "',ngaynhap =N'" + hdn.NGAYNHAP + "',mancc =N'" + hdn.MANCC + "' where mahdn =N'" + hdn.MAHDN + "'");
cn.ExcuteNonQuery(sql);
}
public void themoihdn(EC_tb_HDN hdn)
{
if (!hdnsql.kiemtraHDN(hdn.MAHDN))
{
hdnsql.themmoiHDN(hdn);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void xoahdn(EC_tb_HDN hdn)
{
hdnsql.xoaHDN(hdn);
}
public void suahdn(EC_tb_HDN hdn)
{
hdnsql.suaHDN(hdn);
}
public void xoaHDN(EC_tb_HDN hdn)
{
cn.ExcuteNonQuery("DELETE FROM [tb_HDN] WHERE [mahdn] = N'" + hdn.MAHDN + "'");
}
public void themmoiHDN(EC_tb_HDN hdn)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_HDN
(mahdn, ngaynhap, manv, mancc, tongtien) VALUES (N'" + hdn.MAHDN + "',N'" + hdn.NGAYNHAP + "',N'" + hdn.MANV + "',N'" + hdn.MANCC + "',N'" + hdn.TONGTIEN + "')");
}
public void themmoiHDN(EC_tb_HDN hdn)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_HDN
(sohdn, manv,ngaynhap,mancc) VALUES (N'" + hdn.SOHDN + "',N'" + hdn.MANV + "',N'" + hdn.NGAYNHAP + "',N'" + hdn.MANCC + "')");
}
