public bool XoaXuatNL(NXNguyenLieu nl)
{
string[] param = { "@MaPX" };
object[] values = { nl.MaPhieuXuat };
string query = "Delete from tblXuatNL where MaPhieuXuat=@MaPX";
return(db.ExecuteNonQueryPara(query, param, values));
}
public bool XuatNL(NXNguyenLieu nl)
{
string[] param = { "@MaPX", "@NgayXuat", "@MaNV" };
object[] values = { nl.MaPhieuXuat, nl.NgayXuat, nl.MaNV };
string query = "Insert into tblXuatNL(MaPhieuXuat,NgayXuat,MaNV) values (@MaPX,@NgayXuat,@MaNV)";
return(db.ExecuteNonQueryPara(query, param, values));
}
public bool XoaNhapNL(NXNguyenLieu nl)
{
string[] param = { "@MaPN" };
object[] values = { nl.MaPhieuNhap };
string query = "Delete from tblNhapNL where MaPhieuNhap=@MaPN";
return(db.ExecuteNonQueryPara(query, param, values));
}
public bool NhapNL(NXNguyenLieu nl)
{
string[] param = { "@MaPN", "@NgayNhap", "@TongTien", "@MaNV" };
object[] values = { nl.MaPhieuNhap, nl.NgayNhap, nl.TongTien, nl.MaNV };
string query = "Insert into tblNhapNL(MaPhieuNhap,NgayNhap,TongTien,MaNV) values(@MaPN,@NgayNhap, @TongTien,@MaNV)";
return(db.ExecuteNonQueryPara(query, param, values));
}
public bool XoaXuatNL(NXNguyenLieu nl)
{
return(dalnxnl.XoaXuatNL(nl));
}
public bool NhapNL(NXNguyenLieu nl)
{
return(dalnxnl.NhapNL(nl));
}
