public bool Sua(EC_PhieuMuon et) { try { cn.ThucHienLenh(@"UPDATE PhieuMuon SET MaBD = N'" + et.MaBD + "',TrangThai = " + et.TrangThai + " where MaPM = N'" + et.MaPM + "')"); return(true); } catch { return(false); } }
public bool Them(EC_PhieuMuon et) { try { cn.ThucHienLenh(@"INSERT INTO PhieuMuon (MaPM,MaBD,TrangThai) VALUES ('" + et.MaPM + "',N'" + et.MaBD + "'," + et.TrangThai + ")"); return(true); } catch { return(false); } }
public void Xoa(EC_PhieuMuon et) { cn.ThucHienLenh(@"DELETE FROM PhieuMuon where MaPM = '" + et.MaPM + "'"); }