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); }