public void Xoa(EC_tblPhieuNhap et)
{
cn.ThucThiCauLenhSQL(@"DELETE FROM tblPhieuNhap where MaPN = '" + et.MaPN + "'");
}
public void Them(EC_tblPhieuNhap et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO tblPhieuNhap (MaPN,MaNCC,NgayNhap) VALUES ('" + et.MaPN + "','" + et.MaNCC + "','" + et.NgayNhap + "')");
}
public void Sua(EC_tblPhieuNhap et)
{
cn.ThucThiCauLenhSQL(@"UPDATE tblPhieuNhap SET MANCC = '" + et.MaNCC + "',NgayNhap = '" + et.NgayNhap + "' where MaPN = '" + et.MaPN + "'");
}
public void suadulieu(EC_tblPhieuNhap et)
{
this.cn.thucthicaulenh("UPDATE PhieuNhap SET NgayNhap ='" + et.NgayNhap + "', NguoiNhap ='" + et.NguoiNhap + "', mancc ='" + et.Mancc + "', mahh ='" + et.Mahh + "' where MaPNK='" + et.MaPNK + "' ");
}
public void xoadulieu(EC_tblPhieuNhap et)
{
this.cn.thucthicaulenh("DELETE FROM PhieuNhap where MaPNK='" + et.MaPNK + "'");
}
public void Xoa(EC_tblPhieuNhap et)
{
sql.Xoa(et);
}
public void themdulieu(EC_tblPhieuNhap et)
{
this.cn.thucthicaulenh("INSERT INTO PhieuNhap (MaPNK, NgayNhap, NguoiNhap, mancc, mahh) VALUES ('" + et.MaPNK + "','" + et.NgayNhap + "','" + et.NguoiNhap + "','" + et.Mancc + "','" + et.Mahh + "')");
}
public void Sua(EC_tblPhieuNhap et)
{
sql.Sua(et);
}
public void Them(EC_tblPhieuNhap et)
{
sql.Them(et);
}
public void xoadulieu(EC_tblPhieuNhap et)
{
this.sql.xoadulieu(et);
}
public void suadulieu(EC_tblPhieuNhap et)
{
this.sql.suadulieu(et);
}
public void themdulieu(EC_tblPhieuNhap et)
{
this.sql.themdulieu(et);
}
